APPS.CZ_POPULATORS_PKG dependencies on CZ_MODEL_REF_EXPLS

Line 1130: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag='1'

1126: -- delete an associated non-virtual components --
1127: --
1128: IF t_ps_node_id.Count>0 THEN
1129: FORALL i IN t_ps_node_id.First..t_ps_node_id.Last
1130: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag='1'
1131: WHERE model_id=t_devl_project(i) AND
1132: model_ref_expl_id
1133: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1134: WHERE deleted_flag='0'

Line 1133: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1129: FORALL i IN t_ps_node_id.First..t_ps_node_id.Last
1130: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag='1'
1131: WHERE model_id=t_devl_project(i) AND
1132: model_ref_expl_id
1133: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1134: WHERE deleted_flag='0'
1135: START WITH component_id=t_ps_node_id(i)
1136: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id);
1137:

Line 1193: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag='1'

1189: -- delete an associated non-virtual components --
1190: --
1191: IF t_ps_node_id.Count>0 THEN
1192: FORALL i IN t_ps_node_id.First..t_ps_node_id.Last
1193: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag='1'
1194: WHERE model_id=t_devl_project(i) AND
1195: model_ref_expl_id
1196: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1197: WHERE deleted_flag='0'

Line 1196: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1192: FORALL i IN t_ps_node_id.First..t_ps_node_id.Last
1193: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag='1'
1194: WHERE model_id=t_devl_project(i) AND
1195: model_ref_expl_id
1196: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1197: WHERE deleted_flag='0'
1198: START WITH component_id=t_ps_node_id(i)
1199: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id);
1200: