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

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

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

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

Line 16429: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_populators_seq

16425: l_populators_set_id_tbl.DELETE;
16426: l_populators_new_id_tbl.DELETE;
16427:
16428: BEGIN
16429: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_populators_seq
16430: , 'cz_populators_s.nextval' || cz_pb_mgr.v_db_link
16431: ,cz_pb_mgr.v_oraclesequenceincr
16432: )
16433: ,populator_id, owned_by_node_id, filter_set_id

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

16426: l_populators_new_id_tbl.DELETE;
16427:
16428: BEGIN
16429: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_populators_seq
16430: , 'cz_populators_s.nextval' || cz_pb_mgr.v_db_link
16431: ,cz_pb_mgr.v_oraclesequenceincr
16432: )
16433: ,populator_id, owned_by_node_id, filter_set_id
16434: BULK COLLECT INTO l_populators_new_id_tbl

Line 16436: FROM cz_populators

16432: )
16433: ,populator_id, owned_by_node_id, filter_set_id
16434: BULK COLLECT INTO l_populators_new_id_tbl
16435: ,l_populators_id_tbl, l_populators_node_tbl, l_populators_set_id_tbl
16436: FROM cz_populators
16437: WHERE cz_populators.filter_set_id = cz_pb_mgr.v_filter_sets_id_ref(i) AND cz_populators.deleted_flag = '0';
16438: EXCEPTION
16439: WHEN NO_DATA_FOUND
16440: THEN

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

16433: ,populator_id, owned_by_node_id, filter_set_id
16434: BULK COLLECT INTO l_populators_new_id_tbl
16435: ,l_populators_id_tbl, l_populators_node_tbl, l_populators_set_id_tbl
16436: FROM cz_populators
16437: WHERE cz_populators.filter_set_id = cz_pb_mgr.v_filter_sets_id_ref(i) AND cz_populators.deleted_flag = '0';
16438: EXCEPTION
16439: WHEN NO_DATA_FOUND
16440: THEN
16441: NULL;

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

16440: THEN
16441: NULL;
16442: WHEN OTHERS
16443: THEN
16444: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_populators', 'SQLERRM', SQLERRM);
16445: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.POPULATORS', SQLCODE);
16446: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16447: RAISE;
16448: END;

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

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

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

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');
16473: plsql_table_list.DELETE;
16474: rec_count := 1;
16475: plsql_table_list(rec_count).col_name := 'filter_set_id';
16476: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_filter_sets_new_id_ref';

Line 16500: insert_into_table('cz_populators'

16496: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_populators_node_ref';
16497: rec_count := rec_count + 1;
16498: plsql_table_list(rec_count).col_name := 'filter_set_id';
16499: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_populators_set_id_ref';
16500: insert_into_table('cz_populators'
16501: ,'populator_id'
16502: ,cz_pb_mgr.v_db_link
16503: ,plsql_table_list
16504: ,'cz_pb_mgr.v_populators_id_ref'

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

16525: END IF;
16526: EXCEPTION
16527: WHEN OTHERS
16528: THEN
16529: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_populators', 'SQLERRM', SQLERRM);
16530: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.POPULATORS', SQLCODE);
16531: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16532: RAISE;
16533: END export_populators;