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_SIGNATURE_ARGUMENTS

Line 6177: FROM cz_signature_arguments

6173: FOR j IN cz_pb_mgr.v_sig_old_ref.FIRST .. cz_pb_mgr.v_sig_old_ref.LAST
6174: LOOP
6175: SELECT argument_signature_id, datatype_signature_id, argument_index
6176: BULK COLLECT INTO l_arg_sig_tbl, l_data_sig_tbl, l_arg_ind_tbl
6177: FROM cz_signature_arguments
6178: WHERE cz_signature_arguments.argument_signature_id = cz_pb_mgr.v_sig_old_ref(j)
6179: AND cz_signature_arguments.deleted_flag = record_not_deleted
6180: AND cz_signature_arguments.seeded_flag <> seed_data;
6181:

Line 6178: WHERE cz_signature_arguments.argument_signature_id = cz_pb_mgr.v_sig_old_ref(j)

6174: LOOP
6175: SELECT argument_signature_id, datatype_signature_id, argument_index
6176: BULK COLLECT INTO l_arg_sig_tbl, l_data_sig_tbl, l_arg_ind_tbl
6177: FROM cz_signature_arguments
6178: WHERE cz_signature_arguments.argument_signature_id = cz_pb_mgr.v_sig_old_ref(j)
6179: AND cz_signature_arguments.deleted_flag = record_not_deleted
6180: AND cz_signature_arguments.seeded_flag <> seed_data;
6181:
6182: IF (l_arg_sig_tbl.COUNT > 0)

Line 6179: AND cz_signature_arguments.deleted_flag = record_not_deleted

6175: SELECT argument_signature_id, datatype_signature_id, argument_index
6176: BULK COLLECT INTO l_arg_sig_tbl, l_data_sig_tbl, l_arg_ind_tbl
6177: FROM cz_signature_arguments
6178: WHERE cz_signature_arguments.argument_signature_id = cz_pb_mgr.v_sig_old_ref(j)
6179: AND cz_signature_arguments.deleted_flag = record_not_deleted
6180: AND cz_signature_arguments.seeded_flag <> seed_data;
6181:
6182: IF (l_arg_sig_tbl.COUNT > 0)
6183: THEN

Line 6180: AND cz_signature_arguments.seeded_flag <> seed_data;

6176: BULK COLLECT INTO l_arg_sig_tbl, l_data_sig_tbl, l_arg_ind_tbl
6177: FROM cz_signature_arguments
6178: WHERE cz_signature_arguments.argument_signature_id = cz_pb_mgr.v_sig_old_ref(j)
6179: AND cz_signature_arguments.deleted_flag = record_not_deleted
6180: AND cz_signature_arguments.seeded_flag <> seed_data;
6181:
6182: IF (l_arg_sig_tbl.COUNT > 0)
6183: THEN
6184: FOR k IN l_arg_sig_tbl.FIRST .. l_arg_sig_tbl.LAST

Line 6196: resolve_ids(cz_pb_mgr.v_arg_sig_old_tbl,cz_pb_mgr.v_arg_sig_tbl, cz_pb_mgr.v_sig_idx_ref, 'arg sig ids cz signature arguments');

6192: END IF;
6193: END LOOP;
6194:
6195: ----resolve ids
6196: resolve_ids(cz_pb_mgr.v_arg_sig_old_tbl,cz_pb_mgr.v_arg_sig_tbl, cz_pb_mgr.v_sig_idx_ref, 'arg sig ids cz signature arguments');
6197: resolve_ids(cz_pb_mgr.v_data_sig_tbl, cz_pb_mgr.v_sig_idx_ref, 'data sig ids cz signature arguments', ENTITY_TYPE_SIGNATURE);
6198: plsql_table_list.DELETE;
6199: rec_count := 1;
6200: plsql_table_list(rec_count).col_name := 'argument_signature_id';

Line 6197: resolve_ids(cz_pb_mgr.v_data_sig_tbl, cz_pb_mgr.v_sig_idx_ref, 'data sig ids cz signature arguments', ENTITY_TYPE_SIGNATURE);

6193: END LOOP;
6194:
6195: ----resolve ids
6196: resolve_ids(cz_pb_mgr.v_arg_sig_old_tbl,cz_pb_mgr.v_arg_sig_tbl, cz_pb_mgr.v_sig_idx_ref, 'arg sig ids cz signature arguments');
6197: resolve_ids(cz_pb_mgr.v_data_sig_tbl, cz_pb_mgr.v_sig_idx_ref, 'data sig ids cz signature arguments', ENTITY_TYPE_SIGNATURE);
6198: plsql_table_list.DELETE;
6199: rec_count := 1;
6200: plsql_table_list(rec_count).col_name := 'argument_signature_id';
6201: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_arg_sig_tbl';

Line 6208: insert_into_table('cz_signature_arguments'

6204: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_data_sig_tbl';
6205: rec_count := rec_count + 1;
6206: plsql_table_list(rec_count).col_name := 'argument_index';
6207: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_arg_ind_old_tbl';
6208: insert_into_table('cz_signature_arguments'
6209: ,'argument_signature_id'
6210: ,'argument_index'
6211: ,cz_pb_mgr.v_db_link
6212: ,plsql_table_list

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

7232:
7233: delete_from_table('cz_ui_actions','ui_def_id','ui_action_id',v_database_link,'cz_pb_mgr.g_ui_actns_ui_uidef_ref','cz_pb_mgr.g_ui_actns_ui_act_id_ref',cz_pb_mgr.g_ui_actns_ui_uidef_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);