APPS.CZ_PB_MGR dependencies on CZ_SIGNATURES

Line 6132: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_signatures_seq

6128: l_signature_old_tbl.DELETE;
6129: l_signature_new_tbl.DELETE;
6130:
6131: BEGIN
6132: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_signatures_seq
6133: , 'cz_signatures_s.nextval' || cz_pb_mgr.v_db_link
6134: ,cz_pb_mgr.v_oraclesequenceincr
6135: )
6136: ,signature_id

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

6129: l_signature_new_tbl.DELETE;
6130:
6131: BEGIN
6132: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_signatures_seq
6133: , 'cz_signatures_s.nextval' || cz_pb_mgr.v_db_link
6134: ,cz_pb_mgr.v_oraclesequenceincr
6135: )
6136: ,signature_id
6137: BULK COLLECT INTO l_signature_new_tbl

Line 6139: FROM cz_signatures

6135: )
6136: ,signature_id
6137: BULK COLLECT INTO l_signature_new_tbl
6138: ,l_signature_old_tbl
6139: FROM cz_signatures
6140: WHERE cz_signatures.signature_id = p_sig_array(sigid)
6141: AND cz_signatures.deleted_flag = record_not_deleted
6142: AND cz_signatures.seeded_flag <> seed_data;
6143: EXCEPTION

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

6136: ,signature_id
6137: BULK COLLECT INTO l_signature_new_tbl
6138: ,l_signature_old_tbl
6139: FROM cz_signatures
6140: WHERE cz_signatures.signature_id = p_sig_array(sigid)
6141: AND cz_signatures.deleted_flag = record_not_deleted
6142: AND cz_signatures.seeded_flag <> seed_data;
6143: EXCEPTION
6144: WHEN NO_DATA_FOUND

Line 6141: AND cz_signatures.deleted_flag = record_not_deleted

6137: BULK COLLECT INTO l_signature_new_tbl
6138: ,l_signature_old_tbl
6139: FROM cz_signatures
6140: WHERE cz_signatures.signature_id = p_sig_array(sigid)
6141: AND cz_signatures.deleted_flag = record_not_deleted
6142: AND cz_signatures.seeded_flag <> seed_data;
6143: EXCEPTION
6144: WHEN NO_DATA_FOUND
6145: THEN

Line 6142: AND cz_signatures.seeded_flag <> seed_data;

6138: ,l_signature_old_tbl
6139: FROM cz_signatures
6140: WHERE cz_signatures.signature_id = p_sig_array(sigid)
6141: AND cz_signatures.deleted_flag = record_not_deleted
6142: AND cz_signatures.seeded_flag <> seed_data;
6143: EXCEPTION
6144: WHEN NO_DATA_FOUND
6145: THEN
6146: NULL;

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

6164: plsql_table_list.DELETE;
6165: rec_count := 1;
6166: plsql_table_list(rec_count).col_name := 'signature_id';
6167: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_sig_new_ref';
6168: 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);
6169: END IF;
6170:
6171: IF (cz_pb_mgr.v_sig_old_ref.COUNT > 0)
6172: THEN

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

7231: END IF;
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);