APPS.CZ_PS_COPY dependencies on CZ_FUNC_COMP_SPECS

Line 72: Sequences(14).name:='CZ_FUNC_COMP_SPECS_S';

68: Sequences(10).name:='CZ_GRID_COLS_S';
69: Sequences(11).name:='CZ_GRID_CELLS_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;

Line 829: FOR i IN (SELECT * FROM CZ_FUNC_COMP_SPECS

825: new_model_ref_expl_id INTEGER;
826:
827: BEGIN
828:
829: FOR i IN (SELECT * FROM CZ_FUNC_COMP_SPECS
830: WHERE DEVL_PROJECT_ID=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
831: LOOP
832: BEGIN
833: get_Next_Val(new_id,'CZ_FUNC_COMP_SPECS_S');

Line 833: get_Next_Val(new_id,'CZ_FUNC_COMP_SPECS_S');

829: FOR i IN (SELECT * FROM CZ_FUNC_COMP_SPECS
830: WHERE DEVL_PROJECT_ID=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
831: LOOP
832: BEGIN
833: get_Next_Val(new_id,'CZ_FUNC_COMP_SPECS_S');
834:
835: IF i.component_id IS NOT NULL THEN
836: BEGIN
837: new_component_id:=FlowId_PS_NODE(i.component_id);

Line 868: INSERT INTO CZ_FUNC_COMP_SPECS(

864: ELSE
865: new_model_ref_expl_id:=NULL;
866: END IF;
867:
868: INSERT INTO CZ_FUNC_COMP_SPECS(
869: FUNC_COMP_ID,
870: COMPANION_TYPE,
871: DEVL_PROJECT_ID,
872: COMPONENT_ID,

Line 2458: FOR i IN (SELECT * FROM CZ_FUNC_COMP_SPECS

2454: BEGIN
2455:
2456: Initialize;
2457:
2458: FOR i IN (SELECT * FROM CZ_FUNC_COMP_SPECS
2459: WHERE DEVL_PROJECT_ID=p_project_id
2460: AND RULE_FOLDER_ID=p_old_rule_folder_id AND deleted_flag=NO_FLAG)
2461: LOOP
2462: get_Next_Val(new_id,'CZ_FUNC_COMP_SPECS_S');

Line 2462: get_Next_Val(new_id,'CZ_FUNC_COMP_SPECS_S');

2458: FOR i IN (SELECT * FROM CZ_FUNC_COMP_SPECS
2459: WHERE DEVL_PROJECT_ID=p_project_id
2460: AND RULE_FOLDER_ID=p_old_rule_folder_id AND deleted_flag=NO_FLAG)
2461: LOOP
2462: get_Next_Val(new_id,'CZ_FUNC_COMP_SPECS_S');
2463:
2464: INSERT INTO CZ_FUNC_COMP_SPECS
2465: (FUNC_COMP_ID,
2466: COMPANION_TYPE,

Line 2464: INSERT INTO CZ_FUNC_COMP_SPECS

2460: AND RULE_FOLDER_ID=p_old_rule_folder_id AND deleted_flag=NO_FLAG)
2461: LOOP
2462: get_Next_Val(new_id,'CZ_FUNC_COMP_SPECS_S');
2463:
2464: INSERT INTO CZ_FUNC_COMP_SPECS
2465: (FUNC_COMP_ID,
2466: COMPANION_TYPE,
2467: DEVL_PROJECT_ID,
2468: COMPONENT_ID,

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 2521: FOR i IN(SELECT component_id FROM CZ_FUNC_COMP_SPECS

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
2523: AND func_comp_id=p_func_comp_id AND deleted_flag=NO_FLAG)
2524: LOOP
2525: var_component_id:=i.component_id;

Line 2528: FOR i IN (SELECT * FROM CZ_FUNC_COMP_SPECS

2524: LOOP
2525: var_component_id:=i.component_id;
2526: END LOOP;
2527:
2528: FOR i IN (SELECT * FROM CZ_FUNC_COMP_SPECS
2529: WHERE func_comp_id=p_func_comp_id
2530: AND devl_project_id=p_project_id AND deleted_flag=NO_FLAG)
2531: LOOP
2532:

Line 2539: INSERT INTO CZ_FUNC_COMP_SPECS(

2535: ELSE
2536: new_rule_folder_id:=i.rule_folder_id;
2537: END IF;
2538:
2539: INSERT INTO CZ_FUNC_COMP_SPECS(
2540: FUNC_COMP_ID,
2541: COMPANION_TYPE,
2542: DEVL_PROJECT_ID,
2543: COMPONENT_ID,

Line 2753: SELECT devl_project_id INTO OLD_PROJECT_ID FROM CZ_FUNC_COMP_SPECS

2749: RAISE END_OPERATION;
2750: END IF;
2751:
2752: IF p_FUNC_COMP_Flag='1' THEN
2753: SELECT devl_project_id INTO OLD_PROJECT_ID FROM CZ_FUNC_COMP_SPECS
2754: WHERE func_comp_id=p_rule_id AND deleted_flag=NO_FLAG;
2755: NEW_PROJECT_ID:=OLD_PROJECT_ID;
2756: COPY_FUNC_COMPANION(p_rule_id,OLD_PROJECT_ID,NULL,p_out_new_rule_id);
2757: RAISE END_OPERATION;