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_S

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