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_PB_MGR dependencies on CZ_ARCHIVES

Line 6519: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.g_archives_new_ref',cz_pb_mgr.g_archives_new_ref);

6515: delete_from_table('cz_signature_arguments','argument_signature_id','argument_index',v_database_link,'cz_pb_mgr.v_arg_sig_tbl','cz_pb_mgr.v_arg_ind_old_tbl',cz_pb_mgr.v_arg_sig_tbl);
6516: delete_from_table('cz_func_comp_specs','func_comp_id',v_database_link,'cz_pb_mgr.v_cz_func_comp_new_ref',cz_pb_mgr.v_cz_func_comp_new_ref);
6517: delete_from_table('cz_populators','populator_id',v_database_link,'cz_pb_mgr.v_populators_new_id_ref',cz_pb_mgr.v_populators_new_id_ref);
6518: delete_from_table('cz_filter_sets','filter_set_id',v_database_link,'cz_pb_mgr.v_filter_sets_new_id_ref',cz_pb_mgr.v_filter_sets_new_id_ref);
6519: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.g_archives_new_ref',cz_pb_mgr.g_archives_new_ref);
6520:
6521: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.mm_v_ht_sync_archives',cz_pb_mgr.mm_v_ht_sync_archives);
6522:
6523: delete_from_table('cz_archive_refs','archive_id','devl_project_id',v_database_link,'cz_pb_mgr.g_archive_id_ref','cz_pb_mgr.g_devl_proj_ref',cz_pb_mgr.g_archive_id_ref);

Line 6521: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.mm_v_ht_sync_archives',cz_pb_mgr.mm_v_ht_sync_archives);

6517: delete_from_table('cz_populators','populator_id',v_database_link,'cz_pb_mgr.v_populators_new_id_ref',cz_pb_mgr.v_populators_new_id_ref);
6518: delete_from_table('cz_filter_sets','filter_set_id',v_database_link,'cz_pb_mgr.v_filter_sets_new_id_ref',cz_pb_mgr.v_filter_sets_new_id_ref);
6519: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.g_archives_new_ref',cz_pb_mgr.g_archives_new_ref);
6520:
6521: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.mm_v_ht_sync_archives',cz_pb_mgr.mm_v_ht_sync_archives);
6522:
6523: delete_from_table('cz_archive_refs','archive_id','devl_project_id',v_database_link,'cz_pb_mgr.g_archive_id_ref','cz_pb_mgr.g_devl_proj_ref',cz_pb_mgr.g_archive_id_ref);
6524: delete_from_table('cz_localized_texts','intl_text_id',v_database_link,'cz_pb_mgr.v_cz_intl_text_new_ref',cz_pb_mgr.v_cz_intl_text_new_ref);
6525:

Line 7654: v_last_archive_update cz_archives.last_update_date%TYPE;

7650: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7651: --------procedure that checks if archives have changed since the model was last published
7652: PROCEDURE chk_if_archives_changed(p_model_array IN cz_pb_mgr.t_ref, p_last_xfr_date IN DATE, x_record_count IN OUT NOCOPY NUMBER)
7653: AS
7654: v_last_archive_update cz_archives.last_update_date%TYPE;
7655: BEGIN
7656: IF (p_model_array.COUNT > 0)
7657: THEN
7658: FOR i IN p_model_array.FIRST .. p_model_array.LAST

Line 7663: FROM cz_archives arch, cz_archive_refs refs

7659: LOOP
7660: BEGIN
7661: SELECT GREATEST(MAX(arch.last_update_date), MAX(refs.last_update_date))
7662: INTO v_last_archive_update
7663: FROM cz_archives arch, cz_archive_refs refs
7664: WHERE refs.devl_project_id = p_model_array(i) AND arch.archive_id = refs.archive_id AND arch.deleted_flag = '0'
7665: AND refs.deleted_flag = 0;
7666: EXCEPTION
7667: WHEN NO_DATA_FOUND

Line 9276: FROM cz_archives arc, cz_archive_refs REF

9272:
9273: -----------end expr nodes check
9274: SELECT GREATEST(MAX(arc.last_update_date), MAX(REF.last_update_date))
9275: INTO l_max_arc_date
9276: FROM cz_archives arc, cz_archive_refs REF
9277: WHERE REF.devl_project_id = v_model_id AND arc.archive_id = REF.archive_id AND arc.deleted_flag = '0' AND REF.deleted_flag = '0';
9278:
9279: IF l_max_arc_date IS NOT NULL AND l_max_arc_date > v_expr_last_update
9280: THEN

Line 15168: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_archives_seq

15164: LOOP
15165: l_old_archives_tbl.DELETE;
15166: l_archives_tbl.DELETE;
15167:
15168: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_archives_seq
15169: , 'cz_archives_s.nextval' || cz_pb_mgr.v_db_link
15170: ,cz_pb_mgr.v_oraclesequenceincr
15171: )
15172: ,archive_id

Line 15169: , 'cz_archives_s.nextval' || cz_pb_mgr.v_db_link

15165: l_old_archives_tbl.DELETE;
15166: l_archives_tbl.DELETE;
15167:
15168: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_archives_seq
15169: , 'cz_archives_s.nextval' || cz_pb_mgr.v_db_link
15170: ,cz_pb_mgr.v_oraclesequenceincr
15171: )
15172: ,archive_id
15173: BULK COLLECT INTO l_archives_tbl

Line 15175: FROM cz_archives

15171: )
15172: ,archive_id
15173: BULK COLLECT INTO l_archives_tbl
15174: ,l_old_archives_tbl
15175: FROM cz_archives
15176: WHERE cz_archives.archive_id = cz_pb_mgr.g_archive_id_old_ref(i) AND cz_archives.deleted_flag = record_not_deleted;
15177:
15178: IF (l_archives_tbl.COUNT > 0)
15179: THEN

Line 15176: WHERE cz_archives.archive_id = cz_pb_mgr.g_archive_id_old_ref(i) AND cz_archives.deleted_flag = record_not_deleted;

15172: ,archive_id
15173: BULK COLLECT INTO l_archives_tbl
15174: ,l_old_archives_tbl
15175: FROM cz_archives
15176: WHERE cz_archives.archive_id = cz_pb_mgr.g_archive_id_old_ref(i) AND cz_archives.deleted_flag = record_not_deleted;
15177:
15178: IF (l_archives_tbl.COUNT > 0)
15179: THEN
15180: FOR j IN l_archives_tbl.FIRST .. l_archives_tbl.LAST

Line 15218: log_timing_message('end insert_into_table cz_archives');

15214: END IF;
15215:
15216: IF (cz_pb_mgr.g_log_timing = publication_timing)
15217: THEN
15218: log_timing_message('end insert_into_table cz_archives');
15219: END IF;
15220: END IF;
15221: EXCEPTION
15222: WHEN OTHERS

Line 22901: 'cz_archives s' || ' ' ||

22897: ELSIF(what_exists = 'ARCHIVE')
22898: THEN
22899: l_sql_str :=
22900: 'SELECT t.object_id, t.NAME FROM cz_rp_entries' || cz_pb_mgr.v_db_link || ' t' || ',' ||
22901: 'cz_archives s' || ' ' ||
22902: 'WHERE t.object_type = ''ARC'' AND t.NAME = s.NAME' || ' ' ||
22903: 'AND t.DELETED_FLAG = ''0'' '|| ' ' ||
22904: 'AND s.archive_id = :1';
22905: l_sync_msg_object_type_tkn := cz_archive_caption;

Line 22981: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ARCHIVES_SEQ

22977: );
22978:
22979: ELSIF(what_id = 'ARCHIVE')
22980: THEN
22981: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ARCHIVES_SEQ
22982: , 'CZ_ARCHIVES_S.nextval' || cz_pb_mgr.v_db_link
22983: ,cz_pb_mgr.v_oraclesequenceincr
22984: );
22985: ELSIF(what_id = 'INTL_TEXT')

Line 22982: , 'CZ_ARCHIVES_S.nextval' || cz_pb_mgr.v_db_link

22978:
22979: ELSIF(what_id = 'ARCHIVE')
22980: THEN
22981: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ARCHIVES_SEQ
22982: , 'CZ_ARCHIVES_S.nextval' || cz_pb_mgr.v_db_link
22983: ,cz_pb_mgr.v_oraclesequenceincr
22984: );
22985: ELSIF(what_id = 'INTL_TEXT')
22986: THEN

Line 23177: log_timing_message('start insert_into_table cz_archives');

23173: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_archives_new_ref';
23174:
23175: IF (cz_pb_mgr.g_log_timing = publication_timing)
23176: THEN
23177: log_timing_message('start insert_into_table cz_archives');
23178: END IF;
23179:
23180: insert_into_table('cz_archives'
23181: ,'archive_id'

Line 23180: insert_into_table('cz_archives'

23176: THEN
23177: log_timing_message('start insert_into_table cz_archives');
23178: END IF;
23179:
23180: insert_into_table('cz_archives'
23181: ,'archive_id'
23182: ,cz_pb_mgr.v_db_link
23183: ,plsql_table_list
23184: ,'cz_pb_mgr.g_archives_old_ref'

Line 23224: log_timing_message('start insert_into_table cz_archives');

23220: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_v_ht_sync_archives';
23221:
23222: IF (cz_pb_mgr.g_log_timing = publication_timing)
23223: THEN
23224: log_timing_message('start insert_into_table cz_archives');
23225: END IF;
23226:
23227: insert_into_table('cz_archives'
23228: ,'archive_id'

Line 23227: insert_into_table('cz_archives'

23223: THEN
23224: log_timing_message('start insert_into_table cz_archives');
23225: END IF;
23226:
23227: insert_into_table('cz_archives'
23228: ,'archive_id'
23229: ,cz_pb_mgr.v_db_link
23230: ,plsql_table_list
23231: ,'cz_pb_mgr.g_archives_old_tbl'