DBA Data[Home] [Help]

APPS.IGF_AP_ISIR_IMPORT_PKG dependencies on IGF_AP_ISIR_CORR_PKG

Line 1530: igf_ap_ISIR_corr_pkg.update_row (

1526: BEGIN
1527:
1528: FOR cur_ISIR_corr IN cur_corr LOOP
1529:
1530: igf_ap_ISIR_corr_pkg.update_row (
1531: x_rowid => cur_ISIR_corr.row_id,
1532: x_ISIRc_id => cur_ISIR_corr.ISIRc_id,
1533: x_ISIR_id => cur_ISIR_corr.ISIR_id,
1534: x_ci_sequence_number => cur_ISIR_corr.ci_sequence_number,

Line 1632: IF NOT igf_ap_ISIR_corr_pkg.get_uk_for_validation ( x_ISIR_id => rec_ISIR_corr.ISIR_id,

1628: -- Compare the values and if the value send for correction is same as the value present in the ISIR then
1629: -- Mark the record as ACKNOWLEDGED.
1630: --
1631: IF LTRIM(RTRIM(UPPER(NVL(lv_retval,'##')))) = LTRIM(RTRIM(UPPER(NVL(l_correction_value,'##')))) THEN
1632: IF NOT igf_ap_ISIR_corr_pkg.get_uk_for_validation ( x_ISIR_id => rec_ISIR_corr.ISIR_id,
1633: x_sar_field_number => rec_ISIR_corr.sar_field_number,
1634: x_correction_status => 'ACKNOWLEDGED') THEN
1635: update_ISIR_corr (rec_ISIR_corr.ISIRc_id, 'ACKNOWLEDGED');
1636: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_ACK');

Line 1642: IF NOT igf_ap_ISIR_corr_pkg.get_uk_for_validation ( x_ISIR_id => rec_ISIR_corr.ISIR_id,

1638: fnd_file.put_line(fnd_file.log,fnd_message.get);
1639: END IF;
1640:
1641: ELSE
1642: IF NOT igf_ap_ISIR_corr_pkg.get_uk_for_validation ( x_ISIR_id => rec_ISIR_corr.ISIR_id,
1643: x_sar_field_number => rec_ISIR_corr.sar_field_number,
1644: x_correction_status => 'READY') THEN
1645: update_ISIR_corr (rec_ISIR_corr.ISIRc_id, 'READY');
1646: ln_count_corr := ln_count_corr + 1;