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_MODEL_REF_EXPLS

Line 1695: l_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

1691: p_ps_node_id IN NUMBER,
1692: p_component_id IN NUMBER,
1693: p_ps_node_type IN NUMBER) RETURN NUMBER IS
1694:
1695: l_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
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

Line 1719: FROM CZ_MODEL_REF_EXPLS a

1715: ELSE
1716: IF p_ps_node_type IN (G_REFERENCE_TYPE, G_CONNECTOR_TYPE) THEN
1717: SELECT MIN(model_ref_expl_id)
1718: INTO l_model_ref_expl_id
1719: FROM CZ_MODEL_REF_EXPLS a
1720: WHERE model_id = p_model_id AND
1721: referring_node_id = p_ps_node_id AND
1722: deleted_flag = G_NO_FLAG;
1723: ELSE

Line 1726: FROM CZ_MODEL_REF_EXPLS

1722: deleted_flag = G_NO_FLAG;
1723: ELSE
1724: SELECT MIN(model_ref_expl_id)
1725: INTO l_model_ref_expl_id
1726: FROM CZ_MODEL_REF_EXPLS
1727: WHERE model_id = p_model_id AND
1728: component_id = p_component_id AND
1729: referring_node_id IS NULL AND
1730: deleted_flag = G_NO_FLAG;

Line 3275: (SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS

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
3278: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND
3279: deleted_flag='0' AND PRIOR deleted_flag='0') AND

Line 3502: FROM CZ_MODEL_REF_EXPLS

3498: g_ps_node_persist_id_tbl(i.persistent_node_id) := i.ps_node_id;
3499: END LOOP;
3500:
3501: FOR i IN(SELECT model_ref_expl_id,referring_node_id,component_id
3502: FROM CZ_MODEL_REF_EXPLS
3503: WHERE model_id=g_UI_Context.devl_project_id AND
3504: deleted_flag=G_NO_FLAG)
3505: LOOP
3506: IF i.referring_node_id IS NOT NULL THEN

Line 5402: FROM CZ_MODEL_REF_EXPLS

5398: END IF;
5399:
5400: -- validation of expl_id
5401: SELECT model_ref_expl_id INTO l_model_ref_expl_id
5402: FROM CZ_MODEL_REF_EXPLS
5403: WHERE model_ref_expl_id=p_ui_node_expl_id;
5404:
5405: --
5406: -- AMN of UI node belongs to referenced model

Line 5411: FROM CZ_MODEL_REF_EXPLS

5407: --
5408:
5409: FOR i IN(SELECT model_ref_expl_id,parent_expl_node_id,ps_node_type,
5410: component_id,referring_node_id
5411: FROM CZ_MODEL_REF_EXPLS
5412: START WITH model_ref_expl_id=p_ui_node_expl_id
5413: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND
5414: deleted_flag='0')
5415: LOOP

Line 5430: (SELECT model_ref_expl_id,referring_node_id,component_id FROM CZ_MODEL_REF_EXPLS

5426:
5427: IF NOT(l_ps_node_type IN(G_REFERENCE_TYPE,G_CONNECTOR_TYPE) AND p_ui_node_expl_id<>i.model_ref_expl_id) THEN
5428:
5429: SELECT model_ref_expl_id INTO l_expl_id FROM
5430: (SELECT model_ref_expl_id,referring_node_id,component_id FROM CZ_MODEL_REF_EXPLS
5431: START WITH model_ref_expl_id=i.model_ref_expl_id
5432: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag='0') a
5433: WHERE (l_ps_node_type IN(G_REFERENCE_TYPE,G_CONNECTOR_TYPE) AND a.referring_node_id=l_ps_node_id) OR
5434: (l_ps_node_type NOT IN(G_REFERENCE_TYPE,G_CONNECTOR_TYPE) AND a.component_id=l_component_id);

Line 9178: (SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS

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
9181: deleted_flag='0'
9182: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND

Line 9335: FOR k IN(SELECT component_id, ps_node_type FROM CZ_MODEL_REF_EXPLS

9331: ,G_NO_FLAG
9332: );
9333:
9334: -- find model to which model ref expl node with i.model_ref_expl_id belongs to
9335: FOR k IN(SELECT component_id, ps_node_type FROM CZ_MODEL_REF_EXPLS
9336: START WITH model_ref_expl_id=i.model_ref_expl_id
9337: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND deleted_flag='0')
9338: LOOP
9339: IF k.ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE THEN

Line 15212: (SELECT refexpl.component_id FROM CZ_MODEL_REF_EXPLS refexpl

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
15215: psnode.deleted_flag='0'
15216: AND psnode.ui_timestamp_move > NVL(g_UI_Context.ui_timestamp_refresh, g_UI_Context.creation_date)

Line 16586: FOR i IN(SELECT * FROM CZ_MODEL_REF_EXPLS

16582:
16583: IF NVL(g_UI_Context.suppress_refresh_flag,G_NO_FLAG)=G_YES_FLAG
16584: OR NVL(g_UI_Context.empty_ui_flag,G_NO_FLAG)=G_YES_FLAG THEN
16585:
16586: FOR i IN(SELECT * FROM CZ_MODEL_REF_EXPLS
16587: WHERE model_id=g_UI_Context.devl_project_id AND
16588: ps_node_type=G_REFERENCE_TYPE AND deleted_flag='0')
16589: LOOP
16590: BEGIN

Line 20650: SELECT MIN(model_ref_expl_id) INTO l_expl_node_id FROM CZ_MODEL_REF_EXPLS

20646: WHERE ui_def_id=p_ui_def_id AND
20647: parent_page_ref_id=i.page_ref_id AND
20648: deleted_flag=G_NO_FLAG;
20649:
20650: SELECT MIN(model_ref_expl_id) INTO l_expl_node_id FROM CZ_MODEL_REF_EXPLS
20651: WHERE model_id=g_UI_Context.devl_project_id AND
20652: referring_node_id=p_ref_persistent_node_id AND
20653: deleted_flag=G_NO_FLAG;
20654: