SELECT menu_id id
,      parent_menu_id pid
,      code_desc text
,      NULL url
,      NULL display_seq
,      NULL css_class
,      NULL info
,      CASE 
         WHEN flag = '1' THEN
           '"checked" : true'
         ELSE
           NULL
       END custom
FROM   MENU
ORDER BY menu_id

SELECT menu_id id
,      parent_menu_id pid
,      code_desc text
,      NULL url
,      NULL display_seq
,      NULL css_class
,      NULL info
,      CASE 
         WHEN flag_priv = 1 THEN
           '"checked" : true'
         ELSE
           '"checked" : false'
       END custom
FROM   MAIN_MENU_PROB

SELECT menu_id id
,      parent_menu_id pid
,      code_desc text
,      NULL url
,      NULL display_seq
,      NULL css_class
,      NULL info
,      CASE 
         WHEN flag_priv = 1 THEN
           '"checked" : true'
         ELSE
           '"checked" : false'
       END custom
FROM   MENU

SELECT menu_id as id
,      parent_menu_id as pid
,      code_desc as text
,      NULL url
,      page_id as display_seq
,      NULL css_class
,      NULL info
,      NULL custom
from MAIN_MENU
where (FLAG IN (SELECT TO_NUMBER(c001)
                from apex_collections
                where collection_name = 'Tree'
                )
       )

 
Begin
    APEX_COLLECTION.CREATE_COLLECTION(
        p_collection_name => 'Tree');
End;

DECLARE
  flag_priv number;
BEGIN
  IF apex_collection.collection_exists('Tree') = false 
    THEN
    APEX_COLLECTION.CREATE_COLLECTION('Tree');
  END IF;
  for i in 1..apex_application.g_f01.count 
  LOOP
    SELECT FLAG INTO flag_priv FROM MAIN_MENU
    WHERE page_id = apex_application.g_f01(i);
    APEX_COLLECTION.ADD_MEMBER('Tree', flag_priv);
  END LOOP;
END;