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_FILTER_SETS

Line 6518: delete_from_table('cz_filter_sets','filter_set_id',v_database_link,'cz_pb_mgr.v_filter_sets_new_id_ref',cz_pb_mgr.v_filter_sets_new_id_ref);

6514: delete_from_table('cz_signatures','signature_id',v_database_link,'cz_pb_mgr.v_sig_new_ref',cz_pb_mgr.v_sig_new_ref);
6515: delete_from_table('cz_signature_arguments','argument_signature_id','argument_index',v_database_link,'cz_pb_mgr.v_arg_sig_tbl','cz_pb_mgr.v_arg_ind_old_tbl',cz_pb_mgr.v_arg_sig_tbl);
6516: delete_from_table('cz_func_comp_specs','func_comp_id',v_database_link,'cz_pb_mgr.v_cz_func_comp_new_ref',cz_pb_mgr.v_cz_func_comp_new_ref);
6517: delete_from_table('cz_populators','populator_id',v_database_link,'cz_pb_mgr.v_populators_new_id_ref',cz_pb_mgr.v_populators_new_id_ref);
6518: delete_from_table('cz_filter_sets','filter_set_id',v_database_link,'cz_pb_mgr.v_filter_sets_new_id_ref',cz_pb_mgr.v_filter_sets_new_id_ref);
6519: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.g_archives_new_ref',cz_pb_mgr.g_archives_new_ref);
6520:
6521: 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);
6522:

Line 15259: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_filter_sets_seq

15255: l_filter_sets_devl_tbl.DELETE;
15256: l_filter_sets_rule_tbl.DELETE;
15257:
15258: BEGIN
15259: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_filter_sets_seq
15260: , 'cz_filter_sets_s.nextval' || cz_pb_mgr.v_db_link
15261: ,cz_pb_mgr.v_oraclesequenceincr
15262: )
15263: ,filter_set_id, devl_project_id, rule_id

Line 15260: , 'cz_filter_sets_s.nextval' || cz_pb_mgr.v_db_link

15256: l_filter_sets_rule_tbl.DELETE;
15257:
15258: BEGIN
15259: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_filter_sets_seq
15260: , 'cz_filter_sets_s.nextval' || cz_pb_mgr.v_db_link
15261: ,cz_pb_mgr.v_oraclesequenceincr
15262: )
15263: ,filter_set_id, devl_project_id, rule_id
15264: BULK COLLECT INTO l_filter_sets_new_id_tbl

Line 15266: FROM cz_filter_sets

15262: )
15263: ,filter_set_id, devl_project_id, rule_id
15264: BULK COLLECT INTO l_filter_sets_new_id_tbl
15265: ,l_filter_sets_id_tbl, l_filter_sets_devl_tbl, l_filter_sets_rule_tbl
15266: FROM cz_filter_sets
15267: WHERE cz_filter_sets.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_filter_sets.deleted_flag = '0'
15268: AND EXISTS (SELECT NULL FROM cz_populators pop, cz_ps_nodes psn
15269: WHERE pop.deleted_flag = '0' AND pop.filter_set_id = cz_filter_sets.filter_set_id
15270: AND pop.owned_by_node_id = psn.ps_node_id AND psn.deleted_flag = '0');

Line 15267: WHERE cz_filter_sets.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_filter_sets.deleted_flag = '0'

15263: ,filter_set_id, devl_project_id, rule_id
15264: BULK COLLECT INTO l_filter_sets_new_id_tbl
15265: ,l_filter_sets_id_tbl, l_filter_sets_devl_tbl, l_filter_sets_rule_tbl
15266: FROM cz_filter_sets
15267: WHERE cz_filter_sets.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_filter_sets.deleted_flag = '0'
15268: AND EXISTS (SELECT NULL FROM cz_populators pop, cz_ps_nodes psn
15269: WHERE pop.deleted_flag = '0' AND pop.filter_set_id = cz_filter_sets.filter_set_id
15270: AND pop.owned_by_node_id = psn.ps_node_id AND psn.deleted_flag = '0');
15271:

Line 15269: WHERE pop.deleted_flag = '0' AND pop.filter_set_id = cz_filter_sets.filter_set_id

15265: ,l_filter_sets_id_tbl, l_filter_sets_devl_tbl, l_filter_sets_rule_tbl
15266: FROM cz_filter_sets
15267: WHERE cz_filter_sets.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_filter_sets.deleted_flag = '0'
15268: AND EXISTS (SELECT NULL FROM cz_populators pop, cz_ps_nodes psn
15269: WHERE pop.deleted_flag = '0' AND pop.filter_set_id = cz_filter_sets.filter_set_id
15270: AND pop.owned_by_node_id = psn.ps_node_id AND psn.deleted_flag = '0');
15271:
15272: EXCEPTION
15273: WHEN NO_DATA_FOUND

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

15274: THEN
15275: NULL;
15276: WHEN OTHERS
15277: THEN
15278: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_filter_sets', 'SQLERRM', SQLERRM);
15279: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.FILTERSETS', SQLCODE);
15280: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15281: RAISE;
15282: END;

Line 15352: resolve_ids(cz_pb_mgr.v_filter_sets_devl_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'dev proj id of cz filter sets');

15348: END IF;
15349: END LOOP;
15350:
15351: ------resolve devl id and rule id
15352: resolve_ids(cz_pb_mgr.v_filter_sets_devl_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'dev proj id of cz filter sets');
15353: ------resolve devl id
15354: resolve_ids(cz_pb_mgr.v_filter_sets_rule_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of cz filter sets');
15355: -----resolve ps node id
15356: resolve_ids(cz_pb_mgr.v_populators_node_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'owned by node id of cz populators');

Line 15354: resolve_ids(cz_pb_mgr.v_filter_sets_rule_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of cz filter sets');

15350:
15351: ------resolve devl id and rule id
15352: resolve_ids(cz_pb_mgr.v_filter_sets_devl_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'dev proj id of cz filter sets');
15353: ------resolve devl id
15354: resolve_ids(cz_pb_mgr.v_filter_sets_rule_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of cz filter sets');
15355: -----resolve ps node id
15356: resolve_ids(cz_pb_mgr.v_populators_node_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'owned by node id of cz populators');
15357: -----resolve filter set id
15358: resolve_ids(cz_pb_mgr.v_populators_set_id_ref, cz_pb_mgr.v_filter_sets_idx_ref, 'filter set id of cz populators');

Line 15369: insert_into_table('cz_filter_sets'

15365: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_filter_sets_devl_ref';
15366: rec_count := rec_count + 1;
15367: plsql_table_list(rec_count).col_name := 'rule_id';
15368: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_filter_sets_rule_ref';
15369: insert_into_table('cz_filter_sets'
15370: ,'filter_set_id'
15371: ,cz_pb_mgr.v_db_link
15372: ,plsql_table_list
15373: ,'cz_pb_mgr.v_filter_sets_id_ref'