eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_UPGRADE dependencies on CZ_DEVL_PROJECTS

Line 22: FOR c_devl IN (SELECT devl_project_id, orig_sys_ref FROM cz_devl_projects p

18: PROCEDURE generate_xfr_reference_bills IS
19:
20: BEGIN
21:
22: FOR c_devl IN (SELECT devl_project_id, orig_sys_ref FROM cz_devl_projects p
23: WHERE deleted_flag = flag_not_deleted
24: AND devl_project_id <> 0
25: AND orig_sys_ref is not NULL
26: AND EXISTS (SELECT NULL FROM cz_rp_entries

Line 60: TYPE devl_project_id_table IS TABLE OF cz_devl_projects.devl_project_id%TYPE INDEX BY BINARY_INTEGER;

56: -----------------------------------------------------
57:
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';

Line 61: TYPE orig_sys_ref_table IS TABLE OF cz_devl_projects.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

57:
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';

Line 80: v_pr_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE := 'DUMMY';

76: v_ui_style VARCHAR2(3);
77: v_product_key cz_model_publications.product_key%TYPE;
78: v_top_item_id NUMBER;
79: v_org_id NUMBER;
80: v_pr_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE := 'DUMMY';
81: v_pb_run_id NUMBER;
82: v_pb_status VARCHAR2(3);
83: v_base_language cz_pb_languages.language%TYPE;
84: xERROR BOOLEAN:=FALSE;

Line 93: CURSOR ui_def_cur(v_models cz_devl_projects.devl_project_id%TYPE) IS

89: FROM cz_model_publications
90: WHERE cz_model_publications.export_status = 'PEN'
91: AND cz_model_publications.product_key like '%:%';
92:
93: CURSOR ui_def_cur(v_models cz_devl_projects.devl_project_id%TYPE) IS
94: SELECT ui_def_id, ui_style
95: FROM cz_ui_defs
96: WHERE cz_ui_defs.devl_project_id = v_models
97: AND deleted_flag = '0'

Line 119: p_models cz_devl_projects.devl_project_id%TYPE) AS

115: END;
116:
117: PROCEDURE insert_publication(p_ui_def_id NUMBER,
118: p_ui_style VARCHAR2,
119: p_models cz_devl_projects.devl_project_id%TYPE) AS
120: v_application_id cz_ext_applications_v.application_id%TYPE;
121: v_application_short_name cz_ext_applications_v.application_short_name%TYPE;
122: BEGIN
123: get_base_language(v_base_language);

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 204: WHERE cz_devl_projects.ORIG_SYS_REF IS NOT NULL

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'
208: AND cz_devl_projects.devl_project_id = cz_xfr_project_bills.model_ps_node_id(+)

Line 205: AND cz_devl_projects.deleted_flag = '0'

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'
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;

Line 206: AND cz_devl_projects.devl_project_id = cz_rp_entries.object_id

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'
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:

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 553: FOR c_devl IN (SELECT devl_project_id, orig_sys_ref FROM cz_devl_projects p

549: )))));
550:
551: COMMIT;
552:
553: FOR c_devl IN (SELECT devl_project_id, orig_sys_ref FROM cz_devl_projects p
554: WHERE deleted_flag = flag_not_deleted
555: AND devl_project_id <> 0
556: AND EXISTS (
557: SELECT NULL FROM cz_ps_nodes

Line 568: UPDATE cz_devl_projects SET

564: ) LOOP
565:
566: IF(c_devl.orig_sys_ref IS NOT NULL)THEN
567:
568: UPDATE cz_devl_projects SET
569: orig_sys_ref =
570: (SELECT nvl(substr(parent.orig_sys_ref,instr(parent.orig_sys_ref,':',-1,3)+1),
571: substr(child.orig_sys_ref,instr(child.orig_sys_ref,':',-1,3)+1))
572: FROM cz_ps_nodes parent, cz_ps_nodes child

Line 582: (SELECT orig_sys_ref FROM cz_devl_projects WHERE devl_project_id = c_devl.devl_project_id)

578: WHERE devl_project_id = c_devl.devl_project_id;
579:
580: UPDATE cz_ps_nodes SET
581: orig_sys_ref =
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,

Line 938: INSERT INTO cz_devl_projects

934: parent_rule_folder_id IS NULL AND name=ntname(i)||' Rules');
935:
936: --Insert and take care of orig_sys_ref
937:
938: INSERT INTO cz_devl_projects
939: (devl_project_id, name, persistent_project_id, deleted_flag, orig_sys_ref)
940: SELECT
941: ntpsnodeid(i), genname, ntpsnodeid(i), flag_not_deleted,
942: substr(ntorigsysref(i),instr(ntorigsysref(i),':',-1,3)+1,instr(ntorigsysref(i),':',-1,2)-instr(ntorigsysref(i),':',-1,3)-1) || ':' ||

Line 946: (SELECT NULL FROM cz_devl_projects WHERE devl_project_id = ntpsnodeid(i));

942: substr(ntorigsysref(i),instr(ntorigsysref(i),':',-1,3)+1,instr(ntorigsysref(i),':',-1,2)-instr(ntorigsysref(i),':',-1,3)-1) || ':' ||
943: substr(ntorigsysref(i),instr(ntorigsysref(i),':',-1,2)+1,instr(ntorigsysref(i),':',-1,1)-instr(ntorigsysref(i),':',-1,2)-1) || ':' ||
944: stopitemid /*substr(ntOrigSysRef(i),instr(ntOrigSysRef(i),':',-1,1)+1)*/
945: FROM dual WHERE NOT EXISTS
946: (SELECT NULL FROM cz_devl_projects WHERE devl_project_id = ntpsnodeid(i));
947:
948: --Insert into cz_rp_entries
949:
950: INSERT INTO cz_rp_entries

Line 1033: TYPE tDevlProjectId IS TABLE OF cz_devl_projects.devl_project_id%TYPE;

1029: --------procedure that upgrades logic from a 14 build to a 18 build
1030: PROCEDURE upgrade_logic_from_14
1031: IS
1032:
1033: TYPE tDevlProjectId IS TABLE OF cz_devl_projects.devl_project_id%TYPE;
1034: runId number;
1035: devlProjectId tDevlProjectId;
1036: v_rule_count number := 0;
1037:

Line 1044: FROM cz_devl_projects

1040: SELECT devl_project_id
1041: BULK
1042: COLLECT
1043: INTO devlProjectId
1044: FROM cz_devl_projects
1045: WHERE cz_devl_projects.deleted_flag = '0'
1046: AND cz_devl_projects.devl_project_id IN (SELECT object_id
1047: FROM cz_rp_entries
1048: WHERE cz_rp_entries.deleted_flag = '0'

Line 1045: WHERE cz_devl_projects.deleted_flag = '0'

1041: BULK
1042: COLLECT
1043: INTO devlProjectId
1044: FROM cz_devl_projects
1045: WHERE cz_devl_projects.deleted_flag = '0'
1046: AND cz_devl_projects.devl_project_id IN (SELECT object_id
1047: FROM cz_rp_entries
1048: WHERE cz_rp_entries.deleted_flag = '0'
1049: AND cz_rp_entries.object_type = 'PRJ');

Line 1046: AND cz_devl_projects.devl_project_id IN (SELECT object_id

1042: COLLECT
1043: INTO devlProjectId
1044: FROM cz_devl_projects
1045: WHERE cz_devl_projects.deleted_flag = '0'
1046: AND cz_devl_projects.devl_project_id IN (SELECT object_id
1047: FROM cz_rp_entries
1048: WHERE cz_rp_entries.deleted_flag = '0'
1049: AND cz_rp_entries.object_type = 'PRJ');
1050:

Line 1756: thisProjectId cz_devl_projects.devl_project_id%TYPE;

1752: v_IndexByNodeId tIntegerArray;
1753: v_TypeByExplId tExplNodeType;
1754:
1755: thisComponentExplId cz_model_ref_expls.model_ref_expl_id%TYPE;
1756: thisProjectId cz_devl_projects.devl_project_id%TYPE;
1757: thisRootExplIndex PLS_INTEGER;
1758:
1759: i PLS_INTEGER;
1760: j PLS_INTEGER;

Line 2738: FROM cz_devl_projects

2734:
2735: --Get the project name for reporting purposes
2736:
2737: SELECT name INTO errorMessage
2738: FROM cz_devl_projects
2739: WHERE devl_project_id = inProjectId;
2740:
2741: EXCEPTION
2742: WHEN OTHERS THEN