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 1575: FROM CZ_PS_NODES

1571: g_root_persist_id_tbl(g_UI_Context.devl_project_id) := g_model_nodes_tbl(g_UI_Context.devl_project_id).persistent_node_id;
1572: ELSE
1573: SELECT persistent_node_id
1574: INTO g_root_persist_id_tbl(g_UI_Context.devl_project_id)
1575: FROM CZ_PS_NODES
1576: WHERE devl_project_id=g_UI_Context.devl_project_id AND
1577: parent_id IS NULL AND
1578: deleted_flag=G_NO_FLAG;
1579: END IF;

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

1696:
1697: BEGIN
1698:
1699: IF p_ps_node_id IS NOT NULL AND (p_component_id IS NULL OR p_component_id=0) THEN
1700: DEBUG('Wrong data in CZ_PS_NODES. Node with ps_node_id='||TO_CHAR(p_ps_node_id)||
1701: ' has invalid component_id='||TO_CHAR(p_component_id));
1702: RETURN 0;
1703: END IF;
1704:

Line 2387: SELECT parent_id INTO l_parent_id FROM CZ_PS_NODES

2383: l_ps_node := get_Model_Node_By_Persist_Id(l_persistent_node_id, g_UI_Context.devl_project_id);
2384:
2385: END IF;
2386:
2387: SELECT parent_id INTO l_parent_id FROM CZ_PS_NODES
2388: WHERE ps_node_id=p_ps_node_id;
2389:
2390: IF l_parent_id IS NULL THEN
2391: RETURN '.';

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

2391: RETURN '.';
2392: END IF;
2393:
2394: IF p_page_set_id IS NULL THEN
2395: FOR i IN(SELECT persistent_node_id, parent_id FROM CZ_PS_NODES
2396: START WITH ps_node_id=p_ps_node_id AND deleted_flag=G_NO_FLAG
2397: CONNECT BY PRIOR parent_id=ps_node_id AND
2398: PRIOR deleted_flag=G_NO_FLAG AND deleted_flag=G_NO_FLAG)
2399: LOOP

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

2409: RETURN l_model_path;
2410:
2411: ELSE
2412:
2413: FOR i IN(SELECT ps_node_id,persistent_node_id, parent_id FROM CZ_PS_NODES
2414: START WITH ps_node_id=p_ps_node_id AND deleted_flag=G_NO_FLAG
2415: CONNECT BY PRIOR parent_id=ps_node_id AND
2416: PRIOR deleted_flag=G_NO_FLAG AND deleted_flag=G_NO_FLAG)
2417: LOOP

Line 3273: (SELECT ps_node_id FROM CZ_PS_NODES

3269: a.INSTANTIATION_SCOPE, b.data_value
3270: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
3271: WHERE a.devl_project_id=l_model_node.devl_project_id AND
3272: a.component_id IN
3273: (SELECT ps_node_id FROM CZ_PS_NODES
3274: WHERE devl_project_id IN
3275: (SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS
3276: START WITH model_id=l_model_node.devl_project_id AND
3277: referring_node_id=l_model_node.ps_node_id

Line 5366: INTO l_ps_node_id, l_ps_node_type, l_component_id FROM CZ_PS_NODES

5362: -- does the current node with persistent_node_id=p_persistent_node_id
5363: -- belongs to model with devl_project_id=p_model_id ?
5364: --
5365: SELECT ps_node_id,ps_node_type,component_id
5366: INTO l_ps_node_id, l_ps_node_type, l_component_id FROM CZ_PS_NODES
5367: WHERE devl_project_id=p_model_id AND
5368: persistent_node_id=p_persistent_node_id;
5369:
5370: EXCEPTION

Line 5422: FROM CZ_PS_NODES

5418:
5419: -- get ps node data for AMN of UI node
5420: SELECT ps_node_id,ps_node_type,component_id
5421: INTO l_ps_node_id, l_ps_node_type,l_component_id
5422: FROM CZ_PS_NODES
5423: WHERE devl_project_id=i.component_id AND
5424: persistent_node_id=p_persistent_node_id AND
5425: deleted_flag=G_NO_FLAG;
5426:

Line 6502: FROM CZ_PS_NODES

6498: resolve_view_names(l_xml_node_to_move, p_ui_node.page_id, l_counter, l_element_ids_tbl);
6499:
6500:
6501: SELECT ps_node_id INTO l_component_id
6502: FROM CZ_PS_NODES
6503: WHERE devl_project_id = g_UI_Context.devl_project_id
6504: AND persistent_node_Id = p_ui_node.pagebase_persistent_node_id;
6505:
6506: SELECT ps_node_id INTO l_old_component_id

Line 6507: FROM CZ_PS_NODES

6503: WHERE devl_project_id = g_UI_Context.devl_project_id
6504: AND persistent_node_Id = p_ui_node.pagebase_persistent_node_id;
6505:
6506: SELECT ps_node_id INTO l_old_component_id
6507: FROM CZ_PS_NODES
6508: WHERE devl_project_id = g_UI_Context.devl_project_id
6509: AND persistent_node_id = (SELECT persistent_node_id
6510: FROM CZ_UI_PAGES
6511: WHERE ui_def_id = g_UI_Context.ui_Def_id

Line 8966: persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES

8962: page_id IN(SELECT page_id FROM CZ_UI_PAGES
8963: WHERE ui_def_id=g_UI_Context.ui_def_id AND
8964: persistent_node_id=l_page_persistent_node_id AND deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE)) AND
8965: element_type=G_UI_CX_BUTTON_NODE_TYPE AND
8966: persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
8967: WHERE ps_node_id=p_component_id)
8968: AND deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE))
8969: LOOP
8970: FOR k IN(SELECT ui_action_id FROM CZ_UI_ACTIONS

Line 9176: (SELECT ps_node_id FROM CZ_PS_NODES

9172: FOR i IN(SELECT a.model_ref_expl_id, b.data_value, a.component_id, b.expr_node_id, a.name, a.INSTANTIATION_SCOPE
9173: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9174: WHERE a.devl_project_id=p_node.devl_project_id AND
9175: a.component_id IN
9176: (SELECT ps_node_id FROM CZ_PS_NODES
9177: WHERE devl_project_id IN
9178: (SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS
9179: START WITH model_id=p_node.devl_project_id AND
9180: referring_node_id=p_node.ps_node_id AND

Line 9346: SELECT persistent_node_id INTO l_persistent_id FROM CZ_PS_NODES

9342: END IF;
9343: END LOOP;
9344:
9345: -- find persistent_node_id of PS node which is used in CX binding
9346: SELECT persistent_node_id INTO l_persistent_id FROM CZ_PS_NODES
9347: WHERE devl_project_id=l_ref_model_id AND ps_node_id=i.component_id;
9348:
9349: -- find model_ref_expl_id and persistent_node_id of pagebase
9350: 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 9615: FROM CZ_PS_NODES

9611:
9612:
9613: FOR i in (SELECT b.data_value, b.expr_node_id, a.INSTANTIATION_SCOPE, a.NAME,
9614: (SELECT persistent_node_id
9615: FROM CZ_PS_NODES
9616: WHERE devl_project_id = g_UI_Context.devl_project_id
9617: AND ps_node_id = a.component_id) persistent_node_Id
9618: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9619: WHERE a.devl_project_id=g_UI_Context.devl_project_id AND

Line 10044: SELECT ps_node_type INTO l_ps_node_type FROM CZ_PS_NODES

10040: RETURN BOOLEAN IS
10041: l_ps_node_type NUMBER;
10042: BEGIN
10043:
10044: SELECT ps_node_type INTO l_ps_node_type FROM CZ_PS_NODES
10045: WHERE ps_node_id=p_ps_node_id AND deleted_flag=G_NO_FLAG;
10046:
10047: IF l_ps_node_type=G_REFERENCE_TYPE THEN
10048: RETURN TRUE;

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

10047: IF l_ps_node_type=G_REFERENCE_TYPE THEN
10048: RETURN TRUE;
10049: END IF;
10050:
10051: FOR i IN (SELECT DISTINCT ps_node_type,reference_id FROM CZ_PS_NODES
10052: WHERE parent_id=p_ps_node_id AND
10053: deleted_flag=G_NO_FLAG AND ui_omit=G_NO_FLAG AND
10054: (ps_node_type IN(G_BOM_MODEL_TYPE,G_BOM_OPTION_CLASS_TYPE,G_BOM_STANDART_ITEM_TYPE) OR
10055: ps_node_type=G_REFERENCE_TYPE))

Line 10058: SELECT ps_node_type INTO l_ps_node_type FROM CZ_PS_NODES

10054: (ps_node_type IN(G_BOM_MODEL_TYPE,G_BOM_OPTION_CLASS_TYPE,G_BOM_STANDART_ITEM_TYPE) OR
10055: ps_node_type=G_REFERENCE_TYPE))
10056: LOOP
10057: IF i.ps_node_type=G_REFERENCE_TYPE THEN
10058: SELECT ps_node_type INTO l_ps_node_type FROM CZ_PS_NODES
10059: WHERE ps_node_id=i.reference_id;
10060: IF l_ps_node_type=G_BOM_MODEL_TYPE THEN
10061: RETURN TRUE;
10062: END IF;

Line 10256: FROM CZ_PS_NODES

10252: --DEBUG('asp: Getting seq_nbr for ps node ' || p_node.name || ', tree_seq ' || p_node.tree_seq);
10253: FOR i IN 1..p_node.tree_seq-1
10254: LOOP
10255: FOR j in (SELECT persistent_node_id
10256: FROM CZ_PS_NODES
10257: WHERE devl_project_id = g_UI_Context.devl_project_id
10258: AND parent_id = p_node.parent_id
10259: AND tree_seq = p_node.tree_seq-i
10260: AND deleted_flag = G_NO_FLAG)

Line 10286: -- seq_nbrs in cz_ps_nodes are not correct

10282: RETURN 1;
10283:
10284: EXCEPTION
10285: WHEN NO_DATA_FOUND THEN
10286: -- seq_nbrs in cz_ps_nodes are not correct
10287: SELECT NVL(count(*), 0) + 1 INTO l_seq_nbr
10288: FROM CZ_UI_PAGE_REFS
10289: WHERE ui_def_id = g_UI_Context.ui_def_Id
10290: AND page_set_id = p_page_set_id

Line 10870: l_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;

10866: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
10867: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
10868: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10869: l_max_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
10870: l_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
10871: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
10872: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
10873: l_counter NUMBER;
10874: l_persistent_node_id NUMBER;

Line 10975: FROM CZ_PS_NODES

10971:
10972: l_ps_node := get_Model_Node_By_Persist_Id(l_persistent_node_id,g_UI_COntext.devl_project_id);
10973:
10974: SELECT ps_node_type INTO l_ps_node_type
10975: FROM CZ_PS_NODES
10976: WHERE devl_project_id=p_node.reference_id AND
10977: parent_id IS NULL AND
10978: deleted_flag=G_NO_FLAG;
10979:

Line 11527: NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a

11523: -- delete UI References
11524: UPDATE CZ_UI_PAGE_REFS uiref
11525: SET deleted_flag=G_YES_FLAG
11526: WHERE ui_def_id=p_ui_def_id AND target_ui_def_id IS NOT NULL AND
11527: NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a
11528: WHERE a.devl_project_id=(SELECT b.devl_project_id FROM CZ_UI_DEFS b
11529: WHERE b.ui_def_id=p_ui_def_id) AND
11530: persistent_node_id=uiref.target_persistent_node_id AND deleted_flag=G_NO_FLAG)
11531: AND deleted_flag=G_NO_FLAG;

Line 11536: NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a

11532:
11533: UPDATE CZ_UI_REFS uiref
11534: SET deleted_flag=G_YES_FLAG
11535: WHERE ui_def_id=p_ui_def_id AND
11536: NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a
11537: WHERE a.devl_project_id=(SELECT b.devl_project_id FROM CZ_UI_DEFS b
11538: WHERE b.ui_def_id=p_ui_def_id) AND
11539: persistent_node_id=uiref.ref_persistent_node_id AND deleted_flag=G_NO_FLAG)
11540: AND deleted_flag=G_NO_FLAG;

Line 11944: -- CZ_PS_NODES.instantiable_flag

11940: g_check_boundaries_tbl(g_UI_Context.ui_def_id) := G_YES_FLAG;
11941:
11942: --
11943: -- synchronize CZ_UI_PAGE_ELEMENTS.instantiable_flag with
11944: -- CZ_PS_NODES.instantiable_flag
11945: --
11946: FOR n IN(SELECT ui_def_id,page_id,element_id FROM CZ_UI_PAGE_ELEMENTS a
11947: WHERE ui_def_id=p_ui_node.ui_def_id AND
11948: persistent_node_id=p_ui_node.persistent_node_id AND

Line 12050: -- CZ_PS_NODES.instantiable_flag

12046: END IF;
12047:
12048: --
12049: -- synchronize CZ_UI_PAGE_ELEMENTS.instantiable_flag with
12050: -- CZ_PS_NODES.instantiable_flag
12051: --
12052: UPDATE CZ_UI_PAGE_ELEMENTS
12053: SET instantiable_flag = p_node.instantiable_flag,
12054: parent_persistent_node_id=p_node.parent_persistent_node_id

Line 12092: FROM CZ_PS_NODES

12088:
12089: BEGIN
12090:
12091: SELECT ps_node_type INTO l_ps_node_type
12092: FROM CZ_PS_NODES
12093: WHERE devl_project_id=p_node.reference_id AND
12094: parent_id IS NULL AND
12095: deleted_flag=G_NO_FLAG;
12096:

Line 13298: AND target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES

13294:
13295: IF g_UI_Context.PRIMARY_NAVIGATION=G_MODEL_TREE_MENU THEN
13296: SELECT COUNT(*) INTO l_num_if_roots FROM CZ_UI_PAGE_REFS
13297: WHERE ui_def_id=g_UI_Context.ui_def_id AND parent_page_ref_id IS NULL
13298: AND target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
13299: WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND
13300: deleted_flag=G_NO_FLAG) AND deleted_flag=G_NO_FLAG;
13301: IF l_num_if_roots > 1 THEN
13302:

Line 13307: AND target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES

13303: SELECT target_persistent_node_id,page_set_id,page_ref_type
13304: INTO l_target_persistent_node_id,l_page_set_id,l_page_set_type
13305: FROM CZ_UI_PAGE_REFS
13306: WHERE ui_def_id=g_UI_Context.ui_def_id AND parent_page_ref_id IS NULL
13307: AND target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
13308: WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND
13309: deleted_flag=G_NO_FLAG) AND deleted_flag=G_NO_FLAG AND rownum<2;
13310:
13311: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');

Line 13361: target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES

13357:
13358: UPDATE CZ_UI_PAGE_REFS
13359: SET parent_page_ref_id=l_page_ref_id
13360: WHERE ui_def_id=g_UI_Context.ui_def_id AND parent_page_ref_id IS NULL AND
13361: target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
13362: WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND
13363: deleted_flag=G_NO_FLAG) AND deleted_flag=G_NO_FLAG;
13364:
13365: END IF;

Line 13583: SELECT ps_node_type INTO l_ps_node_type FROM CZ_PS_NODES

13579: LOOP
13580: IF i.element_type=G_UI_CX_BUTTON_NODE_TYPE THEN
13581: BEGIN
13582: l_ps_node_type := NULL;
13583: SELECT ps_node_type INTO l_ps_node_type FROM CZ_PS_NODES
13584: WHERE devl_project_id=g_UI_Context.devl_project_id AND
13585: persistent_node_id=i.persistent_node_id;
13586: EXCEPTION
13587: WHEN NO_DATA_FOUND THEN

Line 13593: FOR h IN(SELECT NULL FROM CZ_PS_NODES

13589: END;
13590: END IF;
13591:
13592: l_delete_in_model := TRUE;
13593: FOR h IN(SELECT NULL FROM CZ_PS_NODES
13594: WHERE devl_project_id=g_UI_Context.devl_project_id AND
13595: persistent_node_id=i.persistent_node_id AND
13596: deleted_flag=G_NO_FLAG)
13597: LOOP

Line 14304: FROM CZ_PS_NODES

14300: AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH)
14301: AND parent_element_id IS NOT NULL
14302: AND NOT (p_ps_node.ps_node_type <> G_BOM_OPTION_CLASS_TYPE
14303: AND ((SELECT NVL(ps_node_type,G_UNDEFINED_DATA_TYPE)
14304: FROM CZ_PS_NODES
14305: WHERE devl_project_id = p_ps_node.devl_project_id
14306: AND persistent_node_id = pe.persistent_node_id) = G_BOM_OPTION_CLASS_TYPE))
14307: GROUP BY parent_element_id, page_id
14308: ORDER BY count(parent_element_id) DESC)

Line 15210: (SELECT psnode.persistent_node_id FROM CZ_PS_NODES psnode

15206: model_ref_expl_id,persistent_node_id FROM CZ_UI_PAGE_ELEMENTS
15207: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15208: page_id=upg.page_id AND
15209: persistent_node_id IN
15210: (SELECT psnode.persistent_node_id FROM CZ_PS_NODES psnode
15211: WHERE psnode.devl_project_id IN
15212: (SELECT refexpl.component_id FROM CZ_MODEL_REF_EXPLS refexpl
15213: WHERE refexpl.model_id=g_UI_Context.devl_project_id AND
15214: refexpl.ps_node_type=G_REFERENCE_TYPE AND refexpl.deleted_flag='0') AND

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

15241: IF NVL(g_UI_Context.suppress_refresh_flag, G_NO_FLAG)=G_YES_FLAG THEN
15242: RETURN;
15243: END IF;
15244: /*
15245: FOR i IN(SELECT ps_node_id FROM CZ_PS_NODES a
15246: WHERE devl_project_id=g_UI_Context.devl_project_id AND
15247: ps_node_type IN(258,259,436,437) AND
15248: deleted_flag=G_YES_FLAG AND EXISTS(SELECT NULL
15249: FROM CZ_UI_PAGE_ELEMENTS WHERE ui_def_id=g_UI_Context.ui_def_id AND

Line 15252: UPDATE CZ_PS_NODES

15248: deleted_flag=G_YES_FLAG AND EXISTS(SELECT NULL
15249: FROM CZ_UI_PAGE_ELEMENTS WHERE ui_def_id=g_UI_Context.ui_def_id AND
15250: persistent_node_id=a.persistent_node_id AND deleted_flag=G_NO_FLAG))
15251: LOOP
15252: UPDATE CZ_PS_NODES
15253: SET deleted_flag=G_YES_FLAG
15254: WHERE ps_node_id IN
15255: (SELECT ps_node_id FROM CZ_PS_NODES
15256: START WITH ps_node_id=i.ps_node_id

Line 15255: (SELECT ps_node_id FROM CZ_PS_NODES

15251: LOOP
15252: UPDATE CZ_PS_NODES
15253: SET deleted_flag=G_YES_FLAG
15254: WHERE ps_node_id IN
15255: (SELECT ps_node_id FROM CZ_PS_NODES
15256: START WITH ps_node_id=i.ps_node_id
15257: CONNECT BY PRIOR ps_node_id=parent_id);
15258: END LOOP;
15259:

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

15256: START WITH ps_node_id=i.ps_node_id
15257: CONNECT BY PRIOR ps_node_id=parent_id);
15258: END LOOP;
15259:
15260: FOR i IN(SELECT ps_node_id FROM CZ_PS_NODES a
15261: WHERE devl_project_id=g_UI_Context.devl_project_id AND
15262: ps_node_type IN(258,259,436,437) AND ui_omit=G_YES_FLAG AND
15263: deleted_flag=G_NO_FLAG AND EXISTS(SELECT NULL
15264: FROM CZ_UI_PAGE_ELEMENTS WHERE ui_def_id=g_UI_Context.ui_def_id AND

Line 15267: UPDATE CZ_PS_NODES

15263: deleted_flag=G_NO_FLAG AND EXISTS(SELECT NULL
15264: FROM CZ_UI_PAGE_ELEMENTS WHERE ui_def_id=g_UI_Context.ui_def_id AND
15265: persistent_node_id=a.persistent_node_id AND deleted_flag=G_NO_FLAG))
15266: LOOP
15267: UPDATE CZ_PS_NODES
15268: SET deleted_flag=G_YES_FLAG
15269: WHERE ps_node_id IN
15270: (SELECT ps_node_id FROM CZ_PS_NODES
15271: START WITH ps_node_id=i.ps_node_id

Line 15270: (SELECT ps_node_id FROM CZ_PS_NODES

15266: LOOP
15267: UPDATE CZ_PS_NODES
15268: SET deleted_flag=G_YES_FLAG
15269: WHERE ps_node_id IN
15270: (SELECT ps_node_id FROM CZ_PS_NODES
15271: START WITH ps_node_id=i.ps_node_id
15272: CONNECT BY PRIOR ps_node_id=parent_id);
15273: END LOOP;
15274: */

Line 16233: l_instantiable_flag cz_ps_nodes.INSTANTIABLE_FLAG%TYPE;

16229: p_node_persistent_id IN NUMBER,
16230: p_ui_def_id IN NUMBER)
16231: RETURN BOOLEAN
16232: IS
16233: l_instantiable_flag cz_ps_nodes.INSTANTIABLE_FLAG%TYPE;
16234: BEGIN
16235: IF CZ_DEVELOPER_UTILS_PVT.in_boundary
16236: (p_pagebase_expl_id, p_node_expl_id, p_node_persistent_id) = 0 THEN
16237: RETURN FALSE;

Line 16240: FROM cz_ps_nodes

16236: (p_pagebase_expl_id, p_node_expl_id, p_node_persistent_id) = 0 THEN
16237: RETURN FALSE;
16238: ELSE
16239: SELECT instantiable_flag INTO l_instantiable_flag
16240: FROM cz_ps_nodes
16241: WHERE devl_project_id = (SELECT devl_project_id FROM cz_ui_defs
16242: WHERE ui_def_id = p_ui_def_id) AND
16243: persistent_node_id = p_node_persistent_id;
16244: RETURN (l_instantiable_flag IS NULL OR

Line 16608: FROM CZ_PS_NODES

16604: set_UI_Context(l_init_ui_def_id);
16605: END IF;
16606:
16607: SELECT persistent_node_id INTO l_ref_persistent_node_id
16608: FROM CZ_PS_NODES
16609: WHERE devl_project_id=g_UI_Context.devl_project_id AND
16610: ps_node_id=i.referring_node_id AND
16611: deleted_flag=G_NO_FLAG;
16612:

Line 20607: FROM CZ_PS_NODES

20603: set_UI_Context(p_ui_def_id);
20604:
20605: SELECT ps_node_id,parent_id,name
20606: INTO l_ref_ps_node_id,l_ref_parent_id,l_reference_name
20607: FROM CZ_PS_NODES
20608: WHERE devl_project_id=g_UI_Context.devl_project_id AND
20609: persistent_node_id=p_ref_persistent_node_id AND
20610: deleted_flag=G_NO_FLAG;
20611:

Line 20614: FROM CZ_PS_NODES

20610: deleted_flag=G_NO_FLAG;
20611:
20612: SELECT persistent_node_id
20613: INTO l_ref_parent_persist_node_id
20614: FROM CZ_PS_NODES
20615: WHERE ps_node_id=l_ref_parent_id AND
20616: deleted_flag=G_NO_FLAG;
20617:
20618: FOR i IN(SELECT page_ref_id,node_depth,page_set_id,page_ref_type, seq_nbr