APPS.CZ_PS_COPY dependencies on CZ_PS_NODES_S

Line 59: Sequences(1).name:='CZ_PS_NODES_S';

55:
56: PROCEDURE Initialize IS
57: BEGIN
58: numRecords:=0;
59: Sequences(1).name:='CZ_PS_NODES_S';
60: Sequences(2).name:='CZ_FILTER_SETS_S';
61: Sequences(3).name:='CZ_SUB_CON_SETS_S';
62: Sequences(4).name:='CZ_EXPRESSIONS_S';
63: Sequences(5).name:='CZ_RULES_S';

Line 224: SELECT CZ_PS_NODES_S.NEXTVAL INTO NEW_PROJECT_ID FROM dual;

220: var_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
221:
222: BEGIN
223:
224: SELECT CZ_PS_NODES_S.NEXTVAL INTO NEW_PROJECT_ID FROM dual;
225: SELECT * INTO i FROM CZ_DEVL_PROJECTS
226: WHERE DEVL_PROJECT_ID=OLD_PROJECT_ID AND deleted_flag=NO_FLAG;
227:
228: GLOBAL_ORIG_SYS_REF:=i.ORIG_SYS_REF;

Line 659: get_Next_Val(new_id,'CZ_PS_NODES_S');

655:
656: FOR i IN (SELECT ps_node_id FROM CZ_PS_NODES
657: WHERE devl_project_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
658: LOOP
659: get_Next_Val(new_id,'CZ_PS_NODES_S');
660: FlowId_PS_NODE(i.ps_node_id):=new_id;
661: END LOOP;
662:
663: FlowId_PS_NODE(OLD_PROJECT_ID):=NEW_PROJECT_ID;

Line 996: UPDATE CZ_PS_NODES SET from_populator_id=FlowId_POPULATOR(k)

992: LOOP
993: IF k IS NULL THEN
994: EXIT;
995: END IF;
996: UPDATE CZ_PS_NODES SET from_populator_id=FlowId_POPULATOR(k)
997: WHERE from_populator_id=k AND devl_project_id=NEW_PROJECT_ID;
998: k:=FlowId_POPULATOR.NEXT(k);
999: END LOOP;
1000: END IF;

Line 2279: get_Next_Val(new_id,'CZ_PS_NODES_S');

2275: WHERE devl_project_id=p_project_id AND deleted_flag=NO_FLAG
2276: START WITH parent_id=p_parent_id
2277: CONNECT BY PRIOR ps_node_id=parent_id)
2278: LOOP
2279: get_Next_Val(new_id,'CZ_PS_NODES_S');
2280: FlowId_PS_NODE(i.ps_node_id):=new_id;
2281:
2282: IF i.parent_id=p_parent_id THEN
2283: p_out_new_root:=new_id;