APPS.CZ_UPGRADE dependencies on CZ_XFR_PROJECT_BILLS

Line 17: -- generate cz_xfr_project_bills for references

13: current_node_id NUMBER;
14:
15: root_model_id NUMBER;
16:
17: -- generate cz_xfr_project_bills for references
18: PROCEDURE generate_xfr_reference_bills IS
19:
20: BEGIN
21:

Line 30: AND NOT EXISTS (SELECT NULL FROM cz_xfr_project_bills

26: AND EXISTS (SELECT NULL FROM cz_rp_entries
27: WHERE object_id = p.devl_project_id
28: AND object_type = 'PRJ'
29: AND deleted_flag = flag_not_deleted)
30: AND NOT EXISTS (SELECT NULL FROM cz_xfr_project_bills
31: WHERE model_ps_node_id = p.devl_project_id )
32: )
33: LOOP
34:

Line 35: INSERT INTO cz_xfr_project_bills (model_ps_node_id,

31: WHERE model_ps_node_id = p.devl_project_id )
32: )
33: LOOP
34:
35: INSERT INTO cz_xfr_project_bills (model_ps_node_id,
36: organization_id,
37: top_item_id,
38: explosion_type,
39: deleted_flag,

Line 62: TYPE last_import_date_table IS TABLE OF cz_xfr_project_bills.last_import_date%TYPE INDEX BY BINARY_INTEGER;

58: PROCEDURE AUTO_PUBLISH(p_server_id NUMBER) IS
59:
60: TYPE devl_project_id_table IS TABLE OF cz_devl_projects.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
61: TYPE orig_sys_ref_table IS TABLE OF cz_devl_projects.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
62: TYPE last_import_date_table IS TABLE OF cz_xfr_project_bills.last_import_date%TYPE INDEX BY BINARY_INTEGER;
63:
64: APPLET constant VARCHAR2(3) := '3';
65: DHTML constant VARCHAR2(3) := '0';
66: v_models_to_be_published devl_project_id_table;

Line 203: FROM cz_devl_projects, cz_rp_entries, cz_xfr_project_bills

199: COLLECT
200: INTO v_models_to_be_published,
201: v_orig_sys_ref,
202: v_last_import_date
203: FROM cz_devl_projects, cz_rp_entries, cz_xfr_project_bills
204: WHERE cz_devl_projects.ORIG_SYS_REF IS NOT NULL
205: AND cz_devl_projects.deleted_flag = '0'
206: AND cz_devl_projects.devl_project_id = cz_rp_entries.object_id
207: AND cz_rp_entries.object_type = 'PRJ' and cz_rp_entries.deleted_flag = '0'

Line 208: AND cz_devl_projects.devl_project_id = cz_xfr_project_bills.model_ps_node_id(+)

204: WHERE cz_devl_projects.ORIG_SYS_REF IS NOT NULL
205: AND cz_devl_projects.deleted_flag = '0'
206: AND cz_devl_projects.devl_project_id = cz_rp_entries.object_id
207: AND cz_rp_entries.object_type = 'PRJ' and cz_rp_entries.deleted_flag = '0'
208: AND cz_devl_projects.devl_project_id = cz_xfr_project_bills.model_ps_node_id(+)
209: ORDER BY orig_sys_ref, last_import_date DESC;
210:
211: IF (v_models_to_be_published.COUNT > 0 ) THEN
212:

Line 392: -- insert cz_xfr_project_bills records for references

388: cz_pb_mgr.log_pb_errors(SQLERRM,1,'AUTO PUBLISH',SQLCODE);
389: END;
390: END LOOP;
391:
392: -- insert cz_xfr_project_bills records for references
393: generate_xfr_reference_bills;
394: COMMIT;
395:
396: EXCEPTION

Line 586: INSERT INTO cz_xfr_project_bills (model_ps_node_id,

582: (SELECT orig_sys_ref FROM cz_devl_projects WHERE devl_project_id = c_devl.devl_project_id)
583: WHERE ps_node_id = c_devl.devl_project_id
584: returning orig_sys_ref INTO v_origsysref;
585:
586: INSERT INTO cz_xfr_project_bills (model_ps_node_id,
587: organization_id,
588: top_item_id,
589: explosion_type,
590: deleted_flag,

Line 601: WHERE NOT EXISTS (SELECT NULL FROM cz_xfr_project_bills

597: '0',
598: 0,
599: sysdate -- fix for bug # 2406244
600: FROM dual
601: WHERE NOT EXISTS (SELECT NULL FROM cz_xfr_project_bills
602: WHERE model_ps_node_id = c_devl.devl_project_id);
603:
604: END IF;
605: