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_CL_RESP_R1

Line 98: -- igf_sl_lor_pkg.update_row and igf_sl_cl_resp_r1

94: -- Refunds DLD 2144600
95: ---------------------------------------------------------------------------------
96: -- masehgal 17-Feb-2002 # 2216956 FACR007
97: -- Added Elec_mpn_ind,Borrow_sign_ind in
98: -- igf_sl_lor_pkg.update_row and igf_sl_cl_resp_r1
99: ---------------------------------------------------------------------------------
100: -- npalanis 11/jan/2002 The process Common Line Origination
101: -- Process( procedure place_holds_disb )
102: -- is modified to pick up disbursement

Line 167: CURSOR cur_resp1_records(p_cbth_id igf_sl_cl_resp_r1.cbth_id%TYPE,

163:
164:
165: -- Select the Records from Resp1 Table to process them
166:
167: CURSOR cur_resp1_records(p_cbth_id igf_sl_cl_resp_r1.cbth_id%TYPE,
168: p_rec_status igf_sl_cl_resp_r1.resp_record_status%TYPE )
169: IS
170: SELECT clrp1.* FROM igf_sl_cl_resp_r1 clrp1
171: WHERE clrp1.cbth_id = p_cbth_id

Line 168: p_rec_status igf_sl_cl_resp_r1.resp_record_status%TYPE )

164:
165: -- Select the Records from Resp1 Table to process them
166:
167: CURSOR cur_resp1_records(p_cbth_id igf_sl_cl_resp_r1.cbth_id%TYPE,
168: p_rec_status igf_sl_cl_resp_r1.resp_record_status%TYPE )
169: IS
170: SELECT clrp1.* FROM igf_sl_cl_resp_r1 clrp1
171: WHERE clrp1.cbth_id = p_cbth_id
172: AND clrp1.resp_record_status = p_rec_status

Line 170: SELECT clrp1.* FROM igf_sl_cl_resp_r1 clrp1

166:
167: CURSOR cur_resp1_records(p_cbth_id igf_sl_cl_resp_r1.cbth_id%TYPE,
168: p_rec_status igf_sl_cl_resp_r1.resp_record_status%TYPE )
169: IS
170: SELECT clrp1.* FROM igf_sl_cl_resp_r1 clrp1
171: WHERE clrp1.cbth_id = p_cbth_id
172: AND clrp1.resp_record_status = p_rec_status
173: ORDER BY clrp1.clrp1_id
174: FOR UPDATE OF resp_record_status NOWAIT;

Line 201: p_resp_record_status igf_sl_cl_resp_r1_all.resp_record_status%TYPE,

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;
205:

Line 202: p_rec_type_ind igf_sl_cl_resp_r1_all.rec_type_ind%TYPE);

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;
205:
206: PROCEDURE update_lor(p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,

Line 206: PROCEDURE update_lor(p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,

202: p_rec_type_ind igf_sl_cl_resp_r1_all.rec_type_ind%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);

Line 216: PROCEDURE insert_into_resp_r4(p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,

212: --
213: -- Declaration of a Procedure for inserting the @4 Records as per New DLD
214: --
215:
216: PROCEDURE insert_into_resp_r4(p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,
217: p_r4_record igf_sl_load_file_t.record_data%TYPE);
218:
219: --
220: -- Procedure to show the difference in information bet OFA and File Details

Line 222: PROCEDURE show_alt_details(p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,

218:
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,

Line 230: PROCEDURE process_borrow_stud_rec (p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE);

226: PROCEDURE log_to_fnd ( p_v_module IN VARCHAR2,
227: p_v_string IN VARCHAR2
228: );
229:
230: PROCEDURE process_borrow_stud_rec (p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE);
231:
232: PROCEDURE perform_ssn_match(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
233: p_c_pers_typ_ind IN VARCHAR2,
234: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,

Line 232: PROCEDURE perform_ssn_match(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,

228: );
229:
230: PROCEDURE process_borrow_stud_rec (p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE);
231:
232: PROCEDURE perform_ssn_match(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
233: p_c_pers_typ_ind IN VARCHAR2,
234: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,
235: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE,
236: p_c_pers_exists OUT NOCOPY BOOLEAN

Line 239: FUNCTION create_person_record(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,

235: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE,
236: p_c_pers_exists OUT NOCOPY BOOLEAN
237: ) ;
238:
239: FUNCTION create_person_record(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
240: p_c_pers_typ_ind IN VARCHAR2,
241: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,
242: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE
243: ) RETURN BOOLEAN ;

Line 247: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE

243: ) RETURN BOOLEAN ;
244:
245: FUNCTION create_person_addr_record(p_n_person_id IN hz_parties.party_id%TYPE,
246: p_v_person_number IN hz_parties.party_number%TYPE,
247: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE
248: ) RETURN BOOLEAN ;
249:
250: -- bvisvana - Bug # 4120082 - Telphone Number not created
251:

Line 253: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE

249:
250: -- bvisvana - Bug # 4120082 - Telphone Number not created
251:
252: FUNCTION create_person_telephone_record (p_n_person_id IN hz_parties.party_id%TYPE,
253: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE
254: ) RETURN BOOLEAN;
255:
256: FUNCTION create_borrow_stud_rel ( p_n_borrower_id IN hz_parties.party_id%TYPE,
257: p_v_borrower_number IN hz_parties.party_number%TYPE,

Line 262: PROCEDURE raise_scr_event ( p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,

258: p_n_student_id IN hz_parties.party_id%TYPE,
259: p_v_student_number IN hz_parties.party_number%TYPE
260: ) RETURN BOOLEAN;
261:
262: PROCEDURE raise_scr_event ( p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
263: p_c_borrow_created IN VARCHAR2,
264: p_c_student_created IN VARCHAR2,
265: p_c_rel_created IN VARCHAR2
266: );

Line 279: p_n_guarantee_amt IN igf_sl_cl_resp_r1_all.guarantee_amt%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
281: );
282:
283: PROCEDURE insert_into_resp_r2(p_r2_record IN igf_sl_cl_resp_r2_dtls%ROWTYPE);

Line 280: p_n_approved_amt IN igf_sl_cl_resp_r1_all.alt_approved_amt%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
281: );
282:
283: PROCEDURE insert_into_resp_r2(p_r2_record IN igf_sl_cl_resp_r2_dtls%ROWTYPE);
284:

Line 291: PROCEDURE process_change_records (p_n_clrp1_id IN igf_sl_cl_resp_r1_all.clrp1_id%TYPE,

287: PROCEDURE insert_into_resp_r7(p_r7_record IN igf_sl_cl_resp_r7_dtls%ROWTYPE);
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

Line 563: the tables IGF_SL_CL_RESP_R1 and IGF_SL_CL_RESP_R8

559: Created By : mesriniv
560: Date Created By : 2000/12/07
561: Purpose : To Call Respective procedures which
562: will insert the format file(@1 and @8) data into
563: the tables IGF_SL_CL_RESP_R1 and IGF_SL_CL_RESP_R8
564: tables correspondingly.
565: Known Limitations,Enhancements or Remarks
566: Change History :
567: Who When What

Line 571: l_resp_record_status igf_sl_cl_resp_r1_all.resp_record_status%TYPE;

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,
575: p_record_data igf_sl_load_file_t.record_data%TYPE)

Line 641: rec_scr_sl_resp igf_sl_cl_resp_r1_all%ROWTYPE;

637: rec_c_igf_aw_award_v c_igf_aw_award_v%ROWTYPE;
638:
639: l_v_cl_file_type igf_sl_cl_file_type.cl_file_type%TYPE;
640: e_skip EXCEPTION;
641: rec_scr_sl_resp igf_sl_cl_resp_r1_all%ROWTYPE;
642: l_v_rec_type_ind igf_sl_lor_all.rec_type_ind%TYPE;
643: l_n_award_id igf_aw_award_all.award_id%TYPE;
644: l_n_resp_guarantee_amt igf_sl_cl_resp_r1_all.guarantee_amt%TYPE;
645: l_n_resp_fls_approved_amt igf_sl_cl_resp_r1_all.fls_approved_amt%TYPE;

Line 644: l_n_resp_guarantee_amt igf_sl_cl_resp_r1_all.guarantee_amt%TYPE;

640: e_skip EXCEPTION;
641: rec_scr_sl_resp igf_sl_cl_resp_r1_all%ROWTYPE;
642: l_v_rec_type_ind igf_sl_lor_all.rec_type_ind%TYPE;
643: l_n_award_id igf_aw_award_all.award_id%TYPE;
644: l_n_resp_guarantee_amt igf_sl_cl_resp_r1_all.guarantee_amt%TYPE;
645: l_n_resp_fls_approved_amt igf_sl_cl_resp_r1_all.fls_approved_amt%TYPE;
646: l_n_resp_flu_approved_amt igf_sl_cl_resp_r1_all.flu_approved_amt%TYPE;
647: l_n_resp_flp_approved_amt igf_sl_cl_resp_r1_all.flp_approved_amt%TYPE;
648: l_n_resp_alt_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;

Line 645: l_n_resp_fls_approved_amt igf_sl_cl_resp_r1_all.fls_approved_amt%TYPE;

641: rec_scr_sl_resp igf_sl_cl_resp_r1_all%ROWTYPE;
642: l_v_rec_type_ind igf_sl_lor_all.rec_type_ind%TYPE;
643: l_n_award_id igf_aw_award_all.award_id%TYPE;
644: l_n_resp_guarantee_amt igf_sl_cl_resp_r1_all.guarantee_amt%TYPE;
645: l_n_resp_fls_approved_amt igf_sl_cl_resp_r1_all.fls_approved_amt%TYPE;
646: l_n_resp_flu_approved_amt igf_sl_cl_resp_r1_all.flu_approved_amt%TYPE;
647: l_n_resp_flp_approved_amt igf_sl_cl_resp_r1_all.flp_approved_amt%TYPE;
648: l_n_resp_alt_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;
649: l_n_resp_actual_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;

Line 646: l_n_resp_flu_approved_amt igf_sl_cl_resp_r1_all.flu_approved_amt%TYPE;

642: l_v_rec_type_ind igf_sl_lor_all.rec_type_ind%TYPE;
643: l_n_award_id igf_aw_award_all.award_id%TYPE;
644: l_n_resp_guarantee_amt igf_sl_cl_resp_r1_all.guarantee_amt%TYPE;
645: l_n_resp_fls_approved_amt igf_sl_cl_resp_r1_all.fls_approved_amt%TYPE;
646: l_n_resp_flu_approved_amt igf_sl_cl_resp_r1_all.flu_approved_amt%TYPE;
647: l_n_resp_flp_approved_amt igf_sl_cl_resp_r1_all.flp_approved_amt%TYPE;
648: l_n_resp_alt_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;
649: l_n_resp_actual_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;
650: l_d_loan_per_begin_date igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;

Line 647: l_n_resp_flp_approved_amt igf_sl_cl_resp_r1_all.flp_approved_amt%TYPE;

643: l_n_award_id igf_aw_award_all.award_id%TYPE;
644: l_n_resp_guarantee_amt igf_sl_cl_resp_r1_all.guarantee_amt%TYPE;
645: l_n_resp_fls_approved_amt igf_sl_cl_resp_r1_all.fls_approved_amt%TYPE;
646: l_n_resp_flu_approved_amt igf_sl_cl_resp_r1_all.flu_approved_amt%TYPE;
647: l_n_resp_flp_approved_amt igf_sl_cl_resp_r1_all.flp_approved_amt%TYPE;
648: l_n_resp_alt_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;
649: l_n_resp_actual_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;
650: l_d_loan_per_begin_date igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;
651: l_d_loan_per_end_date igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;

Line 648: l_n_resp_alt_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;

644: l_n_resp_guarantee_amt igf_sl_cl_resp_r1_all.guarantee_amt%TYPE;
645: l_n_resp_fls_approved_amt igf_sl_cl_resp_r1_all.fls_approved_amt%TYPE;
646: l_n_resp_flu_approved_amt igf_sl_cl_resp_r1_all.flu_approved_amt%TYPE;
647: l_n_resp_flp_approved_amt igf_sl_cl_resp_r1_all.flp_approved_amt%TYPE;
648: l_n_resp_alt_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;
649: l_n_resp_actual_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;
650: l_d_loan_per_begin_date igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;
651: l_d_loan_per_end_date igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;
652: lv_resp_prc_type VARCHAR2(30);

Line 649: l_n_resp_actual_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;

645: l_n_resp_fls_approved_amt igf_sl_cl_resp_r1_all.fls_approved_amt%TYPE;
646: l_n_resp_flu_approved_amt igf_sl_cl_resp_r1_all.flu_approved_amt%TYPE;
647: l_n_resp_flp_approved_amt igf_sl_cl_resp_r1_all.flp_approved_amt%TYPE;
648: l_n_resp_alt_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;
649: l_n_resp_actual_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;
650: l_d_loan_per_begin_date igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;
651: l_d_loan_per_end_date igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;
652: lv_resp_prc_type VARCHAR2(30);
653: lv_resp_rec_type VARCHAR2(30);

Line 650: l_d_loan_per_begin_date igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;

646: l_n_resp_flu_approved_amt igf_sl_cl_resp_r1_all.flu_approved_amt%TYPE;
647: l_n_resp_flp_approved_amt igf_sl_cl_resp_r1_all.flp_approved_amt%TYPE;
648: l_n_resp_alt_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;
649: l_n_resp_actual_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;
650: l_d_loan_per_begin_date igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;
651: l_d_loan_per_end_date igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;
652: lv_resp_prc_type VARCHAR2(30);
653: lv_resp_rec_type VARCHAR2(30);
654: lv_sys_loan_version VARCHAR2(30);

Line 651: l_d_loan_per_end_date igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;

647: l_n_resp_flp_approved_amt igf_sl_cl_resp_r1_all.flp_approved_amt%TYPE;
648: l_n_resp_alt_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;
649: l_n_resp_actual_approved_amt igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE;
650: l_d_loan_per_begin_date igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;
651: l_d_loan_per_end_date igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;
652: lv_resp_prc_type VARCHAR2(30);
653: lv_resp_rec_type VARCHAR2(30);
654: lv_sys_loan_version VARCHAR2(30);
655: lv_fed_appl_form_code VARCHAR2(30);

Line 1158: p_resp_record_status igf_sl_cl_resp_r1_all.resp_record_status%TYPE,

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: /***************************************************************
1162: Created By : mesriniv

Line 1159: p_rec_type_ind igf_sl_cl_resp_r1_all.rec_type_ind%TYPE)

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: /***************************************************************
1162: Created By : mesriniv
1163: Date Created By : 2000/12/07

Line 1164: Purpose : To Insert File data into IGF_SL_CL_RESP_R1

1160: AS
1161: /***************************************************************
1162: Created By : mesriniv
1163: Date Created By : 2000/12/07
1164: Purpose : To Insert File data into IGF_SL_CL_RESP_R1
1165: and IGF_SL_CL_RESP_R8 tables
1166: Known Limitations,Enhancements or Remarks
1167: Change History :
1168: Who When What

Line 1175: l_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;

1171: ***************************************************************/
1172:
1173:
1174: l_ind NUMBER;
1175: l_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
1176: l_row_id VARCHAR2(25);
1177: l_start_guar_pos NUMBER;
1178: l_start_orig_pos NUMBER;
1179:

Line 1212: rec_cl_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;

1208:
1209: TYPE r8_tab_type IS TABLE OF r8_rec%TYPE INDEX BY BINARY_INTEGER;
1210: r8_tab r8_tab_type;
1211:
1212: rec_cl_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
1213:
1214: TYPE tab_resp_r2 IS TABLE OF igf_sl_cl_resp_r2_dtls%ROWTYPE INDEX BY BINARY_INTEGER;
1215: v_tab_resp_r2 tab_resp_r2;
1216: TYPE tab_resp_r3 IS TABLE OF igf_sl_cl_resp_r3_dtls%ROWTYPE INDEX BY BINARY_INTEGER;

Line 1411: p_v_string => 'Invoking igf_sl_cl_resp_r1_pkg.insert_row'

1407: END IF;
1408:
1409: gv_debug_str := 'INSERT_INTO_RESP1 - 1' ||' ';
1410: log_to_fnd(p_v_module => 'insert_into_resp_r1',
1411: p_v_string => 'Invoking igf_sl_cl_resp_r1_pkg.insert_row'
1412: );
1413:
1414: igf_sl_cl_resp_r1_pkg.insert_row (
1415: x_mode => 'R' ,

Line 1414: igf_sl_cl_resp_r1_pkg.insert_row (

1410: log_to_fnd(p_v_module => 'insert_into_resp_r1',
1411: p_v_string => 'Invoking igf_sl_cl_resp_r1_pkg.insert_row'
1412: );
1413:
1414: igf_sl_cl_resp_r1_pkg.insert_row (
1415: x_mode => 'R' ,
1416: x_rowid => l_row_id ,
1417: x_clrp1_id => l_clrp1_id ,
1418: x_cbth_id => g_cbth_id ,

Line 1895: Added Elec_mpn_ind , Borrow_sign_ind in igf_sl_cl_resp_r1

1891: Known Limitations,Enhancements or Remarks
1892: Change History :
1893: Who When What
1894: masehgal 17-Feb-2002 # 2216956 FACR007
1895: Added Elec_mpn_ind , Borrow_sign_ind in igf_sl_cl_resp_r1
1896: ***************************************************************/
1897: l_msg NUMBER;
1898: l_mesg VARCHAR2(100);
1899: l_rowid VARCHAR2(25);

Line 1904: TYPE t_message IS TABLE OF igf_sl_cl_resp_r1_all.err_mesg_2%TYPE

1900: l_index NUMBER;
1901: lb_rejected_rec BOOLEAN;
1902: -- Array to maintain the Error Messages
1903:
1904: TYPE t_message IS TABLE OF igf_sl_cl_resp_r1_all.err_mesg_2%TYPE
1905: INDEX BY BINARY_INTEGER;
1906:
1907: err_mesg_array t_message;
1908:

Line 2059: igf_sl_cl_resp_r1_pkg.update_row (

2055: -- Update the all the Response Record Status to 'Y'
2056: -- to indicate the Records have been processed for this Batch Id
2057: --
2058:
2059: igf_sl_cl_resp_r1_pkg.update_row (
2060: X_Mode => 'R',
2061: x_rowid => loaded_1rec.row_id,
2062: x_clrp1_id => loaded_1rec.clrp1_id,
2063: x_cbth_id => loaded_1rec.cbth_id,

Line 2236: PROCEDURE update_lor(p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,

2232:
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: /***************************************************************

Line 3973: PROCEDURE insert_into_resp_r4(p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,

3969:
3970:
3971: --Procedure Definition for Inserting into igf_sl_resp_r4 w.r.to new DLD
3972:
3973: PROCEDURE insert_into_resp_r4(p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,
3974: p_r4_record igf_sl_load_file_t.record_data%TYPE)
3975:
3976: /***************************************************************
3977: Created By : mesriniv

Line 4156: p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,

4152: --Procedure declared and defined here to display the difference in the Alternate Borrower Information between
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: /***************************************************************

Line 4372: PROCEDURE process_borrow_stud_rec (p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE) AS

4368: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig_ack.'||p_v_module, p_v_string);
4369: END IF;
4370: END log_to_fnd;
4371:
4372: PROCEDURE process_borrow_stud_rec (p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE) AS
4373: ------------------------------------------------------------------
4374: --Created by : Sanil Madathil, Oracle IDC
4375: --Date created: 05 November 2004
4376: --

Line 4390: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;

4386: --
4387: --Change History:
4388: --Who When What
4389: ------------------------------------------------------------------
4390: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
4391: l_b_pers_exists BOOLEAN;
4392: l_b_ret_status BOOLEAN;
4393: l_c_borrow_created VARCHAR2(1);
4394: l_c_student_created VARCHAR2(1);

Line 4792: PROCEDURE perform_ssn_match(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,

4788:
4789: END process_borrow_stud_rec;
4790:
4791:
4792: PROCEDURE perform_ssn_match(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
4793: p_c_pers_typ_ind IN VARCHAR2,
4794: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,
4795: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE,
4796: p_c_pers_exists OUT NOCOPY BOOLEAN

Line 4976: FUNCTION create_person_record(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,

4972: END LOOP;
4973:
4974: END perform_ssn_match;
4975:
4976: FUNCTION create_person_record(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
4977: p_c_pers_typ_ind IN VARCHAR2,
4978: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,
4979: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE
4980: )

Line 5014: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;

5010: l_n_person_id hz_parties.party_id%TYPE;
5011: l_v_person_number hz_parties.party_number%TYPE;
5012: l_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
5013: l_n_location_ovn hz_locations.object_version_number%TYPE;
5014: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
5015: l_v_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE;
5016: l_v_person_first_name hz_parties.person_first_name%TYPE;
5017: l_v_person_last_name hz_parties.person_last_name%TYPE;
5018: l_v_person_middle_name hz_parties.person_middle_name%TYPE;

Line 5203: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE

5199: END create_person_record;
5200:
5201: FUNCTION create_person_addr_record(p_n_person_id IN hz_parties.party_id%TYPE,
5202: p_v_person_number IN hz_parties.party_number%TYPE,
5203: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE
5204: ) RETURN BOOLEAN AS
5205: ------------------------------------------------------------------
5206: --Created by : Sanil Madathil, Oracle IDC
5207: --Date created: 21 October 2004

Line 5243: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;

5239: l_v_permt_addr2 igs_pe_person_addr.addr_line_2%TYPE;
5240: l_v_permt_city hz_parties.city%TYPE;
5241: l_v_permt_state hz_parties.state%TYPE;
5242: l_v_postal_code igs_pe_person_addr.postal_code%TYPE;
5243: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
5244: BEGIN
5245: log_to_fnd(p_v_module => 'create_person_addr_record',
5246: p_v_string => ' p_rec_resp_r1.b_ssn : ' || p_rec_resp_r1.b_ssn ||
5247: ' p_rec_resp_r1.b_last_name : ' || p_rec_resp_r1.b_last_name ||

Line 5397: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE

5393: RETURN TRUE;
5394: END create_person_addr_record;
5395:
5396: FUNCTION create_person_telephone_record (p_n_person_id IN hz_parties.party_id%TYPE,
5397: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE
5398: ) RETURN BOOLEAN AS
5399: ------------------------------------------------------------------
5400: --Created by : bvisvana, Oracle IDC
5401: --Date created: 29 July 2005

Line 5658: PROCEDURE raise_scr_event ( p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,

5654: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.prepare_scr_message.debug','sqlerrm ' || SQLERRM);
5655: END IF;
5656: END prepare_scr_message;
5657:
5658: PROCEDURE raise_scr_event ( p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
5659: p_c_borrow_created IN VARCHAR2,
5660: p_c_student_created IN VARCHAR2,
5661: p_c_rel_created IN VARCHAR2
5662: ) AS

Line 5690: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;

5686: l_wf_parameter_list_t wf_parameter_list_t;
5687: l_wf_event_name VARCHAR2(255);
5688: l_wf_event_key NUMBER;
5689: l_v_role fnd_user.user_name%TYPE;
5690: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
5691: BEGIN
5692: log_to_fnd(p_v_module => 'raise_scr_event',
5693: p_v_string => ' p_rec_resp_r1.loan_number : ' ||p_rec_resp_r1.loan_number ||
5694: ' p_c_borrow_created : ' ||p_c_borrow_created ||

Line 6373: p_n_guarantee_amt IN igf_sl_cl_resp_r1_all.guarantee_amt%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
6375: ) AS
6376: ------------------------------------------------------------------
6377: --Created by : Sanil Madathil, Oracle IDC

Line 6374: p_n_approved_amt IN igf_sl_cl_resp_r1_all.alt_approved_amt%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
6375: ) AS
6376: ------------------------------------------------------------------
6377: --Created by : Sanil Madathil, Oracle IDC
6378: --Date created: 04 November 2004

Line 6567: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;

6563: --Who When What
6564: ------------------------------------------------------------------
6565: l_v_rowid ROWID;
6566: l_n_clresp2_id igf_sl_cl_resp_r2_dtls.clresp2_id%TYPE;
6567: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
6568: rec_cl_resp_r2 igf_sl_cl_resp_r2_dtls%ROWTYPE;
6569:
6570: BEGIN
6571: l_v_rowid := NULL;

Line 6614: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;

6610: --Who When What
6611: ------------------------------------------------------------------
6612: l_v_rowid ROWID;
6613: l_n_clresp3_id igf_sl_cl_resp_r3_dtls.clresp3_id%TYPE;
6614: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
6615: rec_cl_resp_r3 igf_sl_cl_resp_r3_dtls%ROWTYPE;
6616:
6617: BEGIN
6618: l_v_rowid := NULL;

Line 6662: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;

6658: --Who When What
6659: ------------------------------------------------------------------
6660: l_v_rowid ROWID;
6661: l_n_clresp7_id igf_sl_cl_resp_r7_dtls.clresp7_id%TYPE;
6662: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
6663: rec_cl_resp_r7 igf_sl_cl_resp_r7_dtls%ROWTYPE;
6664:
6665: BEGIN
6666: l_v_rowid := NULL;

Line 6717: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;

6713: --Who When What
6714: ------------------------------------------------------------------
6715: l_v_rowid ROWID;
6716: rec_cl_resp_r6 igf_sl_clchrs_dtls%ROWTYPE;
6717: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
6718: l_n_clchgrsp_id igf_sl_clchrs_dtls.clchgrsp_id%TYPE;
6719:
6720: BEGIN
6721: l_v_rowid := NULL;

Line 6748: PROCEDURE process_change_records (p_n_clrp1_id IN igf_sl_cl_resp_r1_all.clrp1_id%TYPE,

6744:
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

Line 6775: CURSOR c_sl_clchrs_dtls (cp_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,

6771: AND chdt.status_code = 'S';
6772:
6773: rec_c_sl_clchsn_dtls c_sl_clchsn_dtls%ROWTYPE;
6774:
6775: CURSOR c_sl_clchrs_dtls (cp_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,
6776: cp_v_send_record_txt igf_sl_clchrs_dtls.send_record_txt%TYPE) IS
6777: SELECT chrsdtls.*
6778: FROM igf_sl_clchrs_dtls chrsdtls
6779: WHERE chrsdtls.clrp1_id = cp_n_clrp1_id

Line 6784: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;

6780: AND send_record_txt = TRIM(cp_v_send_record_txt);
6781:
6782: rec_c_sl_clchrs_dtls c_sl_clchrs_dtls%ROWTYPE;
6783:
6784: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
6785: l_v_response_status_code igf_sl_clchsn_dtls.response_status_code%TYPE;
6786: l_v_status_code igf_sl_clchsn_dtls.status_code%TYPE;
6787: e_skip_change_rec EXCEPTION;
6788: BEGIN