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.LNS_LOAN_PUB dependencies on LNS_FREQ_SCHEDULES

Line 3698: -- Create LNS_FREQ_SCHEDULES records

3694: END IF;
3695:
3696: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Loan term object created successfully');
3697:
3698: -- Create LNS_FREQ_SCHEDULES records
3699: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting into LNS_FREQ_SCHEDULES...');
3700: BEGIN
3701: if l_open_freq_schedule_tbl is not null then
3702: insert into LNS_FREQ_SCHEDULES

Line 3699: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting into LNS_FREQ_SCHEDULES...');

3695:
3696: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Loan term object created successfully');
3697:
3698: -- Create LNS_FREQ_SCHEDULES records
3699: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting into LNS_FREQ_SCHEDULES...');
3700: BEGIN
3701: if l_open_freq_schedule_tbl is not null then
3702: insert into LNS_FREQ_SCHEDULES
3703: (FREQ_SCHEDULE_ID,

Line 3702: insert into LNS_FREQ_SCHEDULES

3698: -- Create LNS_FREQ_SCHEDULES records
3699: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting into LNS_FREQ_SCHEDULES...');
3700: BEGIN
3701: if l_open_freq_schedule_tbl is not null then
3702: insert into LNS_FREQ_SCHEDULES
3703: (FREQ_SCHEDULE_ID,
3704: LOAN_ID,
3705: PHASE,
3706: COMPONENT,

Line 3716: (LNS_FREQ_SCHEDULES_S.nextval,

3712: LAST_UPDATE_DATE,
3713: LAST_UPDATED_BY,
3714: LAST_UPDATE_LOGIN)
3715: values
3716: (LNS_FREQ_SCHEDULES_S.nextval,
3717: l_loan_rec.loan_id,
3718: 'OPEN',
3719: 'PRIN_INT',
3720: l_open_freq_schedule_tbl(1).PERIOD_BEGIN_DATE,

Line 3734: insert into LNS_FREQ_SCHEDULES

3730:
3731: -- insert term phase record(s)
3732: if P_Loan_Details_Rec.PAYMENT_CALC_METHOD = 'SEPARATE_SCHEDULES' then
3733: -- insert 2 records if its SEPARATE_SCHEDULES
3734: insert into LNS_FREQ_SCHEDULES
3735: (FREQ_SCHEDULE_ID,
3736: LOAN_ID,
3737: PHASE,
3738: COMPONENT,

Line 3748: (LNS_FREQ_SCHEDULES_S.nextval,

3744: LAST_UPDATE_DATE,
3745: LAST_UPDATED_BY,
3746: LAST_UPDATE_LOGIN)
3747: values
3748: (LNS_FREQ_SCHEDULES_S.nextval,
3749: l_loan_rec.loan_id,
3750: 'TERM',
3751: 'INT',
3752: l_int_freq_schedule_tbl(1).PERIOD_BEGIN_DATE,

Line 3762: insert into LNS_FREQ_SCHEDULES

3758: lns_utility_pub.last_updated_by,
3759: lns_utility_pub.LAST_UPDATE_LOGIN);
3760: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Inserted INT record');
3761:
3762: insert into LNS_FREQ_SCHEDULES
3763: (FREQ_SCHEDULE_ID,
3764: LOAN_ID,
3765: PHASE,
3766: COMPONENT,

Line 3776: (LNS_FREQ_SCHEDULES_S.nextval,

3772: LAST_UPDATE_DATE,
3773: LAST_UPDATED_BY,
3774: LAST_UPDATE_LOGIN)
3775: values
3776: (LNS_FREQ_SCHEDULES_S.nextval,
3777: l_loan_id,
3778: 'TERM',
3779: 'PRIN',
3780: l_prin_freq_schedule_tbl(1).PERIOD_BEGIN_DATE,

Line 3791: insert into LNS_FREQ_SCHEDULES

3787: lns_utility_pub.LAST_UPDATE_LOGIN);
3788: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Inserted PRIN record');
3789: else
3790: -- insert 1 record if its others
3791: insert into LNS_FREQ_SCHEDULES
3792: (FREQ_SCHEDULE_ID,
3793: LOAN_ID,
3794: PHASE,
3795: COMPONENT,

Line 3805: (LNS_FREQ_SCHEDULES_S.nextval,

3801: LAST_UPDATE_DATE,
3802: LAST_UPDATED_BY,
3803: LAST_UPDATE_LOGIN)
3804: values
3805: (LNS_FREQ_SCHEDULES_S.nextval,
3806: l_loan_id,
3807: 'TERM',
3808: 'PRIN_INT',
3809: l_freq_schedule_tbl(1).PERIOD_BEGIN_DATE,