DBA Data[Home] [Help]

APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGF_AP_ISIR_CORR_PKG

Line 6477: IF NOT igf_ap_isir_corr_pkg.get_uk_for_validation( NVL(p_new_isir_id,isir_corr_rec.isir_id),

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,

Line 6480: igf_ap_ISIR_corr_pkg.update_row (

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,

Line 6504: IF NOT igf_ap_isir_corr_pkg.get_uk_for_validation( NVL(p_new_isir_id,isir_corr_rec.isir_id),

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,

Line 6507: igf_ap_ISIR_corr_pkg.update_row (

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,

Line 6554: IF NOT igf_ap_isir_corr_pkg.get_uk_for_validation( p_new_isir_id,

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 (

Line 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,