APPS.CZ_PB_MGR dependencies on CZ_ARCHIVE_REFS

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

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:
7247: delete_from_idx_tables('cz_rule_folders', 'rule_folder_id', cz_pb_mgr.v_cz_folders_id_old_ref, cz_pb_mgr.v_cz_folders_id_idx_ref);
7248: delete_from_idx_tables('cz_expression_nodes', 'expr_node_id', cz_pb_mgr.v_cz_enodes_enode_id_old_ref, cz_pb_mgr.v_cz_enodes_enode_id_idx_ref);

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 16230: FROM cz_archive_refs

16226:
16227: BEGIN
16228: SELECT archive_id, devl_project_id
16229: BULK COLLECT INTO l_archive_refs_tbl, l_devl_proj_tbl
16230: FROM cz_archive_refs
16231: WHERE cz_archive_refs.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_archive_refs.deleted_flag = record_not_deleted;
16232: EXCEPTION
16233: WHEN NO_DATA_FOUND
16234: THEN

Line 16231: WHERE cz_archive_refs.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_archive_refs.deleted_flag = record_not_deleted;

16227: BEGIN
16228: SELECT archive_id, devl_project_id
16229: BULK COLLECT INTO l_archive_refs_tbl, l_devl_proj_tbl
16230: FROM cz_archive_refs
16231: WHERE cz_archive_refs.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_archive_refs.deleted_flag = record_not_deleted;
16232: EXCEPTION
16233: WHEN NO_DATA_FOUND
16234: THEN
16235: NULL;

Line 16256: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_archive_refs', 'SQLERRM', SQLERRM);

16252: END IF;
16253: EXCEPTION
16254: WHEN OTHERS
16255: THEN
16256: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_archive_refs', 'SQLERRM', SQLERRM);
16257: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.ARCHIVES', SQLCODE);
16258: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16259: RAISE;
16260: END bulk_collect_archives;

Line 24648: insert_into_table('cz_archive_refs'

24644: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_archive_id_ref';
24645: rec_count := rec_count + 1;
24646: plsql_table_list(rec_count).col_name := 'devl_project_id';
24647: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_devl_proj_ref';
24648: insert_into_table('cz_archive_refs'
24649: ,'archive_id'
24650: ,'devl_project_id'
24651: ,cz_pb_mgr.v_db_link
24652: ,plsql_table_list

Line 24721: insert_into_table('cz_archive_refs'

24717: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_archive_id_ref';
24718: rec_count := rec_count + 1;
24719: plsql_table_list(rec_count).col_name := 'devl_project_id';
24720: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_devl_proj_ref';
24721: insert_into_table('cz_archive_refs'
24722: ,'archive_id'
24723: ,'devl_project_id'
24724: ,cz_pb_mgr.v_db_link
24725: ,plsql_table_list