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_RP_ENTRIES

Line 1789: insert_into_rp_entries('cz_rp_entries'

1785: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_objtype_array';
1786: rec_count := rec_count + 1;
1787: plsql_table_list(rec_count).col_name := 'enclosing_folder';
1788: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_tgtfldr_array';
1789: insert_into_rp_entries('cz_rp_entries'
1790: ,'object_id'
1791: ,'object_type'
1792: ,cz_pb_mgr.v_db_link
1793: ,plsql_table_list

Line 4214: FROM cz_rp_entries

4210: SELECT ui_def_id
4211: FROM cz_ui_defs
4212: WHERE cz_ui_defs.deleted_flag = '0'
4213: AND cz_ui_defs.devl_project_id IN(SELECT object_id
4214: FROM cz_rp_entries
4215: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0'))
4216: );
4217:
4218: IF (l_ui_def_id_tbl.COUNT > 0)

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

4211: FROM cz_ui_defs
4212: WHERE cz_ui_defs.deleted_flag = '0'
4213: AND cz_ui_defs.devl_project_id IN(SELECT object_id
4214: FROM cz_rp_entries
4215: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0'))
4216: );
4217:
4218: IF (l_ui_def_id_tbl.COUNT > 0)
4219: THEN

Line 5633: ----------begin insert into cz_rp_entries----------------

5629: refresh_global_templates(cz_pb_mgr.g_ui_templates_old_temp_id_ref);
5630: END IF;
5631:
5632: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
5633: ----------begin insert into cz_rp_entries----------------
5634: plsql_table_list.DELETE;
5635: rec_count := 1;
5636: plsql_table_list(rec_count).col_name := 'object_id';
5637: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_templates_new_temp_id_ref';

Line 5644: insert_into_rp_entries('cz_rp_entries'

5640: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_templates_obj_type';
5641: rec_count := rec_count + 1;
5642: plsql_table_list(rec_count).col_name := 'enclosing_folder';
5643: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_enclosing_fld_rp_entry';
5644: insert_into_rp_entries('cz_rp_entries'
5645: ,'object_id'
5646: ,'object_type'
5647: ,cz_pb_mgr.v_db_link
5648: ,plsql_table_list

Line 5654: ----------end insert into cz_rp_entries----------------

5650: ,'cz_pb_mgr.g_ui_templates_obj_type'
5651: ,cz_pb_mgr.g_ui_templates_old_temp_id_ref
5652: ,cz_pb_mgr.g_ui_templates_obj_type
5653: );
5654: ----------end insert into cz_rp_entries----------------
5655: END IF;
5656: -- END IF;
5657:
5658: -- bug #10417318

Line 6909: v_DeleteProj := v_DeleteProj||' AND NOT EXISTS( SELECT null FROM cz_rp_entries'||v_db_link;

6905: BEGIN
6906: v_DeleteProj := 'BEGIN FOR i IN cz_pb_mgr.v_models_to_be_exported_new.FIRST..cz_pb_mgr.v_models_to_be_exported_new.LAST LOOP ';
6907: v_DeleteProj := v_DeleteProj||' DELETE FROM cz_devl_projects'||v_db_link||' tgt ';
6908: v_DeleteProj := v_DeleteProj||' WHERE tgt.devl_project_id = cz_pb_mgr.v_models_to_be_exported_new(i) ';
6909: v_DeleteProj := v_DeleteProj||' AND NOT EXISTS( SELECT null FROM cz_rp_entries'||v_db_link;
6910: v_DeleteProj := v_DeleteProj||' WHERE object_type=''PRJ'' AND seeded_flag=''1'' AND object_id=tgt.devl_project_id)';
6911: v_DeleteProj := v_DeleteProj||' ; END LOOP; COMMIT; END; ';
6912:
6913:

Line 10426: ----------begin insert into cz_rp_entries----------------

10422: );
10423:
10424: IF (p_eff_sets_new_key.COUNT > 0 AND cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
10425: THEN
10426: ----------begin insert into cz_rp_entries----------------
10427: plsql_table_list.DELETE;
10428: rec_count := 1;
10429: plsql_table_list(rec_count).col_name := 'object_id';
10430: plsql_table_list(rec_count).table_name := p_new_key_name;

Line 10437: insert_into_rp_entries('cz_rp_entries'

10433: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_eff_set_obj_type';
10434: rec_count := rec_count + 1;
10435: plsql_table_list(rec_count).col_name := 'enclosing_folder';
10436: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_enclosing_fld_rp_entry';
10437: insert_into_rp_entries('cz_rp_entries'
10438: ,'object_id'
10439: ,'object_type'
10440: ,cz_pb_mgr.v_db_link
10441: ,plsql_table_list

Line 10447: ----------end insert into cz_rp_entries----------------

10443: ,'cz_pb_mgr.g_eff_set_obj_type'
10444: ,p_eff_sets_old_key
10445: ,cz_pb_mgr.g_eff_set_obj_type
10446: );
10447: ----------end insert into cz_rp_entries----------------
10448: END IF;
10449:
10450: COMMIT;
10451: EXCEPTION

Line 14393: ----------insert into cz_rp_entries

14389:
14390: EXECUTE IMMEDIATE l_str
14391: USING l_usage_name, l_usage_desc, l_avail_usage_id;
14392:
14393: ----------insert into cz_rp_entries
14394: l_str :=
14395: 'BEGIN
14396: insert into cz_rp_entries'
14397: || cz_pb_mgr.v_db_link

Line 14396: insert into cz_rp_entries'

14392:
14393: ----------insert into cz_rp_entries
14394: l_str :=
14395: 'BEGIN
14396: insert into cz_rp_entries'
14397: || cz_pb_mgr.v_db_link
14398: || ' ( OBJECT_TYPE'
14399: || ' '
14400: || ',OBJECT_ID'

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

14430: || 'EXCEPTION'
14431: || ' '
14432: || 'WHEN OTHERS THEN'
14433: || ' '
14434: || 'update cz_rp_entries set deleted_flag = ''0'' where object_id = :1;'
14435: || ' '
14436: || 'END;';
14437:
14438: EXECUTE IMMEDIATE l_str

Line 15178: ----------begin insert into cz_rp_entries----------------

15174: rec_count := 1;
15175: plsql_table_list(rec_count).col_name := 'ui_def_id';
15176: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_new_mt_id_tbl';
15177: 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);
15178: ----------begin insert into cz_rp_entries----------------
15179: plsql_table_list.DELETE;
15180: rec_count := 1;
15181: plsql_table_list(rec_count).col_name := 'object_id';
15182: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_new_mt_id_tbl';

Line 15189: insert_into_rp_entries('cz_rp_entries'

15185: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_mt_obj_type';
15186: rec_count := rec_count + 1;
15187: plsql_table_list(rec_count).col_name := 'enclosing_folder';
15188: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_mt_enclosing_fld_rp_entry';
15189: insert_into_rp_entries('cz_rp_entries'
15190: ,'object_id'
15191: ,'object_type'
15192: ,cz_pb_mgr.v_db_link
15193: ,plsql_table_list

Line 15199: ----------end insert into cz_rp_entries----------------

15195: ,'cz_pb_mgr.g_mt_obj_type'
15196: ,cz_pb_mgr.v_mt_old_only
15197: ,cz_pb_mgr.g_mt_obj_type
15198: );
15199: ----------end insert into cz_rp_entries----------------
15200: END IF;
15201: END IF;
15202: END synch_master_template;
15203:

Line 18619: v_rp_entries_name cz_rp_entries.NAME%TYPE;

18615: v_count PLS_INTEGER := 0;
18616: v_model_chk_count PLS_INTEGER := 0;
18617: v_ui_chk_count PLS_INTEGER := 0;
18618: v_folder_chk PLS_INTEGER := 0;
18619: v_rp_entries_name cz_rp_entries.NAME%TYPE;
18620: v_rp_entries_desc cz_rp_entries.description%TYPE;
18621: v_object_id cz_rp_entries.object_id%TYPE;
18622: v_copy_number NUMBER := 0.0;
18623: v_rp_orig_sys_ref VARCHAR2(255);

Line 18620: v_rp_entries_desc cz_rp_entries.description%TYPE;

18616: v_model_chk_count PLS_INTEGER := 0;
18617: v_ui_chk_count PLS_INTEGER := 0;
18618: v_folder_chk PLS_INTEGER := 0;
18619: v_rp_entries_name cz_rp_entries.NAME%TYPE;
18620: v_rp_entries_desc cz_rp_entries.description%TYPE;
18621: v_object_id cz_rp_entries.object_id%TYPE;
18622: v_copy_number NUMBER := 0.0;
18623: v_rp_orig_sys_ref VARCHAR2(255);
18624: v_imp_ps_node_count PLS_INTEGER := 0;

Line 18621: v_object_id cz_rp_entries.object_id%TYPE;

18617: v_ui_chk_count PLS_INTEGER := 0;
18618: v_folder_chk PLS_INTEGER := 0;
18619: v_rp_entries_name cz_rp_entries.NAME%TYPE;
18620: v_rp_entries_desc cz_rp_entries.description%TYPE;
18621: v_object_id cz_rp_entries.object_id%TYPE;
18622: v_copy_number NUMBER := 0.0;
18623: v_rp_orig_sys_ref VARCHAR2(255);
18624: v_imp_ps_node_count PLS_INTEGER := 0;
18625: v_pub_id cz_model_publications.publication_id%TYPE;

Line 18834: FROM cz_rp_entries

18830: THEN
18831: BEGIN
18832: SELECT 1
18833: INTO v_folder_chk
18834: FROM cz_rp_entries
18835: WHERE object_type = 'FLD' AND object_id = p_folder AND deleted_flag = '0';
18836: EXCEPTION
18837: WHEN OTHERS
18838: THEN

Line 18913: ----------insert into cz_rp_entries

18909: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
18910: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18911: END;
18912:
18913: ----------insert into cz_rp_entries
18914: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
18915: THEN
18916: v_imp_ps_node_count := 0;
18917:

Line 18974: || 'insert into cz_rp_entries'

18970: cz_pb_mgr.v_rp_desc := v_rp_entries_desc;
18971:
18972: EXECUTE IMMEDIATE 'BEGIN'
18973: || ' '
18974: || 'insert into cz_rp_entries'
18975: || cz_pb_mgr.v_db_link
18976: || ' ( OBJECT_TYPE'
18977: || ' '
18978: || ',OBJECT_ID'

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

19008: || 'END;';
19009: EXCEPTION
19010: WHEN OTHERS
19011: THEN
19012: cz_pb_mgr.v_err_message := 'Error in inserting into cz_rp_entries: ' || SQLERRM;
19013: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
19014: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
19015: END;
19016:

Line 19242: || 'DELETE FROM cz_rp_entries'

19238: || 'FOR I IN cz_pb_mgr.v_imported_ps_ref.FISRT..cz_pb_mgr.v_imported_ps_ref.LAST'
19239: || ' '
19240: || 'LOOP'
19241: || ' '
19242: || 'DELETE FROM cz_rp_entries'
19243: || cz_pb_mgr.v_db_link
19244: || ' t'
19245: || ' '
19246: || 'WHERE t.object_id = cz_pb_mgr.v_imported_ps_ref(i)'

Line 19842: FROM cz_rp_entries

19838: IF NOT l_ui_upto_date OR NOT l_model_upto_date THEN
19839: BEGIN
19840: SELECT enclosing_folder
19841: INTO l_folder_id
19842: FROM cz_rp_entries
19843: WHERE object_id = modelid AND enclosing_folder <> 0 AND object_type = 'PRJ' AND deleted_flag = '0';
19844:
19845: FOR rp_rec IN (SELECT NAME
19846: FROM cz_rp_entries

Line 19846: FROM cz_rp_entries

19842: FROM cz_rp_entries
19843: WHERE object_id = modelid AND enclosing_folder <> 0 AND object_type = 'PRJ' AND deleted_flag = '0';
19844:
19845: FOR rp_rec IN (SELECT NAME
19846: FROM cz_rp_entries
19847: START WITH object_type = 'FLD' AND object_id = l_folder_id
19848: CONNECT BY PRIOR enclosing_folder = object_id AND object_type = 'FLD' AND object_id <> 0 AND deleted_flag = '0')
19849: LOOP
19850: l_folder_path := rp_rec.NAME || '/' || l_folder_path;

Line 19907: FROM cz_rp_entries

19903: WHERE server_local_id = 0;
19904:
19905: SELECT NAME
19906: INTO original_name
19907: FROM cz_rp_entries
19908: WHERE object_id = p_devl_project_id AND object_type = 'PRJ' AND deleted_flag = '0';
19909: EXCEPTION
19910: WHEN NO_DATA_FOUND
19911: THEN

Line 19941: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_rp_entries'

19937: ELSE
19938: l_endBr:=')';
19939: END IF;
19940: BEGIN
19941: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_rp_entries'
19942: || cz_pb_mgr.v_db_link
19943: || ' WHERE deleted_flag = ''0'' AND object_type = ''PRJ'' AND '
19944: || ' name = :1'
19945: INTO v_null

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

19950: RETURN v_name || l_endBr;
19951: END;
19952:
19953: BEGIN
19954: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM cz_rp_entries'
19955: || cz_pb_mgr.v_db_link
19956: || ' WHERE deleted_flag = ''0'' AND object_type = ''PRJ'' AND '
19957: || ' name LIKE :1'
19958: INTO v_null

Line 19997: v_rp_entries_name cz_rp_entries.NAME%TYPE;

19993: l_tgt_msg VARCHAR2(2000);
19994: l_msg_data VARCHAR2(2000);
19995: l_msg_count NUMBER;
19996: l_lock_status VARCHAR2(1);
19997: v_rp_entries_name cz_rp_entries.NAME%TYPE;
19998: v_rp_entries_desc cz_rp_entries.description%TYPE;
19999: v_object_id cz_rp_entries.object_id%TYPE;
20000: v_rp_orig_sys_ref VARCHAR2(255);
20001: v_imp_ps_node_count PLS_INTEGER;

Line 19998: v_rp_entries_desc cz_rp_entries.description%TYPE;

19994: l_msg_data VARCHAR2(2000);
19995: l_msg_count NUMBER;
19996: l_lock_status VARCHAR2(1);
19997: v_rp_entries_name cz_rp_entries.NAME%TYPE;
19998: v_rp_entries_desc cz_rp_entries.description%TYPE;
19999: v_object_id cz_rp_entries.object_id%TYPE;
20000: v_rp_orig_sys_ref VARCHAR2(255);
20001: v_imp_ps_node_count PLS_INTEGER;
20002: l_locked_models cz_security_pvt.number_type_tbl;

Line 19999: v_object_id cz_rp_entries.object_id%TYPE;

19995: l_msg_count NUMBER;
19996: l_lock_status VARCHAR2(1);
19997: v_rp_entries_name cz_rp_entries.NAME%TYPE;
19998: v_rp_entries_desc cz_rp_entries.description%TYPE;
19999: v_object_id cz_rp_entries.object_id%TYPE;
20000: v_rp_orig_sys_ref VARCHAR2(255);
20001: v_imp_ps_node_count PLS_INTEGER;
20002: l_locked_models cz_security_pvt.number_type_tbl;
20003: l_upto_date_status VARCHAR2(2000);

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

20279:
20280: insert_template_elements;
20281:
20282: --------------------------------------------------------------------------------------------
20283: --If this is Model Migration, insert into cz_rp_entries, calculate max_persistent_rec_id and
20284: --and insert into CZ_PERSISTENT_REC_IDS with its value, report the migrated and not migrated models.
20285: --------------------------------------------------------------------------------------------
20286:
20287: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR) THEN

Line 20349: || 'insert into cz_rp_entries'

20345: cz_pb_mgr.v_rp_desc := v_rp_entries_desc;
20346:
20347: EXECUTE IMMEDIATE 'BEGIN'
20348: || ' '
20349: || 'insert into cz_rp_entries'
20350: || cz_pb_mgr.v_db_link
20351: || ' ( OBJECT_TYPE'
20352: || ' '
20353: || ',OBJECT_ID'

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

20382: || ' '
20383: || 'END;';
20384: EXCEPTION
20385: WHEN OTHERS THEN
20386: cz_pb_mgr.v_err_message := 'Error in inserting into cz_rp_entries: ' || SQLERRM;
20387: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MIGRATEMODEL', SQLCODE);
20388: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
20389: END;
20390:

Line 23027: FROM cz_rp_entries

23023: BEGIN
23024: BEGIN
23025: SELECT name
23026: INTO original_name
23027: FROM cz_rp_entries
23028: WHERE object_id = p_devl_project_id
23029: AND object_type = 'PRJ'
23030: AND deleted_flag = '0';
23031: EXCEPTION

Line 23044: FROM cz_rp_entries

23040: BEGIN
23041:
23042: 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)
23043: INTO L
23044: FROM cz_rp_entries
23045: WHERE name LIKE 'Copy (%) of '||original_name
23046: and instr(SUBSTR(name, 1, instr(name,original_name, -1, 1)-1),'Copy (',7)=0
23047: 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'
23048: AND deleted_flag = '0' and object_type='PRJ';

Line 23086: l_model_id cz_rp_entries.object_id%TYPE;

23082: ,x_msg_count OUT NOCOPY NUMBER
23083: ,x_msg_data OUT NOCOPY VARCHAR2
23084: )
23085: IS
23086: l_model_id cz_rp_entries.object_id%TYPE;
23087: l_publication_mode cz_model_publications.publication_mode%TYPE;
23088: l_usg_id cz_publication_usages.usage_id%TYPE;
23089: l_lang_code cz_pb_languages.LANGUAGE%TYPE;
23090: l_start_date DATE;

Line 23135: FROM cz_rp_entries

23131: FROM cz_devl_projects
23132: WHERE cz_devl_projects.devl_project_id = p_model_id
23133: AND cz_devl_projects.deleted_flag = '0'
23134: AND cz_devl_projects.devl_project_id IN(SELECT object_id
23135: FROM cz_rp_entries
23136: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0');
23137: EXCEPTION
23138: WHEN NO_DATA_FOUND
23139: THEN

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

23132: WHERE cz_devl_projects.devl_project_id = p_model_id
23133: AND cz_devl_projects.deleted_flag = '0'
23134: AND cz_devl_projects.devl_project_id IN(SELECT object_id
23135: FROM cz_rp_entries
23136: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0');
23137: EXCEPTION
23138: WHEN NO_DATA_FOUND
23139: THEN
23140: RAISE no_model_exists;

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

24307: IF (what_exists = 'PROP')
24308: THEN
24309: l_sql_str :=
24310: 'SELECT t.property_id, t.NAME FROM cz_properties' || cz_pb_mgr.v_db_link || ' t' || ',' ||
24311: 'cz_rp_entries' || cz_pb_mgr.v_db_link || ' t1' || ',' ||
24312: 'cz_properties s' || ' ' ||
24313: 'WHERE t1.object_id = t.property_id AND t1.object_type = ''PRP'' ' || ' ' ||
24314: 'AND t1.DELETED_FLAG = ''0'' '|| ' ' ||
24315: 'AND t.NAME = s.NAME AND t1.NAME = s.NAME' || ' ' ||

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

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

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

24358: l_sync_msg_object_type_tkn := cz_archive_caption;
24359: ELSIF(what_exists = 'EFF_SETS')
24360: THEN
24361: l_sql_str :=
24362: 'SELECT t.object_id, t.NAME FROM cz_rp_entries' || cz_pb_mgr.v_db_link || 't' || ',' ||
24363: 'cz_effectivity_sets s' || ' ' ||
24364: 'WHERE t.object_type = ''EFF'' AND t.NAME = s.NAME' || ' ' ||
24365: 'AND t.DELETED_FLAG = ''0'' '|| ' ' ||
24366: 'AND s.effectivity_set_id = :1';

Line 24687: ----------begin insert into cz_rp_entries----------------

24683: ,plsql_table_list
24684: ,'cz_pb_mgr.g_archives_old_tbl'
24685: ,cz_pb_mgr.g_archives_old_tbl
24686: );
24687: ----------begin insert into cz_rp_entries----------------
24688: plsql_table_list.DELETE;
24689: rec_count := 1;
24690: plsql_table_list(rec_count).col_name := 'object_id';
24691: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_v_ht_sync_archives';

Line 24698: insert_into_rp_entries('cz_rp_entries'

24694: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_archives_obj_type';
24695: rec_count := rec_count + 1;
24696: plsql_table_list(rec_count).col_name := 'enclosing_folder';
24697: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_enclosing_fld_rp_entry';
24698: insert_into_rp_entries('cz_rp_entries'
24699: ,'object_id'
24700: ,'object_type'
24701: ,cz_pb_mgr.v_db_link
24702: ,plsql_table_list

Line 24708: ----------end insert into cz_rp_entries----------------

24704: ,'cz_pb_mgr.g_archives_obj_type'
24705: ,cz_pb_mgr.g_archives_old_tbl
24706: ,cz_pb_mgr.g_archives_obj_type
24707: );
24708: ----------end insert into cz_rp_entries----------------
24709: END IF;
24710:
24711: 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');
24712: -- Need to use the right array to resolve the devl project ids.