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 7239: 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);

7235: delete_from_table('cz_signatures','signature_id',v_database_link,'cz_pb_mgr.v_sig_new_ref',cz_pb_mgr.v_sig_new_ref);
7236: 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);
7237: 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);
7238: 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);
7239: 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);
7240: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.g_archives_new_ref',cz_pb_mgr.g_archives_new_ref);
7241:
7242: 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);
7243:

Line 16373: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_filter_sets_seq

16369: l_filter_sets_devl_tbl.DELETE;
16370: l_filter_sets_rule_tbl.DELETE;
16371:
16372: BEGIN
16373: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_filter_sets_seq
16374: , 'cz_filter_sets_s.nextval' || cz_pb_mgr.v_db_link
16375: ,cz_pb_mgr.v_oraclesequenceincr
16376: )
16377: ,filter_set_id, devl_project_id, rule_id

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

16370: l_filter_sets_rule_tbl.DELETE;
16371:
16372: BEGIN
16373: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_filter_sets_seq
16374: , 'cz_filter_sets_s.nextval' || cz_pb_mgr.v_db_link
16375: ,cz_pb_mgr.v_oraclesequenceincr
16376: )
16377: ,filter_set_id, devl_project_id, rule_id
16378: BULK COLLECT INTO l_filter_sets_new_id_tbl

Line 16380: FROM cz_filter_sets

16376: )
16377: ,filter_set_id, devl_project_id, rule_id
16378: BULK COLLECT INTO l_filter_sets_new_id_tbl
16379: ,l_filter_sets_id_tbl, l_filter_sets_devl_tbl, l_filter_sets_rule_tbl
16380: FROM cz_filter_sets
16381: WHERE cz_filter_sets.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_filter_sets.deleted_flag = '0'
16382: AND EXISTS (SELECT NULL FROM cz_populators pop, cz_ps_nodes psn
16383: WHERE pop.deleted_flag = '0' AND pop.filter_set_id = cz_filter_sets.filter_set_id
16384: AND pop.owned_by_node_id = psn.ps_node_id AND psn.deleted_flag = '0');

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

16377: ,filter_set_id, devl_project_id, rule_id
16378: BULK COLLECT INTO l_filter_sets_new_id_tbl
16379: ,l_filter_sets_id_tbl, l_filter_sets_devl_tbl, l_filter_sets_rule_tbl
16380: FROM cz_filter_sets
16381: WHERE cz_filter_sets.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_filter_sets.deleted_flag = '0'
16382: AND EXISTS (SELECT NULL FROM cz_populators pop, cz_ps_nodes psn
16383: WHERE pop.deleted_flag = '0' AND pop.filter_set_id = cz_filter_sets.filter_set_id
16384: AND pop.owned_by_node_id = psn.ps_node_id AND psn.deleted_flag = '0');
16385:

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

16379: ,l_filter_sets_id_tbl, l_filter_sets_devl_tbl, l_filter_sets_rule_tbl
16380: FROM cz_filter_sets
16381: WHERE cz_filter_sets.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_filter_sets.deleted_flag = '0'
16382: AND EXISTS (SELECT NULL FROM cz_populators pop, cz_ps_nodes psn
16383: WHERE pop.deleted_flag = '0' AND pop.filter_set_id = cz_filter_sets.filter_set_id
16384: AND pop.owned_by_node_id = psn.ps_node_id AND psn.deleted_flag = '0');
16385:
16386: EXCEPTION
16387: WHEN NO_DATA_FOUND

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

16388: THEN
16389: NULL;
16390: WHEN OTHERS
16391: THEN
16392: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_filter_sets', 'SQLERRM', SQLERRM);
16393: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.FILTERSETS', SQLCODE);
16394: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16395: RAISE;
16396: END;

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

16462: END IF;
16463: END LOOP;
16464:
16465: ------resolve devl id and rule id
16466: 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');
16467: ------resolve devl id
16468: 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');
16469: -----resolve ps node id
16470: 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 16468: 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');

16464:
16465: ------resolve devl id and rule id
16466: 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');
16467: ------resolve devl id
16468: 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');
16469: -----resolve ps node id
16470: 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');
16471: -----resolve filter set id
16472: 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 16483: insert_into_table('cz_filter_sets'

16479: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_filter_sets_devl_ref';
16480: rec_count := rec_count + 1;
16481: plsql_table_list(rec_count).col_name := 'rule_id';
16482: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_filter_sets_rule_ref';
16483: insert_into_table('cz_filter_sets'
16484: ,'filter_set_id'
16485: ,cz_pb_mgr.v_db_link
16486: ,plsql_table_list
16487: ,'cz_pb_mgr.v_filter_sets_id_ref'