APPS.CZ_PS_COPY dependencies on DUAL

Line 156: EXECUTE IMMEDIATE 'SELECT '||p_sequence_name||'.NEXTVAL FROM dual'

152: IF p_sequence_name=Sequences(i).name THEN
153: IF NVL(p_id,1)>=NVL(Sequences(i).id,-INCREMENT)+INCREMENT-1
154: OR (p_id IS NULL AND Sequences(i).id IS NOT NULL) THEN
155:
156: EXECUTE IMMEDIATE 'SELECT '||p_sequence_name||'.NEXTVAL FROM dual'
157: INTO var_id;
158:
159: p_id:=var_id;
160: Sequences(i).id:=var_id;

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 932: SELECT CZ_POPULATORS_S.NEXTVAL INTO new_id FROM dual;

928: AND EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=OLD_PROJECT_ID
929: AND ps_node_id=a.owned_by_node_id AND deleted_flag=NO_FLAG))
930: LOOP
931: BEGIN
932: SELECT CZ_POPULATORS_S.NEXTVAL INTO new_id FROM dual;
933:
934: new_node_id:=FlowId_PS_NODE(i.owned_by_node_id);
935: new_filter_id:=FlowId_FILTER_SET(i.filter_set_id);
936:

Line 2264: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;

2260:
2261: /* Exception is raised for BUG No.4028599*/
2262: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');
2263:
2264: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
2265:
2266: Initialize;
2267:
2268: IF p_new_project_id IS NULL THEN

Line 2518: SELECT CZ_FUNC_COMP_SPECS_S.NEXTVAL INTO p_out_new_func_comp_id FROM dual;

2514:
2515: /* Exception is raised for BUG No.4028599*/
2516: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');
2517:
2518: SELECT CZ_FUNC_COMP_SPECS_S.NEXTVAL INTO p_out_new_func_comp_id FROM dual;
2519:
2520: var_component_id:=NULL;
2521: FOR i IN(SELECT component_id FROM CZ_FUNC_COMP_SPECS
2522: WHERE devl_project_id=p_project_id

Line 2738: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;

2734:
2735: /* Exception is raised for BUG No.4028599*/
2736: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');
2737:
2738: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
2739:
2740: p_out_new_rule_id:=0;
2741:
2742: Initialize;

Line 3089: SELECT CZ_RULE_FOLDERS_S.NEXTVAL INTO p_new_rule_seq_id FROM dual;

3085:
3086: /* Exception is raised for BUG No.4028599*/
3087: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');
3088:
3089: SELECT CZ_RULE_FOLDERS_S.NEXTVAL INTO p_new_rule_seq_id FROM dual;
3090: INSERT INTO CZ_RULE_FOLDERS
3091: (RULE_FOLDER_ID,
3092: FOLDER_TYPE,
3093: NAME,

Line 3196: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;

3192:
3193: /* Exception is raised for BUG No.4028599*/
3194: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');
3195:
3196: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
3197: Initialize;
3198:
3199: OLD_PROJECT_ID:=p_old_id;
3200: ENCLOSE_FOLDER:=p_folder_id;