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_CL_ORIG_ACK dependencies on IGF_SL_LOANS_ALL

Line 181: l_loan_number igf_sl_loans_all.loan_number%TYPE;

177: Format_1_rec igf_sl_load_file_t%ROWTYPE;
178: Format_1_rec_temp igf_sl_load_file_t%ROWTYPE;
179: loaded_1rec cur_resp1_records%ROWTYPE;
180: g_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
181: l_loan_number igf_sl_loans_all.loan_number%TYPE;
182: p_disb_title VARCHAR2(1000);
183: p_disb_under_line VARCHAR2(1000);
184:
185: TYPE tab_title IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;

Line 200: PROCEDURE insert_into_resp1(p_loan_number igf_sl_loans_all.loan_number%TYPE,

196:
197:
198: --Procedure Declarations
199:
200: PROCEDURE insert_into_resp1(p_loan_number igf_sl_loans_all.loan_number%TYPE,
201: p_resp_record_status igf_sl_cl_resp_r1_all.resp_record_status%TYPE,
202: p_rec_type_ind igf_sl_cl_resp_r1_all.rec_type_ind%TYPE);
203:
204: PROCEDURE process_1_records;

Line 207: p_loan_number igf_sl_loans_all.loan_number%TYPE,

203:
204: PROCEDURE process_1_records;
205:
206: PROCEDURE update_lor(p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,
207: p_loan_number igf_sl_loans_all.loan_number%TYPE,
208: p_rejected_rec BOOLEAN);
209:
210: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE);
211:

Line 210: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE);

206: PROCEDURE update_lor(p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,
207: p_loan_number igf_sl_loans_all.loan_number%TYPE,
208: p_rejected_rec BOOLEAN);
209:
210: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE);
211:
212: --
213: -- Declaration of a Procedure for inserting the @4 Records as per New DLD
214: --

Line 223: p_loan_id igf_sl_loans_all.loan_id%TYPE);

219: --
220: -- Procedure to show the difference in information bet OFA and File Details
221: --
222: PROCEDURE show_alt_details(p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,
223: p_loan_id igf_sl_loans_all.loan_id%TYPE);
224:
225: -- procedure for enabling statement level logging
226: PROCEDURE log_to_fnd ( p_v_module IN VARCHAR2,
227: p_v_string IN VARCHAR2

Line 274: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,

270: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,
271: p_v_person_number IN hz_parties.party_number%TYPE,
272: p_v_person_name IN hz_parties.party_name%TYPE,
273: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
274: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
275: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,
276: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,
277: p_v_loan_type IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
278: p_n_award_accept_amt IN igf_aw_award_all.accepted_amt%TYPE,

Line 275: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,

271: p_v_person_number IN hz_parties.party_number%TYPE,
272: p_v_person_name IN hz_parties.party_name%TYPE,
273: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
274: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
275: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,
276: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,
277: p_v_loan_type IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
278: p_n_award_accept_amt IN igf_aw_award_all.accepted_amt%TYPE,
279: p_n_guarantee_amt IN igf_sl_cl_resp_r1_all.guarantee_amt%TYPE,

Line 276: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,

272: p_v_person_name IN hz_parties.party_name%TYPE,
273: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
274: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
275: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,
276: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,
277: p_v_loan_type IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
278: p_n_award_accept_amt IN igf_aw_award_all.accepted_amt%TYPE,
279: p_n_guarantee_amt IN igf_sl_cl_resp_r1_all.guarantee_amt%TYPE,
280: p_n_approved_amt IN igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE

Line 292: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE);

288:
289: PROCEDURE insert_into_resp_r6(p_r6_record IN igf_sl_clchrs_dtls%ROWTYPE);
290:
291: PROCEDURE process_change_records (p_n_clrp1_id IN igf_sl_cl_resp_r1_all.clrp1_id%TYPE,
292: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE);
293:
294: PROCEDURE log_parameters ( p_v_param_typ IN VARCHAR2,
295: p_v_param_val IN VARCHAR2
296: ) ;

Line 570: l_loan_active igf_sl_loans_all.active%TYPE;

566: Change History :
567: Who When What
568: ***************************************************************/
569:
570: l_loan_active igf_sl_loans_all.active%TYPE;
571: l_resp_record_status igf_sl_cl_resp_r1_all.resp_record_status%TYPE;
572:
573: -- To select all the @1 Records from the Load Table
574: CURSOR cur_1records (p_file_type igf_sl_load_file_t.file_type%TYPE,

Line 586: FROM igf_sl_loans_all

582: CURSOR c_loan IS
583: SELECT active
584: ,loan_id
585: ,award_id
586: FROM igf_sl_loans_all
587: WHERE NVL(external_loan_id_txt,loan_number) = l_loan_number;
588:
589: rec_c_loan c_loan%ROWTYPE;
590:

Line 591: CURSOR c_igf_sl_lor (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS

587: WHERE NVL(external_loan_id_txt,loan_number) = l_loan_number;
588:
589: rec_c_loan c_loan%ROWTYPE;
590:
591: CURSOR c_igf_sl_lor (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
592: SELECT lor.rec_type_ind
593: FROM igf_sl_lor_all lor,
594: igf_sl_loans_all loan
595: WHERE loan.loan_id = lor.loan_id AND

Line 594: igf_sl_loans_all loan

590:
591: CURSOR c_igf_sl_lor (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
592: SELECT lor.rec_type_ind
593: FROM igf_sl_lor_all lor,
594: igf_sl_loans_all loan
595: WHERE loan.loan_id = lor.loan_id AND
596: NVL(loan.external_loan_id_txt,loan.loan_number) = cp_v_loan_number;
597:
598: rec_c_igf_sl_lor c_igf_sl_lor%ROWTYPE;

Line 1157: PROCEDURE insert_into_resp1(p_loan_number igf_sl_loans_all.loan_number%TYPE,

1153:
1154:
1155: /* Inserts Data into Resp1 ,Resp4 and Resp8 Tables*/
1156:
1157: PROCEDURE insert_into_resp1(p_loan_number igf_sl_loans_all.loan_number%TYPE,
1158: p_resp_record_status igf_sl_cl_resp_r1_all.resp_record_status%TYPE,
1159: p_rec_type_ind igf_sl_cl_resp_r1_all.rec_type_ind%TYPE)
1160: AS
1161: /***************************************************************

Line 2237: p_loan_number igf_sl_loans_all.loan_number%TYPE,

2233: END process_ack;
2234:
2235:
2236: PROCEDURE update_lor(p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,
2237: p_loan_number igf_sl_loans_all.loan_number%TYPE,
2238: p_rejected_rec BOOLEAN)
2239: AS
2240: /***************************************************************
2241: Created By : mesriniv

Line 2280: l_loan_status igf_sl_loans_all.loan_status%TYPE;

2276: ***************************************************************/
2277:
2278: l_row_id VARCHAR2(25);
2279: l_log_mesg VARCHAR2(1000);
2280: l_loan_status igf_sl_loans_all.loan_status%TYPE;
2281: lv_defer_req_code VARCHAR2(30);
2282: lv_s_signature_code VARCHAR2(30);
2283: lv_stud_sign_ind VARCHAR2(30);
2284: lv_log_mesg VARCHAR2(100);

Line 2295: WHERE loan_id IN (SELECT loan_id FROM igf_sl_loans_all

2291: CURSOR cur_tbh_lor
2292: IS
2293: SELECT *
2294: FROM igf_sl_lor_v
2295: WHERE loan_id IN (SELECT loan_id FROM igf_sl_loans_all
2296: WHERE NVL(external_loan_id_txt,loan_number) = p_loan_number);
2297:
2298: --
2299: -- Select the Loans Data for the particular Loan number

Line 2348: CURSOR c_igf_sl_loans (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS

2344: AND ci_sequence_number = p_seq_number;
2345:
2346: find_rel_code_rec cur_find_rel_code%ROWTYPE;
2347:
2348: CURSOR c_igf_sl_loans (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
2349: SELECT lar.loan_number
2350: ,lar.loan_status
2351: ,lar.loan_chg_status
2352: FROM igf_sl_loans_all lar

Line 2352: FROM igf_sl_loans_all lar

2348: CURSOR c_igf_sl_loans (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
2349: SELECT lar.loan_number
2350: ,lar.loan_status
2351: ,lar.loan_chg_status
2352: FROM igf_sl_loans_all lar
2353: WHERE NVL(external_loan_id_txt,loan_number) = cp_v_loan_number;
2354:
2355: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;
2356:

Line 3305: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE)

3301: app_exception.raise_exception;
3302:
3303: END update_lor;
3304:
3305: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE)
3306: AS
3307: /***************************************************************
3308: Created By : mesriniv
3309: Date Created By : 2000/12/07

Line 3992: l_loan_id igf_sl_loans_all.loan_id%TYPE;

3988: AS
3989:
3990:
3991: l_rowid VARCHAR2(25) DEFAULT NULL;
3992: l_loan_id igf_sl_loans_all.loan_id%TYPE;
3993: l_fed_stafford igf_sl_alt_borw.fed_stafford_loan_debt%TYPE;
3994: l_fed_sls igf_sl_alt_borw.fed_sls_debt%TYPE;
3995: rec_cl_resp_r4 igf_sl_cl_resp_r4_all%ROWTYPE;
3996: BEGIN --for the procedure insert_into_resp_r4

Line 4157: p_loan_id igf_sl_loans_all.loan_id%TYPE

4153: --OFA and that inserted into the igf_sl_cl_resp_r4 table
4154:
4155: PROCEDURE show_alt_details(
4156: p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,
4157: p_loan_id igf_sl_loans_all.loan_id%TYPE
4158: )
4159:
4160: /***************************************************************
4161: Created By : mesriniv

Line 6368: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,

6364: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,
6365: p_v_person_number IN hz_parties.party_number%TYPE,
6366: p_v_person_name IN hz_parties.party_name%TYPE,
6367: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
6368: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
6369: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,
6370: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,
6371: p_v_loan_type IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
6372: p_n_award_accept_amt IN igf_aw_award_all.accepted_amt%TYPE,

Line 6369: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,

6365: p_v_person_number IN hz_parties.party_number%TYPE,
6366: p_v_person_name IN hz_parties.party_name%TYPE,
6367: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
6368: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
6369: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,
6370: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,
6371: p_v_loan_type IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
6372: p_n_award_accept_amt IN igf_aw_award_all.accepted_amt%TYPE,
6373: p_n_guarantee_amt IN igf_sl_cl_resp_r1_all.guarantee_amt%TYPE,

Line 6370: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,

6366: p_v_person_name IN hz_parties.party_name%TYPE,
6367: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
6368: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
6369: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,
6370: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,
6371: p_v_loan_type IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
6372: p_n_award_accept_amt IN igf_aw_award_all.accepted_amt%TYPE,
6373: p_n_guarantee_amt IN igf_sl_cl_resp_r1_all.guarantee_amt%TYPE,
6374: p_n_approved_amt IN igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE

Line 6749: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE) AS

6745:
6746: END insert_into_resp_r6;
6747:
6748: PROCEDURE process_change_records (p_n_clrp1_id IN igf_sl_cl_resp_r1_all.clrp1_id%TYPE,
6749: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE) AS
6750: ------------------------------------------------------------------
6751: --Created by : Sanil Madathil, Oracle IDC
6752: --Date created: 07 November 2004
6753: --

Line 6766: CURSOR c_sl_clchsn_dtls (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS

6762: --
6763: --Change History:
6764: --Who When What
6765: ------------------------------------------------------------------
6766: CURSOR c_sl_clchsn_dtls (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
6767: --cp_v_send_record_txt igf_sl_clchsn_dtls.send_record_txt%TYPE)
6768: SELECT chdt.*, chdt.ROWID row_id
6769: FROM igf_sl_clchsn_dtls chdt
6770: WHERE loan_number_txt = cp_v_loan_number