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 383: ELSIF(p_table_name = 'cz_rule_folders')

379: cz_pb_mgr.v_property_record_ref.DELETE;
380: cz_pb_mgr.v_type_property_record_ref.DELETE;
381: cz_pb_mgr.v_type_record_ref.DELETE;
382: END IF;
383: ELSIF(p_table_name = 'cz_rule_folders')
384: THEN
385: IF (p_table_type = 'ref')
386: THEN
387: cz_pb_mgr.v_cz_folders_id_old_ref.DELETE;

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

6522:
6523: 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);
6524: 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);
6525:
6526: 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);
6527: 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);
6528:
6529: DELETE FROM cz_pb_model_exports
6530: WHERE publication_id = cz_pb_mgr.v_publication_id;

Line 12025: l_object_type cz_rule_folders.object_type%TYPE;

12021: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12022: l_cz_rules_ui_tbl cz_pb_mgr.t_ref;
12023: l_cz_rules_perst_id_tbl cz_pb_mgr.t_ref;
12024: l_eff_usg_mask_tbl cz_pb_mgr.t_eff_usage_mask;
12025: l_object_type cz_rule_folders.object_type%TYPE;
12026: l_rule_type_tbl cz_pb_mgr.t_ref;
12027:
12028: rec_count PLS_INTEGER;
12029:

Line 12183: FROM cz_rule_folders

12179: FOR j IN p_rules_old_array.FIRST .. p_rules_old_array.LAST
12180: LOOP
12181: BEGIN
12182: SELECT object_type INTO l_object_type
12183: FROM cz_rule_folders
12184: WHERE rule_folder_id = p_rules_old_array(j) AND object_type NOT IN ('FNC', 'RFL', 'RSQ');
12185: cz_pb_mgr.v_cz_rules_obj_ref(j) := l_object_type;
12186: EXCEPTION
12187: WHEN NO_DATA_FOUND THEN

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

12214: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
12215: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
12216: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
12217: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
12218: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
12219: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
12220: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
12221: clear_tables('cz_expression_nodes', 'ref', cz_pb_mgr.v_status_code);
12222: clear_tables('cz_rules', 'ref', cz_pb_mgr.v_status_code);

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

12215: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
12216: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
12217: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
12218: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
12219: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
12220: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
12221: clear_tables('cz_expression_nodes', 'ref', cz_pb_mgr.v_status_code);
12222: clear_tables('cz_rules', 'ref', cz_pb_mgr.v_status_code);
12223: clear_tables('cz_des_chart_features', 'ref', cz_pb_mgr.v_status_code);

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

15057: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
15058: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
15059: );
15060:
15061: -----insert new records into cz_rule_folders
15062: plsql_table_list.DELETE;
15063: rec_count := 1;
15064: plsql_table_list(rec_count).col_name := 'rule_folder_id';
15065: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rule_id_new_ref';

Line 15079: insert_into_table('cz_rule_folders'

15075: rec_count := rec_count + 1;
15076: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
15077: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_eff_id_ref';
15078: ----------insert into cz_func_comp_specs
15079: insert_into_table('cz_rule_folders'
15080: ,'rule_folder_id'
15081: ,'object_type'
15082: ,cz_pb_mgr.v_db_link
15083: ,plsql_table_list

Line 15441: v_cz_rule_folders_orig_tbl cz_pb_mgr.orig_sys_ref_type;

15437: v_cz_des_cells_sopt_id_tbl cz_pb_mgr.t_ref;
15438: v_cz_des_cells_popt_id_tbl cz_pb_mgr.t_ref;
15439: v_cz_des_cells_sexpl_id_tbl cz_pb_mgr.t_ref;
15440: v_cz_des_cells_mark_char_tbl cz_pb_mgr.exprflgtype;
15441: v_cz_rule_folders_orig_tbl cz_pb_mgr.orig_sys_ref_type;
15442: v_cz_rule_folders_eff_tbl cz_pb_mgr.t_ref;
15443: v_sig_count NUMBER := 0;
15444: v_object_type_tbl cz_pb_mgr.objtype;
15445: rec_count_rsq NUMBER := 0;

Line 15442: v_cz_rule_folders_eff_tbl cz_pb_mgr.t_ref;

15438: v_cz_des_cells_popt_id_tbl cz_pb_mgr.t_ref;
15439: v_cz_des_cells_sexpl_id_tbl cz_pb_mgr.t_ref;
15440: v_cz_des_cells_mark_char_tbl cz_pb_mgr.exprflgtype;
15441: v_cz_rule_folders_orig_tbl cz_pb_mgr.orig_sys_ref_type;
15442: v_cz_rule_folders_eff_tbl cz_pb_mgr.t_ref;
15443: v_sig_count NUMBER := 0;
15444: v_object_type_tbl cz_pb_mgr.objtype;
15445: rec_count_rsq NUMBER := 0;
15446: v_rule_type_tbl cz_pb_mgr.t_ref;

Line 15479: -------insert into cz_rule_folders

15475: get_rem_nodes_of_models(cz_pb_mgr.v_models_not_to_be_exported
15476: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
15477: ,cz_pb_mgr.v_status_code
15478: );
15479: -------insert into cz_rule_folders
15480: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
15481: mm_v_tbl_rule_seq.DELETE;
15482:
15483: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)

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

15476: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
15477: ,cz_pb_mgr.v_status_code
15478: );
15479: -------insert into cz_rule_folders
15480: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
15481: mm_v_tbl_rule_seq.DELETE;
15482:
15483: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
15484: THEN

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

15483: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
15484: THEN
15485: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST
15486: LOOP
15487: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
15488: v_cz_folders_pf_id_tbl.DELETE;
15489: v_cz_folders_pj_id_tbl.DELETE;
15490: v_cz_rule_folders_orig_tbl.DELETE;
15491: v_cz_rule_folders_eff_tbl.DELETE;

Line 15490: v_cz_rule_folders_orig_tbl.DELETE;

15486: LOOP
15487: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
15488: v_cz_folders_pf_id_tbl.DELETE;
15489: v_cz_folders_pj_id_tbl.DELETE;
15490: v_cz_rule_folders_orig_tbl.DELETE;
15491: v_cz_rule_folders_eff_tbl.DELETE;
15492: v_object_type_tbl.DELETE;
15493:
15494: BEGIN

Line 15491: v_cz_rule_folders_eff_tbl.DELETE;

15487: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
15488: v_cz_folders_pf_id_tbl.DELETE;
15489: v_cz_folders_pj_id_tbl.DELETE;
15490: v_cz_rule_folders_orig_tbl.DELETE;
15491: v_cz_rule_folders_eff_tbl.DELETE;
15492: v_object_type_tbl.DELETE;
15493:
15494: BEGIN
15495: IF (cz_pb_mgr.v_session_parameter = model_copy)

Line 15498: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rule_folders_seq

15494: BEGIN
15495: IF (cz_pb_mgr.v_session_parameter = model_copy)
15496: THEN
15497: IF (p_copy_rules_flag = 'YES') THEN
15498: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rule_folders_seq
15499: , 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link
15500: ,cz_pb_mgr.v_oraclesequenceincr
15501: )
15502: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id

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

15495: IF (cz_pb_mgr.v_session_parameter = model_copy)
15496: THEN
15497: IF (p_copy_rules_flag = 'YES') THEN
15498: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rule_folders_seq
15499: , 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link
15500: ,cz_pb_mgr.v_oraclesequenceincr
15501: )
15502: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id
15503: ,orig_sys_ref, object_type

Line 15505: ,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

15501: )
15502: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id
15503: ,orig_sys_ref, object_type
15504: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl
15505: ,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
15506: ,v_cz_rule_folders_eff_tbl, v_object_type_tbl
15507: FROM cz_rule_folders t
15508: 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');
15509: ELSE -- Just create the Model Rule Folder if not copying rules

Line 15506: ,v_cz_rule_folders_eff_tbl, v_object_type_tbl

15502: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id
15503: ,orig_sys_ref, object_type
15504: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl
15505: ,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
15506: ,v_cz_rule_folders_eff_tbl, v_object_type_tbl
15507: FROM cz_rule_folders t
15508: 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');
15509: ELSE -- Just create the Model Rule Folder if not copying rules
15510: SELECT cz_pb_mgr.sequence_generate(

Line 15507: FROM cz_rule_folders t

15503: ,orig_sys_ref, object_type
15504: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl
15505: ,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
15506: ,v_cz_rule_folders_eff_tbl, v_object_type_tbl
15507: FROM cz_rule_folders t
15508: 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');
15509: ELSE -- Just create the Model Rule Folder if not copying rules
15510: SELECT cz_pb_mgr.sequence_generate(
15511: cz_pb_mgr.cz_rule_folders_seq,

Line 15511: cz_pb_mgr.cz_rule_folders_seq,

15507: FROM cz_rule_folders t
15508: 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');
15509: ELSE -- Just create the Model Rule Folder if not copying rules
15510: SELECT cz_pb_mgr.sequence_generate(
15511: cz_pb_mgr.cz_rule_folders_seq,
15512: 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link,
15513: cz_pb_mgr.v_oraclesequenceincr
15514: ),
15515: rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id,orig_sys_ref, object_type

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

15508: 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');
15509: ELSE -- Just create the Model Rule Folder if not copying rules
15510: SELECT cz_pb_mgr.sequence_generate(
15511: cz_pb_mgr.cz_rule_folders_seq,
15512: 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link,
15513: cz_pb_mgr.v_oraclesequenceincr
15514: ),
15515: rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id,orig_sys_ref, object_type
15516: 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 15517: v_cz_folders_pj_id_tbl, v_cz_rule_folders_orig_tbl, v_cz_rule_folders_eff_tbl, v_object_type_tbl

15513: cz_pb_mgr.v_oraclesequenceincr
15514: ),
15515: rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id,orig_sys_ref, object_type
15516: 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,
15517: v_cz_folders_pj_id_tbl, v_cz_rule_folders_orig_tbl, v_cz_rule_folders_eff_tbl, v_object_type_tbl
15518: FROM cz_rule_folders t
15519: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
15520: AND t.deleted_flag = '0'
15521: AND t.parent_rule_folder_id IS NULL

Line 15518: FROM cz_rule_folders t

15514: ),
15515: rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id,orig_sys_ref, object_type
15516: 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,
15517: v_cz_folders_pj_id_tbl, v_cz_rule_folders_orig_tbl, v_cz_rule_folders_eff_tbl, v_object_type_tbl
15518: FROM cz_rule_folders t
15519: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
15520: AND t.deleted_flag = '0'
15521: AND t.parent_rule_folder_id IS NULL
15522: AND t.object_type = 'RFL';

Line 15527: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rule_folders_seq

15523: END IF;
15524: ELSE
15525: IF (p_copy_rules_flag = 'YES')
15526: THEN
15527: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rule_folders_seq
15528: , 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link
15529: ,cz_pb_mgr.v_oraclesequenceincr
15530: )
15531: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id

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

15524: ELSE
15525: IF (p_copy_rules_flag = 'YES')
15526: THEN
15527: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rule_folders_seq
15528: , 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link
15529: ,cz_pb_mgr.v_oraclesequenceincr
15530: )
15531: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id
15532: ,orig_sys_ref, object_type

Line 15534: ,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

15530: )
15531: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id
15532: ,orig_sys_ref, object_type
15533: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl
15534: ,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
15535: ,v_cz_rule_folders_orig_tbl, v_object_type_tbl
15536: FROM cz_rule_folders t
15537: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
15538: AND t.deleted_flag = '0'

Line 15535: ,v_cz_rule_folders_orig_tbl, v_object_type_tbl

15531: ,rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id
15532: ,orig_sys_ref, object_type
15533: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl
15534: ,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
15535: ,v_cz_rule_folders_orig_tbl, v_object_type_tbl
15536: FROM cz_rule_folders t
15537: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
15538: AND t.deleted_flag = '0'
15539: AND t.object_type IN('RFL', 'RSQ');

Line 15536: FROM cz_rule_folders t

15532: ,orig_sys_ref, object_type
15533: BULK COLLECT INTO cz_pb_mgr.v_cz_folders_id_new_tbl
15534: ,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
15535: ,v_cz_rule_folders_orig_tbl, v_object_type_tbl
15536: FROM cz_rule_folders t
15537: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
15538: AND t.deleted_flag = '0'
15539: AND t.object_type IN('RFL', 'RSQ');
15540: ELSE -- Just create the Model Rule Folder if not copying rules

Line 15542: cz_pb_mgr.cz_rule_folders_seq,

15538: AND t.deleted_flag = '0'
15539: AND t.object_type IN('RFL', 'RSQ');
15540: ELSE -- Just create the Model Rule Folder if not copying rules
15541: SELECT cz_pb_mgr.sequence_generate(
15542: cz_pb_mgr.cz_rule_folders_seq,
15543: 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link,
15544: cz_pb_mgr.v_oraclesequenceincr
15545: ), rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id, orig_sys_ref, object_type
15546: 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 15543: 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link,

15539: AND t.object_type IN('RFL', 'RSQ');
15540: ELSE -- Just create the Model Rule Folder if not copying rules
15541: SELECT cz_pb_mgr.sequence_generate(
15542: cz_pb_mgr.cz_rule_folders_seq,
15543: 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link,
15544: cz_pb_mgr.v_oraclesequenceincr
15545: ), rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id, orig_sys_ref, object_type
15546: 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,
15547: v_cz_folders_pj_id_tbl, v_cz_rule_folders_eff_tbl, v_cz_rule_folders_orig_tbl, v_object_type_tbl

Line 15547: v_cz_folders_pj_id_tbl, v_cz_rule_folders_eff_tbl, v_cz_rule_folders_orig_tbl, v_object_type_tbl

15543: 'cz_rule_folders_s.nextval' || cz_pb_mgr.v_db_link,
15544: cz_pb_mgr.v_oraclesequenceincr
15545: ), rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id, orig_sys_ref, object_type
15546: 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,
15547: v_cz_folders_pj_id_tbl, v_cz_rule_folders_eff_tbl, v_cz_rule_folders_orig_tbl, v_object_type_tbl
15548: FROM cz_rule_folders t
15549: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
15550: AND t.deleted_flag = '0'
15551: AND t.parent_rule_folder_id IS NULL

Line 15548: FROM cz_rule_folders t

15544: cz_pb_mgr.v_oraclesequenceincr
15545: ), rule_folder_id, parent_rule_folder_id, devl_project_id, effectivity_set_id, orig_sys_ref, object_type
15546: 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,
15547: v_cz_folders_pj_id_tbl, v_cz_rule_folders_eff_tbl, v_cz_rule_folders_orig_tbl, v_object_type_tbl
15548: FROM cz_rule_folders t
15549: WHERE t.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
15550: AND t.deleted_flag = '0'
15551: AND t.parent_rule_folder_id IS NULL
15552: AND t.object_type = 'RFL';

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

15558: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
15559: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RULEFOLDERS', SQLCODE);
15560: WHEN OTHERS
15561: THEN
15562: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rule_folders', 'SQLERRM', SQLERRM);
15563: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RULEFOLDERS', SQLCODE);
15564: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15565: RAISE;
15566: END;

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

15577: cz_pb_mgr.v_cz_folders_id_old_ref(rec_count) := cz_pb_mgr.v_cz_folders_id_old_tbl(k);
15578: 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);
15579: cz_pb_mgr.v_cz_folders_pf_id_ref(rec_count) := v_cz_folders_pf_id_tbl(k);
15580: cz_pb_mgr.v_cz_folders_pj_id_ref(rec_count) := v_cz_folders_pj_id_tbl(k);
15581: cz_pb_mgr.v_cz_folders_eff_ref(rec_count) := v_cz_rule_folders_eff_tbl(k);
15582: cz_pb_mgr.v_cz_folders_orig_ref(rec_count) := v_cz_rule_folders_orig_tbl(k);
15583: cz_pb_mgr.v_cz_folders_obj_ref(rec_count) := v_object_type_tbl(k);
15584:
15585: IF cz_pb_mgr.v_session_parameter=pub_model AND p_copy_rules_flag<>'YES' THEN

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

15578: 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);
15579: cz_pb_mgr.v_cz_folders_pf_id_ref(rec_count) := v_cz_folders_pf_id_tbl(k);
15580: cz_pb_mgr.v_cz_folders_pj_id_ref(rec_count) := v_cz_folders_pj_id_tbl(k);
15581: cz_pb_mgr.v_cz_folders_eff_ref(rec_count) := v_cz_rule_folders_eff_tbl(k);
15582: cz_pb_mgr.v_cz_folders_orig_ref(rec_count) := v_cz_rule_folders_orig_tbl(k);
15583: cz_pb_mgr.v_cz_folders_obj_ref(rec_count) := v_object_type_tbl(k);
15584:
15585: IF cz_pb_mgr.v_session_parameter=pub_model AND p_copy_rules_flag<>'YES' THEN
15586: v_model_root_folder_map(cz_pb_mgr.v_models_to_be_exported(i)):=v_cz_folders_id_old_tbl(k);

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

15607: ,'cz_pb_mgr.v_cz_eff_sets_new_tbl'
15608: ,'Eff sets of rule folders'
15609: );
15610: resolve_ids(cz_pb_mgr.v_cz_folders_eff_ref, cz_pb_mgr.v_cz_eff_sets_idx_tbl, 'eff id of rule folders');
15611: -----insert new records into cz_rule_folders
15612: plsql_table_list.DELETE;
15613: rec_count := 1;
15614: plsql_table_list(rec_count).col_name := 'rule_folder_id';
15615: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_folders_id_new_ref';

Line 15631: insert_into_table('cz_rule_folders'

15627: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_folders_eff_ref';
15628: rec_count := rec_count + 1;
15629: plsql_table_list(rec_count).col_name := 'orig_sys_ref';
15630: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_folders_orig_ref';
15631: insert_into_table('cz_rule_folders'
15632: ,'rule_folder_id'
15633: ,'object_type'
15634: ,cz_pb_mgr.v_db_link
15635: ,plsql_table_list

Line 15645: v_cz_rule_folders_eff_tbl.DELETE;

15641:
15642: --------release local pl/sql tables of rule folders
15643: v_cz_folders_pf_id_tbl.DELETE;
15644: v_cz_folders_pj_id_tbl.DELETE;
15645: v_cz_rule_folders_eff_tbl.DELETE;
15646: v_cz_rule_folders_orig_tbl.DELETE;
15647: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
15648:
15649: -------------insert into func comp specs

Line 15646: v_cz_rule_folders_orig_tbl.DELETE;

15642: --------release local pl/sql tables of rule folders
15643: v_cz_folders_pf_id_tbl.DELETE;
15644: v_cz_folders_pj_id_tbl.DELETE;
15645: v_cz_rule_folders_eff_tbl.DELETE;
15646: v_cz_rule_folders_orig_tbl.DELETE;
15647: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
15648:
15649: -------------insert into func comp specs
15650: IF cz_pb_mgr.v_cz_func_comp_old_ref.COUNT > 0 THEN

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

15643: v_cz_folders_pf_id_tbl.DELETE;
15644: v_cz_folders_pj_id_tbl.DELETE;
15645: v_cz_rule_folders_eff_tbl.DELETE;
15646: v_cz_rule_folders_orig_tbl.DELETE;
15647: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
15648:
15649: -------------insert into func comp specs
15650: IF cz_pb_mgr.v_cz_func_comp_old_ref.COUNT > 0 THEN
15651: IF cz_pb_mgr.v_session_parameter=pub_model AND p_copy_rules_flag<>'YES' THEN

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

15721: THEN
15722: log_timing_message('end insert_into_table cz_func_comp_specs');
15723: END IF;
15724:
15725: -----insert new records into cz_rule_folders
15726: plsql_table_list.DELETE;
15727: rec_count := 1;
15728: plsql_table_list(rec_count).col_name := 'rule_folder_id';
15729: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_func_comp_new_ref';

Line 15740: insert_into_table('cz_rule_folders'

15736: rec_count := rec_count + 1;
15737: plsql_table_list(rec_count).col_name := 'parent_rule_folder_id';
15738: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_func_fld_old_ref';
15739: ----------insert into cz_func_comp_specs
15740: insert_into_table('cz_rule_folders'
15741: ,'rule_folder_id'
15742: ,'object_type'
15743: ,cz_pb_mgr.v_db_link
15744: ,plsql_table_list

Line 23468: l_rule_folder_name cz_rule_folders.NAME%TYPE;

23464: l_sql_string VARCHAR2(2000);
23465: remote_effs_cv ref_cursor;
23466: remote_rule_seq_name_cv ref_cursor;
23467: l_effecivity_set_id NUMBER;
23468: l_rule_folder_name cz_rule_folders.NAME%TYPE;
23469: l_rule_name cz_rules.NAME%TYPE;
23470: BEGIN
23471: --all the rule sequences have been accumulated here
23472: IF (mm_v_tbl_rule_seq.COUNT > 0) THEN

Line 23515: || 'FROM cz_rule_folders'

23511: --log the event
23512: l_sql_string :=
23513: 'SELECT name'
23514: || ' '
23515: || 'FROM cz_rule_folders'
23516: || cz_pb_mgr.v_db_link
23517: || ' '
23518: || 'WHERE rule_folder_id = :1'
23519: || ' '