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_MODEL_PUBLICATIONS

Line 70: v_to_publish_id cz_model_publications.publication_id%TYPE;

66: v_models_to_be_published devl_project_id_table;
67: v_orig_sys_ref orig_sys_ref_table;
68: v_last_import_date last_import_date_table;
69: v_application_id cz_ext_applications_v.application_id%TYPE;
70: v_to_publish_id cz_model_publications.publication_id%TYPE;
71: v_ui_def_id NUMBER;
72: v_run_id NUMBER;
73: v_ui_def_id_tmp NUMBER;
74: v_applet_ui_def_id NUMBER;

Line 77: v_product_key cz_model_publications.product_key%TYPE;

73: v_ui_def_id_tmp NUMBER;
74: v_applet_ui_def_id NUMBER;
75: v_dhtml_ui_def_id NUMBER;
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;

Line 89: FROM cz_model_publications

85:
86:
87: CURSOR to_publish_cur IS
88: SELECT publication_id
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

Line 90: WHERE cz_model_publications.export_status = 'PEN'

86:
87: CURSOR to_publish_cur IS
88: SELECT publication_id
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

Line 91: AND cz_model_publications.product_key like '%:%';

87: CURSOR to_publish_cur IS
88: SELECT publication_id
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

Line 125: INSERT INTO cz_model_publications(

121: v_application_short_name cz_ext_applications_v.application_short_name%TYPE;
122: BEGIN
123: get_base_language(v_base_language);
124:
125: INSERT INTO cz_model_publications(
126: PUBLICATION_ID,
127: MODEL_ID,
128: SERVER_ID,
129: PRODUCT_KEY,

Line 142: VALUES ( cz_model_publications_s.NEXTVAL,

138: DELETED_FLAG,
139: SOURCE_TARGET_FLAG,
140: REMOTE_PUBLICATION_ID
141: )
142: VALUES ( cz_model_publications_s.NEXTVAL,
143: p_models,
144: p_server_id,
145: v_product_key,
146: v_org_id,

Line 169: VALUES (cz_model_publications_s.CURRVAL,

165: FND_APPLICATION_ID,
166: APPLICATION_SHORT_NAME,
167: NOTES
168: )
169: VALUES (cz_model_publications_s.CURRVAL,
170: v_application_id,
171: v_application_short_name,
172: NULL
173: );

Line 180: values (cz_model_publications_s.CURRVAL,v_base_language);

176: cz_pb_mgr.log_pb_errors(SQLERRM,1,'AUTO PUBLISH',SQLCODE);
177: END;
178:
179: INSERT INTO cz_pb_languages (publication_id,language)
180: values (cz_model_publications_s.CURRVAL,v_base_language);
181: END LOOP;
182: CLOSE appl_cur;
183:
184: INSERT INTO cz_publication_usages ( PUBLICATION_ID,

Line 187: VALUES (cz_model_publications_s.CURRVAL,

183:
184: INSERT INTO cz_publication_usages ( PUBLICATION_ID,
185: USAGE_ID
186: )
187: VALUES (cz_model_publications_s.CURRVAL,
188: -1
189: );
190: END;
191:

Line 284: update cz_model_publications set ui_style = DHTML where ui_def_id

280: IF (v_applet_ui_def_id = 0) THEN
281: insert_publication(v_dhtml_ui_def_id, APPLET, v_models_to_be_published(i));
282: -- publication has incorrect ui_style at this point, need to update it
283: -- to DHTML
284: update cz_model_publications set ui_style = DHTML where ui_def_id
285: = v_dhtml_ui_def_id;
286: END IF;
287:
288: insert_publication(v_dhtml_ui_def_id, DHTML, v_models_to_be_published(i));

Line 298: INSERT INTO cz_model_publications(

294: 30, 640, 480, '0', '1', 'BLAF', 10, '0');
295:
296: BEGIN
297: get_base_language(v_base_language);
298: INSERT INTO cz_model_publications(
299: PUBLICATION_ID
300: ,MODEL_ID
301: ,SERVER_ID
302: ,PRODUCT_KEY

Line 315: VALUES ( cz_model_publications_s.NEXTVAL,

311: ,DELETED_FLAG
312: ,SOURCE_TARGET_FLAG
313: ,REMOTE_PUBLICATION_ID
314: )
315: VALUES ( cz_model_publications_s.NEXTVAL,
316: v_models_to_be_published(i),
317: p_server_id,
318: v_product_key,
319: v_org_id,

Line 348: VALUES ( cz_model_publications_s.CURRVAL,

344: ,FND_APPLICATION_ID
345: ,APPLICATION_SHORT_NAME
346: ,NOTES
347: )
348: VALUES ( cz_model_publications_s.CURRVAL,
349: v_application_id,
350: 'ONT',
351: null
352: );

Line 358: VALUES (cz_model_publications_s.CURRVAL,

354:
355: INSERT INTO cz_publication_usages ( PUBLICATION_ID
356: ,USAGE_ID
357: )
358: VALUES (cz_model_publications_s.CURRVAL,
359: -1
360: );
361:
362: INSERT INTO cz_pb_languages (publication_id,language)

Line 363: values (cz_model_publications_s.CURRVAL,v_base_language);

359: -1
360: );
361:
362: INSERT INTO cz_pb_languages (publication_id,language)
363: values (cz_model_publications_s.CURRVAL,v_base_language);
364: EXCEPTION
365: WHEN OTHERS THEN
366: cz_pb_mgr.log_pb_errors(SQLERRM,1,'AUTO PUBLISH',SQLCODE);
367: END;

Line 1159: FROM cz_model_publications

1155: SELECT model_id
1156: BULK
1157: COLLECT
1158: INTO v_published_root_models_tbl
1159: FROM cz_model_publications
1160: WHERE cz_model_publications.deleted_flag = '0'
1161: AND cz_model_publications.export_status = 'OK'
1162: AND cz_model_publications.source_target_flag = 'T';
1163: EXCEPTION

Line 1160: WHERE cz_model_publications.deleted_flag = '0'

1156: BULK
1157: COLLECT
1158: INTO v_published_root_models_tbl
1159: FROM cz_model_publications
1160: WHERE cz_model_publications.deleted_flag = '0'
1161: AND cz_model_publications.export_status = 'OK'
1162: AND cz_model_publications.source_target_flag = 'T';
1163: EXCEPTION
1164: WHEN OTHERS THEN

Line 1161: AND cz_model_publications.export_status = 'OK'

1157: COLLECT
1158: INTO v_published_root_models_tbl
1159: FROM cz_model_publications
1160: WHERE cz_model_publications.deleted_flag = '0'
1161: AND cz_model_publications.export_status = 'OK'
1162: AND cz_model_publications.source_target_flag = 'T';
1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: RAISE;

Line 1162: AND cz_model_publications.source_target_flag = 'T';

1158: INTO v_published_root_models_tbl
1159: FROM cz_model_publications
1160: WHERE cz_model_publications.deleted_flag = '0'
1161: AND cz_model_publications.export_status = 'OK'
1162: AND cz_model_publications.source_target_flag = 'T';
1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: RAISE;
1166: END;

Line 3195: FROM cz_model_publications

3191: SELECT publication_id
3192: BULK
3193: COLLECT
3194: INTO t_publ_ids_tbl
3195: FROM cz_model_publications
3196: WHERE deleted_flag = '0'
3197: AND source_target_flag = 'S'
3198: AND export_status = 'OK'
3199: AND trunc(creation_date) < TO_DATE('12/31/2002', 'mm/dd/yyyy')

Line 3248: update cz_model_publications set remote_publication_id = NULL where publication_id = t_publ_ids_ref(i);

3244: -------for the above publication id(s) reset the publications
3245: IF (t_publ_ids_ref.COUNT > 0) THEN
3246: FOR I IN t_publ_ids_ref.FIRST..t_publ_ids_ref.LAST
3247: LOOP
3248: update cz_model_publications set remote_publication_id = NULL where publication_id = t_publ_ids_ref(i);
3249: update cz_model_publications set export_status = 'PEN' where publication_id = t_publ_ids_ref(i);
3250: update cz_model_publications set creation_date = sysdate where publication_id = t_publ_ids_ref(i);
3251: delete from cz_pb_model_exports where publication_id = t_publ_ids_ref(i);
3252: delete from cZ_model_publications where remote_publication_id = t_publ_ids_ref(i);

Line 3249: update cz_model_publications set export_status = 'PEN' where publication_id = t_publ_ids_ref(i);

3245: IF (t_publ_ids_ref.COUNT > 0) THEN
3246: FOR I IN t_publ_ids_ref.FIRST..t_publ_ids_ref.LAST
3247: LOOP
3248: update cz_model_publications set remote_publication_id = NULL where publication_id = t_publ_ids_ref(i);
3249: update cz_model_publications set export_status = 'PEN' where publication_id = t_publ_ids_ref(i);
3250: update cz_model_publications set creation_date = sysdate where publication_id = t_publ_ids_ref(i);
3251: delete from cz_pb_model_exports where publication_id = t_publ_ids_ref(i);
3252: delete from cZ_model_publications where remote_publication_id = t_publ_ids_ref(i);
3253: END LOOP;

Line 3250: update cz_model_publications set creation_date = sysdate where publication_id = t_publ_ids_ref(i);

3246: FOR I IN t_publ_ids_ref.FIRST..t_publ_ids_ref.LAST
3247: LOOP
3248: update cz_model_publications set remote_publication_id = NULL where publication_id = t_publ_ids_ref(i);
3249: update cz_model_publications set export_status = 'PEN' where publication_id = t_publ_ids_ref(i);
3250: update cz_model_publications set creation_date = sysdate where publication_id = t_publ_ids_ref(i);
3251: delete from cz_pb_model_exports where publication_id = t_publ_ids_ref(i);
3252: delete from cZ_model_publications where remote_publication_id = t_publ_ids_ref(i);
3253: END LOOP;
3254: COMMIT;

Line 3252: delete from cZ_model_publications where remote_publication_id = t_publ_ids_ref(i);

3248: update cz_model_publications set remote_publication_id = NULL where publication_id = t_publ_ids_ref(i);
3249: update cz_model_publications set export_status = 'PEN' where publication_id = t_publ_ids_ref(i);
3250: update cz_model_publications set creation_date = sysdate where publication_id = t_publ_ids_ref(i);
3251: delete from cz_pb_model_exports where publication_id = t_publ_ids_ref(i);
3252: delete from cZ_model_publications where remote_publication_id = t_publ_ids_ref(i);
3253: END LOOP;
3254: COMMIT;
3255:
3256: ----publish models