eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_UIOA_PVT dependencies on CZ_PS_NODES

Line 1581: FROM CZ_PS_NODES

1577: g_root_persist_id_tbl(g_UI_Context.devl_project_id) := g_model_nodes_tbl(g_UI_Context.devl_project_id).persistent_node_id;
1578: ELSE
1579: SELECT persistent_node_id
1580: INTO g_root_persist_id_tbl(g_UI_Context.devl_project_id)
1581: FROM CZ_PS_NODES
1582: WHERE devl_project_id=g_UI_Context.devl_project_id AND
1583: parent_id IS NULL AND
1584: deleted_flag=G_NO_FLAG;
1585: END IF;

Line 1756: DEBUG('Wrong data in CZ_PS_NODES. Node with ps_node_id='||TO_CHAR(p_ps_node_id)||

1752:
1753: BEGIN
1754:
1755: IF p_ps_node_id IS NOT NULL AND (p_component_id IS NULL OR p_component_id=0) THEN
1756: DEBUG('Wrong data in CZ_PS_NODES. Node with ps_node_id='||TO_CHAR(p_ps_node_id)||
1757: ' has invalid component_id='||TO_CHAR(p_component_id));
1758: RETURN 0;
1759: END IF;
1760:

Line 2449: SELECT parent_id INTO l_parent_id FROM CZ_PS_NODES

2445: l_ps_node := get_Model_Node_By_Persist_Id(l_persistent_node_id, g_UI_Context.devl_project_id);
2446:
2447: END IF;
2448:
2449: SELECT parent_id INTO l_parent_id FROM CZ_PS_NODES
2450: WHERE ps_node_id=p_ps_node_id;
2451:
2452: IF l_parent_id IS NULL THEN
2453: RETURN '.';

Line 2457: FOR i IN(SELECT persistent_node_id, parent_id FROM CZ_PS_NODES

2453: RETURN '.';
2454: END IF;
2455:
2456: IF p_page_set_id IS NULL THEN
2457: FOR i IN(SELECT persistent_node_id, parent_id FROM CZ_PS_NODES
2458: START WITH ps_node_id=p_ps_node_id AND deleted_flag=G_NO_FLAG
2459: CONNECT BY PRIOR parent_id=ps_node_id AND
2460: PRIOR deleted_flag=G_NO_FLAG AND deleted_flag=G_NO_FLAG)
2461: LOOP

Line 2475: FOR i IN(SELECT ps_node_id,persistent_node_id, parent_id FROM CZ_PS_NODES

2471: RETURN l_model_path;
2472:
2473: ELSE
2474:
2475: FOR i IN(SELECT ps_node_id,persistent_node_id, parent_id FROM CZ_PS_NODES
2476: START WITH ps_node_id=p_ps_node_id AND deleted_flag=G_NO_FLAG
2477: CONNECT BY PRIOR parent_id=ps_node_id AND
2478: PRIOR deleted_flag=G_NO_FLAG AND deleted_flag=G_NO_FLAG)
2479: LOOP

Line 3335: (SELECT ps_node_id FROM CZ_PS_NODES

3331: a.INSTANTIATION_SCOPE, b.data_value
3332: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
3333: WHERE a.devl_project_id=l_model_node.devl_project_id AND
3334: a.component_id IN
3335: (SELECT ps_node_id FROM CZ_PS_NODES
3336: WHERE devl_project_id IN
3337: (SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS
3338: START WITH model_id=l_model_node.devl_project_id AND
3339: referring_node_id=l_model_node.ps_node_id

Line 5500: INTO l_ps_node_id, l_ps_node_type, l_component_id FROM CZ_PS_NODES

5496: -- does the current node with persistent_node_id=p_persistent_node_id
5497: -- belongs to model with devl_project_id=p_model_id ?
5498: --
5499: SELECT ps_node_id,ps_node_type,component_id
5500: INTO l_ps_node_id, l_ps_node_type, l_component_id FROM CZ_PS_NODES
5501: WHERE devl_project_id=p_model_id AND
5502: persistent_node_id=p_persistent_node_id;
5503:
5504: EXCEPTION

Line 5562: FROM CZ_PS_NODES

5558:
5559: -- get ps node data for AMN of UI node
5560: SELECT ps_node_id,ps_node_type,component_id
5561: INTO l_ps_node_id, l_ps_node_type,l_component_id
5562: FROM CZ_PS_NODES
5563: WHERE devl_project_id=i.component_id AND
5564: persistent_node_id=p_persistent_node_id AND
5565: deleted_flag=G_NO_FLAG;
5566:

Line 6771: FROM CZ_PS_NODES

6767: resolve_view_names(l_xml_node_to_move, p_ui_node.page_id, l_counter, l_element_ids_tbl);
6768:
6769:
6770: SELECT ps_node_id INTO l_component_id
6771: FROM CZ_PS_NODES
6772: WHERE devl_project_id = g_UI_Context.devl_project_id
6773: AND persistent_node_Id = p_ui_node.pagebase_persistent_node_id;
6774:
6775: SELECT ps_node_id INTO l_old_component_id

Line 6776: FROM CZ_PS_NODES

6772: WHERE devl_project_id = g_UI_Context.devl_project_id
6773: AND persistent_node_Id = p_ui_node.pagebase_persistent_node_id;
6774:
6775: SELECT ps_node_id INTO l_old_component_id
6776: FROM CZ_PS_NODES
6777: WHERE devl_project_id = g_UI_Context.devl_project_id
6778: AND persistent_node_id = (SELECT persistent_node_id
6779: FROM CZ_UI_PAGES
6780: WHERE ui_def_id = g_UI_Context.ui_Def_id

Line 9426: persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES

9422: page_id IN(SELECT page_id FROM CZ_UI_PAGES
9423: WHERE ui_def_id=g_UI_Context.ui_def_id AND
9424: persistent_node_id=l_page_persistent_node_id AND deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE)) AND
9425: element_type=G_UI_CX_BUTTON_NODE_TYPE AND
9426: persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
9427: WHERE ps_node_id=p_component_id)
9428: AND deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE))
9429: LOOP
9430: FOR k IN(SELECT ui_action_id FROM CZ_UI_ACTIONS

Line 9641: (SELECT ps_node_id FROM CZ_PS_NODES

9637: FOR i IN(SELECT a.model_ref_expl_id, b.data_value, a.component_id, b.expr_node_id, a.name, a.INSTANTIATION_SCOPE
9638: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9639: WHERE a.devl_project_id=p_node.devl_project_id AND
9640: a.component_id IN
9641: (SELECT ps_node_id FROM CZ_PS_NODES
9642: WHERE devl_project_id IN
9643: (SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS
9644: START WITH model_id=p_node.devl_project_id AND
9645: referring_node_id=p_node.ps_node_id AND

Line 9816: SELECT persistent_node_id INTO l_persistent_id FROM CZ_PS_NODES

9812: END IF;
9813: END LOOP;
9814:
9815: -- find persistent_node_id of PS node which is used in CX binding
9816: SELECT persistent_node_id INTO l_persistent_id FROM CZ_PS_NODES
9817: WHERE devl_project_id=l_ref_model_id AND ps_node_id=i.component_id;
9818:
9819: -- find model_ref_expl_id and persistent_node_id of pagebase
9820: SELECT model_ref_expl_id, persistent_node_id INTO l_pb_model_ref_expl_id, l_pb_persistent_node_id FROM CZ_UI_PAGE_ELEMENTS

Line 10089: FROM CZ_PS_NODES

10085:
10086:
10087: FOR i in (SELECT b.data_value, b.expr_node_id, a.INSTANTIATION_SCOPE, a.NAME,
10088: (SELECT persistent_node_id
10089: FROM CZ_PS_NODES
10090: WHERE devl_project_id = g_UI_Context.devl_project_id
10091: AND ps_node_id = a.component_id) persistent_node_Id
10092: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
10093: WHERE a.devl_project_id=g_UI_Context.devl_project_id AND

Line 10519: SELECT ps_node_type INTO l_ps_node_type FROM CZ_PS_NODES

10515: l_ps_node_type NUMBER;
10516: BEGIN
10517: BEGIN
10518: -- Handle No data Found Exeption BUG 11712366
10519: SELECT ps_node_type INTO l_ps_node_type FROM CZ_PS_NODES
10520: WHERE ps_node_id=p_ps_node_id AND deleted_flag=G_NO_FLAG;
10521: EXCEPTION
10522: WHEN NO_DATA_FOUND THEN
10523: RETURN FALSE;

Line 10530: FOR i IN (SELECT DISTINCT ps_node_type,reference_id FROM CZ_PS_NODES

10526: IF l_ps_node_type=G_REFERENCE_TYPE THEN
10527: RETURN TRUE;
10528: END IF;
10529:
10530: FOR i IN (SELECT DISTINCT ps_node_type,reference_id FROM CZ_PS_NODES
10531: WHERE parent_id=p_ps_node_id AND
10532: deleted_flag=G_NO_FLAG AND ui_omit=G_NO_FLAG AND
10533: (ps_node_type IN(G_BOM_MODEL_TYPE,G_BOM_OPTION_CLASS_TYPE,G_BOM_STANDART_ITEM_TYPE) OR
10534: ps_node_type=G_REFERENCE_TYPE))

Line 10537: SELECT ps_node_type INTO l_ps_node_type FROM CZ_PS_NODES

10533: (ps_node_type IN(G_BOM_MODEL_TYPE,G_BOM_OPTION_CLASS_TYPE,G_BOM_STANDART_ITEM_TYPE) OR
10534: ps_node_type=G_REFERENCE_TYPE))
10535: LOOP
10536: IF i.ps_node_type=G_REFERENCE_TYPE THEN
10537: SELECT ps_node_type INTO l_ps_node_type FROM CZ_PS_NODES
10538: WHERE ps_node_id=i.reference_id;
10539: IF l_ps_node_type=G_BOM_MODEL_TYPE THEN
10540: RETURN TRUE;
10541: END IF;

Line 10735: FROM CZ_PS_NODES

10731: --DEBUG('asp: Getting seq_nbr for ps node ' || p_node.name || ', tree_seq ' || p_node.tree_seq);
10732: FOR i IN 1..p_node.tree_seq-1
10733: LOOP
10734: FOR j in (SELECT persistent_node_id
10735: FROM CZ_PS_NODES
10736: WHERE devl_project_id = g_UI_Context.devl_project_id
10737: AND parent_id = p_node.parent_id
10738: AND tree_seq = p_node.tree_seq-i
10739: AND deleted_flag = G_NO_FLAG)

Line 10765: -- seq_nbrs in cz_ps_nodes are not correct

10761: RETURN 1;
10762:
10763: EXCEPTION
10764: WHEN NO_DATA_FOUND THEN
10765: -- seq_nbrs in cz_ps_nodes are not correct
10766: SELECT NVL(count(*), 0) + 1 INTO l_seq_nbr
10767: FROM CZ_UI_PAGE_REFS
10768: WHERE ui_def_id = g_UI_Context.ui_def_Id
10769: AND page_set_id = p_page_set_id

Line 11349: l_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;

11345: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
11346: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11347: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
11348: l_max_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
11349: l_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
11350: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11351: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
11352: l_counter NUMBER;
11353: l_persistent_node_id NUMBER;

Line 11454: FROM CZ_PS_NODES

11450:
11451: l_ps_node := get_Model_Node_By_Persist_Id(l_persistent_node_id,g_UI_COntext.devl_project_id);
11452:
11453: SELECT ps_node_type INTO l_ps_node_type
11454: FROM CZ_PS_NODES
11455: WHERE devl_project_id=p_node.reference_id AND
11456: parent_id IS NULL AND
11457: deleted_flag=G_NO_FLAG;
11458:

Line 12006: NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a

12002: -- delete UI References
12003: UPDATE CZ_UI_PAGE_REFS uiref
12004: SET deleted_flag=G_YES_FLAG
12005: WHERE ui_def_id=p_ui_def_id AND target_ui_def_id IS NOT NULL AND
12006: NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a
12007: WHERE a.devl_project_id=(SELECT b.devl_project_id FROM CZ_UI_DEFS b
12008: WHERE b.ui_def_id=p_ui_def_id) AND
12009: persistent_node_id=uiref.target_persistent_node_id AND deleted_flag=G_NO_FLAG)
12010: AND deleted_flag=G_NO_FLAG;

Line 12015: NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a

12011:
12012: UPDATE CZ_UI_REFS uiref
12013: SET deleted_flag=G_YES_FLAG
12014: WHERE ui_def_id=p_ui_def_id AND
12015: NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a
12016: WHERE a.devl_project_id=(SELECT b.devl_project_id FROM CZ_UI_DEFS b
12017: WHERE b.ui_def_id=p_ui_def_id) AND
12018: persistent_node_id=uiref.ref_persistent_node_id AND deleted_flag=G_NO_FLAG)
12019: AND deleted_flag=G_NO_FLAG;

Line 12423: -- CZ_PS_NODES.instantiable_flag

12419: g_check_boundaries_tbl(g_UI_Context.ui_def_id) := G_YES_FLAG;
12420:
12421: --
12422: -- synchronize CZ_UI_PAGE_ELEMENTS.instantiable_flag with
12423: -- CZ_PS_NODES.instantiable_flag
12424: --
12425: FOR n IN(SELECT ui_def_id,page_id,element_id FROM CZ_UI_PAGE_ELEMENTS a
12426: WHERE ui_def_id=p_ui_node.ui_def_id AND
12427: persistent_node_id=p_ui_node.persistent_node_id AND

Line 12529: -- CZ_PS_NODES.instantiable_flag

12525: END IF;
12526:
12527: --
12528: -- synchronize CZ_UI_PAGE_ELEMENTS.instantiable_flag with
12529: -- CZ_PS_NODES.instantiable_flag
12530: --
12531: UPDATE CZ_UI_PAGE_ELEMENTS
12532: SET instantiable_flag = p_node.instantiable_flag,
12533: parent_persistent_node_id=p_node.parent_persistent_node_id

Line 12572: FROM CZ_PS_NODES

12568:
12569: BEGIN
12570:
12571: SELECT ps_node_type INTO l_ps_node_type
12572: FROM CZ_PS_NODES
12573: WHERE devl_project_id=p_node.reference_id AND
12574: parent_id IS NULL AND
12575: deleted_flag=G_NO_FLAG;
12576:

Line 13782: AND target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES

13778:
13779: IF g_UI_Context.PRIMARY_NAVIGATION=G_MODEL_TREE_MENU THEN
13780: SELECT COUNT(*) INTO l_num_if_roots FROM CZ_UI_PAGE_REFS
13781: WHERE ui_def_id=g_UI_Context.ui_def_id AND parent_page_ref_id IS NULL
13782: AND target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
13783: WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND
13784: deleted_flag=G_NO_FLAG) AND deleted_flag=G_NO_FLAG;
13785: IF l_num_if_roots > 1 THEN
13786:

Line 13791: AND target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES

13787: SELECT target_persistent_node_id,page_set_id,page_ref_type
13788: INTO l_target_persistent_node_id,l_page_set_id,l_page_set_type
13789: FROM CZ_UI_PAGE_REFS
13790: WHERE ui_def_id=g_UI_Context.ui_def_id AND parent_page_ref_id IS NULL
13791: AND target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
13792: WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND
13793: deleted_flag=G_NO_FLAG) AND deleted_flag=G_NO_FLAG AND rownum<2;
13794:
13795: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');

Line 13845: target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES

13841:
13842: UPDATE CZ_UI_PAGE_REFS
13843: SET parent_page_ref_id=l_page_ref_id
13844: WHERE ui_def_id=g_UI_Context.ui_def_id AND parent_page_ref_id IS NULL AND
13845: target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
13846: WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND
13847: deleted_flag=G_NO_FLAG) AND deleted_flag=G_NO_FLAG;
13848:
13849: END IF;

Line 14067: SELECT ps_node_type INTO l_ps_node_type FROM CZ_PS_NODES

14063: LOOP
14064: IF i.element_type=G_UI_CX_BUTTON_NODE_TYPE THEN
14065: BEGIN
14066: l_ps_node_type := NULL;
14067: SELECT ps_node_type INTO l_ps_node_type FROM CZ_PS_NODES
14068: WHERE devl_project_id=g_UI_Context.devl_project_id AND
14069: persistent_node_id=i.persistent_node_id;
14070: EXCEPTION
14071: WHEN NO_DATA_FOUND THEN

Line 14077: FOR h IN(SELECT NULL FROM CZ_PS_NODES

14073: END;
14074: END IF;
14075:
14076: l_delete_in_model := TRUE;
14077: FOR h IN(SELECT NULL FROM CZ_PS_NODES
14078: WHERE devl_project_id=g_UI_Context.devl_project_id AND
14079: persistent_node_id=i.persistent_node_id AND
14080: deleted_flag=G_NO_FLAG)
14081: LOOP

Line 14883: FROM CZ_PS_NODES

14879: AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH)
14880: AND parent_element_id IS NOT NULL
14881: AND NOT (p_ps_node.ps_node_type <> G_BOM_OPTION_CLASS_TYPE
14882: AND ((SELECT NVL(ps_node_type,G_UNDEFINED_DATA_TYPE)
14883: FROM CZ_PS_NODES
14884: WHERE devl_project_id = p_ps_node.devl_project_id
14885: AND persistent_node_id = pe.persistent_node_id) = G_BOM_OPTION_CLASS_TYPE))
14886: GROUP BY parent_element_id, page_id
14887: ORDER BY count(parent_element_id) DESC)

Line 15793: FROM CZ_PS_NODES psnode

15789:
15790: BEGIN
15791:
15792: FOR t IN (SELECT ps_node_id,persistent_node_id as psnode_persistent_node_id,ps_node_type,component_id
15793: FROM CZ_PS_NODES psnode
15794: START WITH psnode.devl_project_id IN
15795: (SELECT refexpl.component_id FROM CZ_MODEL_REF_EXPLS refexpl
15796: WHERE refexpl.model_id=g_UI_Context.devl_project_id AND
15797: refexpl.ps_node_type=G_REFERENCE_TYPE AND refexpl.deleted_flag='0') AND

Line 15909: FOR i IN(SELECT ps_node_id FROM CZ_PS_NODES a

15905: IF NVL(g_UI_Context.suppress_refresh_flag, G_NO_FLAG)=G_YES_FLAG THEN
15906: RETURN;
15907: END IF;
15908: /*
15909: FOR i IN(SELECT ps_node_id FROM CZ_PS_NODES a
15910: WHERE devl_project_id=g_UI_Context.devl_project_id AND
15911: ps_node_type IN(258,259,436,437) AND
15912: deleted_flag=G_YES_FLAG AND EXISTS(SELECT NULL
15913: FROM CZ_UI_PAGE_ELEMENTS WHERE ui_def_id=g_UI_Context.ui_def_id AND

Line 15916: UPDATE CZ_PS_NODES

15912: deleted_flag=G_YES_FLAG AND EXISTS(SELECT NULL
15913: FROM CZ_UI_PAGE_ELEMENTS WHERE ui_def_id=g_UI_Context.ui_def_id AND
15914: persistent_node_id=a.persistent_node_id AND deleted_flag=G_NO_FLAG))
15915: LOOP
15916: UPDATE CZ_PS_NODES
15917: SET deleted_flag=G_YES_FLAG
15918: WHERE ps_node_id IN
15919: (SELECT ps_node_id FROM CZ_PS_NODES
15920: START WITH ps_node_id=i.ps_node_id

Line 15919: (SELECT ps_node_id FROM CZ_PS_NODES

15915: LOOP
15916: UPDATE CZ_PS_NODES
15917: SET deleted_flag=G_YES_FLAG
15918: WHERE ps_node_id IN
15919: (SELECT ps_node_id FROM CZ_PS_NODES
15920: START WITH ps_node_id=i.ps_node_id
15921: CONNECT BY PRIOR ps_node_id=parent_id);
15922: END LOOP;
15923:

Line 15924: FOR i IN(SELECT ps_node_id FROM CZ_PS_NODES a

15920: START WITH ps_node_id=i.ps_node_id
15921: CONNECT BY PRIOR ps_node_id=parent_id);
15922: END LOOP;
15923:
15924: FOR i IN(SELECT ps_node_id FROM CZ_PS_NODES a
15925: WHERE devl_project_id=g_UI_Context.devl_project_id AND
15926: ps_node_type IN(258,259,436,437) AND ui_omit=G_YES_FLAG AND
15927: deleted_flag=G_NO_FLAG AND EXISTS(SELECT NULL
15928: FROM CZ_UI_PAGE_ELEMENTS WHERE ui_def_id=g_UI_Context.ui_def_id AND

Line 15931: UPDATE CZ_PS_NODES

15927: deleted_flag=G_NO_FLAG AND EXISTS(SELECT NULL
15928: FROM CZ_UI_PAGE_ELEMENTS WHERE ui_def_id=g_UI_Context.ui_def_id AND
15929: persistent_node_id=a.persistent_node_id AND deleted_flag=G_NO_FLAG))
15930: LOOP
15931: UPDATE CZ_PS_NODES
15932: SET deleted_flag=G_YES_FLAG
15933: WHERE ps_node_id IN
15934: (SELECT ps_node_id FROM CZ_PS_NODES
15935: START WITH ps_node_id=i.ps_node_id

Line 15934: (SELECT ps_node_id FROM CZ_PS_NODES

15930: LOOP
15931: UPDATE CZ_PS_NODES
15932: SET deleted_flag=G_YES_FLAG
15933: WHERE ps_node_id IN
15934: (SELECT ps_node_id FROM CZ_PS_NODES
15935: START WITH ps_node_id=i.ps_node_id
15936: CONNECT BY PRIOR ps_node_id=parent_id);
15937: END LOOP;
15938: */

Line 16897: l_instantiable_flag cz_ps_nodes.INSTANTIABLE_FLAG%TYPE;

16893: p_node_persistent_id IN NUMBER,
16894: p_ui_def_id IN NUMBER)
16895: RETURN BOOLEAN
16896: IS
16897: l_instantiable_flag cz_ps_nodes.INSTANTIABLE_FLAG%TYPE;
16898: BEGIN
16899: IF CZ_DEVELOPER_UTILS_PVT.in_boundary
16900: (p_base_expl_id, p_node_expl_id, p_node_persistent_id) = 0 THEN
16901: RETURN FALSE;

Line 16904: FROM cz_ps_nodes

16900: (p_base_expl_id, p_node_expl_id, p_node_persistent_id) = 0 THEN
16901: RETURN FALSE;
16902: ELSE
16903: SELECT instantiable_flag INTO l_instantiable_flag
16904: FROM cz_ps_nodes
16905: WHERE devl_project_id = (SELECT devl_project_id FROM cz_ui_defs
16906: WHERE ui_def_id = p_ui_def_id) AND
16907: persistent_node_id = p_node_persistent_id;
16908: RETURN (l_instantiable_flag IS NULL OR

Line 17320: FROM CZ_PS_NODES

17316: set_UI_Context(l_init_ui_def_id);
17317: END IF;
17318:
17319: SELECT persistent_node_id INTO l_ref_persistent_node_id
17320: FROM CZ_PS_NODES
17321: WHERE devl_project_id=g_UI_Context.devl_project_id AND
17322: ps_node_id=i.referring_node_id AND
17323: deleted_flag=G_NO_FLAG;
17324:

Line 21723: FROM CZ_PS_NODES

21719: set_UI_Context(p_ui_def_id);
21720:
21721: SELECT ps_node_id,parent_id,name
21722: INTO l_ref_ps_node_id,l_ref_parent_id,l_reference_name
21723: FROM CZ_PS_NODES
21724: WHERE devl_project_id=g_UI_Context.devl_project_id AND
21725: persistent_node_id=p_ref_persistent_node_id AND
21726: deleted_flag=G_NO_FLAG;
21727:

Line 21730: FROM CZ_PS_NODES

21726: deleted_flag=G_NO_FLAG;
21727:
21728: SELECT persistent_node_id
21729: INTO l_ref_parent_persist_node_id
21730: FROM CZ_PS_NODES
21731: WHERE ps_node_id=l_ref_parent_id AND
21732: deleted_flag=G_NO_FLAG;
21733:
21734: FOR i IN(SELECT page_ref_id,node_depth,page_set_id,page_ref_type, seq_nbr