APPS.IGF_AP_MK_ISIR_ACT_PKG dependencies on IGF_AP_ISIR_MATCHED

Line 261: FROM igf_ap_isir_matched ISIR

257: CURSOR c_chk_isir_rec_legacy(cp_base_id NUMBER,
258: cp_batch_year NUMBER )
259: IS
260: SELECT ISIR.isir_id isir_id
261: FROM igf_ap_isir_matched ISIR
262: WHERE ISIR.base_id = cp_base_id
263: AND ISIR.batch_year = cp_batch_year
264: AND NVL(ISIR.legacy_record_flag,'X') <> 'Y'
265: AND rownum = 1;

Line 598: FROM igf_ap_isir_matched ISIR

594: ISIR.reject_override_j_flag,
595: ISIR.reject_override_k_flag,
596: ISIR.rejected_status_change_flag,
597: ISIR.verification_selection_flag
598: FROM igf_ap_isir_matched ISIR
599:
600: WHERE ISIR.base_id = cp_base_id
601: AND ISIR.batch_year = cp_batch_year
602: AND ISIR.transaction_num = cp_transaction_num

Line 923: FROM igf_ap_isir_matched ISIR

919: ISIR.reject_override_j_flag,
920: ISIR.reject_override_k_flag,
921: ISIR.rejected_status_change_flag,
922: ISIR.verification_selection_flag
923: FROM igf_ap_isir_matched ISIR
924: WHERE ISIR.base_id = cp_base_id
925: AND ISIR.active_isir = 'Y'
926: AND ISIR.system_record_type = cp_rec_type;
927:

Line 1178: PROCEDURE update_isir_rec( p_isir_rec IN igf_ap_isir_matched%ROWTYPE,

1174: END LOOP;
1175: RETURN FALSE;
1176: END;
1177:
1178: PROCEDURE update_isir_rec( p_isir_rec IN igf_ap_isir_matched%ROWTYPE,
1179: p_make_isir IN VARCHAR2
1180: ) IS
1181: /*
1182: || Created By : bkkumar

Line 1193: igf_ap_isir_matched_pkg.update_row(

1189: */
1190:
1191: BEGIN
1192:
1193: igf_ap_isir_matched_pkg.update_row(
1194: x_Mode => 'R',
1195: x_rowid => p_isir_rec.row_id,
1196: x_isir_id => p_isir_rec.isir_id,
1197: x_base_id => p_isir_rec.base_id,