APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGF_AP_FA_BASE_REC_ALL

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