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_RULE_FOLDERS

Line 432: ELSIF(p_table_name = 'cz_rule_folders')

428: cz_pb_mgr.v_property_record_ref.DELETE;
429: cz_pb_mgr.v_type_property_record_ref.DELETE;
430: cz_pb_mgr.v_type_record_ref.DELETE;
431: END IF;
432: ELSIF(p_table_name = 'cz_rule_folders')
433: THEN
434: IF (p_table_type = 'ref')
435: THEN
436: cz_pb_mgr.v_cz_folders_id_old_ref.DELETE;

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

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);
7249:
7250: DELETE FROM cz_pb_model_exports
7251: WHERE publication_id = cz_pb_mgr.v_publication_id;

Line 12989: l_object_type cz_rule_folders.object_type%TYPE;

12985: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12986: l_cz_rules_ui_tbl cz_pb_mgr.t_ref;
12987: l_cz_rules_perst_id_tbl cz_pb_mgr.t_ref;
12988: l_eff_usg_mask_tbl cz_pb_mgr.t_eff_usage_mask;
12989: l_object_type cz_rule_folders.object_type%TYPE;
12990: l_rule_type_tbl cz_pb_mgr.t_ref;
12991:
12992: rec_count PLS_INTEGER;
12993:

Line 13175: FROM cz_rule_folders

13171: FOR j IN p_rules_old_array.FIRST .. p_rules_old_array.LAST
13172: LOOP
13173: BEGIN
13174: SELECT object_type INTO l_object_type
13175: FROM cz_rule_folders
13176: WHERE rule_folder_id = p_rules_old_array(j) AND object_type NOT IN ('FNC', 'RFL', 'RSQ');
13177: cz_pb_mgr.v_cz_rules_obj_ref(j) := l_object_type;
13178: EXCEPTION
13179: WHEN NO_DATA_FOUND THEN

Line 13210: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);

13206: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
13207: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
13208: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
13209: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
13210: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
13211: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
13212: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
13213: clear_tables('cz_expression_nodes', 'ref', cz_pb_mgr.v_status_code);
13214: clear_tables('cz_rules', 'ref', cz_pb_mgr.v_status_code);

Line 13211: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);

13207: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
13208: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
13209: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
13210: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
13211: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
13212: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
13213: clear_tables('cz_expression_nodes', 'ref', cz_pb_mgr.v_status_code);
13214: clear_tables('cz_rules', 'ref', cz_pb_mgr.v_status_code);
13215: clear_tables('cz_des_chart_features', 'ref', cz_pb_mgr.v_status_code);

Line 16175: -----insert new records into cz_rule_folders

16171: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
16172: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
16173: );
16174:
16175: -----insert new records into cz_rule_folders
16176: plsql_table_list.DELETE;
16177: rec_count := 1;
16178: plsql_table_list(rec_count).col_name := 'rule_folder_id';
16179: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rule_id_new_ref';

Line 16193: insert_into_table('cz_rule_folders'

16189: rec_count := rec_count + 1;
16190: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
16191: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_eff_id_ref';
16192: ----------insert into cz_func_comp_specs
16193: insert_into_table('cz_rule_folders'
16194: ,'rule_folder_id'
16195: ,'object_type'
16196: ,cz_pb_mgr.v_db_link
16197: ,plsql_table_list

Line 16555: v_cz_rule_folders_orig_tbl cz_pb_mgr.orig_sys_ref_type;

16551: v_cz_des_cells_sopt_id_tbl cz_pb_mgr.t_ref;
16552: v_cz_des_cells_popt_id_tbl cz_pb_mgr.t_ref;
16553: v_cz_des_cells_sexpl_id_tbl cz_pb_mgr.t_ref;
16554: v_cz_des_cells_mark_char_tbl cz_pb_mgr.exprflgtype;
16555: v_cz_rule_folders_orig_tbl cz_pb_mgr.orig_sys_ref_type;
16556: v_cz_rule_folders_eff_tbl cz_pb_mgr.t_ref;
16557: v_sig_count NUMBER := 0;
16558: v_object_type_tbl cz_pb_mgr.objtype;
16559: rec_count_rsq NUMBER := 0;

Line 16556: v_cz_rule_folders_eff_tbl cz_pb_mgr.t_ref;

16552: v_cz_des_cells_popt_id_tbl cz_pb_mgr.t_ref;
16553: v_cz_des_cells_sexpl_id_tbl cz_pb_mgr.t_ref;
16554: v_cz_des_cells_mark_char_tbl cz_pb_mgr.exprflgtype;
16555: v_cz_rule_folders_orig_tbl cz_pb_mgr.orig_sys_ref_type;
16556: v_cz_rule_folders_eff_tbl cz_pb_mgr.t_ref;
16557: v_sig_count NUMBER := 0;
16558: v_object_type_tbl cz_pb_mgr.objtype;
16559: rec_count_rsq NUMBER := 0;
16560: v_rule_type_tbl cz_pb_mgr.t_ref;

Line 16593: -------insert into cz_rule_folders

16589: get_rem_nodes_of_models(cz_pb_mgr.v_models_not_to_be_exported
16590: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
16591: ,cz_pb_mgr.v_status_code
16592: );
16593: -------insert into cz_rule_folders
16594: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
16595: mm_v_tbl_rule_seq.DELETE;
16596:
16597: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)

Line 16594: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);

16590: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
16591: ,cz_pb_mgr.v_status_code
16592: );
16593: -------insert into cz_rule_folders
16594: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
16595: mm_v_tbl_rule_seq.DELETE;
16596:
16597: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
16598: THEN

Line 16601: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);

16597: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
16598: THEN
16599: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST
16600: LOOP
16601: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
16602: v_cz_folders_pf_id_tbl.DELETE;
16603: v_cz_folders_pj_id_tbl.DELETE;
16604: v_cz_rule_folders_orig_tbl.DELETE;
16605: v_cz_rule_folders_eff_tbl.DELETE;

Line 16604: v_cz_rule_folders_orig_tbl.DELETE;

16600: LOOP
16601: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
16602: v_cz_folders_pf_id_tbl.DELETE;
16603: v_cz_folders_pj_id_tbl.DELETE;
16604: v_cz_rule_folders_orig_tbl.DELETE;
16605: v_cz_rule_folders_eff_tbl.DELETE;
16606: v_object_type_tbl.DELETE;
16607:
16608: BEGIN

Line 16605: v_cz_rule_folders_eff_tbl.DELETE;

16601: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
16602: v_cz_folders_pf_id_tbl.DELETE;
16603: v_cz_folders_pj_id_tbl.DELETE;
16604: v_cz_rule_folders_orig_tbl.DELETE;
16605: v_cz_rule_folders_eff_tbl.DELETE;
16606: v_object_type_tbl.DELETE;
16607:
16608: BEGIN
16609: IF (cz_pb_mgr.v_session_parameter = model_copy)

Line 16612: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rule_folders_seq

16608: BEGIN
16609: IF (cz_pb_mgr.v_session_parameter = model_copy)
16610: THEN
16611: IF (p_copy_rules_flag = 'YES') THEN
16612: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rule_folders_seq
16613: , 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link
16614: ,cz_pb_mgr.v_oraclesequenceincr
16615: )
16616: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id

Line 16613: , 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link

16609: IF (cz_pb_mgr.v_session_parameter = model_copy)
16610: THEN
16611: IF (p_copy_rules_flag = 'YES') THEN
16612: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rule_folders_seq
16613: , 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link
16614: ,cz_pb_mgr.v_oraclesequenceincr
16615: )
16616: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id
16617: ,orig_sys_ref, object_type

Line 16619: ,cz_pb_mgr.v_cz_folders_id_old_tbl, v_cz_folders_pf_id_tbl, v_cz_folders_pj_id_tbl, v_cz_rule_folders_orig_tbl

16615: )
16616: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id
16617: ,orig_sys_ref, object_type
16618: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl
16619: ,cz_pb_mgr.v_cz_folders_id_old_tbl, v_cz_folders_pf_id_tbl, v_cz_folders_pj_id_tbl, v_cz_rule_folders_orig_tbl
16620: ,v_cz_rule_folders_eff_tbl, v_object_type_tbl
16621: FROM cz_rule_folders t
16622: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND t.deleted_flag = '0' AND t.object_type IN('RFL', 'RSQ');
16623: ELSE -- Just create the Model Rule Folder if not copying rules

Line 16620: ,v_cz_rule_folders_eff_tbl, v_object_type_tbl

16616: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id
16617: ,orig_sys_ref, object_type
16618: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl
16619: ,cz_pb_mgr.v_cz_folders_id_old_tbl, v_cz_folders_pf_id_tbl, v_cz_folders_pj_id_tbl, v_cz_rule_folders_orig_tbl
16620: ,v_cz_rule_folders_eff_tbl, v_object_type_tbl
16621: FROM cz_rule_folders t
16622: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND t.deleted_flag = '0' AND t.object_type IN('RFL', 'RSQ');
16623: ELSE -- Just create the Model Rule Folder if not copying rules
16624: SELECT cz_pb_mgr.sequence_generate(

Line 16621: FROM cz_rule_folders t

16617: ,orig_sys_ref, object_type
16618: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl
16619: ,cz_pb_mgr.v_cz_folders_id_old_tbl, v_cz_folders_pf_id_tbl, v_cz_folders_pj_id_tbl, v_cz_rule_folders_orig_tbl
16620: ,v_cz_rule_folders_eff_tbl, v_object_type_tbl
16621: FROM cz_rule_folders t
16622: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND t.deleted_flag = '0' AND t.object_type IN('RFL', 'RSQ');
16623: ELSE -- Just create the Model Rule Folder if not copying rules
16624: SELECT cz_pb_mgr.sequence_generate(
16625: cz_pb_mgr.cz_rule_folders_seq,

Line 16625: cz_pb_mgr.cz_rule_folders_seq,

16621: FROM cz_rule_folders t
16622: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND t.deleted_flag = '0' AND t.object_type IN('RFL', 'RSQ');
16623: ELSE -- Just create the Model Rule Folder if not copying rules
16624: SELECT cz_pb_mgr.sequence_generate(
16625: cz_pb_mgr.cz_rule_folders_seq,
16626: 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link,
16627: cz_pb_mgr.v_oraclesequenceincr
16628: ),
16629: rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id,orig_sys_ref, object_type

Line 16626: 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link,

16622: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND t.deleted_flag = '0' AND t.object_type IN('RFL', 'RSQ');
16623: ELSE -- Just create the Model Rule Folder if not copying rules
16624: SELECT cz_pb_mgr.sequence_generate(
16625: cz_pb_mgr.cz_rule_folders_seq,
16626: 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link,
16627: cz_pb_mgr.v_oraclesequenceincr
16628: ),
16629: rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id,orig_sys_ref, object_type
16630: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl, cz_pb_mgr.v_cz_folders_id_old_tbl, v_cz_folders_pf_id_tbl,

Line 16631: v_cz_folders_pj_id_tbl, v_cz_rule_folders_orig_tbl, v_cz_rule_folders_eff_tbl, v_object_type_tbl

16627: cz_pb_mgr.v_oraclesequenceincr
16628: ),
16629: rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id,orig_sys_ref, object_type
16630: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl, cz_pb_mgr.v_cz_folders_id_old_tbl, v_cz_folders_pf_id_tbl,
16631: v_cz_folders_pj_id_tbl, v_cz_rule_folders_orig_tbl, v_cz_rule_folders_eff_tbl, v_object_type_tbl
16632: FROM cz_rule_folders t
16633: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
16634: AND t.deleted_flag = '0'
16635: AND t.parent_rule_folder_id IS NULL

Line 16632: FROM cz_rule_folders t

16628: ),
16629: rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id,orig_sys_ref, object_type
16630: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl, cz_pb_mgr.v_cz_folders_id_old_tbl, v_cz_folders_pf_id_tbl,
16631: v_cz_folders_pj_id_tbl, v_cz_rule_folders_orig_tbl, v_cz_rule_folders_eff_tbl, v_object_type_tbl
16632: FROM cz_rule_folders t
16633: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
16634: AND t.deleted_flag = '0'
16635: AND t.parent_rule_folder_id IS NULL
16636: AND t.object_type = 'RFL';

Line 16641: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rule_folders_seq

16637: END IF;
16638: ELSE
16639: IF (p_copy_rules_flag = 'YES')
16640: THEN
16641: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rule_folders_seq
16642: , 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link
16643: ,cz_pb_mgr.v_oraclesequenceincr
16644: )
16645: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id

Line 16642: , 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link

16638: ELSE
16639: IF (p_copy_rules_flag = 'YES')
16640: THEN
16641: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rule_folders_seq
16642: , 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link
16643: ,cz_pb_mgr.v_oraclesequenceincr
16644: )
16645: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id
16646: ,orig_sys_ref, object_type

Line 16648: ,cz_pb_mgr.v_cz_folders_id_old_tbl, v_cz_folders_pf_id_tbl, v_cz_folders_pj_id_tbl, v_cz_rule_folders_eff_tbl

16644: )
16645: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id
16646: ,orig_sys_ref, object_type
16647: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl
16648: ,cz_pb_mgr.v_cz_folders_id_old_tbl, v_cz_folders_pf_id_tbl, v_cz_folders_pj_id_tbl, v_cz_rule_folders_eff_tbl
16649: ,v_cz_rule_folders_orig_tbl, v_object_type_tbl
16650: FROM cz_rule_folders t
16651: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
16652: AND t.deleted_flag = '0'

Line 16649: ,v_cz_rule_folders_orig_tbl, v_object_type_tbl

16645: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id
16646: ,orig_sys_ref, object_type
16647: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl
16648: ,cz_pb_mgr.v_cz_folders_id_old_tbl, v_cz_folders_pf_id_tbl, v_cz_folders_pj_id_tbl, v_cz_rule_folders_eff_tbl
16649: ,v_cz_rule_folders_orig_tbl, v_object_type_tbl
16650: FROM cz_rule_folders t
16651: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
16652: AND t.deleted_flag = '0'
16653: AND t.object_type IN('RFL', 'RSQ');

Line 16650: FROM cz_rule_folders t

16646: ,orig_sys_ref, object_type
16647: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl
16648: ,cz_pb_mgr.v_cz_folders_id_old_tbl, v_cz_folders_pf_id_tbl, v_cz_folders_pj_id_tbl, v_cz_rule_folders_eff_tbl
16649: ,v_cz_rule_folders_orig_tbl, v_object_type_tbl
16650: FROM cz_rule_folders t
16651: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
16652: AND t.deleted_flag = '0'
16653: AND t.object_type IN('RFL', 'RSQ');
16654: ELSE -- Just create the Model Rule Folder if not copying rules

Line 16656: cz_pb_mgr.cz_rule_folders_seq,

16652: AND t.deleted_flag = '0'
16653: AND t.object_type IN('RFL', 'RSQ');
16654: ELSE -- Just create the Model Rule Folder if not copying rules
16655: SELECT cz_pb_mgr.sequence_generate(
16656: cz_pb_mgr.cz_rule_folders_seq,
16657: 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link,
16658: cz_pb_mgr.v_oraclesequenceincr
16659: ), rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id, orig_sys_ref, object_type
16660: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl, cz_pb_mgr.v_cz_folders_id_old_tbl, v_cz_folders_pf_id_tbl,

Line 16657: 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link,

16653: AND t.object_type IN('RFL', 'RSQ');
16654: ELSE -- Just create the Model Rule Folder if not copying rules
16655: SELECT cz_pb_mgr.sequence_generate(
16656: cz_pb_mgr.cz_rule_folders_seq,
16657: 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link,
16658: cz_pb_mgr.v_oraclesequenceincr
16659: ), rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id, orig_sys_ref, object_type
16660: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl, cz_pb_mgr.v_cz_folders_id_old_tbl, v_cz_folders_pf_id_tbl,
16661: v_cz_folders_pj_id_tbl, v_cz_rule_folders_eff_tbl, v_cz_rule_folders_orig_tbl, v_object_type_tbl

Line 16661: v_cz_folders_pj_id_tbl, v_cz_rule_folders_eff_tbl, v_cz_rule_folders_orig_tbl, v_object_type_tbl

16657: 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link,
16658: cz_pb_mgr.v_oraclesequenceincr
16659: ), rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id, orig_sys_ref, object_type
16660: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl, cz_pb_mgr.v_cz_folders_id_old_tbl, v_cz_folders_pf_id_tbl,
16661: v_cz_folders_pj_id_tbl, v_cz_rule_folders_eff_tbl, v_cz_rule_folders_orig_tbl, v_object_type_tbl
16662: FROM cz_rule_folders t
16663: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
16664: AND t.deleted_flag = '0'
16665: AND t.parent_rule_folder_id IS NULL

Line 16662: FROM cz_rule_folders t

16658: cz_pb_mgr.v_oraclesequenceincr
16659: ), rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id, orig_sys_ref, object_type
16660: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl, cz_pb_mgr.v_cz_folders_id_old_tbl, v_cz_folders_pf_id_tbl,
16661: v_cz_folders_pj_id_tbl, v_cz_rule_folders_eff_tbl, v_cz_rule_folders_orig_tbl, v_object_type_tbl
16662: FROM cz_rule_folders t
16663: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
16664: AND t.deleted_flag = '0'
16665: AND t.parent_rule_folder_id IS NULL
16666: AND t.object_type = 'RFL';

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

16672: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
16673: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RULEFOLDERS', SQLCODE);
16674: WHEN OTHERS
16675: THEN
16676: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rule_folders', 'SQLERRM', SQLERRM);
16677: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RULEFOLDERS', SQLCODE);
16678: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16679: RAISE;
16680: END;

Line 16695: cz_pb_mgr.v_cz_folders_eff_ref(rec_count) := v_cz_rule_folders_eff_tbl(k);

16691: cz_pb_mgr.v_cz_folders_id_old_ref(rec_count) := cz_pb_mgr.v_cz_folders_id_old_tbl(k);
16692: cz_pb_mgr.v_cz_folders_id_idx_ref(cz_pb_mgr.v_cz_folders_id_old_tbl(k)):=cz_pb_mgr.v_cz_folders_id_new_tbl(k);
16693: cz_pb_mgr.v_cz_folders_pf_id_ref(rec_count) := v_cz_folders_pf_id_tbl(k);
16694: cz_pb_mgr.v_cz_folders_pj_id_ref(rec_count) := v_cz_folders_pj_id_tbl(k);
16695: cz_pb_mgr.v_cz_folders_eff_ref(rec_count) := v_cz_rule_folders_eff_tbl(k);
16696: cz_pb_mgr.v_cz_folders_orig_ref(rec_count) := v_cz_rule_folders_orig_tbl(k);
16697: cz_pb_mgr.v_cz_folders_obj_ref(rec_count) := v_object_type_tbl(k);
16698:
16699: IF cz_pb_mgr.v_session_parameter=pub_model AND p_copy_rules_flag<>'YES' THEN

Line 16696: cz_pb_mgr.v_cz_folders_orig_ref(rec_count) := v_cz_rule_folders_orig_tbl(k);

16692: cz_pb_mgr.v_cz_folders_id_idx_ref(cz_pb_mgr.v_cz_folders_id_old_tbl(k)):=cz_pb_mgr.v_cz_folders_id_new_tbl(k);
16693: cz_pb_mgr.v_cz_folders_pf_id_ref(rec_count) := v_cz_folders_pf_id_tbl(k);
16694: cz_pb_mgr.v_cz_folders_pj_id_ref(rec_count) := v_cz_folders_pj_id_tbl(k);
16695: cz_pb_mgr.v_cz_folders_eff_ref(rec_count) := v_cz_rule_folders_eff_tbl(k);
16696: cz_pb_mgr.v_cz_folders_orig_ref(rec_count) := v_cz_rule_folders_orig_tbl(k);
16697: cz_pb_mgr.v_cz_folders_obj_ref(rec_count) := v_object_type_tbl(k);
16698:
16699: IF cz_pb_mgr.v_session_parameter=pub_model AND p_copy_rules_flag<>'YES' THEN
16700: v_model_root_folder_map(cz_pb_mgr.v_models_to_be_exported(i)):=v_cz_folders_id_old_tbl(k);

Line 16725: -----insert new records into cz_rule_folders

16721: ,'cz_pb_mgr.v_cz_eff_sets_new_tbl'
16722: ,'Eff sets of rule folders'
16723: );
16724: resolve_ids(cz_pb_mgr.v_cz_folders_eff_ref, cz_pb_mgr.v_cz_eff_sets_idx_tbl, 'eff id of rule folders');
16725: -----insert new records into cz_rule_folders
16726: plsql_table_list.DELETE;
16727: rec_count := 1;
16728: plsql_table_list(rec_count).col_name := 'rule_folder_id';
16729: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_folders_id_new_ref';

Line 16745: insert_into_table('cz_rule_folders'

16741: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_folders_eff_ref';
16742: rec_count := rec_count + 1;
16743: plsql_table_list(rec_count).col_name := 'orig_sys_ref';
16744: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_folders_orig_ref';
16745: insert_into_table('cz_rule_folders'
16746: ,'rule_folder_id'
16747: ,'object_type'
16748: ,cz_pb_mgr.v_db_link
16749: ,plsql_table_list

Line 16759: v_cz_rule_folders_eff_tbl.DELETE;

16755:
16756: --------release local pl/sql tables of rule folders
16757: v_cz_folders_pf_id_tbl.DELETE;
16758: v_cz_folders_pj_id_tbl.DELETE;
16759: v_cz_rule_folders_eff_tbl.DELETE;
16760: v_cz_rule_folders_orig_tbl.DELETE;
16761: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
16762:
16763: -------------insert into func comp specs

Line 16760: v_cz_rule_folders_orig_tbl.DELETE;

16756: --------release local pl/sql tables of rule folders
16757: v_cz_folders_pf_id_tbl.DELETE;
16758: v_cz_folders_pj_id_tbl.DELETE;
16759: v_cz_rule_folders_eff_tbl.DELETE;
16760: v_cz_rule_folders_orig_tbl.DELETE;
16761: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
16762:
16763: -------------insert into func comp specs
16764: IF cz_pb_mgr.v_cz_func_comp_old_ref.COUNT > 0 THEN

Line 16761: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);

16757: v_cz_folders_pf_id_tbl.DELETE;
16758: v_cz_folders_pj_id_tbl.DELETE;
16759: v_cz_rule_folders_eff_tbl.DELETE;
16760: v_cz_rule_folders_orig_tbl.DELETE;
16761: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
16762:
16763: -------------insert into func comp specs
16764: IF cz_pb_mgr.v_cz_func_comp_old_ref.COUNT > 0 THEN
16765: IF cz_pb_mgr.v_session_parameter=pub_model AND p_copy_rules_flag<>'YES' THEN

Line 16839: -----insert new records into cz_rule_folders

16835: THEN
16836: log_timing_message('end insert_into_table cz_func_comp_specs');
16837: END IF;
16838:
16839: -----insert new records into cz_rule_folders
16840: plsql_table_list.DELETE;
16841: rec_count := 1;
16842: plsql_table_list(rec_count).col_name := 'rule_folder_id';
16843: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_func_comp_new_ref';

Line 16854: insert_into_table('cz_rule_folders'

16850: rec_count := rec_count + 1;
16851: plsql_table_list(rec_count).col_name := 'parent_rule_folder_id';
16852: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_func_fld_old_ref';
16853: ----------insert into cz_func_comp_specs
16854: insert_into_table('cz_rule_folders'
16855: ,'rule_folder_id'
16856: ,'object_type'
16857: ,cz_pb_mgr.v_db_link
16858: ,plsql_table_list

Line 24979: l_rule_folder_name cz_rule_folders.NAME%TYPE;

24975: l_sql_string VARCHAR2(2000);
24976: remote_effs_cv ref_cursor;
24977: remote_rule_seq_name_cv ref_cursor;
24978: l_effecivity_set_id NUMBER;
24979: l_rule_folder_name cz_rule_folders.NAME%TYPE;
24980: l_rule_name cz_rules.NAME%TYPE;
24981: BEGIN
24982: --all the rule sequences have been accumulated here
24983: IF (mm_v_tbl_rule_seq.COUNT > 0) THEN

Line 25026: || 'FROM cz_rule_folders'

25022: --log the event
25023: l_sql_string :=
25024: 'SELECT name'
25025: || ' '
25026: || 'FROM cz_rule_folders'
25027: || cz_pb_mgr.v_db_link
25028: || ' '
25029: || 'WHERE rule_folder_id = :1'
25030: || ' '