APPS.IGF_SL_DL_PNOTE_ACK dependencies on IGF_SL_DL_PDET_RESP

Line 312: l_dlpdr_id igf_sl_dl_pdet_resp.dlpdr_id%TYPE;

308: l_lor_resp_num NUMBER;
309: lv_rowid VARCHAR2(100);
310: lc_rowid VARCHAR2(100);
311: l_dlpnr_id igf_sl_dl_pnote_resp.dlpnr_id%TYPE;
312: l_dlpdr_id igf_sl_dl_pdet_resp.dlpdr_id%TYPE;
313: l_c_elec_mpn_ind igf_sl_dl_pnote_resp.ELEC_MPN_IND%TYPE := NULL;
314:
315: CURSOR c_trans
316: IS

Line 356: -- ## Insert that record in IGF_SL_DL_PDET_RESP table

352: );
353:
354:
355: -- ## For each Loan there will be Many Disbursement Records
356: -- ## Insert that record in IGF_SL_DL_PDET_RESP table
357:
358: FOR i IN 0..19 LOOP
359: IF RTRIM(SUBSTR(orec.record_data, 64 + (i * 5),5)) IS NOT NULL THEN
360:

Line 361: igf_sl_dl_pdet_resp_pkg.insert_row (

357:
358: FOR i IN 0..19 LOOP
359: IF RTRIM(SUBSTR(orec.record_data, 64 + (i * 5),5)) IS NOT NULL THEN
360:
361: igf_sl_dl_pdet_resp_pkg.insert_row (
362: x_mode => 'R',
363: x_rowid => lc_rowid,
364: x_dlpnr_id => l_dlpnr_id,
365: x_dlpdr_id => i + 1,

Line 950: SELECT NVL(COUNT(resp.dlpdr_id),0) FROM igf_sl_dl_pdet_resp resp

946:
947: --Count the No.of Disbursements for the award id in Response8 Disbursements Table
948: CURSOR cur_count_new_disb
949: IS
950: SELECT NVL(COUNT(resp.dlpdr_id),0) FROM igf_sl_dl_pdet_resp resp
951: WHERE dlpnr_id = loaded_1rec.dlpnr_id;
952:
953: -- Check if the Disb-Num and Disb_gross_amts are same between the File and
954: -- currently in our system.

Line 961: SELECT dlpdr_id, disb_gross_amt FROM igf_sl_dl_pdet_resp resp

957: ((
958: SELECT disb_num, NVL(disb_accepted_amt,0) disb_gross_amt FROM igf_aw_awd_disb adisb
959: WHERE award_id = l_award_id
960: MINUS
961: SELECT dlpdr_id, disb_gross_amt FROM igf_sl_dl_pdet_resp resp
962: WHERE dlpnr_id = loaded_1rec.dlpnr_id
963: )
964: UNION
965: (SELECT dlpdr_id, disb_gross_amt FROM igf_sl_dl_pdet_resp resp

Line 965: (SELECT dlpdr_id, disb_gross_amt FROM igf_sl_dl_pdet_resp resp

961: SELECT dlpdr_id, disb_gross_amt FROM igf_sl_dl_pdet_resp resp
962: WHERE dlpnr_id = loaded_1rec.dlpnr_id
963: )
964: UNION
965: (SELECT dlpdr_id, disb_gross_amt FROM igf_sl_dl_pdet_resp resp
966: WHERE dlpnr_id = loaded_1rec.dlpnr_id
967: MINUS
968: SELECT disb_num, NVL(disb_accepted_amt,0) disb_gross_amt FROM igf_aw_awd_disb adisb
969: WHERE award_id = l_award_id

Line 976: SELECT * FROM igf_sl_dl_pdet_resp resp

972:
973: --select the NewDisbursements for the award id in Response8 Disbursements Table
974: CURSOR cur_new_disbursements
975: IS
976: SELECT * FROM igf_sl_dl_pdet_resp resp
977: WHERE dlpnr_id = loaded_1rec.dlpnr_id
978: ORDER By dlpnr_id;
979:
980: --Select the old Disbursements for the award id in Awards Disbursements Table