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_SL_DL_PNOTE_ACK dependencies on IGF_SL_DL_PNOTE_RESP

Line 91: PROCEDURE update_resp_edit(p_dlpnr_id igf_sl_dl_pnote_resp_all.dlpnr_id%TYPE,

87:
88: g_log_title VARCHAR2(1000);
89: g_log_start_flag BOOLEAN;
90:
91: PROCEDURE update_resp_edit(p_dlpnr_id igf_sl_dl_pnote_resp_all.dlpnr_id%TYPE,
92: p_status igf_sl_dl_pnote_resp_all.status%TYPE);
93:
94: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE ,
95: loaded_1rec igf_sl_dl_pnote_resp%ROWTYPE);

Line 92: p_status igf_sl_dl_pnote_resp_all.status%TYPE);

88: g_log_title VARCHAR2(1000);
89: g_log_start_flag BOOLEAN;
90:
91: PROCEDURE update_resp_edit(p_dlpnr_id igf_sl_dl_pnote_resp_all.dlpnr_id%TYPE,
92: p_status igf_sl_dl_pnote_resp_all.status%TYPE);
93:
94: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE ,
95: loaded_1rec igf_sl_dl_pnote_resp%ROWTYPE);
96:

Line 95: loaded_1rec igf_sl_dl_pnote_resp%ROWTYPE);

91: PROCEDURE update_resp_edit(p_dlpnr_id igf_sl_dl_pnote_resp_all.dlpnr_id%TYPE,
92: p_status igf_sl_dl_pnote_resp_all.status%TYPE);
93:
94: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE ,
95: loaded_1rec igf_sl_dl_pnote_resp%ROWTYPE);
96:
97:
98: PROCEDURE log_message(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
99: BEGIN

Line 311: l_dlpnr_id igf_sl_dl_pnote_resp.dlpnr_id%TYPE;

307: l_actual_rec NUMBER DEFAULT 0;
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

Line 313: l_c_elec_mpn_ind igf_sl_dl_pnote_resp.ELEC_MPN_IND%TYPE := NULL;

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
317: SELECT record_data

Line 338: igf_sl_dl_pnote_resp_pkg.insert_row (

334: l_c_elec_mpn_ind := 'P';
335: ELSE
336: l_c_elec_mpn_ind := SUBSTR(orec.record_data,190,1);
337: END IF;
338: igf_sl_dl_pnote_resp_pkg.insert_row (
339: x_rowid => lv_rowid,
340: x_dlpnr_id => l_dlpnr_id,
341: x_dbth_id => l_dbth_id,
342: x_pnote_ack_date => TO_DATE(RTRIM(SUBSTR(orec.record_data, 1,8)),'YYYYMMDD'),

Line 388: igf_sl_dl_pnote_resp_pkg.insert_row (

384: l_c_elec_mpn_ind := 'P';
385: ELSE
386: l_c_elec_mpn_ind := SUBSTR(orec.record_data,190,1);
387: END IF;
388: igf_sl_dl_pnote_resp_pkg.insert_row (
389: x_rowid => lv_rowid,
390: x_dlpnr_id => l_dlpnr_id,
391: x_dbth_id => l_dbth_id,
392: x_pnote_ack_date => TO_DATE(RTRIM(SUBSTR(orec.record_data, 1,8)),'YYYYMMDD'),

Line 485: SELECT igf_sl_dl_pnote_resp.* FROM igf_sl_dl_pnote_resp

481: -- ## Cursor to Fetch the Unprocessed Records from Promissory Note
482: -- ## Table
483:
484: CURSOR cur_pnote_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE) IS
485: SELECT igf_sl_dl_pnote_resp.* FROM igf_sl_dl_pnote_resp
486: WHERE dbth_id = l_dbth_id
487: AND status = 'N';
488:
489:

Line 492: CURSOR cur_loans(p_loan_number igf_sl_dl_pnote_resp_all.loan_number%TYPE) IS

488:
489:
490: -- To Check whether the Loan Exists in Financial Aid i.e exists in
491:
492: CURSOR cur_loans(p_loan_number igf_sl_dl_pnote_resp_all.loan_number%TYPE) IS
493: SELECT fed_fund_code, count(*) countcol
494: FROM igf_sl_loans_v loans
495: WHERE loan_number=p_loan_number
496: GROUP BY fed_fund_code;

Line 802: CURSOR cur_award(p_loan_number igf_sl_dl_pnote_resp_all.loan_number%TYPE) IS

798: IF igf_sl_gen.chk_dl_plus(l_cur_loans.fed_fund_code) = 'TRUE' AND
799: l_dl_version = '2002-2003' THEN
800:
801: DECLARE
802: CURSOR cur_award(p_loan_number igf_sl_dl_pnote_resp_all.loan_number%TYPE) IS
803: SELECT NVL(loan_amt_offered,loan_amt_accepted) loan_amt FROM
804: igf_sl_loans_v WHERE
805: loan_number = TRIM(p_loan_number);
806:

Line 877: PROCEDURE update_resp_edit(p_dlpnr_id igf_sl_dl_pnote_resp_all.dlpnr_id%TYPE,p_status igf_sl_dl_pnote_resp_all.status%TYPE) IS

873: igs_ge_msg_stack.conc_exception_hndl;
874:
875: END process_ack;
876:
877: PROCEDURE update_resp_edit(p_dlpnr_id igf_sl_dl_pnote_resp_all.dlpnr_id%TYPE,p_status igf_sl_dl_pnote_resp_all.status%TYPE) IS
878:
879: CURSOR c_tbh_cur IS
880: SELECT resp.* FROM igf_sl_dl_pnote_resp resp
881: WHERE dlpnr_id = p_dlpnr_id

Line 880: SELECT resp.* FROM igf_sl_dl_pnote_resp resp

876:
877: PROCEDURE update_resp_edit(p_dlpnr_id igf_sl_dl_pnote_resp_all.dlpnr_id%TYPE,p_status igf_sl_dl_pnote_resp_all.status%TYPE) IS
878:
879: CURSOR c_tbh_cur IS
880: SELECT resp.* FROM igf_sl_dl_pnote_resp resp
881: WHERE dlpnr_id = p_dlpnr_id
882: FOR UPDATE NOWAIT;
883:
884: /*************************************************************

Line 899: igf_sl_dl_pnote_resp_pkg.update_row (

895: BEGIN
896:
897: FOR tbh_cur IN c_tbh_cur LOOP
898:
899: igf_sl_dl_pnote_resp_pkg.update_row (
900: x_mode => 'R',
901: x_rowid => tbh_cur.row_id,
902: x_dlpnr_id => tbh_cur.dlpnr_id,
903: x_dbth_id => tbh_cur.dbth_id,

Line 920: loaded_1rec igf_sl_dl_pnote_resp%ROWTYPE)

916:
917: END update_resp_edit;
918:
919: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE ,
920: loaded_1rec igf_sl_dl_pnote_resp%ROWTYPE)
921: AS
922: /***************************************************************
923: Created By : prchandr
924: Date Created By : 2000/12/07