6473:
6474: -- Current col in pl/sql table reached
6475: IF l_corrected_value = l_column_value THEN
6476: -- update only if it is not already acknowledged
6477: IF NOT igf_ap_isir_corr_pkg.get_uk_for_validation( NVL(p_new_isir_id,isir_corr_rec.isir_id),
6478: isir_corr_rec.sar_field_number,
6479: 'ACKNOWLEDGED') THEN
6480: igf_ap_ISIR_corr_pkg.update_row (
6481: x_rowid => isir_corr_rec.row_id,
6476: -- update only if it is not already acknowledged
6477: IF NOT igf_ap_isir_corr_pkg.get_uk_for_validation( NVL(p_new_isir_id,isir_corr_rec.isir_id),
6478: isir_corr_rec.sar_field_number,
6479: 'ACKNOWLEDGED') THEN
6480: igf_ap_ISIR_corr_pkg.update_row (
6481: x_rowid => isir_corr_rec.row_id,
6482: x_ISIRc_id => isir_corr_rec.ISIRc_id,
6483: x_ISIR_id => NVL(p_new_isir_id,isir_corr_rec.isir_id),
6484: x_ci_sequence_number => isir_corr_rec.ci_sequence_number,
6500: -- Set the flag that there are still corrections.
6501: lv_all_corr_rcvd := 'N' ;
6502:
6503: -- update only if the matching record is not already in ready status
6504: IF NOT igf_ap_isir_corr_pkg.get_uk_for_validation( NVL(p_new_isir_id,isir_corr_rec.isir_id),
6505: isir_corr_rec.sar_field_number,
6506: 'READY') THEN
6507: igf_ap_ISIR_corr_pkg.update_row (
6508: x_rowid => isir_corr_rec.row_id,
6503: -- update only if the matching record is not already in ready status
6504: IF NOT igf_ap_isir_corr_pkg.get_uk_for_validation( NVL(p_new_isir_id,isir_corr_rec.isir_id),
6505: isir_corr_rec.sar_field_number,
6506: 'READY') THEN
6507: igf_ap_ISIR_corr_pkg.update_row (
6508: x_rowid => isir_corr_rec.row_id,
6509: x_ISIRc_id => isir_corr_rec.ISIRc_id,
6510: x_ISIR_id => NVL(p_new_isir_id,isir_corr_rec.isir_id),
6511: x_ci_sequence_number => isir_corr_rec.ci_sequence_number,
6550: FOR l_cur_isir_corr_pymnt IN cur_isir_corr_pymt(p_old_payment_isir)
6551: LOOP
6552:
6553: -- update only if not already in the said status
6554: IF NOT igf_ap_isir_corr_pkg.get_uk_for_validation( p_new_isir_id,
6555: l_cur_isir_corr_pymnt.sar_field_number,
6556: l_cur_isir_corr_pymnt.correction_status) THEN
6557:
6558: igf_ap_ISIR_corr_pkg.update_row (
6554: IF NOT igf_ap_isir_corr_pkg.get_uk_for_validation( p_new_isir_id,
6555: l_cur_isir_corr_pymnt.sar_field_number,
6556: l_cur_isir_corr_pymnt.correction_status) THEN
6557:
6558: igf_ap_ISIR_corr_pkg.update_row (
6559: x_rowid => l_cur_isir_corr_pymnt.row_id,
6560: x_ISIRc_id => l_cur_isir_corr_pymnt.ISIRc_id,
6561: x_ISIR_id => p_new_isir_id,
6562: x_ci_sequence_number => l_cur_isir_corr_pymnt.ci_sequence_number,