DBA Data[Home] [Help]

APPS.CZ_PB_MGR dependencies on CZ_RP_ENTRIES

Line 1430: insert_into_rp_entries('cz_rp_entries'

1426: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_objtype_array';
1427: rec_count := rec_count + 1;
1428: plsql_table_list(rec_count).col_name := 'enclosing_folder';
1429: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_tgtfldr_array';
1430: insert_into_rp_entries('cz_rp_entries'
1431: ,'object_id'
1432: ,'object_type'
1433: ,cz_pb_mgr.v_db_link
1434: ,plsql_table_list

Line 3576: FROM cz_rp_entries

3572: SELECT ui_def_id
3573: FROM cz_ui_defs
3574: WHERE cz_ui_defs.deleted_flag = '0'
3575: AND cz_ui_defs.devl_project_id IN(SELECT object_id
3576: FROM cz_rp_entries
3577: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0'))
3578: );
3579:
3580: IF (l_ui_def_id_tbl.COUNT > 0)

Line 3577: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0'))

3573: FROM cz_ui_defs
3574: WHERE cz_ui_defs.deleted_flag = '0'
3575: AND cz_ui_defs.devl_project_id IN(SELECT object_id
3576: FROM cz_rp_entries
3577: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0'))
3578: );
3579:
3580: IF (l_ui_def_id_tbl.COUNT > 0)
3581: THEN

Line 4910: ----------begin insert into cz_rp_entries----------------

4906: refresh_global_templates(cz_pb_mgr.g_ui_templates_old_temp_id_ref);
4907: END IF;
4908:
4909: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
4910: ----------begin insert into cz_rp_entries----------------
4911: plsql_table_list.DELETE;
4912: rec_count := 1;
4913: plsql_table_list(rec_count).col_name := 'object_id';
4914: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_templates_new_temp_id_ref';

Line 4921: insert_into_rp_entries('cz_rp_entries'

4917: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_templates_obj_type';
4918: rec_count := rec_count + 1;
4919: plsql_table_list(rec_count).col_name := 'enclosing_folder';
4920: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_enclosing_fld_rp_entry';
4921: insert_into_rp_entries('cz_rp_entries'
4922: ,'object_id'
4923: ,'object_type'
4924: ,cz_pb_mgr.v_db_link
4925: ,plsql_table_list

Line 4931: ----------end insert into cz_rp_entries----------------

4927: ,'cz_pb_mgr.g_ui_templates_obj_type'
4928: ,cz_pb_mgr.g_ui_templates_old_temp_id_ref
4929: ,cz_pb_mgr.g_ui_templates_obj_type
4930: );
4931: ----------end insert into cz_rp_entries----------------
4932: END IF;
4933: -- END IF;
4934:
4935: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);

Line 9670: ----------begin insert into cz_rp_entries----------------

9666: );
9667:
9668: IF (p_eff_sets_new_key.COUNT > 0 AND cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
9669: THEN
9670: ----------begin insert into cz_rp_entries----------------
9671: plsql_table_list.DELETE;
9672: rec_count := 1;
9673: plsql_table_list(rec_count).col_name := 'object_id';
9674: plsql_table_list(rec_count).table_name := p_new_key_name;

Line 9681: insert_into_rp_entries('cz_rp_entries'

9677: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_eff_set_obj_type';
9678: rec_count := rec_count + 1;
9679: plsql_table_list(rec_count).col_name := 'enclosing_folder';
9680: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_enclosing_fld_rp_entry';
9681: insert_into_rp_entries('cz_rp_entries'
9682: ,'object_id'
9683: ,'object_type'
9684: ,cz_pb_mgr.v_db_link
9685: ,plsql_table_list

Line 9691: ----------end insert into cz_rp_entries----------------

9687: ,'cz_pb_mgr.g_eff_set_obj_type'
9688: ,p_eff_sets_old_key
9689: ,cz_pb_mgr.g_eff_set_obj_type
9690: );
9691: ----------end insert into cz_rp_entries----------------
9692: END IF;
9693:
9694: COMMIT;
9695: EXCEPTION

Line 13338: ----------insert into cz_rp_entries

13334:
13335: EXECUTE IMMEDIATE l_str
13336: USING l_usage_name, l_usage_desc, l_avail_usage_id;
13337:
13338: ----------insert into cz_rp_entries
13339: l_str :=
13340: 'BEGIN
13341: insert into cz_rp_entries'
13342: || cz_pb_mgr.v_db_link

Line 13341: insert into cz_rp_entries'

13337:
13338: ----------insert into cz_rp_entries
13339: l_str :=
13340: 'BEGIN
13341: insert into cz_rp_entries'
13342: || cz_pb_mgr.v_db_link
13343: || ' ( OBJECT_TYPE'
13344: || ' '
13345: || ',OBJECT_ID'

Line 13379: || 'update cz_rp_entries set deleted_flag = ''0'' where object_id = :1;'

13375: || 'EXCEPTION'
13376: || ' '
13377: || 'WHEN OTHERS THEN'
13378: || ' '
13379: || 'update cz_rp_entries set deleted_flag = ''0'' where object_id = :1;'
13380: || ' '
13381: || 'END;';
13382:
13383: EXECUTE IMMEDIATE l_str

Line 14118: ----------begin insert into cz_rp_entries----------------

14114: rec_count := 1;
14115: plsql_table_list(rec_count).col_name := 'ui_def_id';
14116: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_new_mt_id_tbl';
14117: insert_into_table('cz_ui_defs', 'ui_def_id', cz_pb_mgr.v_db_link, plsql_table_list, 'cz_pb_mgr.v_mt_old_only', cz_pb_mgr.v_mt_old_only);
14118: ----------begin insert into cz_rp_entries----------------
14119: plsql_table_list.DELETE;
14120: rec_count := 1;
14121: plsql_table_list(rec_count).col_name := 'object_id';
14122: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_new_mt_id_tbl';

Line 14129: insert_into_rp_entries('cz_rp_entries'

14125: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_mt_obj_type';
14126: rec_count := rec_count + 1;
14127: plsql_table_list(rec_count).col_name := 'enclosing_folder';
14128: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_mt_enclosing_fld_rp_entry';
14129: insert_into_rp_entries('cz_rp_entries'
14130: ,'object_id'
14131: ,'object_type'
14132: ,cz_pb_mgr.v_db_link
14133: ,plsql_table_list

Line 14139: ----------end insert into cz_rp_entries----------------

14135: ,'cz_pb_mgr.g_mt_obj_type'
14136: ,cz_pb_mgr.v_mt_old_only
14137: ,cz_pb_mgr.g_mt_obj_type
14138: );
14139: ----------end insert into cz_rp_entries----------------
14140: END IF;
14141: END IF;
14142: END synch_master_template;
14143:

Line 17476: v_rp_entries_name cz_rp_entries.NAME%TYPE;

17472: v_count PLS_INTEGER := 0;
17473: v_model_chk_count PLS_INTEGER := 0;
17474: v_ui_chk_count PLS_INTEGER := 0;
17475: v_folder_chk PLS_INTEGER := 0;
17476: v_rp_entries_name cz_rp_entries.NAME%TYPE;
17477: v_rp_entries_desc cz_rp_entries.description%TYPE;
17478: v_object_id cz_rp_entries.object_id%TYPE;
17479: v_copy_number NUMBER := 0.0;
17480: v_rp_orig_sys_ref VARCHAR2(255);

Line 17477: v_rp_entries_desc cz_rp_entries.description%TYPE;

17473: v_model_chk_count PLS_INTEGER := 0;
17474: v_ui_chk_count PLS_INTEGER := 0;
17475: v_folder_chk PLS_INTEGER := 0;
17476: v_rp_entries_name cz_rp_entries.NAME%TYPE;
17477: v_rp_entries_desc cz_rp_entries.description%TYPE;
17478: v_object_id cz_rp_entries.object_id%TYPE;
17479: v_copy_number NUMBER := 0.0;
17480: v_rp_orig_sys_ref VARCHAR2(255);
17481: v_imp_ps_node_count PLS_INTEGER := 0;

Line 17478: v_object_id cz_rp_entries.object_id%TYPE;

17474: v_ui_chk_count PLS_INTEGER := 0;
17475: v_folder_chk PLS_INTEGER := 0;
17476: v_rp_entries_name cz_rp_entries.NAME%TYPE;
17477: v_rp_entries_desc cz_rp_entries.description%TYPE;
17478: v_object_id cz_rp_entries.object_id%TYPE;
17479: v_copy_number NUMBER := 0.0;
17480: v_rp_orig_sys_ref VARCHAR2(255);
17481: v_imp_ps_node_count PLS_INTEGER := 0;
17482: v_pub_id cz_model_publications.publication_id%TYPE;

Line 17691: FROM cz_rp_entries

17687: THEN
17688: BEGIN
17689: SELECT 1
17690: INTO v_folder_chk
17691: FROM cz_rp_entries
17692: WHERE object_type = 'FLD' AND object_id = p_folder AND deleted_flag = '0';
17693: EXCEPTION
17694: WHEN OTHERS
17695: THEN

Line 17770: ----------insert into cz_rp_entries

17766: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
17767: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17768: END;
17769:
17770: ----------insert into cz_rp_entries
17771: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
17772: THEN
17773: v_imp_ps_node_count := 0;
17774:

Line 17831: || 'insert into cz_rp_entries'

17827: cz_pb_mgr.v_rp_desc := v_rp_entries_desc;
17828:
17829: EXECUTE IMMEDIATE 'BEGIN'
17830: || ' '
17831: || 'insert into cz_rp_entries'
17832: || cz_pb_mgr.v_db_link
17833: || ' ( OBJECT_TYPE'
17834: || ' '
17835: || ',OBJECT_ID'

Line 17869: cz_pb_mgr.v_err_message := 'Error in inserting into cz_rp_entries: ' || SQLERRM;

17865: || 'END;';
17866: EXCEPTION
17867: WHEN OTHERS
17868: THEN
17869: cz_pb_mgr.v_err_message := 'Error in inserting into cz_rp_entries: ' || SQLERRM;
17870: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
17871: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17872: END;
17873:

Line 18099: || 'DELETE FROM cz_rp_entries'

18095: || 'FOR I IN cz_pb_mgr.v_imported_ps_ref.FISRT..cz_pb_mgr.v_imported_ps_ref.LAST'
18096: || ' '
18097: || 'LOOP'
18098: || ' '
18099: || 'DELETE FROM cz_rp_entries'
18100: || cz_pb_mgr.v_db_link
18101: || ' t'
18102: || ' '
18103: || 'WHERE t.object_id = cz_pb_mgr.v_imported_ps_ref(i)'

Line 18705: FROM cz_rp_entries

18701: IF NOT l_ui_upto_date OR NOT l_model_upto_date THEN
18702: BEGIN
18703: SELECT enclosing_folder
18704: INTO l_folder_id
18705: FROM cz_rp_entries
18706: WHERE object_id = modelid AND enclosing_folder <> 0 AND object_type = 'PRJ' AND deleted_flag = '0';
18707:
18708: FOR rp_rec IN (SELECT NAME
18709: FROM cz_rp_entries

Line 18709: FROM cz_rp_entries

18705: FROM cz_rp_entries
18706: WHERE object_id = modelid AND enclosing_folder <> 0 AND object_type = 'PRJ' AND deleted_flag = '0';
18707:
18708: FOR rp_rec IN (SELECT NAME
18709: FROM cz_rp_entries
18710: START WITH object_type = 'FLD' AND object_id = l_folder_id
18711: CONNECT BY PRIOR enclosing_folder = object_id AND object_type = 'FLD' AND object_id <> 0 AND deleted_flag = '0')
18712: LOOP
18713: l_folder_path := rp_rec.NAME || '/' || l_folder_path;

Line 18770: FROM cz_rp_entries

18766: WHERE server_local_id = 0;
18767:
18768: SELECT NAME
18769: INTO original_name
18770: FROM cz_rp_entries
18771: WHERE object_id = p_devl_project_id AND object_type = 'PRJ' AND deleted_flag = '0';
18772: EXCEPTION
18773: WHEN NO_DATA_FOUND
18774: THEN

Line 18804: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_rp_entries'

18800: ELSE
18801: l_endBr:=')';
18802: END IF;
18803: BEGIN
18804: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_rp_entries'
18805: || cz_pb_mgr.v_db_link
18806: || ' WHERE deleted_flag = ''0'' AND object_type = ''PRJ'' AND '
18807: || ' name = :1'
18808: INTO v_null

Line 18817: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM cz_rp_entries'

18813: RETURN v_name || l_endBr;
18814: END;
18815:
18816: BEGIN
18817: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM cz_rp_entries'
18818: || cz_pb_mgr.v_db_link
18819: || ' WHERE deleted_flag = ''0'' AND object_type = ''PRJ'' AND '
18820: || ' name LIKE :1'
18821: INTO v_null

Line 18860: v_rp_entries_name cz_rp_entries.NAME%TYPE;

18856: l_tgt_msg VARCHAR2(2000);
18857: l_msg_data VARCHAR2(2000);
18858: l_msg_count NUMBER;
18859: l_lock_status VARCHAR2(1);
18860: v_rp_entries_name cz_rp_entries.NAME%TYPE;
18861: v_rp_entries_desc cz_rp_entries.description%TYPE;
18862: v_object_id cz_rp_entries.object_id%TYPE;
18863: v_rp_orig_sys_ref VARCHAR2(255);
18864: v_imp_ps_node_count PLS_INTEGER;

Line 18861: v_rp_entries_desc cz_rp_entries.description%TYPE;

18857: l_msg_data VARCHAR2(2000);
18858: l_msg_count NUMBER;
18859: l_lock_status VARCHAR2(1);
18860: v_rp_entries_name cz_rp_entries.NAME%TYPE;
18861: v_rp_entries_desc cz_rp_entries.description%TYPE;
18862: v_object_id cz_rp_entries.object_id%TYPE;
18863: v_rp_orig_sys_ref VARCHAR2(255);
18864: v_imp_ps_node_count PLS_INTEGER;
18865: l_locked_models cz_security_pvt.number_type_tbl;

Line 18862: v_object_id cz_rp_entries.object_id%TYPE;

18858: l_msg_count NUMBER;
18859: l_lock_status VARCHAR2(1);
18860: v_rp_entries_name cz_rp_entries.NAME%TYPE;
18861: v_rp_entries_desc cz_rp_entries.description%TYPE;
18862: v_object_id cz_rp_entries.object_id%TYPE;
18863: v_rp_orig_sys_ref VARCHAR2(255);
18864: v_imp_ps_node_count PLS_INTEGER;
18865: l_locked_models cz_security_pvt.number_type_tbl;
18866: l_upto_date_status VARCHAR2(2000);

Line 19098: --If this is Model Migration, insert into cz_rp_entries, calculate max_persistent_rec_id and

19094:
19095: insert_template_elements;
19096:
19097: --------------------------------------------------------------------------------------------
19098: --If this is Model Migration, insert into cz_rp_entries, calculate max_persistent_rec_id and
19099: --and insert into CZ_PERSISTENT_REC_IDS with its value, report the migrated and not migrated models.
19100: --------------------------------------------------------------------------------------------
19101:
19102: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR) THEN

Line 19164: || 'insert into cz_rp_entries'

19160: cz_pb_mgr.v_rp_desc := v_rp_entries_desc;
19161:
19162: EXECUTE IMMEDIATE 'BEGIN'
19163: || ' '
19164: || 'insert into cz_rp_entries'
19165: || cz_pb_mgr.v_db_link
19166: || ' ( OBJECT_TYPE'
19167: || ' '
19168: || ',OBJECT_ID'

Line 19201: cz_pb_mgr.v_err_message := 'Error in inserting into cz_rp_entries: ' || SQLERRM;

19197: || ' '
19198: || 'END;';
19199: EXCEPTION
19200: WHEN OTHERS THEN
19201: cz_pb_mgr.v_err_message := 'Error in inserting into cz_rp_entries: ' || SQLERRM;
19202: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MIGRATEMODEL', SQLCODE);
19203: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
19204: END;
19205:

Line 21818: FROM cz_rp_entries

21814: BEGIN
21815: BEGIN
21816: SELECT name
21817: INTO original_name
21818: FROM cz_rp_entries
21819: WHERE object_id = p_devl_project_id
21820: AND object_type = 'PRJ'
21821: AND deleted_flag = '0';
21822: EXCEPTION

Line 21835: FROM cz_rp_entries

21831: BEGIN
21832:
21833: SELECT nvl(max(to_number(substr(SUBSTR(name, 1, instr(name,original_name, -1, 1)-1),7,instr(SUBSTR(name, 1, instr(name,original_name, -1, 1)-1),')',7)-7))),0)
21834: INTO L
21835: FROM cz_rp_entries
21836: WHERE name LIKE 'Copy (%) of '||original_name
21837: and instr(SUBSTR(name, 1, instr(name,original_name, -1, 1)-1),'Copy (',7)=0
21838: and is_val_number(substr(SUBSTR(name, 1, instr(name,original_name, -1, 1)-1),7,instr(SUBSTR(name, 1, instr(name,original_name, -1, 1)-1),')',7)-7))='TRUE'
21839: AND deleted_flag = '0' and object_type='PRJ';

Line 21877: l_model_id cz_rp_entries.object_id%TYPE;

21873: ,x_msg_count OUT NOCOPY NUMBER
21874: ,x_msg_data OUT NOCOPY VARCHAR2
21875: )
21876: IS
21877: l_model_id cz_rp_entries.object_id%TYPE;
21878: l_publication_mode cz_model_publications.publication_mode%TYPE;
21879: l_usg_id cz_publication_usages.usage_id%TYPE;
21880: l_lang_code cz_pb_languages.LANGUAGE%TYPE;
21881: l_start_date DATE;

Line 21926: FROM cz_rp_entries

21922: FROM cz_devl_projects
21923: WHERE cz_devl_projects.devl_project_id = p_model_id
21924: AND cz_devl_projects.deleted_flag = '0'
21925: AND cz_devl_projects.devl_project_id IN(SELECT object_id
21926: FROM cz_rp_entries
21927: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0');
21928: EXCEPTION
21929: WHEN NO_DATA_FOUND
21930: THEN

Line 21927: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0');

21923: WHERE cz_devl_projects.devl_project_id = p_model_id
21924: AND cz_devl_projects.deleted_flag = '0'
21925: AND cz_devl_projects.devl_project_id IN(SELECT object_id
21926: FROM cz_rp_entries
21927: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0');
21928: EXCEPTION
21929: WHEN NO_DATA_FOUND
21930: THEN
21931: RAISE no_model_exists;

Line 22867: 'cz_rp_entries' || cz_pb_mgr.v_db_link || ' t1' || ',' ||

22863: IF (what_exists = 'PROP')
22864: THEN
22865: l_sql_str :=
22866: 'SELECT t.property_id, t.NAME FROM cz_properties' || cz_pb_mgr.v_db_link || ' t' || ',' ||
22867: 'cz_rp_entries' || cz_pb_mgr.v_db_link || ' t1' || ',' ||
22868: 'cz_properties s' || ' ' ||
22869: 'WHERE t1.object_id = t.property_id AND t1.object_type = ''PRP'' ' || ' ' ||
22870: 'AND t1.DELETED_FLAG = ''0'' '|| ' ' ||
22871: 'AND t.NAME = s.NAME AND t1.NAME = s.NAME' || ' ' ||

Line 22900: 'SELECT t.object_id, t.NAME FROM cz_rp_entries' || cz_pb_mgr.v_db_link || ' t' || ',' ||

22896: l_sync_msg_object_type_tkn := cz_item_type_caption;
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';

Line 22909: 'SELECT t.object_id, t.NAME FROM cz_rp_entries' || cz_pb_mgr.v_db_link || 't' || ',' ||

22905: l_sync_msg_object_type_tkn := cz_archive_caption;
22906: ELSIF(what_exists = 'EFF_SETS')
22907: THEN
22908: l_sql_str :=
22909: 'SELECT t.object_id, t.NAME FROM cz_rp_entries' || cz_pb_mgr.v_db_link || 't' || ',' ||
22910: 'cz_effectivity_sets s' || ' ' ||
22911: 'WHERE t.object_type = ''EFF'' AND t.NAME = s.NAME' || ' ' ||
22912: 'AND t.DELETED_FLAG = ''0'' '|| ' ' ||
22913: 'AND s.effectivity_set_id = :1';

Line 23234: ----------begin insert into cz_rp_entries----------------

23230: ,plsql_table_list
23231: ,'cz_pb_mgr.g_archives_old_tbl'
23232: ,cz_pb_mgr.g_archives_old_tbl
23233: );
23234: ----------begin insert into cz_rp_entries----------------
23235: plsql_table_list.DELETE;
23236: rec_count := 1;
23237: plsql_table_list(rec_count).col_name := 'object_id';
23238: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_v_ht_sync_archives';

Line 23245: insert_into_rp_entries('cz_rp_entries'

23241: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_archives_obj_type';
23242: rec_count := rec_count + 1;
23243: plsql_table_list(rec_count).col_name := 'enclosing_folder';
23244: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_enclosing_fld_rp_entry';
23245: insert_into_rp_entries('cz_rp_entries'
23246: ,'object_id'
23247: ,'object_type'
23248: ,cz_pb_mgr.v_db_link
23249: ,plsql_table_list

Line 23255: ----------end insert into cz_rp_entries----------------

23251: ,'cz_pb_mgr.g_archives_obj_type'
23252: ,cz_pb_mgr.g_archives_old_tbl
23253: ,cz_pb_mgr.g_archives_obj_type
23254: );
23255: ----------end insert into cz_rp_entries----------------
23256: END IF;
23257:
23258: resolve_ids(cz_pb_mgr.g_archive_id_old_ref,cz_pb_mgr.g_archive_id_ref, cz_pb_mgr.g_archives_mig_idx_ref, 'rsolve archive ids for ref');
23259: -- Need to use the right array to resolve the devl project ids.