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 7240: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.g_archives_new_ref',cz_pb_mgr.g_archives_new_ref);

7236: 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);
7237: 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);
7238: 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);
7239: 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);
7240: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.g_archives_new_ref',cz_pb_mgr.g_archives_new_ref);
7241:
7242: 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);
7243:
7244: 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 7242: 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);

7238: 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);
7239: 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);
7240: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.g_archives_new_ref',cz_pb_mgr.g_archives_new_ref);
7241:
7242: 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);
7243:
7244: 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);
7245: 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);
7246:

Line 8377: v_last_archive_update cz_archives.last_update_date%TYPE;

8373: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
8374: --------procedure that checks if archives have changed since the model was last published
8375: 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)
8376: AS
8377: v_last_archive_update cz_archives.last_update_date%TYPE;
8378: BEGIN
8379: IF (p_model_array.COUNT > 0)
8380: THEN
8381: FOR i IN p_model_array.FIRST .. p_model_array.LAST

Line 8386: FROM cz_archives arch, cz_archive_refs refs

8382: LOOP
8383: BEGIN
8384: SELECT GREATEST(MAX(arch.last_update_date), MAX(refs.last_update_date))
8385: INTO v_last_archive_update
8386: FROM cz_archives arch, cz_archive_refs refs
8387: WHERE refs.devl_project_id = p_model_array(i) AND arch.archive_id = refs.archive_id AND arch.deleted_flag = '0'
8388: AND refs.deleted_flag = 0;
8389: EXCEPTION
8390: WHEN NO_DATA_FOUND

Line 10032: FROM cz_archives arc, cz_archive_refs REF

10028:
10029: -----------end expr nodes check
10030: SELECT GREATEST(MAX(arc.last_update_date), MAX(REF.last_update_date))
10031: INTO l_max_arc_date
10032: FROM cz_archives arc, cz_archive_refs REF
10033: 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';
10034:
10035: IF l_max_arc_date IS NOT NULL AND l_max_arc_date > v_expr_last_update
10036: THEN

Line 16282: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_archives_seq

16278: LOOP
16279: l_old_archives_tbl.DELETE;
16280: l_archives_tbl.DELETE;
16281:
16282: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_archives_seq
16283: , 'cz_archives_s.nextval' || cz_pb_mgr.v_db_link
16284: ,cz_pb_mgr.v_oraclesequenceincr
16285: )
16286: ,archive_id

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

16279: l_old_archives_tbl.DELETE;
16280: l_archives_tbl.DELETE;
16281:
16282: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_archives_seq
16283: , 'cz_archives_s.nextval' || cz_pb_mgr.v_db_link
16284: ,cz_pb_mgr.v_oraclesequenceincr
16285: )
16286: ,archive_id
16287: BULK COLLECT INTO l_archives_tbl

Line 16289: FROM cz_archives

16285: )
16286: ,archive_id
16287: BULK COLLECT INTO l_archives_tbl
16288: ,l_old_archives_tbl
16289: FROM cz_archives
16290: WHERE cz_archives.archive_id = cz_pb_mgr.g_archive_id_old_ref(i) AND cz_archives.deleted_flag = record_not_deleted;
16291:
16292: IF (l_archives_tbl.COUNT > 0)
16293: THEN

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

16286: ,archive_id
16287: BULK COLLECT INTO l_archives_tbl
16288: ,l_old_archives_tbl
16289: FROM cz_archives
16290: WHERE cz_archives.archive_id = cz_pb_mgr.g_archive_id_old_ref(i) AND cz_archives.deleted_flag = record_not_deleted;
16291:
16292: IF (l_archives_tbl.COUNT > 0)
16293: THEN
16294: FOR j IN l_archives_tbl.FIRST .. l_archives_tbl.LAST

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

16328: END IF;
16329:
16330: IF (cz_pb_mgr.g_log_timing = publication_timing)
16331: THEN
16332: log_timing_message('end insert_into_table cz_archives');
16333: END IF;
16334: END IF;
16335: EXCEPTION
16336: WHEN OTHERS

Line 24354: 'cz_archives s' || ' ' ||

24350: ELSIF(what_exists = 'ARCHIVE')
24351: THEN
24352: l_sql_str :=
24353: 'SELECT t.object_id, t.NAME FROM cz_rp_entries' || cz_pb_mgr.v_db_link || ' t' || ',' ||
24354: 'cz_archives s' || ' ' ||
24355: 'WHERE t.object_type = ''ARC'' AND t.NAME = s.NAME' || ' ' ||
24356: 'AND t.DELETED_FLAG = ''0'' '|| ' ' ||
24357: 'AND s.archive_id = :1';
24358: l_sync_msg_object_type_tkn := cz_archive_caption;

Line 24434: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ARCHIVES_SEQ

24430: );
24431:
24432: ELSIF(what_id = 'ARCHIVE')
24433: THEN
24434: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ARCHIVES_SEQ
24435: , 'CZ_ARCHIVES_S.nextval' || cz_pb_mgr.v_db_link
24436: ,cz_pb_mgr.v_oraclesequenceincr
24437: );
24438: ELSIF(what_id = 'INTL_TEXT')

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

24431:
24432: ELSIF(what_id = 'ARCHIVE')
24433: THEN
24434: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ARCHIVES_SEQ
24435: , 'CZ_ARCHIVES_S.nextval' || cz_pb_mgr.v_db_link
24436: ,cz_pb_mgr.v_oraclesequenceincr
24437: );
24438: ELSIF(what_id = 'INTL_TEXT')
24439: THEN

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

24626: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_archives_new_ref';
24627:
24628: IF (cz_pb_mgr.g_log_timing = publication_timing)
24629: THEN
24630: log_timing_message('start insert_into_table cz_archives');
24631: END IF;
24632:
24633: insert_into_table('cz_archives'
24634: ,'archive_id'

Line 24633: insert_into_table('cz_archives'

24629: THEN
24630: log_timing_message('start insert_into_table cz_archives');
24631: END IF;
24632:
24633: insert_into_table('cz_archives'
24634: ,'archive_id'
24635: ,cz_pb_mgr.v_db_link
24636: ,plsql_table_list
24637: ,'cz_pb_mgr.g_archives_old_ref'

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

24673: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_v_ht_sync_archives';
24674:
24675: IF (cz_pb_mgr.g_log_timing = publication_timing)
24676: THEN
24677: log_timing_message('start insert_into_table cz_archives');
24678: END IF;
24679:
24680: insert_into_table('cz_archives'
24681: ,'archive_id'

Line 24680: insert_into_table('cz_archives'

24676: THEN
24677: log_timing_message('start insert_into_table cz_archives');
24678: END IF;
24679:
24680: insert_into_table('cz_archives'
24681: ,'archive_id'
24682: ,cz_pb_mgr.v_db_link
24683: ,plsql_table_list
24684: ,'cz_pb_mgr.g_archives_old_tbl'