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_DB_CL_ROSTER dependencies on FND_DATE

Line 611: l_guarantee_date := TO_DATE(SUBSTR(db_rec.record_data,370,8),'YYYYMMDD'); --pssahni change fnd_date.string_to_date to TO_DATE

607: l_lend_non_ed_brc_id := LTRIM(RTRIM(SUBSTR(db_rec.record_data,307,4)));
608: l_tot_sched_disb := TO_NUMBER(TRIM(SUBSTR(db_rec.record_data,332,2)));
609: l_disb_num := TO_NUMBER(TRIM(SUBSTR(db_rec.record_data,342,1)));
610: l_guarantor_id := LTRIM(RTRIM(SUBSTR(db_rec.record_data,344,3)));
611: l_guarantee_date := TO_DATE(SUBSTR(db_rec.record_data,370,8),'YYYYMMDD'); --pssahni change fnd_date.string_to_date to TO_DATE
612: l_guarantee_amt := TO_NUMBER(TRIM(SUBSTR(db_rec.record_data,378,5)));
613: l_fund_release_date := TO_DATE(SUBSTR(db_rec.record_data,334,8),'YYYYMMDD'); --pssahni change fnd_date.string_to_date to TO_DATE
614: l_gross_disb_amt := TO_NUMBER(TRIM(SUBSTR(db_rec.record_data,383,7)))/100; -- 9(005)V99
615: l_fee_1 := TO_NUMBER(TRIM(SUBSTR(db_rec.record_data,390,7)))/100;

Line 613: l_fund_release_date := TO_DATE(SUBSTR(db_rec.record_data,334,8),'YYYYMMDD'); --pssahni change fnd_date.string_to_date to TO_DATE

609: l_disb_num := TO_NUMBER(TRIM(SUBSTR(db_rec.record_data,342,1)));
610: l_guarantor_id := LTRIM(RTRIM(SUBSTR(db_rec.record_data,344,3)));
611: l_guarantee_date := TO_DATE(SUBSTR(db_rec.record_data,370,8),'YYYYMMDD'); --pssahni change fnd_date.string_to_date to TO_DATE
612: l_guarantee_amt := TO_NUMBER(TRIM(SUBSTR(db_rec.record_data,378,5)));
613: l_fund_release_date := TO_DATE(SUBSTR(db_rec.record_data,334,8),'YYYYMMDD'); --pssahni change fnd_date.string_to_date to TO_DATE
614: l_gross_disb_amt := TO_NUMBER(TRIM(SUBSTR(db_rec.record_data,383,7)))/100; -- 9(005)V99
615: l_fee_1 := TO_NUMBER(TRIM(SUBSTR(db_rec.record_data,390,7)))/100;
616: l_fee_2 := TO_NUMBER(TRIM(SUBSTR(db_rec.record_data,397,7)))/100;
617: l_net_disb_amt := TO_NUMBER(TRIM(SUBSTR(db_rec.record_data,404,7)))/100;

Line 627: l_pnote_status_date := TO_DATE(SUBSTR(db_rec.record_data,503,14),'YYYYMMDDHH24MISS'); --pssahni change fnd_date.string_to_date to TO_DATE

623:
624: IF g_cl_version = 'RELEASE-5' THEN
625: l_hold_rel_ind := LTRIM(RTRIM(SUBSTR(db_rec.record_data,500,1)));
626: l_pnote_code := LTRIM(RTRIM(SUBSTR(db_rec.record_data,501,2)));
627: l_pnote_status_date := TO_DATE(SUBSTR(db_rec.record_data,503,14),'YYYYMMDDHH24MISS'); --pssahni change fnd_date.string_to_date to TO_DATE
628: l_fee_paid_1 := TO_NUMBER(TRIM(SUBSTR(db_rec.record_data,517,7)))/100;
629: --Build FA163
630: l_fee_paid_2 := TO_NUMBER(TRIM(SUBSTR(db_rec.record_data,444,7)))/100;
631: l_direct_to_borr_ind := NVL(SUBSTR(db_rec.record_data,482,1),' ');

Line 681: x_b_addr_chg_date => fnd_date.string_to_date(SUBSTR(db_rec.record_data,181,8),'YYYYMMDD'),

677: x_b_city => LTRIM(RTRIM(SUBSTR(db_rec.record_data,140,24))),
678: x_b_state => LTRIM(RTRIM(SUBSTR(db_rec.record_data,170,2))),
679: x_b_zip => LTRIM(RTRIM(SUBSTR(db_rec.record_data,172,5))),
680: x_b_zip_suffix => LTRIM(RTRIM(SUBSTR(db_rec.record_data,177,4))),
681: x_b_addr_chg_date => fnd_date.string_to_date(SUBSTR(db_rec.record_data,181,8),'YYYYMMDD'),
682: x_eft_auth_code => LTRIM(RTRIM(SUBSTR(db_rec.record_data,189,1))),
683: x_s_last_name => LTRIM(RTRIM(SUBSTR(db_rec.record_data,190,35))),
684: x_s_first_name => LTRIM(RTRIM(SUBSTR(db_rec.record_data,225,12))),
685: x_s_middle_initial => LTRIM(RTRIM(SUBSTR(db_rec.record_data,237,1))),