eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGF_AP_ISIR_CORR

Line 2768: FROM igf_ap_ISIR_matched isir, igf_ap_isir_corr_all corr

2764: lv_chk_py_isir_rec get_payment_isir%ROWTYPE;
2765:
2766: CURSOR check_correction_items (ln_base_id NUMBER) IS
2767: SELECT 'x'
2768: FROM igf_ap_ISIR_matched isir, igf_ap_isir_corr_all corr
2769: WHERE isir.isir_id = corr.isir_id
2770: AND isir.base_id = ln_base_id;
2771:
2772: lv_chk_corrections check_correction_items%ROWTYPE;

Line 4986: igf_ap_ISIR_corr corr,

4982: cp_corr_stat VARCHAR2 ) IS
4983: SELECT corr.*,
4984: sar.sar_field_name column_name
4985: FROM igf_ap_batch_aw_map map,
4986: igf_ap_ISIR_corr corr,
4987: igf_fc_sar_cd_mst sar,
4988: igf_ap_isir_matched isir
4989: WHERE map.ci_cal_type = g_ci_cal_type
4990: AND map.ci_sequence_number = g_ci_sequence_number

Line 5004: FROM igf_ap_ISIR_corr corr

5000:
5001:
5002: CURSOR cur_isir_corr_pymt (cp_isir_id igf_ap_isir_matched.isir_id%TYPE) IS
5003: SELECT corr.*
5004: FROM igf_ap_ISIR_corr corr
5005: WHERE corr.isir_id = cp_isir_id ;
5006:
5007:
5008: lv_Param_Values VARCHAR2(200);

Line 5024: l_corrected_value igf_ap_isir_corr_all.corrected_value%TYPE;

5020:
5021: l_anticip_status VARCHAR2(30);
5022: l_awd_prc_status VARCHAR2(30);
5023:
5024: l_corrected_value igf_ap_isir_corr_all.corrected_value%TYPE;
5025: l_column_value igf_ap_isir_corr_all.corrected_value%TYPE;
5026:
5027: BEGIN
5028:

Line 5025: l_column_value igf_ap_isir_corr_all.corrected_value%TYPE;

5021: l_anticip_status VARCHAR2(30);
5022: l_awd_prc_status VARCHAR2(30);
5023:
5024: l_corrected_value igf_ap_isir_corr_all.corrected_value%TYPE;
5025: l_column_value igf_ap_isir_corr_all.corrected_value%TYPE;
5026:
5027: BEGIN
5028:
5029: log_debug_message(' Beginning Processing Corrections for payment isir ' || p_new_payment_isir);

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 6495: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_ACK');

6491: x_mode => 'R');
6492: RAM_I_CORR := RAM_I_CORR +1;
6493: END IF;
6494:
6495: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_ACK');
6496: fnd_message.set_token('FIELD', isir_corr_rec.column_name);
6497: fnd_file.put_line(fnd_file.log,fnd_message.get);
6498:
6499: ELSE

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 6523: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_READY');

6519: RAM_U_CORR := RAM_U_CORR +1;
6520: END IF;
6521:
6522: g_count_corr := g_count_corr + 1;
6523: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_READY');
6524: fnd_message.set_token('FIELD', isir_corr_rec.column_name);
6525: fnd_file.put_line(fnd_file.log,fnd_message.get);
6526: END IF;
6527:

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,