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_BATCH_VER_PRC_PKG dependencies on IGF_AP_ISIR_CORR

Line 121: l_new_corr_status igf_ap_isir_corr.correction_status%TYPE;

117: | Added arguments in call to |
118: | IGF_AP_FA_BASE_RECORD_PKG. |
119: *=======================================================================*/
120:
121: l_new_corr_status igf_ap_isir_corr.correction_status%TYPE;
122: ln_corr_count NUMBER;
123: ln_no_corr_count NUMBER;
124: ln_tot_no_corr_count NUMBER;
125: ln_tot_corr_count NUMBER;

Line 143: FROM igf_ap_isir_corr

139:
140: CURSOR cur_dup_rec (pn_isir_id NUMBER, pn_sar_field_number NUMBER) IS
141: SELECT NVL(correction_status,'NOTREADY') correction_status,
142: corrected_value
143: FROM igf_ap_isir_corr
144: WHERE isir_id = pn_isir_id
145: AND sar_field_number = pn_sar_field_number;
146:
147: l_cur_dup_rec cur_dup_rec%ROWTYPE;

Line 151: FROM igf_ap_isir_corr

147: l_cur_dup_rec cur_dup_rec%ROWTYPE;
148:
149: CURSOR cur_find_corr (pn_isir_id NUMBER, pn_sar_field_number NUMBER, pv_status VARCHAR2) IS
150: SELECT count(*)
151: FROM igf_ap_isir_corr
152: WHERE isir_id = pn_isir_id
153: AND sar_field_number = pn_sar_field_number
154: AND correction_status = pv_status;
155:

Line 156: l_corr_status igf_ap_isir_corr.correction_status%TYPE := NULL;

152: WHERE isir_id = pn_isir_id
153: AND sar_field_number = pn_sar_field_number
154: AND correction_status = pv_status;
155:
156: l_corr_status igf_ap_isir_corr.correction_status%TYPE := NULL;
157: l_insert BOOLEAN := FALSE;
158: l_exists_flag BOOLEAN := FALSE; -- this flag is set if the corrected value is same as the already present value.
159: l_count NUMBER;
160:

Line 1218: ln_isirc_id igf_ap_isir_corr.isirc_id%TYPE;

1214: pv_mode VARCHAR2
1215: ) IS
1216:
1217: lv_rowid VARCHAR2(30);
1218: ln_isirc_id igf_ap_isir_corr.isirc_id%TYPE;
1219:
1220: CURSOR upd_corr_cur IS
1221: SELECT corr.*,corr.rowid
1222: FROM igf_ap_isir_corr corr

Line 1222: FROM igf_ap_isir_corr corr

1218: ln_isirc_id igf_ap_isir_corr.isirc_id%TYPE;
1219:
1220: CURSOR upd_corr_cur IS
1221: SELECT corr.*,corr.rowid
1222: FROM igf_ap_isir_corr corr
1223: WHERE isir_id = pn_isir_id
1224: AND sar_field_number = pv_isir_map_column;
1225:
1226: BEGIN

Line 1230: igf_ap_isir_corr_pkg.insert_row

1226: BEGIN
1227:
1228: IF pv_mode = 'INSERT' THEN
1229:
1230: igf_ap_isir_corr_pkg.insert_row
1231: (
1232: X_ROWID => lv_rowid,
1233: X_ISIRC_ID => ln_isirc_id,
1234: X_ISIR_ID => pn_isir_id,

Line 1245: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.insert_row successfull with values ');

1241: X_CORRECTION_STATUS => NVL(l_new_corr_status,'READY'),
1242: X_MODE => 'R'
1243: );
1244: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1245: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.insert_row successfull with values ');
1246: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : ln_isirc_id/pn_isir_id/pn_sequence_number : '||ln_isirc_id||' / '||pn_isir_id||' / '||pn_sequence_number);
1247: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_cal_type/pv_isir_map_column/pv_retval/pv_item_value'||pv_cal_type||'/'||pv_isir_map_column||'/'||pv_retval||'/'||pv_item_value);
1248: END IF;
1249: ELSIF pv_mode = 'UPDATE' THEN

Line 1251: igf_ap_isir_corr_pkg.update_row

1247: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_cal_type/pv_isir_map_column/pv_retval/pv_item_value'||pv_cal_type||'/'||pv_isir_map_column||'/'||pv_retval||'/'||pv_item_value);
1248: END IF;
1249: ELSIF pv_mode = 'UPDATE' THEN
1250: FOR corr_upd_rec IN upd_Corr_cur LOOP
1251: igf_ap_isir_corr_pkg.update_row
1252: (
1253: X_ROWID => corr_upd_rec.rowid,
1254: X_ISIRC_ID => corr_upd_rec.isirc_id,
1255: X_ISIR_ID => corr_upd_rec.isir_id,

Line 1266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.update_row successfull');

1262: X_CORRECTION_STATUS => l_new_corr_status,
1263: X_MODE => 'R'
1264: );
1265: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.update_row successfull');
1267: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.rowid / corr_upd_rec.isirc_id : '||corr_upd_rec.rowid||' / '||corr_upd_rec.isirc_id);
1268: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.isir_id / corr_upd_rec.ci_sequence_number : '||corr_upd_rec.isir_id||' / '||corr_upd_rec.ci_sequence_number);
1269: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.ci_cal_type / corr_upd_rec.sar_field_number : '||corr_upd_rec.ci_cal_type||' / '||corr_upd_rec.sar_field_number);
1270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_retval / pv_item_value / l_new_corr_status : '||pv_retval / pv_item_value||' / '||l_new_corr_status);

Line 1308: lv_retval igf_ap_isir_corr.original_value%TYPE;

1304: || (reverse chronological order - newest change first)
1305: */
1306:
1307: lv_cur PLS_INTEGER;
1308: lv_retval igf_ap_isir_corr.original_value%TYPE;
1309: lv_stmt VARCHAR2(2000);
1310: lv_rows integer;
1311: ln_isir_id igf_ap_isir_matched.isir_id%TYPE := pv_isir_id;
1312: lv_cal_type igs_ca_inst.cal_type%TYPE := pv_ci_cal_type;

Line 1444: cp_corr_status igf_ap_isir_corr_all.correction_status%TYPE

1440: AND im.payment_isir = 'Y';
1441:
1442:
1443: CURSOR cur_chk_batched ( cp_base_id igf_ap_isir_matched_all.base_id%TYPE,
1444: cp_corr_status igf_ap_isir_corr_all.correction_status%TYPE
1445: )
1446: IS
1447: SELECT isir.base_id
1448: FROM igf_ap_isir_matched_all isir,

Line 1449: igf_ap_isir_corr_all corr

1445: )
1446: IS
1447: SELECT isir.base_id
1448: FROM igf_ap_isir_matched_all isir,
1449: igf_ap_isir_corr_all corr
1450: WHERE isir.base_id = cp_base_id
1451: AND isir.isir_id = corr.isir_id
1452: AND NVL(corr.correction_status,'X') = cp_corr_status;
1453: