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.

APPS.IGF_AP_BATCH_VER_PRC_PKG dependencies on IGF_AP_ISIR_MATCHED

Line 37: | Added TBH impact of igf_ap_isir_matched |

33: | |
34: | rasahoo 17-NOV-2003 FA 128 - ISIR update 2004-05 |
35: | added parameter award_fmly_contribution_type |
36: | to TBH call igf_ap_fa_base_rec_pkg |
37: | Added TBH impact of igf_ap_isir_matched |
38: | |
39: | cdcruz 26-SEP-2003 FA 121 - Verification Worksheet. |
40: | Changes per the TD have been incoporated |
41: | EFC Computation is added while creating |

Line 116: | IGF_AP_ISIR_MATCHED_PKG. |

112: | correction record with "NotReady" status is created |
113: | |
114: | gvarapra 14-sep-2004 FA138 - ISIR Enhancements |
115: | Added arguments in call to |
116: | IGF_AP_ISIR_MATCHED_PKG. |
117: | Added arguments in call to |
118: | IGF_AP_FA_BASE_RECORD_PKG. |
119: *=======================================================================*/
120:

Line 421: l_tablename := 'IGF_AP_ISIR_MATCHED';

417: l_tablename VARCHAR2(60) ;
418:
419: BEGIN
420:
421: l_tablename := 'IGF_AP_ISIR_MATCHED';
422: OPEN get_data_type ( l_tablename) ;
423: FETCH get_data_type INTO v_datatype;
424: CLOSE get_data_type;
425:

Line 457: FROM igf_ap_isir_matched im

453: */
454:
455: CURSOR cur_isir_original (cp_base_id NUMBER) IS
456: SELECT im.*
457: FROM igf_ap_isir_matched im
458: WHERE im.payment_isir = 'Y'
459: AND im.system_record_type = 'ORIGINAL'
460: AND im.base_id = cp_base_id;
461:

Line 466: -- INsert Record in IGF_AP_ISIR_Matched table

462: lv_rowid VARCHAR2(30);
463:
464: BEGIN
465:
466: -- INsert Record in IGF_AP_ISIR_Matched table
467: FOR cur_ori_isir_rec IN cur_isir_original(p_base_id) LOOP
468:
469: igf_ap_isir_matched_pkg.insert_row(
470: x_Mode => 'R',

Line 469: igf_ap_isir_matched_pkg.insert_row(

465:
466: -- INsert Record in IGF_AP_ISIR_Matched table
467: FOR cur_ori_isir_rec IN cur_isir_original(p_base_id) LOOP
468:
469: igf_ap_isir_matched_pkg.insert_row(
470: x_Mode => 'R',
471: x_rowid => lv_rowid,
472: x_isir_id => pn_isir_id,
473: x_base_id => cur_ori_isir_rec.base_id,

Line 771: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_update_base_rec.debug','igf_ap_isir_matched_pkg.insert_row successfull New ISIR ID: '||pn_isir_id);

767: x_rejected_status_change_flag => cur_ori_isir_rec.rejected_status_change_flag,
768: x_verification_selection_flag => cur_ori_isir_rec.verification_selection_flag
769: );
770: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
771: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_update_base_rec.debug','igf_ap_isir_matched_pkg.insert_row successfull New ISIR ID: '||pn_isir_id);
772: END IF;
773: END LOOP;
774:
775: EXCEPTION

Line 791: p_isir_rec IGF_AP_ISIR_MATCHED%ROWTYPE ,

787:
788:
789: PROCEDURE update_correction_isir (
790: pn_base_id igf_ap_fa_base_rec.base_id%TYPE ,
791: p_isir_rec IGF_AP_ISIR_MATCHED%ROWTYPE ,
792: p_update_ssn VARCHAR2
793: ) IS
794: /*
795: || Created By : rasingh

Line 830: igf_ap_isir_matched_pkg.update_row(

826: END IF;
827:
828: END IF;
829:
830: igf_ap_isir_matched_pkg.update_row(
831: x_Mode => 'R',
832: x_rowid => p_isir_rec.row_id,
833: x_isir_id => p_isir_rec.isir_id,
834: x_base_id => p_isir_rec.base_id,

Line 1136: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.update_correction_isir.debug','igf_ap_isir_matched_pkg.update_row successfull');

1132: x_rejected_status_change_flag => p_isir_rec.rejected_status_change_flag,
1133: x_verification_selection_flag => p_isir_rec.verification_selection_flag
1134: );
1135: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1136: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.update_correction_isir.debug','igf_ap_isir_matched_pkg.update_row successfull');
1137: END IF;
1138:
1139: EXCEPTION
1140: WHEN OTHERS THEN

Line 1208: pn_isir_id igf_ap_isir_matched.isir_id%TYPE ,

1204:
1205:
1206: PROCEDURE l_create_corr_record(
1207: pn_base_id igf_ap_fa_base_rec.base_id%TYPE ,
1208: pn_isir_id igf_ap_isir_matched.isir_id%TYPE ,
1209: pv_isir_map_column igf_ap_inst_ver_item.isir_map_col%TYPE,
1210: pv_cal_type igs_ca_inst.cal_type%TYPE,
1211: pn_sequence_number igs_ca_inst.sequence_number%TYPE,
1212: pv_retval VARCHAR2,

Line 1287: pv_isir_id IN igf_ap_isir_matched.isir_id%TYPE,

1283: END l_create_corr_record;
1284:
1285:
1286: PROCEDURE l_validate_data ( pn_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1287: pv_isir_id IN igf_ap_isir_matched.isir_id%TYPE,
1288: pv_item_value IN igf_ap_inst_ver_item.item_value%TYPE,
1289: pv_column_name IN igf_fc_sar_cd_mst.sar_field_name%TYPE, --gets the SAR Field name
1290: pv_isir_map_column IN igf_ap_inst_ver_item.isir_map_col%TYPE,
1291: pv_ci_cal_type IN igf_ap_fa_base_rec.ci_cal_type%TYPE,

Line 1311: ln_isir_id igf_ap_isir_matched.isir_id%TYPE := pv_isir_id;

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;
1313: ln_sequence_number igs_ca_inst.sequence_number%TYPE := pv_ci_sequence_number;
1314: lv_item_value igf_ap_inst_ver_item.item_value%TYPE;
1315: l_mode VARCHAR2(30);

Line 1346: lv_stmt := 'SELECT '||pv_column_name ||' FROM igf_ap_isir_matched where isir_id = '||to_char(pv_isir_id);

1342: ELSE
1343:
1344: IF pv_column_name IS NOT NULL THEN
1345: lv_cur := DBMS_SQL.OPEN_CURSOR;
1346: lv_stmt := 'SELECT '||pv_column_name ||' FROM igf_ap_isir_matched where isir_id = '||to_char(pv_isir_id);
1347:
1348: DBMS_SQL.PARSE(lv_cur,lv_stmt,2);
1349: DBMS_SQL.DEFINE_COLUMN(lv_cur,1,lv_retval,30);
1350: lv_rows := DBMS_SQL.EXECUTE_AND_FETCH(lv_cur);

Line 1432: igf_ap_isir_matched_all im,

1428: pe.person_first_name given_names,
1429: pe.person_last_name surname,
1430: im.isir_id
1431: FROM igf_ap_fa_base_rec_all far,
1432: igf_ap_isir_matched_all im,
1433: hz_parties pe
1434: WHERE far.person_id = pe.party_id
1435: AND far.ci_cal_type = NVL(lv_ci_cal_type,far.ci_cal_type)
1436: AND far.ci_sequence_number = NVL(lv_ci_sequence_number, far.ci_sequence_number)

Line 1443: CURSOR cur_chk_batched ( cp_base_id igf_ap_isir_matched_all.base_id%TYPE,

1439: AND im.system_record_type = 'ORIGINAL'
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

Line 1448: FROM igf_ap_isir_matched_all isir,

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

Line 1490: FROM igf_ap_isir_matched

1486: lc_get_ver_item_count cur_get_ver_item_count%ROWTYPE;
1487:
1488: CURSOR c_correction_isir ( cp_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
1489: SELECT *
1490: FROM igf_ap_isir_matched
1491: WHERE BASE_ID = cp_base_id
1492: AND SYSTEM_RECORD_TYPE = 'CORRECTION';
1493:
1494: CURSOR c_get_sys_year(

Line 1511: lv_efc_isir_rec igf_ap_isir_matched%ROWTYPE;

1507: lv_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1508: lv_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1509: lv_ver_status VARCHAR2(30);
1510: ln_tot_count NUMBER(15);
1511: lv_efc_isir_rec igf_ap_isir_matched%ROWTYPE;
1512: p_efc_ret_status VARCHAR2(30);
1513: p_msg_count NUMBER;
1514: p_msg_text VARCHAR2(2000);
1515: lv_update_ssn VARCHAR2(1);

Line 1517: ln_corr_isir_id igf_ap_isir_matched_all.isir_id%TYPE;

1513: p_msg_count NUMBER;
1514: p_msg_text VARCHAR2(2000);
1515: lv_update_ssn VARCHAR2(1);
1516: SKIP_STUDENT EXCEPTION;
1517: ln_corr_isir_id igf_ap_isir_matched_all.isir_id%TYPE;
1518:
1519:
1520: BEGIN
1521: