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_BILLING_BATCH_PUB dependencies on LNS_UTILITY_PUB

Line 3911: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,

3907: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_FEE_SCHEDULES with billed_flag = Y ...');
3908: UPDATE LNS_FEE_SCHEDULES
3909: SET
3910: BILLED_FLAG = 'Y',
3911: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
3912: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,
3913: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3914: WHERE
3915: FEE_SCHEDULE_ID = l_fee_tbl(l_Count).fee_schedule_id;

Line 3912: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,

3908: UPDATE LNS_FEE_SCHEDULES
3909: SET
3910: BILLED_FLAG = 'Y',
3911: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
3912: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,
3913: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3914: WHERE
3915: FEE_SCHEDULE_ID = l_fee_tbl(l_Count).fee_schedule_id;
3916: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_FEE_SCHEDULES');

Line 3913: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

3909: SET
3910: BILLED_FLAG = 'Y',
3911: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
3912: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,
3913: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3914: WHERE
3915: FEE_SCHEDULE_ID = l_fee_tbl(l_Count).fee_schedule_id;
3916: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_FEE_SCHEDULES');
3917:

Line 5631: UPDATE LNS_FEE_SCHEDULES SET ACTIVE_FLAG = 'N', LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = lns_utility_pub.last_updated_by, LAST_UPDATE_LOGIN = lns_utility_pub.last_update_login, OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1

5627: else
5628: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Before inactivating unbilled manual fees for this installment: ' || l_LAST_PAYMENT_NUMBER);
5629: --Bug5397345
5630: --Make sure unbilled manual fees for this reversed installment are inactivated
5631: UPDATE LNS_FEE_SCHEDULES SET ACTIVE_FLAG = 'N', LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = lns_utility_pub.last_updated_by, LAST_UPDATE_LOGIN = lns_utility_pub.last_update_login, OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
5632: WHERE LOAN_ID = P_LOAN_ID AND BILLED_FLAG = 'N' AND FEE_INSTALLMENT = l_LAST_PAYMENT_NUMBER;
5633: LogMessage(FND_LOG.LEVEL_STATEMENT, 'After inactivating unbilled manual fees by updating the active_flag in lns_fee_schedules for this loan and installment');
5634:
5635: end if;

Line 7444: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,

7440: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_FEE_SCHEDULES with billed_flag = Y ...');
7441: UPDATE LNS_FEE_SCHEDULES
7442: SET
7443: BILLED_FLAG = 'Y',
7444: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
7445: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,
7446: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
7447: WHERE
7448: FEE_SCHEDULE_ID = l_fee_tbl(l_Count).fee_schedule_id;

Line 7445: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,

7441: UPDATE LNS_FEE_SCHEDULES
7442: SET
7443: BILLED_FLAG = 'Y',
7444: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
7445: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,
7446: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
7447: WHERE
7448: FEE_SCHEDULE_ID = l_fee_tbl(l_Count).fee_schedule_id;
7449: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_FEE_SCHEDULES');

Line 7446: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

7442: SET
7443: BILLED_FLAG = 'Y',
7444: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
7445: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,
7446: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
7447: WHERE
7448: FEE_SCHEDULE_ID = l_fee_tbl(l_Count).fee_schedule_id;
7449: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_FEE_SCHEDULES');
7450: