APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGF_AP_NSLDS_DATA

Line 1423: igf_ap_nslds_data_pkg.insert_row(

1419: log_debug_message(' Beginning Insert of NSLDS record for ISIR ID : ' || p_isir_id || '. Base ID : ' || p_base_id);
1420:
1421: lv_rowid := NULL;
1422: -- Insert old record into ISIR Matched Table
1423: igf_ap_nslds_data_pkg.insert_row(
1424: x_Mode => 'R',
1425: x_rowid => lv_rowid,
1426: x_nslds_id => p_out_nslds_id,
1427: x_isir_id => p_isir_id,

Line 3685: lv_nslds_id igf_ap_nslds_data_all.nslds_id%TYPE;

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;
3688: l_anticip_status VARCHAR2(30);
3689: l_awd_prc_status VARCHAR2(30);

Line 3888: lv_nslds_id igf_ap_nslds_data_all.nslds_id%TYPE;

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:
3891: BEGIN
3892:

Line 8138: cp_trans_num igf_ap_nslds_data_all.transaction_num_txt%TYPE) IS

8134: FROM igf_ap_isir_ints iii
8135: WHERE si_id = pn_si_id;
8136:
8137: CURSOR cur_nslds_data (cp_base_id NUMBER ,
8138: cp_trans_num igf_ap_nslds_data_all.transaction_num_txt%TYPE) IS
8139: SELECT nslds.rowid row_id,
8140: nslds.nslds_id
8141: FROM igf_ap_nslds_data nslds
8142: WHERE base_id = cp_base_id

Line 8141: FROM igf_ap_nslds_data nslds

8137: CURSOR cur_nslds_data (cp_base_id NUMBER ,
8138: cp_trans_num igf_ap_nslds_data_all.transaction_num_txt%TYPE) IS
8139: SELECT nslds.rowid row_id,
8140: nslds.nslds_id
8141: FROM igf_ap_nslds_data nslds
8142: WHERE base_id = cp_base_id
8143: AND transaction_num_txt = cp_trans_num
8144: FOR UPDATE NOWAIT ;
8145:

Line 8147: ln_nslds_id igf_ap_nslds_data.nslds_id%TYPE;

8143: AND transaction_num_txt = cp_trans_num
8144: FOR UPDATE NOWAIT ;
8145:
8146: lv_rowid VARCHAR2(30);
8147: ln_nslds_id igf_ap_nslds_data.nslds_id%TYPE;
8148:
8149: BEGIN
8150:
8151: -- Update NSLDS data for the given student