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 FND_DATE

Line 439: l_file_creation_date := fnd_date.string_to_date(LTRIM(RTRIM(SUBSTR(Header_rec.record_data,23,14))),'YYYYMMDDHH24MISS');

435: fnd_file.put_line(fnd_file.log, fnd_message.get);
436:
437: g_loaded_batch_id := LTRIM(RTRIM(SUBSTR(header_rec.record_data, 11,12)));
438: gv_debug_str := gv_debug_str || 'CL_LOAD_FILE - 7' ||' ';
439: l_file_creation_date := fnd_date.string_to_date(LTRIM(RTRIM(SUBSTR(Header_rec.record_data,23,14))),'YYYYMMDDHH24MISS');
440: gv_debug_str := gv_debug_str || 'CL_LOAD_FILE - 8' ||' ';
441: l_file_trans_date := fnd_date.string_to_date(LTRIM(RTRIM(SUBSTR(Header_rec.record_data,37,14))),'YYYYMMDDHH24MISS');
442: gv_debug_str := gv_debug_str || 'CL_LOAD_FILE - 8a' ||' ';
443: g_loaded_file_ident_code := LTRIM(RTRIM(SUBSTR(Header_rec.record_data,70,5)));

Line 441: l_file_trans_date := fnd_date.string_to_date(LTRIM(RTRIM(SUBSTR(Header_rec.record_data,37,14))),'YYYYMMDDHH24MISS');

437: g_loaded_batch_id := LTRIM(RTRIM(SUBSTR(header_rec.record_data, 11,12)));
438: gv_debug_str := gv_debug_str || 'CL_LOAD_FILE - 7' ||' ';
439: l_file_creation_date := fnd_date.string_to_date(LTRIM(RTRIM(SUBSTR(Header_rec.record_data,23,14))),'YYYYMMDDHH24MISS');
440: gv_debug_str := gv_debug_str || 'CL_LOAD_FILE - 8' ||' ';
441: l_file_trans_date := fnd_date.string_to_date(LTRIM(RTRIM(SUBSTR(Header_rec.record_data,37,14))),'YYYYMMDDHH24MISS');
442: gv_debug_str := gv_debug_str || 'CL_LOAD_FILE - 8a' ||' ';
443: g_loaded_file_ident_code := LTRIM(RTRIM(SUBSTR(Header_rec.record_data,70,5)));
444: g_loaded_recipient_id := LTRIM(RTRIM(SUBSTR(header_rec.record_data,107,8)));
445: g_loaded_recip_non_ed_brc_id := LTRIM(RTRIM(SUBSTR(header_rec.record_data,117,4)));

Line 966: rec_scr_sl_resp.b_date_of_birth := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,180,8),'YYYYMMDD');

962: rec_scr_sl_resp.b_permt_state := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,159,2)));
963: rec_scr_sl_resp.b_permt_zip := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,161,5))));
964: rec_scr_sl_resp.b_permt_zip_suffix := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,166,4))));
965: rec_scr_sl_resp.b_permt_phone := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,170,10)));
966: rec_scr_sl_resp.b_date_of_birth := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,180,8),'YYYYMMDD');
967: rec_scr_sl_resp.cl_loan_type := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,188,2)));
968: rec_scr_sl_resp.req_loan_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,190,6))));
969: rec_scr_sl_resp.defer_req_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,196,1)));
970: rec_scr_sl_resp.borw_interest_ind := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,197,1)));

Line 973: rec_scr_sl_resp.b_signature_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,200,8),'YYYYMMDD');

969: rec_scr_sl_resp.defer_req_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,196,1)));
970: rec_scr_sl_resp.borw_interest_ind := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,197,1)));
971: rec_scr_sl_resp.eft_auth_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,198,1)));
972: rec_scr_sl_resp.b_signature_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,199,1)));
973: rec_scr_sl_resp.b_signature_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,200,8),'YYYYMMDD');
974: rec_scr_sl_resp.loan_number := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,208,17)));
975: rec_scr_sl_resp.b_citizenship_status := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,228,1)));
976: rec_scr_sl_resp.b_state_of_legal_res := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,229,2)));
977: rec_scr_sl_resp.b_legal_res_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,231,6)||'01','YYYYMMDD');

Line 977: rec_scr_sl_resp.b_legal_res_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,231,6)||'01','YYYYMMDD');

973: rec_scr_sl_resp.b_signature_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,200,8),'YYYYMMDD');
974: rec_scr_sl_resp.loan_number := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,208,17)));
975: rec_scr_sl_resp.b_citizenship_status := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,228,1)));
976: rec_scr_sl_resp.b_state_of_legal_res := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,229,2)));
977: rec_scr_sl_resp.b_legal_res_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,231,6)||'01','YYYYMMDD');
978: rec_scr_sl_resp.b_default_status := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,237,1)));
979: rec_scr_sl_resp.b_outstd_loan_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,238,1)));
980: rec_scr_sl_resp.b_indicator_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,239,1)));
981: rec_scr_sl_resp.s_last_name := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,259,35)));

Line 985: rec_scr_sl_resp.s_date_of_birth := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,316,8),'YYYYMMDD');

981: rec_scr_sl_resp.s_last_name := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,259,35)));
982: rec_scr_sl_resp.s_first_name := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,294,12)));
983: rec_scr_sl_resp.s_middle_name := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,306,1)));
984: rec_scr_sl_resp.s_ssn := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,307,9))));
985: rec_scr_sl_resp.s_date_of_birth := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,316,8),'YYYYMMDD');
986: rec_scr_sl_resp.s_citizenship_status := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,324,1)));
987: rec_scr_sl_resp.s_default_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,325,1)));
988: rec_scr_sl_resp.s_signature_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,326,1)));
989: rec_scr_sl_resp.school_id := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,347,8))));

Line 990: rec_scr_sl_resp.loan_per_begin_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,357,8),'YYYYMMDD');

986: rec_scr_sl_resp.s_citizenship_status := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,324,1)));
987: rec_scr_sl_resp.s_default_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,325,1)));
988: rec_scr_sl_resp.s_signature_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,326,1)));
989: rec_scr_sl_resp.school_id := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,347,8))));
990: rec_scr_sl_resp.loan_per_begin_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,357,8),'YYYYMMDD');
991: rec_scr_sl_resp.loan_per_end_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,365,8),'YYYYMMDD');
992: rec_scr_sl_resp.alt_appl_ver_code := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,443,4))));
993: rec_scr_sl_resp.lender_id := SUBSTR(Format_1_rec.record_data,458,6);
994: rec_scr_sl_resp.guarantor_id := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,507,3)));

Line 991: rec_scr_sl_resp.loan_per_end_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,365,8),'YYYYMMDD');

987: rec_scr_sl_resp.s_default_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,325,1)));
988: rec_scr_sl_resp.s_signature_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,326,1)));
989: rec_scr_sl_resp.school_id := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,347,8))));
990: rec_scr_sl_resp.loan_per_begin_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,357,8),'YYYYMMDD');
991: rec_scr_sl_resp.loan_per_end_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,365,8),'YYYYMMDD');
992: rec_scr_sl_resp.alt_appl_ver_code := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,443,4))));
993: rec_scr_sl_resp.lender_id := SUBSTR(Format_1_rec.record_data,458,6);
994: rec_scr_sl_resp.guarantor_id := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,507,3)));
995: rec_scr_sl_resp.fed_appl_form_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,510,1)));

Line 1004: rec_scr_sl_resp.b_permt_addr_chg_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,899,8),'YYYYMMDD');

1000: rec_scr_sl_resp.b_foreign_postal_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,766,14)));
1001: rec_scr_sl_resp.lend_non_ed_brc_id := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,781,4)));
1002: rec_scr_sl_resp.lender_use_txt := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,785,20)));
1003: rec_scr_sl_resp.guarantor_use_txt := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,876,23)));
1004: rec_scr_sl_resp.b_permt_addr_chg_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,899,8),'YYYYMMDD');
1005: rec_scr_sl_resp.alt_prog_type_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,907,3)));
1006: rec_scr_sl_resp.prc_type_code := lv_resp_prc_type;
1007: -- bvisvana - FA 161 - Bug # 5006583
1008: rec_scr_sl_resp.esign_src_typ_cd := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,449,9)));

Line 1035: rec_scr_sl_resp.guarnt_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1000,14),'YYYYMMDDHH24MISS');

1031: rec_scr_sl_resp.guarnt_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,992,2)));
1032: rec_scr_sl_resp.lender_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,994,2)));
1033: rec_scr_sl_resp.pnote_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,996,2)));
1034: rec_scr_sl_resp.credit_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,998,2)));
1035: rec_scr_sl_resp.guarnt_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1000,14),'YYYYMMDDHH24MISS');
1036: rec_scr_sl_resp.lender_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1014,14),'YYYYMMDDHH24MISS');
1037: rec_scr_sl_resp.pnote_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1028,14),'YYYYMMDDHH24MISS');
1038: rec_scr_sl_resp.credit_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1042,14),'YYYYMMDDHH24MISS');
1039: rec_scr_sl_resp.act_serial_loan_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1056,1)));

Line 1036: rec_scr_sl_resp.lender_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1014,14),'YYYYMMDDHH24MISS');

1032: rec_scr_sl_resp.lender_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,994,2)));
1033: rec_scr_sl_resp.pnote_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,996,2)));
1034: rec_scr_sl_resp.credit_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,998,2)));
1035: rec_scr_sl_resp.guarnt_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1000,14),'YYYYMMDDHH24MISS');
1036: rec_scr_sl_resp.lender_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1014,14),'YYYYMMDDHH24MISS');
1037: rec_scr_sl_resp.pnote_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1028,14),'YYYYMMDDHH24MISS');
1038: rec_scr_sl_resp.credit_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1042,14),'YYYYMMDDHH24MISS');
1039: rec_scr_sl_resp.act_serial_loan_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1056,1)));
1040: rec_scr_sl_resp.sch_non_ed_brc_id := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1090,4)));

Line 1037: rec_scr_sl_resp.pnote_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1028,14),'YYYYMMDDHH24MISS');

1033: rec_scr_sl_resp.pnote_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,996,2)));
1034: rec_scr_sl_resp.credit_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,998,2)));
1035: rec_scr_sl_resp.guarnt_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1000,14),'YYYYMMDDHH24MISS');
1036: rec_scr_sl_resp.lender_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1014,14),'YYYYMMDDHH24MISS');
1037: rec_scr_sl_resp.pnote_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1028,14),'YYYYMMDDHH24MISS');
1038: rec_scr_sl_resp.credit_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1042,14),'YYYYMMDDHH24MISS');
1039: rec_scr_sl_resp.act_serial_loan_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1056,1)));
1040: rec_scr_sl_resp.sch_non_ed_brc_id := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1090,4)));
1041: rec_scr_sl_resp.mpn_confirm_ind := NULL;

Line 1038: rec_scr_sl_resp.credit_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1042,14),'YYYYMMDDHH24MISS');

1034: rec_scr_sl_resp.credit_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,998,2)));
1035: rec_scr_sl_resp.guarnt_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1000,14),'YYYYMMDDHH24MISS');
1036: rec_scr_sl_resp.lender_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1014,14),'YYYYMMDDHH24MISS');
1037: rec_scr_sl_resp.pnote_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1028,14),'YYYYMMDDHH24MISS');
1038: rec_scr_sl_resp.credit_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1042,14),'YYYYMMDDHH24MISS');
1039: rec_scr_sl_resp.act_serial_loan_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1056,1)));
1040: rec_scr_sl_resp.sch_non_ed_brc_id := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1090,4)));
1041: rec_scr_sl_resp.mpn_confirm_ind := NULL;
1042: rec_scr_sl_resp.borr_credit_auth_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,227,1)));

Line 1083: l_d_loan_per_begin_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,357,8),'YYYYMMDD');

1079: l_n_resp_fls_approved_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,464,5))));
1080: l_n_resp_flu_approved_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,469,5))));
1081: l_n_resp_flp_approved_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,474,5))));
1082: l_n_resp_alt_approved_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,488,5))));
1083: l_d_loan_per_begin_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,357,8),'YYYYMMDD');
1084: l_d_loan_per_end_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,365,8),'YYYYMMDD');
1085: --MN 11-Jan-2005 Get Actual Approved Amount based on fed und code and validate that against the Award Accepted Amount
1086: IF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'FLS' THEN
1087: l_n_resp_actual_approved_amt := l_n_resp_fls_approved_amt;

Line 1084: l_d_loan_per_end_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,365,8),'YYYYMMDD');

1080: l_n_resp_flu_approved_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,469,5))));
1081: l_n_resp_flp_approved_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,474,5))));
1082: l_n_resp_alt_approved_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,488,5))));
1083: l_d_loan_per_begin_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,357,8),'YYYYMMDD');
1084: l_d_loan_per_end_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,365,8),'YYYYMMDD');
1085: --MN 11-Jan-2005 Get Actual Approved Amount based on fed und code and validate that against the Award Accepted Amount
1086: IF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'FLS' THEN
1087: l_n_resp_actual_approved_amt := l_n_resp_fls_approved_amt;
1088: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'FLU' THEN

Line 1245: rec_cl_resp_r1.b_date_of_birth := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,180,8),'YYYYMMDD');

1241: rec_cl_resp_r1.b_permt_state := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,159,2)));
1242: rec_cl_resp_r1.b_permt_zip := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,161,5))));
1243: rec_cl_resp_r1.b_permt_zip_suffix := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,166,4))));
1244: rec_cl_resp_r1.b_permt_phone := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,170,10)));
1245: rec_cl_resp_r1.b_date_of_birth := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,180,8),'YYYYMMDD');
1246: rec_cl_resp_r1.cl_loan_type := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,188,2)));
1247: rec_cl_resp_r1.req_loan_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,190,6))));
1248: rec_cl_resp_r1.defer_req_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,196,1)));
1249: rec_cl_resp_r1.borw_interest_ind := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,197,1)));

Line 1252: rec_cl_resp_r1.b_signature_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,200,8),'YYYYMMDD');

1248: rec_cl_resp_r1.defer_req_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,196,1)));
1249: rec_cl_resp_r1.borw_interest_ind := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,197,1)));
1250: rec_cl_resp_r1.eft_auth_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,198,1)));
1251: rec_cl_resp_r1.b_signature_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,199,1)));
1252: rec_cl_resp_r1.b_signature_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,200,8),'YYYYMMDD');
1253: rec_cl_resp_r1.loan_number := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,208,17)));
1254: rec_cl_resp_r1.cl_seq_number := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,225,2))));
1255: rec_cl_resp_r1.b_citizenship_status := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,228,1)));
1256: rec_cl_resp_r1.b_state_of_legal_res := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,229,2)));

Line 1257: rec_cl_resp_r1.b_legal_res_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,231,6)||'01','YYYYMMDD');

1253: rec_cl_resp_r1.loan_number := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,208,17)));
1254: rec_cl_resp_r1.cl_seq_number := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,225,2))));
1255: rec_cl_resp_r1.b_citizenship_status := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,228,1)));
1256: rec_cl_resp_r1.b_state_of_legal_res := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,229,2)));
1257: rec_cl_resp_r1.b_legal_res_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,231,6)||'01','YYYYMMDD');
1258: rec_cl_resp_r1.b_default_status := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,237,1)));
1259: rec_cl_resp_r1.b_outstd_loan_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,238,1)));
1260: rec_cl_resp_r1.b_indicator_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,239,1)));
1261: rec_cl_resp_r1.s_last_name := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,259,35)));

Line 1265: rec_cl_resp_r1.s_date_of_birth := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,316,8),'YYYYMMDD');

1261: rec_cl_resp_r1.s_last_name := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,259,35)));
1262: rec_cl_resp_r1.s_first_name := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,294,12)));
1263: rec_cl_resp_r1.s_middle_name := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,306,1)));
1264: rec_cl_resp_r1.s_ssn := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,307,9))));
1265: rec_cl_resp_r1.s_date_of_birth := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,316,8),'YYYYMMDD');
1266: rec_cl_resp_r1.s_citizenship_status := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,324,1)));
1267: rec_cl_resp_r1.s_default_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,325,1)));
1268: rec_cl_resp_r1.s_signature_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,326,1)));
1269: rec_cl_resp_r1.school_id := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,347,8))));

Line 1270: rec_cl_resp_r1.loan_per_begin_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,357,8),'YYYYMMDD');

1266: rec_cl_resp_r1.s_citizenship_status := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,324,1)));
1267: rec_cl_resp_r1.s_default_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,325,1)));
1268: rec_cl_resp_r1.s_signature_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,326,1)));
1269: rec_cl_resp_r1.school_id := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,347,8))));
1270: rec_cl_resp_r1.loan_per_begin_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,357,8),'YYYYMMDD');
1271: rec_cl_resp_r1.loan_per_end_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,365,8),'YYYYMMDD');
1272: rec_cl_resp_r1.grade_level_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,373,1)));
1273: rec_cl_resp_r1.enrollment_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,375,1)));
1274: rec_cl_resp_r1.anticip_compl_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,376,8),'YYYYMMDD');

Line 1271: rec_cl_resp_r1.loan_per_end_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,365,8),'YYYYMMDD');

1267: rec_cl_resp_r1.s_default_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,325,1)));
1268: rec_cl_resp_r1.s_signature_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,326,1)));
1269: rec_cl_resp_r1.school_id := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,347,8))));
1270: rec_cl_resp_r1.loan_per_begin_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,357,8),'YYYYMMDD');
1271: rec_cl_resp_r1.loan_per_end_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,365,8),'YYYYMMDD');
1272: rec_cl_resp_r1.grade_level_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,373,1)));
1273: rec_cl_resp_r1.enrollment_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,375,1)));
1274: rec_cl_resp_r1.anticip_compl_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,376,8),'YYYYMMDD');
1275: rec_cl_resp_r1.coa_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,384,5))));

Line 1274: rec_cl_resp_r1.anticip_compl_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,376,8),'YYYYMMDD');

1270: rec_cl_resp_r1.loan_per_begin_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,357,8),'YYYYMMDD');
1271: rec_cl_resp_r1.loan_per_end_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,365,8),'YYYYMMDD');
1272: rec_cl_resp_r1.grade_level_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,373,1)));
1273: rec_cl_resp_r1.enrollment_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,375,1)));
1274: rec_cl_resp_r1.anticip_compl_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,376,8),'YYYYMMDD');
1275: rec_cl_resp_r1.coa_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,384,5))));
1276: rec_cl_resp_r1.efc_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,389,5))));
1277: rec_cl_resp_r1.est_fa_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,394,5))));
1278: rec_cl_resp_r1.fls_cert_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,399,5))));

Line 1281: rec_cl_resp_r1.sch_cert_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,414,8),'YYYYMMDD');

1277: rec_cl_resp_r1.est_fa_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,394,5))));
1278: rec_cl_resp_r1.fls_cert_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,399,5))));
1279: rec_cl_resp_r1.flu_cert_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,404,5))));
1280: rec_cl_resp_r1.flp_cert_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,409,5))));
1281: rec_cl_resp_r1.sch_cert_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,414,8),'YYYYMMDD');
1282: rec_cl_resp_r1.alt_cert_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,438,5))));
1283: rec_cl_resp_r1.alt_appl_ver_code := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,443,4))));
1284: rec_cl_resp_r1.lender_id := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,458,6)));
1285: rec_cl_resp_r1.fls_approved_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,464,5))));

Line 1292: rec_cl_resp_r1.guarantee_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,680,8),'YYYYMMDD');

1288: rec_cl_resp_r1.alt_approved_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,488,5))));
1289: rec_cl_resp_r1.guarantor_id := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,507,3)));
1290: rec_cl_resp_r1.fed_appl_form_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,510,1)));
1291: rec_cl_resp_r1.guarnt_adj_ind := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,531,1)));
1292: rec_cl_resp_r1.guarantee_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,680,8),'YYYYMMDD');
1293: rec_cl_resp_r1.b_license_state := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,715,2)));
1294: rec_cl_resp_r1.b_license_number := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,717,20)));
1295: rec_cl_resp_r1.b_ref_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,737,1)));
1296: rec_cl_resp_r1.school_use_txt := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,738,23)));

Line 1312: rec_cl_resp_r1.b_permt_addr_chg_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,899,8),'YYYYMMDD');

1308: rec_cl_resp_r1.guarnt_amt_redn_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,846,2)));
1309: rec_cl_resp_r1.tot_outstd_stafford := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,848,8))))/100;
1310: rec_cl_resp_r1.tot_outstd_plus := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,856,8))))/100;
1311: rec_cl_resp_r1.guarantor_use_txt := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,876,23)));
1312: rec_cl_resp_r1.b_permt_addr_chg_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,899,8),'YYYYMMDD');
1313: rec_cl_resp_r1.alt_prog_type_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,907,3)));
1314: rec_cl_resp_r1.alt_borw_tot_debt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,910,7))));
1315: --MN 16-Dec-2004 15:25 Interest has 3 decimal places after assumed DP.
1316: rec_cl_resp_r1.act_interest_rate := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,957,5))))/1000;

Line 1321: rec_cl_resp_r1.sch_refund_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,974,8),'YYYYMMDD');

1317: rec_cl_resp_r1.prc_type_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,962,2)));
1318: rec_cl_resp_r1.service_type_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,964,2)));
1319: rec_cl_resp_r1.rev_notice_of_guarnt := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,966,1)));
1320: rec_cl_resp_r1.sch_refund_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,967,5))))/100;
1321: rec_cl_resp_r1.sch_refund_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,974,8),'YYYYMMDD');
1322: rec_cl_resp_r1.resp_record_status := p_resp_record_status;
1323: rec_cl_resp_r1.cl_version_code := g_v_cl_version;
1324: -- bvisvana - FA 161 - Bug # 5006583
1325: rec_cl_resp_r1.esign_src_typ_cd := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,449,9)));

Line 1337: rec_cl_resp_r1.lend_apprv_denied_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,479,8),'YYYYMMDD');

1333: );
1334: rec_cl_resp_r1.borr_credit_auth_code := NULL;
1335: rec_cl_resp_r1.borr_sign_ind := NULL;
1336: rec_cl_resp_r1.duns_school_id := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,449,9)));
1337: rec_cl_resp_r1.lend_apprv_denied_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,479,8),'YYYYMMDD');
1338: rec_cl_resp_r1.lend_apprv_denied_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,487,1)));
1339: rec_cl_resp_r1.duns_lender_id := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,493,9)));
1340: rec_cl_resp_r1.duns_guarnt_id := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,511,9)));
1341: rec_cl_resp_r1.lend_blkt_guarnt_ind := NULL;

Line 1349: rec_cl_resp_r1.appl_loan_phase_code_chg := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,868,8),'YYYYMMDD');

1345: rec_cl_resp_r1.mpn_confirm_ind := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,694,1)));
1346: rec_cl_resp_r1.borw_confirm_ind := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,695,1)));
1347: rec_cl_resp_r1.stud_sign_ind := NULL;
1348: rec_cl_resp_r1.appl_loan_phase_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,864,4)));
1349: rec_cl_resp_r1.appl_loan_phase_code_chg := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,868,8),'YYYYMMDD');
1350: rec_cl_resp_r1.guarnt_status_code := NULL;
1351: rec_cl_resp_r1.lender_status_code := NULL;
1352: rec_cl_resp_r1.pnote_status_code := NULL;
1353: rec_cl_resp_r1.credit_status_code := NULL;

Line 1368: rec_cl_resp_r1.cl_rec_status_last_update := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,4,8),'YYYYMMDD');

1364: rec_cl_resp_r1.cl_rec_status := rec_cl_resp_r1.rec_type_ind;
1365: --MN 16-Dec-2004 15:25 The Sent Code and Received Codes are not same
1366: -- rec_cl_resp_r1.rec_type_ind := NVL(p_rec_type_ind,'S'); -- should be same as sent one
1367: END IF; -- else retain old status
1368: rec_cl_resp_r1.cl_rec_status_last_update := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,4,8),'YYYYMMDD');
1369:
1370: -- fields for RELEASE-5 only
1371: ELSIF g_v_cl_version = 'RELEASE-5' THEN
1372: log_to_fnd(p_v_module => 'insert_into_resp_r1',

Line 1383: rec_cl_resp_r1.lend_blkt_guarnt_appr_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,523,8),'YYYYMMDD');

1379: rec_cl_resp_r1.lend_apprv_denied_code := NULL;
1380: rec_cl_resp_r1.duns_lender_id := NULL;
1381: rec_cl_resp_r1.duns_guarnt_id := NULL;
1382: rec_cl_resp_r1.lend_blkt_guarnt_ind := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,522,1)));
1383: rec_cl_resp_r1.lend_blkt_guarnt_appr_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,523,8),'YYYYMMDD');
1384: rec_cl_resp_r1.guarantee_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,688,7))));
1385: rec_cl_resp_r1.req_serial_loan_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,695,1)));
1386: rec_cl_resp_r1.mpn_confirm_ind := NULL;
1387: rec_cl_resp_r1.borw_confirm_ind := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,697,1)));

Line 1395: rec_cl_resp_r1.guarnt_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1000,14),'YYYYMMDDHH24MISS');

1391: rec_cl_resp_r1.guarnt_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,992,2)));
1392: rec_cl_resp_r1.lender_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,994,2)));
1393: rec_cl_resp_r1.pnote_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,996,2)));
1394: rec_cl_resp_r1.credit_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,998,2)));
1395: rec_cl_resp_r1.guarnt_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1000,14),'YYYYMMDDHH24MISS');
1396: rec_cl_resp_r1.lender_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1014,14),'YYYYMMDDHH24MISS');
1397: rec_cl_resp_r1.pnote_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1028,14),'YYYYMMDDHH24MISS');
1398: rec_cl_resp_r1.credit_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1042,14),'YYYYMMDDHH24MISS');
1399: rec_cl_resp_r1.act_serial_loan_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1056,1)));

Line 1396: rec_cl_resp_r1.lender_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1014,14),'YYYYMMDDHH24MISS');

1392: rec_cl_resp_r1.lender_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,994,2)));
1393: rec_cl_resp_r1.pnote_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,996,2)));
1394: rec_cl_resp_r1.credit_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,998,2)));
1395: rec_cl_resp_r1.guarnt_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1000,14),'YYYYMMDDHH24MISS');
1396: rec_cl_resp_r1.lender_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1014,14),'YYYYMMDDHH24MISS');
1397: rec_cl_resp_r1.pnote_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1028,14),'YYYYMMDDHH24MISS');
1398: rec_cl_resp_r1.credit_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1042,14),'YYYYMMDDHH24MISS');
1399: rec_cl_resp_r1.act_serial_loan_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1056,1)));
1400: rec_cl_resp_r1.sch_non_ed_brc_id := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1090,4)));

Line 1397: rec_cl_resp_r1.pnote_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1028,14),'YYYYMMDDHH24MISS');

1393: rec_cl_resp_r1.pnote_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,996,2)));
1394: rec_cl_resp_r1.credit_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,998,2)));
1395: rec_cl_resp_r1.guarnt_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1000,14),'YYYYMMDDHH24MISS');
1396: rec_cl_resp_r1.lender_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1014,14),'YYYYMMDDHH24MISS');
1397: rec_cl_resp_r1.pnote_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1028,14),'YYYYMMDDHH24MISS');
1398: rec_cl_resp_r1.credit_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1042,14),'YYYYMMDDHH24MISS');
1399: rec_cl_resp_r1.act_serial_loan_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1056,1)));
1400: rec_cl_resp_r1.sch_non_ed_brc_id := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1090,4)));
1401: rec_cl_resp_r1.amt_avail_for_reinst := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1094,7))));

Line 1398: rec_cl_resp_r1.credit_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1042,14),'YYYYMMDDHH24MISS');

1394: rec_cl_resp_r1.credit_status_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,998,2)));
1395: rec_cl_resp_r1.guarnt_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1000,14),'YYYYMMDDHH24MISS');
1396: rec_cl_resp_r1.lender_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1014,14),'YYYYMMDDHH24MISS');
1397: rec_cl_resp_r1.pnote_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1028,14),'YYYYMMDDHH24MISS');
1398: rec_cl_resp_r1.credit_status_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,1042,14),'YYYYMMDDHH24MISS');
1399: rec_cl_resp_r1.act_serial_loan_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1056,1)));
1400: rec_cl_resp_r1.sch_non_ed_brc_id := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1090,4)));
1401: rec_cl_resp_r1.amt_avail_for_reinst := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1094,7))));
1402: rec_cl_resp_r1.uniq_layout_vend_code := LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,1142,4)));

Line 1557: r8_tab(l_ind).disb_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,( 536 +36*i),8),'YYYYMMDD');

1553:
1554: gv_debug_str := gv_debug_str || 'INSERT_INTO_RESP1 - 3' ||' ';
1555:
1556: r8_tab(l_ind).clrp8_id := l_ind+1;
1557: r8_tab(l_ind).disb_date := fnd_date.string_to_date(SUBSTR(Format_1_rec.record_data,( 536 +36*i),8),'YYYYMMDD');
1558: r8_tab(l_ind).disb_gross_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,( 544 +36*i),7))))/100;
1559: r8_tab(l_ind).orig_fee := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,( 551 +36*i),7))))/100;
1560: r8_tab(l_ind).guarantee_fee := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,( 558 +36*i),7))))/100;
1561: r8_tab(l_ind).net_disb_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,( 565 +36*i),7))))/100;

Line 1623: r8_tab(l_ind).disb_date := fnd_date.string_to_date(SUBSTR(other_rec.record_data,(9 + 8*i),8),'YYYYMMDD');

1619:
1620: IF LTRIM(RTRIM(SUBSTR(other_rec.record_data,(585+ 1*i),1))) IS NOT NULL THEN
1621: gv_debug_str := gv_debug_str || 'INSERT_INTO_RESP1 - 7' || ' ';
1622: r8_tab(l_ind).clrp8_id := l_ind;
1623: r8_tab(l_ind).disb_date := fnd_date.string_to_date(SUBSTR(other_rec.record_data,(9 + 8*i),8),'YYYYMMDD');
1624: r8_tab(l_ind).disb_gross_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(other_rec.record_data,( 137 + 7*i),7))))/100;
1625: r8_tab(l_ind).orig_fee := TO_NUMBER(LTRIM(RTRIM(SUBSTR(other_rec.record_data,( 249 + 7*i),7))))/100;
1626: r8_tab(l_ind).guarantee_fee := TO_NUMBER(LTRIM(RTRIM(SUBSTR(other_rec.record_data,( 361 + 7*i),7))))/100;
1627: r8_tab(l_ind).net_disb_amt := TO_NUMBER(LTRIM(RTRIM(SUBSTR(other_rec.record_data,( 473 + 7*i),7))))/100;

Line 1727: v_tab_resp_r7(l_n_ctr_r7).email_effective_date := fnd_date.string_to_date(LTRIM(RTRIM(SUBSTR(other_rec.record_data,266,8))),'YYYYMMDD');

1723: v_tab_resp_r7(l_n_ctr_r7).layout_owner_code_txt := LTRIM(RTRIM(SUBSTR(other_rec.record_data,3,4)));
1724: v_tab_resp_r7(l_n_ctr_r7).layout_identifier_code_txt := LTRIM(RTRIM(SUBSTR(other_rec.record_data,7,2)));
1725: v_tab_resp_r7(l_n_ctr_r7).email_txt := LTRIM(RTRIM(SUBSTR(other_rec.record_data,9,256)));
1726: v_tab_resp_r7(l_n_ctr_r7).valid_email_flag := LTRIM(RTRIM(SUBSTR(other_rec.record_data,265,1)));
1727: v_tab_resp_r7(l_n_ctr_r7).email_effective_date := fnd_date.string_to_date(LTRIM(RTRIM(SUBSTR(other_rec.record_data,266,8))),'YYYYMMDD');
1728: v_tab_resp_r7(l_n_ctr_r7).borrower_temp_add_line_1_txt := LTRIM(RTRIM(SUBSTR(other_rec.record_data,274,30)));
1729: v_tab_resp_r7(l_n_ctr_r7).borrower_temp_add_line_2_txt := LTRIM(RTRIM(SUBSTR(other_rec.record_data,304,30)));
1730: v_tab_resp_r7(l_n_ctr_r7).borrower_temp_add_city_txt := LTRIM(RTRIM(SUBSTR(other_rec.record_data,334,24)));
1731: v_tab_resp_r7(l_n_ctr_r7).borrower_temp_add_state_txt := LTRIM(RTRIM(SUBSTR(other_rec.record_data,358,2)));

Line 3489: ||LPAD(fnd_date.date_to_displaydate(OFA_disb.disb_date),30)

3485: FOR OFA_disb IN cur_old_disbursements
3486: LOOP
3487: fnd_file.put_line(fnd_file.log,
3488: LPAD(TO_CHAR(OFA_disb.disb_num),30)
3489: ||LPAD(fnd_date.date_to_displaydate(OFA_disb.disb_date),30)
3490: ||LPAD(TO_CHAR(OFA_disb.disb_accepted_amt),30) -- disb gorss amt changed to disb accepted amt
3491: ||LPAD(TO_CHAR(OFA_disb.fee_1),30)
3492: ||LPAD(TO_CHAR(OFA_disb.fee_2),30)
3493: ||LPAD(TO_CHAR(OFA_disb.fee_paid_1),30)

Line 3509: ||LPAD(fnd_date.date_to_displaydate(LOC_disb.disb_date),30)

3505: FOR LOC_disb IN cur_new_disbursements('N')
3506: LOOP
3507: fnd_file.put_line(fnd_file.log,
3508: LPAD(TO_CHAR(LOC_disb.clrp8_id),30)
3509: ||LPAD(fnd_date.date_to_displaydate(LOC_disb.disb_date),30)
3510: ||LPAD(TO_CHAR(LOC_disb.disb_gross_amt),30)
3511: ||LPAD(TO_CHAR(LOC_disb.orig_fee),30)
3512: ||LPAD(TO_CHAR(LOC_disb.guarantee_fee),30)
3513: ||LPAD(TO_CHAR(LOC_disb.orig_fee_paid),30)

Line 3590: ||LPAD(fnd_date.date_to_displaydate(tbh_rec.disb_date),30)

3586: NVL(tbh_rec.direct_to_borr_flag,'N') <> NVL(loc_disb.direct_to_borr_flag,'N')
3587: THEN
3588: counter := counter + 1;
3589: awd_disb_array(counter) := LPAD(TO_CHAR(tbh_rec.disb_num),30)
3590: ||LPAD(fnd_date.date_to_displaydate(tbh_rec.disb_date),30)
3591: ||LPAD(TO_CHAR(NVL(tbh_rec.disb_accepted_amt,0)),30)
3592: ||LPAD(TO_CHAR(NVL(tbh_rec.fee_1,0)),30)
3593: ||LPAD(TO_CHAR(NVL(tbh_rec.fee_2,0)),30)
3594: ||LPAD(TO_CHAR(NVL(tbh_rec.fee_paid_1,0)),30)

Line 3602: ||LPAD(fnd_date.date_to_displaydate(loc_disb.disb_date),30)

3598: ||LPAD(NVL(TO_CHAR(IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_HOLD_REL_IND_TF',tbh_rec.hold_rel_ind)),' '),45)
3599: ||LPAD(NVL(tbh_rec.direct_to_borr_flag,'N'),30);
3600:
3601: loc_disb_array(counter) := LPAD(TO_CHAR(loc_disb.clrp8_id),30)
3602: ||LPAD(fnd_date.date_to_displaydate(loc_disb.disb_date),30)
3603: ||LPAD(TO_CHAR(NVL(loc_disb.disb_gross_amt,0)),30)
3604: ||LPAD(TO_CHAR(NVL(loc_disb.orig_fee,0)),30)
3605: ||LPAD(TO_CHAR(NVL(loc_disb.guarantee_fee,0)),30)
3606: ||LPAD(TO_CHAR(NVL(loc_disb.orig_fee_paid,0)),30)