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_POPULATORS

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

6513: delete_from_table('cz_ui_images','ui_def_id','image_usage_code','entity_code',v_database_link,'cz_pb_mgr.l_ui_images_ui_ref','cz_pb_mgr.l_ui_images_usg_tbl','cz_pb_mgr.l_ui_images_enty_tbl',cz_pb_mgr.l_ui_images_ui_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);

Line 15268: AND EXISTS (SELECT NULL FROM cz_populators pop, cz_ps_nodes psn

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:
15272: EXCEPTION

Line 15315: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_populators_seq

15311: l_populators_set_id_tbl.DELETE;
15312: l_populators_new_id_tbl.DELETE;
15313:
15314: BEGIN
15315: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_populators_seq
15316: , 'cz_populators_s.nextval' || cz_pb_mgr.v_db_link
15317: ,cz_pb_mgr.v_oraclesequenceincr
15318: )
15319: ,populator_id, owned_by_node_id, filter_set_id

Line 15316: , 'cz_populators_s.nextval' || cz_pb_mgr.v_db_link

15312: l_populators_new_id_tbl.DELETE;
15313:
15314: BEGIN
15315: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_populators_seq
15316: , 'cz_populators_s.nextval' || cz_pb_mgr.v_db_link
15317: ,cz_pb_mgr.v_oraclesequenceincr
15318: )
15319: ,populator_id, owned_by_node_id, filter_set_id
15320: BULK COLLECT INTO l_populators_new_id_tbl

Line 15322: FROM cz_populators

15318: )
15319: ,populator_id, owned_by_node_id, filter_set_id
15320: BULK COLLECT INTO l_populators_new_id_tbl
15321: ,l_populators_id_tbl, l_populators_node_tbl, l_populators_set_id_tbl
15322: FROM cz_populators
15323: WHERE cz_populators.filter_set_id = cz_pb_mgr.v_filter_sets_id_ref(i) AND cz_populators.deleted_flag = '0';
15324: EXCEPTION
15325: WHEN NO_DATA_FOUND
15326: THEN

Line 15323: WHERE cz_populators.filter_set_id = cz_pb_mgr.v_filter_sets_id_ref(i) AND cz_populators.deleted_flag = '0';

15319: ,populator_id, owned_by_node_id, filter_set_id
15320: BULK COLLECT INTO l_populators_new_id_tbl
15321: ,l_populators_id_tbl, l_populators_node_tbl, l_populators_set_id_tbl
15322: FROM cz_populators
15323: WHERE cz_populators.filter_set_id = cz_pb_mgr.v_filter_sets_id_ref(i) AND cz_populators.deleted_flag = '0';
15324: EXCEPTION
15325: WHEN NO_DATA_FOUND
15326: THEN
15327: NULL;

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

15326: THEN
15327: NULL;
15328: WHEN OTHERS
15329: THEN
15330: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_populators', 'SQLERRM', SQLERRM);
15331: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.POPULATORS', SQLCODE);
15332: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15333: RAISE;
15334: END;

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

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');
15359: plsql_table_list.DELETE;
15360: rec_count := 1;

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

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');
15359: plsql_table_list.DELETE;
15360: rec_count := 1;
15361: plsql_table_list(rec_count).col_name := 'filter_set_id';
15362: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_filter_sets_new_id_ref';

Line 15386: insert_into_table('cz_populators'

15382: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_populators_node_ref';
15383: rec_count := rec_count + 1;
15384: plsql_table_list(rec_count).col_name := 'filter_set_id';
15385: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_populators_set_id_ref';
15386: insert_into_table('cz_populators'
15387: ,'populator_id'
15388: ,cz_pb_mgr.v_db_link
15389: ,plsql_table_list
15390: ,'cz_pb_mgr.v_populators_id_ref'

Line 15415: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_populators', 'SQLERRM', SQLERRM);

15411: END IF;
15412: EXCEPTION
15413: WHEN OTHERS
15414: THEN
15415: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_populators', 'SQLERRM', SQLERRM);
15416: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.POPULATORS', SQLCODE);
15417: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15418: RAISE;
15419: END export_populators;