APPS.CZ_PS_COPY dependencies on CZ_MODEL_REF_EXPLS

Line 74: Sequences(16).name:='CZ_MODEL_REF_EXPLS_S';

70: Sequences(12).name:='CZ_UI_DEFS_S';
71: Sequences(13).name:='CZ_UI_NODES_S';
72: Sequences(14).name:='CZ_FUNC_COMP_SPECS_S';
73: Sequences(15).name:='CZ_INTL_TEXTS_S';
74: Sequences(16).name:='CZ_MODEL_REF_EXPLS_S';
75:
76: FlowId_PS_NODE.DELETE;
77: FlowId_INTL_TEXT.DELETE;
78: FlowId_EXPRESSION.DELETE;

Line 561: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

557: new_child_model_expl_id INTEGER;
558:
559: BEGIN
560:
561: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
562: WHERE model_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
563: LOOP
564: get_Next_Val(new_id,'CZ_MODEL_REF_EXPLS_S');
565: FlowId_MODEL_REF_EXPL(i.model_ref_expl_id):=new_id;

Line 564: get_Next_Val(new_id,'CZ_MODEL_REF_EXPLS_S');

560:
561: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
562: WHERE model_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
563: LOOP
564: get_Next_Val(new_id,'CZ_MODEL_REF_EXPLS_S');
565: FlowId_MODEL_REF_EXPL(i.model_ref_expl_id):=new_id;
566: END LOOP;
567:
568: FOR i IN (SELECT * FROM CZ_MODEL_REF_EXPLS

Line 568: FOR i IN (SELECT * FROM CZ_MODEL_REF_EXPLS

564: get_Next_Val(new_id,'CZ_MODEL_REF_EXPLS_S');
565: FlowId_MODEL_REF_EXPL(i.model_ref_expl_id):=new_id;
566: END LOOP;
567:
568: FOR i IN (SELECT * FROM CZ_MODEL_REF_EXPLS
569: WHERE model_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
570: LOOP
571: IF i.parent_expl_node_id IS NOT NULL THEN
572: new_parent:=FlowId_MODEL_REF_EXPL(i.parent_expl_node_id);

Line 611: INSERT INTO CZ_MODEL_REF_EXPLS

607: ELSE
608: new_child_model_expl_id:=NULL;
609: END IF;
610:
611: INSERT INTO CZ_MODEL_REF_EXPLS
612: (model_ref_expl_id,
613: parent_expl_node_id,
614: referring_node_id,
615: model_id,