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_SIGNATURES

Line 5382: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_signatures_seq

5378: l_signature_old_tbl.DELETE;
5379: l_signature_new_tbl.DELETE;
5380:
5381: BEGIN
5382: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_signatures_seq
5383: , 'cz_signatures_s.nextval' || cz_pb_mgr.v_db_link
5384: ,cz_pb_mgr.v_oraclesequenceincr
5385: )
5386: ,signature_id

Line 5383: , 'cz_signatures_s.nextval' || cz_pb_mgr.v_db_link

5379: l_signature_new_tbl.DELETE;
5380:
5381: BEGIN
5382: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_signatures_seq
5383: , 'cz_signatures_s.nextval' || cz_pb_mgr.v_db_link
5384: ,cz_pb_mgr.v_oraclesequenceincr
5385: )
5386: ,signature_id
5387: BULK COLLECT INTO l_signature_new_tbl

Line 5389: FROM cz_signatures

5385: )
5386: ,signature_id
5387: BULK COLLECT INTO l_signature_new_tbl
5388: ,l_signature_old_tbl
5389: FROM cz_signatures
5390: WHERE cz_signatures.signature_id = p_sig_array(sigid)
5391: AND cz_signatures.deleted_flag = record_not_deleted
5392: AND cz_signatures.seeded_flag <> seed_data;
5393: EXCEPTION

Line 5390: WHERE cz_signatures.signature_id = p_sig_array(sigid)

5386: ,signature_id
5387: BULK COLLECT INTO l_signature_new_tbl
5388: ,l_signature_old_tbl
5389: FROM cz_signatures
5390: WHERE cz_signatures.signature_id = p_sig_array(sigid)
5391: AND cz_signatures.deleted_flag = record_not_deleted
5392: AND cz_signatures.seeded_flag <> seed_data;
5393: EXCEPTION
5394: WHEN NO_DATA_FOUND

Line 5391: AND cz_signatures.deleted_flag = record_not_deleted

5387: BULK COLLECT INTO l_signature_new_tbl
5388: ,l_signature_old_tbl
5389: FROM cz_signatures
5390: WHERE cz_signatures.signature_id = p_sig_array(sigid)
5391: AND cz_signatures.deleted_flag = record_not_deleted
5392: AND cz_signatures.seeded_flag <> seed_data;
5393: EXCEPTION
5394: WHEN NO_DATA_FOUND
5395: THEN

Line 5392: AND cz_signatures.seeded_flag <> seed_data;

5388: ,l_signature_old_tbl
5389: FROM cz_signatures
5390: WHERE cz_signatures.signature_id = p_sig_array(sigid)
5391: AND cz_signatures.deleted_flag = record_not_deleted
5392: AND cz_signatures.seeded_flag <> seed_data;
5393: EXCEPTION
5394: WHEN NO_DATA_FOUND
5395: THEN
5396: NULL;

Line 5418: insert_into_table('cz_signatures', 'signature_id', cz_pb_mgr.v_db_link, plsql_table_list, 'cz_pb_mgr.v_sig_old_ref', cz_pb_mgr.v_sig_old_ref);

5414: plsql_table_list.DELETE;
5415: rec_count := 1;
5416: plsql_table_list(rec_count).col_name := 'signature_id';
5417: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_sig_new_ref';
5418: insert_into_table('cz_signatures', 'signature_id', cz_pb_mgr.v_db_link, plsql_table_list, 'cz_pb_mgr.v_sig_old_ref', cz_pb_mgr.v_sig_old_ref);
5419: END IF;
5420:
5421: IF (cz_pb_mgr.v_sig_old_ref.COUNT > 0)
5422: THEN

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

6510: 'ref_template_id','ref_template_ui_def_id',v_database_link,'cz_pb_mgr.g_TEMPLATE_ID_ref','cz_pb_mgr.g_TEMPLATE_UI_ref',
6511: 'cz_pb_mgr.g_REF_TEMPLATE_ID_ref','cz_pb_mgr.g_REF_TEMPL_UI_ref',cz_pb_mgr.g_TEMPLATE_ID_ref);
6512: 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);
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);