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

Line 24: g_fa_base_rec igf_ap_fa_base_rec%ROWTYPE; -- Will be populated once and used in all places

20: g_ci_sequence_number igf_ap_batch_aw_map.ci_sequence_number%TYPE;
21: g_pell_match_type VARCHAR2(1) ; -- Stores the Type of Pell match done Duplicate/New rec
22: g_base_id NUMBER;
23: g_called_from_process BOOLEAN := FALSE;
24: g_fa_base_rec igf_ap_fa_base_rec%ROWTYPE; -- Will be populated once and used in all places
25: g_max_tran_num VARCHAR2(2); -- Stores the max transaction number
26: g_person_id NUMBER;
27: g_count_corr NUMBER ;
28:

Line 462: PROCEDURE update_fa_base_rec(p_fabase_rec igf_ap_fa_base_rec%ROWTYPE,

458: app_exception.raise_exception;
459: END update_isir_int_record;
460:
461:
462: PROCEDURE update_fa_base_rec(p_fabase_rec igf_ap_fa_base_rec%ROWTYPE,
463: p_isir_verification_flag VARCHAR2)
464: IS
465: /*
466: || Created By : rgangara

Line 476: l_fed_verif_status igf_ap_fa_base_rec.fed_verif_status%TYPE;

472: ||
473: || (reverse chronological order - newest change first)
474: */
475:
476: l_fed_verif_status igf_ap_fa_base_rec.fed_verif_status%TYPE;
477:
478: BEGIN
479:
480: l_fed_verif_status := p_fabase_rec.fed_verif_status;

Line 494: igf_ap_fa_base_rec_pkg.update_row(

490: END IF;
491: END IF;
492:
493: -- call the TBH to update the record
494: igf_ap_fa_base_rec_pkg.update_row(
495: x_Mode => 'R' ,
496: x_rowid => p_fabase_rec.row_id ,
497: x_base_id => p_fabase_rec.base_id ,
498: x_ci_cal_type => p_fabase_rec.ci_cal_type ,

Line 1724: l_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;

1720:
1721: lv_profile_value VARCHAR2(20);
1722: l_award_fmly_contr_type VARCHAR2(1);
1723: lv_rowid VARCHAR2(30);
1724: l_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;
1725:
1726: BEGIN
1727:
1728: log_debug_message(' Beginning Insert of FA Base Record. Person ID ' || pn_person_id);

Line 1766: igf_ap_fa_base_rec_pkg.insert_row(

1762: CLOSE ssn_cur;
1763: END IF;
1764: END IF;
1765:
1766: igf_ap_fa_base_rec_pkg.insert_row(
1767: x_Mode => 'R',
1768: x_rowid => lv_rowid,
1769: x_base_id => pn_base_id,
1770: x_ci_cal_type => g_ci_cal_type,

Line 2055: FROM igf_ap_fa_base_rec_all

2051: l_person_num hz_parties.party_number%TYPE;
2052:
2053: CURSOR get_fa_rec_verif_stat (pn_base_id NUMBER) IS
2054: SELECT fed_verif_status
2055: FROM igf_ap_fa_base_rec_all
2056: WHERE base_id = pn_base_id;
2057:
2058: l_verification_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;
2059: BEGIN

Line 2058: l_verification_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;

2054: SELECT fed_verif_status
2055: FROM igf_ap_fa_base_rec_all
2056: WHERE base_id = pn_base_id;
2057:
2058: l_verification_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;
2059: BEGIN
2060:
2061: l_seq_val := 'IGFAPW06'|| TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'); -- for unique identification
2062:

Line 2481: CURSOR person_cur (ln_person_id igf_ap_fa_base_rec.person_id%TYPE) IS

2477:
2478: isir_rec isir_cur%ROWTYPE;
2479:
2480:
2481: CURSOR person_cur (ln_person_id igf_ap_fa_base_rec.person_id%TYPE) IS
2482: SELECT person_number,
2483: api_person_id,
2484: birth_dt,
2485: sex

Line 2491: CURSOR hzparties_cur (ln_person_id igf_ap_fa_base_rec.person_id%TYPE) IS

2487: WHERE person_id = ln_person_id;
2488:
2489: person_rec person_cur%ROWTYPE;
2490:
2491: CURSOR hzparties_cur (ln_person_id igf_ap_fa_base_rec.person_id%TYPE) IS
2492: SELECT person_first_name,
2493: person_last_name,
2494: address1,
2495: city,

Line 2507: ln_person_id igf_ap_fa_base_rec.person_id%TYPE) IS

2503:
2504:
2505:
2506: CURSOR alt_person_id_cur (ln_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE,
2507: ln_person_id igf_ap_fa_base_rec.person_id%TYPE) IS
2508: SELECT rowid row_id,
2509: altp.*
2510: FROM igs_pe_alt_pers_id altp
2511: WHERE altp.pe_person_id = ln_person_id

Line 2532: ln_person_id igf_ap_fa_base_rec.person_id%TYPE;

2528: AND enabled_flag = 'Y';
2529:
2530:
2531: ln_person_number hz_parties.party_number%TYPE;
2532: ln_person_id igf_ap_fa_base_rec.person_id%TYPE;
2533: lv_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
2534: alt_person_id_rec alt_person_id_cur%ROWTYPE;
2535: ln_msg_count NUMBER;
2536: lv_msg_data VARCHAR2(2000);

Line 3058: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

3054: END delete_person_match_rec;
3055:
3056:
3057: PROCEDURE create_admission_rec(
3058: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
3059: p_batch_year igf_ap_batch_aw_map_all.batch_year%TYPE
3060: )
3061: IS
3062: /*

Line 3667: CURSOR chk_isir_exist (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

3663: || (reverse chronological order - newest change first)
3664: || museshad 12-Apr-2006 Bug 5096864. Added code to update the FA Base record details
3665: || with the newly created ISIR info.
3666: */
3667: CURSOR chk_isir_exist (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
3668: IS
3669: SELECT 'x'
3670: FROM igf_ap_isir_matched_all
3671: WHERE base_id = cp_base_id AND

Line 3676: CURSOR cur_fabase (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

3672: ROWNUM = 1;
3673:
3674: l_chk_isir_exist chk_isir_exist%ROWTYPE;
3675:
3676: CURSOR cur_fabase (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
3677: SELECT fa.*
3678: FROM igf_ap_fa_base_rec fa
3679: WHERE fa.base_id = cp_base_id;
3680:

Line 3678: FROM igf_ap_fa_base_rec fa

3674: l_chk_isir_exist chk_isir_exist%ROWTYPE;
3675:
3676: CURSOR cur_fabase (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
3677: SELECT fa.*
3678: FROM igf_ap_fa_base_rec fa
3679: WHERE fa.base_id = cp_base_id;
3680:
3681: lv_cur_fabase_rec cur_fabase%ROWTYPE;
3682:

Line 3683: lv_base_id igf_ap_fa_base_rec.base_id%TYPE;

3679: WHERE fa.base_id = cp_base_id;
3680:
3681: lv_cur_fabase_rec cur_fabase%ROWTYPE;
3682:
3683: lv_base_id igf_ap_fa_base_rec.base_id%TYPE;
3684: lv_isir_id igf_ap_isir_matched_all.isir_id%TYPE;
3685: lv_nslds_id igf_ap_nslds_data_all.nslds_id%TYPE;
3686: l_pymt_isir_flag igf_ap_isir_matched_all.payment_isir%TYPE;
3687: l_chk_fo_ant_data BOOLEAN;

Line 3886: lv_base_id igf_ap_fa_base_rec.base_id%TYPE;

3882: || (reverse chronological order - newest change first)
3883: */
3884:
3885: lv_person_id igf_ap_person_v.person_id%TYPE ;
3886: lv_base_id igf_ap_fa_base_rec.base_id%TYPE;
3887: lv_isir_id igf_ap_css_profile.cssp_id%TYPE;
3888: lv_nslds_id igf_ap_nslds_data_all.nslds_id%TYPE;
3889: l_pymt_isir_flag igf_ap_isir_matched_all.payment_isir%TYPE;
3890:

Line 4701: CURSOR chk_isir_exist (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

4697: AND ci_sequence_number = p_seq_num ;
4698:
4699: l_base_id NUMBER;
4700:
4701: CURSOR chk_isir_exist (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
4702: IS
4703: SELECT 'x'
4704: FROM igf_ap_isir_matched_all
4705: WHERE base_id = cp_base_id AND

Line 6753: FROM igf_ap_fa_base_rec fa

6749: */
6750:
6751: CURSOR cur_fabase (pn_base_id NUMBER) IS
6752: SELECT fa.*
6753: FROM igf_ap_fa_base_rec fa
6754: WHERE fa.base_id = pn_base_id FOR UPDATE NOWAIT ;
6755:
6756: lv_cur_fabase_rec cur_fabase%ROWTYPE;
6757:

Line 6768: CURSOR person_cur (ln_person_id igf_ap_fa_base_rec.person_id%TYPE) IS

6764:
6765: old_pymt_isir_rec cur_old_pymt_isir%ROWTYPE;
6766:
6767:
6768: CURSOR person_cur (ln_person_id igf_ap_fa_base_rec.person_id%TYPE) IS
6769: SELECT party_number person_number
6770: FROM hz_parties
6771: WHERE party_id = ln_person_id;
6772:

Line 6774: CURSOR cur_old_active_isir(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

6770: FROM hz_parties
6771: WHERE party_id = ln_person_id;
6772:
6773: -- Get the privious Active ISIR id for the base id.
6774: CURSOR cur_old_active_isir(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
6775: SELECT isir_id
6776: FROM igf_ap_isir_matched_all
6777: WHERE base_id = cp_base_id
6778: AND active_isir = 'Y';

Line 6780: CURSOR cur_loan_orig_chk(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

6776: FROM igf_ap_isir_matched_all
6777: WHERE base_id = cp_base_id
6778: AND active_isir = 'Y';
6779:
6780: CURSOR cur_loan_orig_chk(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
6781: SELECT
6782: 'X'
6783: FROM
6784: IGF_SL_LOR_ALL LOR, IGF_SL_LOANS_ALL LOAN,

Line 6986: FROM igf_ap_fa_base_rec

6982: l_nslds_id NUMBER;
6983:
6984: CURSOR get_person_cur(pn_base_id NUMBER) IS
6985: SELECT person_id
6986: FROM igf_ap_fa_base_rec
6987: WHERE base_id = pn_base_id;
6988:
6989: BEGIN
6990:

Line 7147: FROM igf_ap_fa_base_rec

7143: AND rownum = 1;
7144:
7145: CURSOR check_pymt_isir_locked_cur(pn_base_id NUMBER) IS
7146: SELECT isir_locked_by
7147: FROM igf_ap_fa_base_rec
7148: WHERE base_id = pn_base_id;
7149:
7150: CURSOR get_pymnt_isir_tran_cur(pn_base_id NUMBER) IS
7151: SELECT transaction_num

Line 7803: FROM igf_ap_fa_base_rec ifb,

7799:
7800: -- Get all the records from base table which are having same person id and the given batch year
7801: CURSOR cur_fa_base_record (pn_person_id NUMBER, ln_batch_year NUMBER) IS
7802: SELECT ifb.*
7803: FROM igf_ap_fa_base_rec ifb,
7804: igf_ap_batch_aw_map ibm
7805: WHERE ifb.person_id = pn_person_id
7806: AND ibm.ci_sequence_number = ifb.ci_sequence_number
7807: AND ibm.ci_cal_type = ifb.ci_cal_type

Line 8414: FROM igf_ap_fa_base_rec br, igf_ap_batch_aw_map am

8410:
8411: -- Added cp_batch_year as a part of Bug Fix 4241350
8412: CURSOR cur_base_id_rec(cp_person_id NUMBER, cp_batch_year NUMBER) IS
8413: SELECT base_id
8414: FROM igf_ap_fa_base_rec br, igf_ap_batch_aw_map am
8415: WHERE person_id = cp_person_id
8416: AND br.ci_cal_type = am.ci_cal_type
8417: AND br.ci_sequence_number = am.ci_sequence_number
8418: AND am.batch_year = cp_batch_year;

Line 8442: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

8438:
8439: person_match_rec get_person_match_cur%ROWTYPE;
8440: ln_apm_id NUMBER;
8441: l_trans_exists VARCHAR2(1);
8442: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
8443:
8444: BEGIN
8445: -- Get the Interface record details
8446: OPEN cur_isir_intrface (p_si_id);