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 1635: FROM cz_model_ref_expls

1631:
1632: BEGIN
1633:
1634: SELECT component_id, model_id, ps_node_type INTO l_reference_id, l_model_id, l_ps_node_type
1635: FROM cz_model_ref_expls
1636: WHERE model_ref_expl_id = p_expl_id
1637: AND deleted_flag = G_NO_FLAG;
1638:
1639: l_node := get_Model_Node_By_Persist_Id(p_persistent_node_id, l_reference_id);

Line 1656: FROM cz_model_ref_expls

1652: -- the model containing the actual reference (263) node
1653:
1654: -- Let's go through the reference chain starting from this model down to the referred model
1655: FOR i in (SELECT model_ref_expl_id, child_model_expl_id, model_id
1656: FROM cz_model_ref_expls
1657: START WITH model_ref_expl_Id = p_expl_id
1658: CONNECT BY PRIOR child_model_expl_id = model_ref_expl_Id
1659: AND deleted_flag = G_NO_FLAG)
1660: LOOP

Line 1751: l_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

1747: p_ps_node_id IN NUMBER,
1748: p_component_id IN NUMBER,
1749: p_ps_node_type IN NUMBER) RETURN NUMBER IS
1750:
1751: l_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
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

Line 1775: FROM CZ_MODEL_REF_EXPLS a

1771: ELSE
1772: IF p_ps_node_type IN (G_REFERENCE_TYPE, G_CONNECTOR_TYPE) THEN
1773: SELECT MIN(model_ref_expl_id)
1774: INTO l_model_ref_expl_id
1775: FROM CZ_MODEL_REF_EXPLS a
1776: WHERE model_id = p_model_id AND
1777: referring_node_id = p_ps_node_id AND
1778: deleted_flag = G_NO_FLAG;
1779: ELSE

Line 1782: FROM CZ_MODEL_REF_EXPLS

1778: deleted_flag = G_NO_FLAG;
1779: ELSE
1780: SELECT MIN(model_ref_expl_id)
1781: INTO l_model_ref_expl_id
1782: FROM CZ_MODEL_REF_EXPLS
1783: WHERE model_id = p_model_id AND
1784: component_id = p_component_id AND
1785: referring_node_id IS NULL AND
1786: deleted_flag = G_NO_FLAG;

Line 3337: (SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS

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

Line 3564: FROM CZ_MODEL_REF_EXPLS

3560: g_ps_node_persist_id_tbl(i.persistent_node_id) := i.ps_node_id;
3561: END LOOP;
3562:
3563: FOR i IN(SELECT model_ref_expl_id,referring_node_id,component_id
3564: FROM CZ_MODEL_REF_EXPLS
3565: WHERE model_id=g_UI_Context.devl_project_id AND
3566: deleted_flag=G_NO_FLAG)
3567: LOOP
3568: IF i.referring_node_id IS NOT NULL THEN

Line 5540: FROM CZ_MODEL_REF_EXPLS

5536:
5537:
5538: -- validation of expl_id
5539: SELECT model_ref_expl_id INTO l_model_ref_expl_id
5540: FROM CZ_MODEL_REF_EXPLS
5541: WHERE model_ref_expl_id=p_ui_node_expl_id;
5542:
5543: --
5544: -- AMN of UI node belongs to referenced model

Line 5550: FROM CZ_MODEL_REF_EXPLS

5546:
5547:
5548: FOR i IN(SELECT model_ref_expl_id,parent_expl_node_id,ps_node_type,
5549: component_id,referring_node_id
5550: FROM CZ_MODEL_REF_EXPLS
5551: START WITH model_ref_expl_id=p_ui_node_expl_id
5552: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND
5553: deleted_flag='0')
5554: LOOP

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

5569: IF (l_ps_node_type NOT IN(G_REFERENCE_TYPE,G_CONNECTOR_TYPE) OR p_ui_node_expl_id=i.model_ref_expl_id) THEN
5570:
5571:
5572: SELECT model_ref_expl_id INTO l_expl_id FROM
5573: (SELECT model_ref_expl_id,referring_node_id,component_id FROM CZ_MODEL_REF_EXPLS
5574: START WITH model_ref_expl_id=i.model_ref_expl_id
5575: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag='0') a
5576: WHERE (l_ps_node_type IN(G_REFERENCE_TYPE,G_CONNECTOR_TYPE) AND a.referring_node_id=l_ps_node_id) OR
5577: (l_ps_node_type NOT IN(G_REFERENCE_TYPE,G_CONNECTOR_TYPE) AND a.component_id=l_component_id);

Line 9643: (SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS

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

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

9801: ,G_NO_FLAG
9802: );
9803:
9804: -- find model to which model ref expl node with i.model_ref_expl_id belongs to
9805: FOR k IN(SELECT component_id, ps_node_type FROM CZ_MODEL_REF_EXPLS
9806: START WITH model_ref_expl_id=i.model_ref_expl_id
9807: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND deleted_flag='0')
9808: LOOP
9809: IF k.ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE THEN

Line 15795: (SELECT refexpl.component_id FROM CZ_MODEL_REF_EXPLS refexpl

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

Line 15805: SELECT MIN(model_ref_expl_id) INTO l_expl_id FROM CZ_MODEL_REF_EXPLS

15801: CONNECT BY PRIOR ps_node_id=parent_id AND deleted_flag='0'
15802: )
15803: LOOP
15804:
15805: SELECT MIN(model_ref_expl_id) INTO l_expl_id FROM CZ_MODEL_REF_EXPLS
15806: WHERE model_id=g_UI_Context.devl_project_id AND deleted_flag='0' AND
15807: ((t.ps_node_type NOT IN(G_REFERENCE_TYPE,G_CONNECTOR_TYPE) AND component_id=t.component_id) OR
15808: (t.ps_node_type IN(G_REFERENCE_TYPE,G_CONNECTOR_TYPE) AND referring_node_id=t.ps_node_id));
15809:

Line 17298: FOR i IN(SELECT * FROM CZ_MODEL_REF_EXPLS

17294:
17295: IF NVL(g_UI_Context.suppress_refresh_flag,G_NO_FLAG)=G_YES_FLAG
17296: OR NVL(g_UI_Context.empty_ui_flag,G_NO_FLAG)=G_YES_FLAG THEN
17297:
17298: FOR i IN(SELECT * FROM CZ_MODEL_REF_EXPLS
17299: WHERE model_id=g_UI_Context.devl_project_id AND
17300: ps_node_type=G_REFERENCE_TYPE AND deleted_flag='0')
17301: LOOP
17302: BEGIN

Line 17524: -- cz_ui_page_refs, cz_ui_page_sets , cz_ui_actions with cz_model_ref_Expls table.

17520: NULL;
17521: END log_message;
17522:
17523: --bug14029835 , Added procedure that checks the data in cz_ui_page_elements, cz_ui_pages
17524: -- cz_ui_page_refs, cz_ui_page_sets , cz_ui_actions with cz_model_ref_Expls table.
17525: -- Logically deletes the invalid elements.
17526: PROCEDURE delete_Invalid_UI_Elements(p_ui_def_id IN NUMBER) IS
17527:
17528: BEGIN

Line 17544: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS

17540: -- Verify for cz_ui_pages.pagebase_expl_node_id
17541: FOR uiPages IN (SELECT uipg.page_id,uipg.pagebase_expl_node_id FROM CZ_UI_PAGES uipg
17542: WHERE deleted_flag = G_NO_FLAG AND ui_def_id = uiDefCur.ref_ui_def_id
17543: AND uipg.pagebase_expl_node_id IS NOT NULL
17544: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
17545: WHERE deleted_flag = G_NO_FLAG AND model_ref_expl_id = uipg.pagebase_expl_node_id
17546: )
17547: )
17548: LOOP

Line 17564: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS

17560: -- Verify for cz_ui_page_refs.target_expl_node_id
17561: FOR pageRefs IN (SELECT pgref.page_ref_id,pgref.target_expl_node_id FROM CZ_UI_PAGE_REFS pgref
17562: WHERE pgref.deleted_flag = G_NO_FLAG AND pgref.ui_def_id = uiDefCur.ref_ui_def_id
17563: AND pgref.target_expl_node_id IS NOT NULL
17564: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
17565: WHERE deleted_flag = G_NO_FLAG AND model_ref_expl_id = pgref.target_expl_node_id
17566: )
17567: )
17568: LOOP

Line 17584: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS

17580: -- Verify for cz_ui_page_sets.pagebase_expl_node_id
17581: FOR pageSets IN (SELECT pgset.page_set_id,pgset.pagebase_expl_node_id FROM CZ_UI_PAGE_SETS pgset
17582: WHERE pgset.deleted_flag = G_NO_FLAG AND pgset.ui_def_id = uiDefCur.ref_ui_def_id
17583: AND pgset.pagebase_expl_node_id IS NOT NULL
17584: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
17585: WHERE deleted_flag = G_NO_FLAG AND model_ref_expl_id = pgset.pagebase_expl_node_id
17586: )
17587: )
17588: LOOP

Line 17603: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS

17599: -- Verify for cz_ui_page_elements.model_ref_expl_id
17600: FOR uiPges IN (SELECT element_id,model_ref_expl_id FROM CZ_UI_PAGE_ELEMENTS pge
17601: WHERE pge.deleted_flag = G_NO_FLAG AND pge.ui_def_id = uiDefCur.ref_ui_def_id
17602: AND pge.model_ref_expl_id IS NOT NULL
17603: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
17604: WHERE deleted_flag = G_NO_FLAG AND model_ref_expl_id = pge.model_ref_expl_id
17605: )
17606: )
17607: LOOP

Line 17624: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS

17620: -- Verify for cz_ui_actions.target_expl_node_id
17621: FOR uiActs IN (SELECT uiact.ui_action_id,uiact.target_expl_node_id FROM CZ_UI_ACTIONS uiact
17622: WHERE uiact.deleted_flag = G_NO_FLAG AND uiact.ui_def_id = uiDefCur.ref_ui_def_id
17623: AND uiact.target_expl_node_id IS NOT NULL
17624: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
17625: WHERE deleted_flag = G_NO_FLAG AND model_ref_expl_id = uiact.target_expl_node_id
17626: )
17627: )
17628: LOOP

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

21762: WHERE ui_def_id=p_ui_def_id AND
21763: parent_page_ref_id=i.page_ref_id AND
21764: deleted_flag=G_NO_FLAG;
21765:
21766: SELECT MIN(model_ref_expl_id) INTO l_expl_node_id FROM CZ_MODEL_REF_EXPLS
21767: WHERE model_id=g_UI_Context.devl_project_id AND
21768: referring_node_id=p_ref_persistent_node_id AND
21769: deleted_flag=G_NO_FLAG;
21770: