APPS.CZ_RUNTIME dependencies on CZ_MODEL_REF_EXPLS

Line 865: SELECT component_id,model_id INTO l_component_id, l_model_id FROM CZ_MODEL_REF_EXPLS

861: l_target_ps_node_id NUMBER;
862: l_path VARCHAR2(2000);
863:
864: BEGIN
865: SELECT component_id,model_id INTO l_component_id, l_model_id FROM CZ_MODEL_REF_EXPLS
866: WHERE model_ref_expl_id=p_target_page_expl_id;
867:
868: SELECT persistent_node_id INTO l_root_persist_id FROM CZ_PS_NODES
869: WHERE devl_project_id=p_root_model_id AND parent_id IS NULL AND deleted_flag='0';

Line 874: SELECT model_ref_expl_id INTO l_model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

870:
871: IF p_root_model_id=l_model_id THEN
872: SELECT ps_node_id INTO l_target_ps_node_id FROM CZ_PS_NODES WHERE devl_project_id=l_model_id AND
873: persistent_node_id=p_target_page_persist_id AND deleted_flag='0';
874: SELECT model_ref_expl_id INTO l_model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
875: WHERE model_id=l_model_id AND parent_expl_node_id IS NULL AND deleted_flag='0';
876:
877: l_path := cz_developer_utils_pvt.annotated_node_path (p_root_model_id,
878: p_target_page_expl_id,

Line 888: FOR l IN(SELECT component_id,referring_node_id FROM CZ_MODEL_REF_EXPLS

884: END IF;
885:
886: ELSE
887:
888: FOR l IN(SELECT component_id,referring_node_id FROM CZ_MODEL_REF_EXPLS
889: WHERE ps_node_type=263
890: START WITH model_ref_expl_id=p_root_model_expl_id
891: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND deleted_flag='0'
892: AND PRIOR deleted_flag='0')

Line 895: SELECT l.referring_node_id INTO l_referring_node_id FROM CZ_MODEL_REF_EXPLS

891: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND deleted_flag='0'
892: AND PRIOR deleted_flag='0')
893: LOOP
894: BEGIN
895: SELECT l.referring_node_id INTO l_referring_node_id FROM CZ_MODEL_REF_EXPLS
896: WHERE model_id=l.component_id AND model_ref_expl_id=p_target_page_expl_id;
897: EXIT;
898: EXCEPTION
899: WHEN NO_DATA_FOUND THEN

Line 904: FOR i IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

900: NULL;
901: END;
902: END LOOP;
903:
904: FOR i IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
905: WHERE referring_node_id=l_referring_node_id AND deleted_flag='0'
906: START WITH model_id=p_root_model_id AND parent_expl_node_id IS NULL AND deleted_flag='0'
907: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag='0'
908: AND PRIOR deleted_flag='0')

Line 910: FOR j IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

906: START WITH model_id=p_root_model_id AND parent_expl_node_id IS NULL AND deleted_flag='0'
907: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag='0'
908: AND PRIOR deleted_flag='0')
909: LOOP
910: FOR j IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
911: WHERE component_id=l_component_id AND deleted_flag='0'
912: START WITH model_ref_expl_id=i.model_ref_expl_id
913: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag='0'
914: AND PRIOR deleted_flag='0')

Line 944: SELECT component_id,model_id INTO l_component_id,l_model_id FROM CZ_MODEL_REF_EXPLS

940: l_model_id NUMBER;
941:
942: BEGIN
943:
944: SELECT component_id,model_id INTO l_component_id,l_model_id FROM CZ_MODEL_REF_EXPLS
945: WHERE model_ref_expl_id=p_target_page_expl_id;
946:
947: IF p_root_model_id=l_model_id THEN
948: RETURN 0;

Line 951: FOR l IN(SELECT component_id,referring_node_id FROM CZ_MODEL_REF_EXPLS

947: IF p_root_model_id=l_model_id THEN
948: RETURN 0;
949: END IF;
950:
951: FOR l IN(SELECT component_id,referring_node_id FROM CZ_MODEL_REF_EXPLS
952: WHERE ps_node_type=263
953: START WITH model_ref_expl_id=p_root_model_expl_id
954: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND deleted_flag='0'
955: AND PRIOR deleted_flag='0')

Line 958: SELECT l.referring_node_id INTO l_referring_node_id FROM CZ_MODEL_REF_EXPLS

954: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND deleted_flag='0'
955: AND PRIOR deleted_flag='0')
956: LOOP
957: BEGIN
958: SELECT l.referring_node_id INTO l_referring_node_id FROM CZ_MODEL_REF_EXPLS
959: WHERE model_id=l.component_id AND model_ref_expl_id=p_target_page_expl_id;
960: EXIT;
961: EXCEPTION
962: WHEN NO_DATA_FOUND THEN

Line 967: FOR i IN(SELECT model_ref_expl_id,node_depth FROM CZ_MODEL_REF_EXPLS

963: NULL;
964: END;
965: END LOOP;
966:
967: FOR i IN(SELECT model_ref_expl_id,node_depth FROM CZ_MODEL_REF_EXPLS
968: WHERE referring_node_id=l_referring_node_id AND deleted_flag='0'
969: START WITH model_id=p_root_model_id AND parent_expl_node_id IS NULL AND deleted_flag='0'
970: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag='0'
971: AND PRIOR deleted_flag='0')

Line 973: FOR j IN (SELECT node_depth FROM CZ_MODEL_REF_EXPLS

969: START WITH model_id=p_root_model_id AND parent_expl_node_id IS NULL AND deleted_flag='0'
970: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag='0'
971: AND PRIOR deleted_flag='0')
972: LOOP
973: FOR j IN (SELECT node_depth FROM CZ_MODEL_REF_EXPLS
974: WHERE component_id=l_component_id AND deleted_flag='0'
975: START WITH model_ref_expl_id=i.model_ref_expl_id
976: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag='0'
977: AND PRIOR deleted_flag='0')