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_ISIR_IMPORT_PKG dependencies on IGF_AP_FA_BASE_REC

Line 5: g_base_rec igf_ap_fa_base_rec%ROWTYPE;

1: PACKAGE BODY IGF_AP_ISIR_IMPORT_PKG AS
2: /* $Header: IGFAP01B.pls 120.2 2006/02/10 02:47:08 bvisvana noship $ */
3:
4: g_ISIR_rec igf_ap_ISIR_matched%ROWTYPE;
5: g_base_rec igf_ap_fa_base_rec%ROWTYPE;
6: g_paid_efc igf_ap_fa_base_rec.efc_f%TYPE;
7: g_pell_grant_elig_flag igf_ap_fa_base_rec_all.pell_eligible%TYPE;
8: g_nslds_match_flag igf_ap_fa_base_rec.nslds_eligible%TYPE;
9: g_verification_flag igf_ap_ISIR_matched.verification_flag%TYPE;

Line 6: g_paid_efc igf_ap_fa_base_rec.efc_f%TYPE;

2: /* $Header: IGFAP01B.pls 120.2 2006/02/10 02:47:08 bvisvana noship $ */
3:
4: g_ISIR_rec igf_ap_ISIR_matched%ROWTYPE;
5: g_base_rec igf_ap_fa_base_rec%ROWTYPE;
6: g_paid_efc igf_ap_fa_base_rec.efc_f%TYPE;
7: g_pell_grant_elig_flag igf_ap_fa_base_rec_all.pell_eligible%TYPE;
8: g_nslds_match_flag igf_ap_fa_base_rec.nslds_eligible%TYPE;
9: g_verification_flag igf_ap_ISIR_matched.verification_flag%TYPE;
10: g_ISIR_id igf_ap_ISIR_matched.ISIR_id%TYPE;

Line 7: g_pell_grant_elig_flag igf_ap_fa_base_rec_all.pell_eligible%TYPE;

3:
4: g_ISIR_rec igf_ap_ISIR_matched%ROWTYPE;
5: g_base_rec igf_ap_fa_base_rec%ROWTYPE;
6: g_paid_efc igf_ap_fa_base_rec.efc_f%TYPE;
7: g_pell_grant_elig_flag igf_ap_fa_base_rec_all.pell_eligible%TYPE;
8: g_nslds_match_flag igf_ap_fa_base_rec.nslds_eligible%TYPE;
9: g_verification_flag igf_ap_ISIR_matched.verification_flag%TYPE;
10: g_ISIR_id igf_ap_ISIR_matched.ISIR_id%TYPE;
11: g_base_id igf_ap_fa_base_rec.base_id%TYPE;

Line 8: g_nslds_match_flag igf_ap_fa_base_rec.nslds_eligible%TYPE;

4: g_ISIR_rec igf_ap_ISIR_matched%ROWTYPE;
5: g_base_rec igf_ap_fa_base_rec%ROWTYPE;
6: g_paid_efc igf_ap_fa_base_rec.efc_f%TYPE;
7: g_pell_grant_elig_flag igf_ap_fa_base_rec_all.pell_eligible%TYPE;
8: g_nslds_match_flag igf_ap_fa_base_rec.nslds_eligible%TYPE;
9: g_verification_flag igf_ap_ISIR_matched.verification_flag%TYPE;
10: g_ISIR_id igf_ap_ISIR_matched.ISIR_id%TYPE;
11: g_base_id igf_ap_fa_base_rec.base_id%TYPE;
12: g_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;

Line 11: g_base_id igf_ap_fa_base_rec.base_id%TYPE;

7: g_pell_grant_elig_flag igf_ap_fa_base_rec_all.pell_eligible%TYPE;
8: g_nslds_match_flag igf_ap_fa_base_rec.nslds_eligible%TYPE;
9: g_verification_flag igf_ap_ISIR_matched.verification_flag%TYPE;
10: g_ISIR_id igf_ap_ISIR_matched.ISIR_id%TYPE;
11: g_base_id igf_ap_fa_base_rec.base_id%TYPE;
12: g_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;
13: g_msg_body VARCHAR2(4000) := NULL;
14: g_transaction_num CHAR(13);
15: g_cnt NUMBER := 1;

Line 12: g_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;

8: g_nslds_match_flag igf_ap_fa_base_rec.nslds_eligible%TYPE;
9: g_verification_flag igf_ap_ISIR_matched.verification_flag%TYPE;
10: g_ISIR_id igf_ap_ISIR_matched.ISIR_id%TYPE;
11: g_base_id igf_ap_fa_base_rec.base_id%TYPE;
12: g_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;
13: g_msg_body VARCHAR2(4000) := NULL;
14: g_transaction_num CHAR(13);
15: g_cnt NUMBER := 1;
16: l_document VARCHAR2(4000);

Line 223: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;

219: l_sql VARCHAR2(32000);
220: l_add_and VARCHAR2(1);
221: ln_total_rec NUMBER := 0;
222:
223: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
224: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
225: l_batch_year igf_ap_batch_aw_map_all.batch_year%TYPE;
226:
227: g_parent_req_number NUMBER;

Line 224: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;

220: l_add_and VARCHAR2(1);
221: ln_total_rec NUMBER := 0;
222:
223: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
224: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
225: l_batch_year igf_ap_batch_aw_map_all.batch_year%TYPE;
226:
227: g_parent_req_number NUMBER;
228: ------------------------------------------------------------

Line 1331: PROCEDURE update_fabase (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

1327: igs_ge_msg_stack.add;
1328: app_exception.raise_exception;
1329: END update_matched_ISIR;
1330:
1331: PROCEDURE update_fabase (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1332: p_ISIR_corr_status igf_ap_fa_base_rec_all.ISIR_corr_status%TYPE,
1333: p_ISIR_corr_status_date igf_ap_fa_base_rec_all.ISIR_corr_status_date%TYPE)
1334: IS
1335: /*

Line 1332: p_ISIR_corr_status igf_ap_fa_base_rec_all.ISIR_corr_status%TYPE,

1328: app_exception.raise_exception;
1329: END update_matched_ISIR;
1330:
1331: PROCEDURE update_fabase (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1332: p_ISIR_corr_status igf_ap_fa_base_rec_all.ISIR_corr_status%TYPE,
1333: p_ISIR_corr_status_date igf_ap_fa_base_rec_all.ISIR_corr_status_date%TYPE)
1334: IS
1335: /*
1336: || Created By : brajendr

Line 1333: p_ISIR_corr_status_date igf_ap_fa_base_rec_all.ISIR_corr_status_date%TYPE)

1329: END update_matched_ISIR;
1330:
1331: PROCEDURE update_fabase (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1332: p_ISIR_corr_status igf_ap_fa_base_rec_all.ISIR_corr_status%TYPE,
1333: p_ISIR_corr_status_date igf_ap_fa_base_rec_all.ISIR_corr_status_date%TYPE)
1334: IS
1335: /*
1336: || Created By : brajendr
1337: || Created On : 08-NOV-2000

Line 1349: CURSOR cur_upd_base (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

1345: || Added manual_disb_hold in update of Fa Base Rec
1346: || (reverse chronological order - newest change first)
1347: */
1348:
1349: CURSOR cur_upd_base (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
1350: SELECT fab.*
1351: FROM igf_ap_fa_base_rec fab
1352: WHERE fab.base_id = p_base_id;
1353:

Line 1351: FROM igf_ap_fa_base_rec fab

1347: */
1348:
1349: CURSOR cur_upd_base (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
1350: SELECT fab.*
1351: FROM igf_ap_fa_base_rec fab
1352: WHERE fab.base_id = p_base_id;
1353:
1354: cur_fbr_rec cur_upd_base%ROWTYPE;
1355: l_fed_verif_stat igf_ap_fa_base_rec.fed_verif_status%TYPE;

Line 1355: l_fed_verif_stat igf_ap_fa_base_rec.fed_verif_status%TYPE;

1351: FROM igf_ap_fa_base_rec fab
1352: WHERE fab.base_id = p_base_id;
1353:
1354: cur_fbr_rec cur_upd_base%ROWTYPE;
1355: l_fed_verif_stat igf_ap_fa_base_rec.fed_verif_status%TYPE;
1356: l_fed_verif_date igf_ap_fa_base_rec.fed_verif_status_date%TYPE := TRUNC(SYSDATE);
1357:
1358: BEGIN
1359:

Line 1356: l_fed_verif_date igf_ap_fa_base_rec.fed_verif_status_date%TYPE := TRUNC(SYSDATE);

1352: WHERE fab.base_id = p_base_id;
1353:
1354: cur_fbr_rec cur_upd_base%ROWTYPE;
1355: l_fed_verif_stat igf_ap_fa_base_rec.fed_verif_status%TYPE;
1356: l_fed_verif_date igf_ap_fa_base_rec.fed_verif_status_date%TYPE := TRUNC(SYSDATE);
1357:
1358: BEGIN
1359:
1360: FOR cur_fbr_rec IN cur_upd_base (p_base_id) LOOP

Line 1378: igf_ap_fa_base_rec_pkg.update_row (x_Mode => 'R',

1374: END IF;
1375:
1376: END IF;
1377:
1378: igf_ap_fa_base_rec_pkg.update_row (x_Mode => 'R',
1379: x_rowid => cur_fbr_rec.row_id,
1380: x_base_id => cur_fbr_rec.base_id,
1381: x_ci_cal_type => cur_fbr_rec.ci_cal_type,
1382: x_person_id => cur_fbr_rec.person_id,

Line 1553: PROCEDURE validate_corrections (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

1549: igs_ge_msg_stack.add;
1550: app_exception.raise_exception;
1551: END update_ISIR_corr;
1552:
1553: PROCEDURE validate_corrections (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1554: p_ISIR_id igf_ap_ISIR_matched.ISIR_id%TYPE)
1555: IS
1556:
1557: CURSOR cur_ISIR (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

Line 1557: CURSOR cur_ISIR (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

1553: PROCEDURE validate_corrections (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1554: p_ISIR_id igf_ap_ISIR_matched.ISIR_id%TYPE)
1555: IS
1556:
1557: CURSOR cur_ISIR (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
1558: SELECT ISIR_id
1559: FROM igf_ap_ISIR_matched
1560: WHERE base_id = p_base_id;
1561:

Line 1562: CURSOR cur_isir_corr (cp_base_id igf_ap_fa_base_rec.base_id%TYPE ,

1558: SELECT ISIR_id
1559: FROM igf_ap_ISIR_matched
1560: WHERE base_id = p_base_id;
1561:
1562: CURSOR cur_isir_corr (cp_base_id igf_ap_fa_base_rec.base_id%TYPE ,
1563: l_isir_id igf_ap_isir_matched.isir_id%TYPE,
1564: cp_corr_stat VARCHAR2,
1565: cp_lkup_type VARCHAR2 ) IS
1566: SELECT corr.ISIR_id,

Line 1574: igf_ap_fa_base_rec_all fabase,

1570: corr.corrected_value,
1571: corr.correction_status ,
1572: lkup.meaning meaning
1573: FROM igf_ap_batch_aw_map map,
1574: igf_ap_fa_base_rec_all fabase,
1575: igf_ap_ISIR_corr corr,
1576: Igf_fc_sar_cd_mst sar ,
1577: igf_lookups_view lkup
1578: WHERE fabase.base_id = cp_base_id