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

Line 693: LNS_UTILITY_PUB.CREATED_BY,

689: null,
690: null,
691: 1,
692: sysdate,
693: LNS_UTILITY_PUB.CREATED_BY,
694: sysdate,
695: LNS_UTILITY_PUB.LAST_UPDATED_BY,
696: LNS_UTILITY_PUB.LAST_UPDATE_LOGIN);
697:

Line 695: LNS_UTILITY_PUB.LAST_UPDATED_BY,

691: 1,
692: sysdate,
693: LNS_UTILITY_PUB.CREATED_BY,
694: sysdate,
695: LNS_UTILITY_PUB.LAST_UPDATED_BY,
696: LNS_UTILITY_PUB.LAST_UPDATE_LOGIN);
697:
698: else
699:

Line 696: LNS_UTILITY_PUB.LAST_UPDATE_LOGIN);

692: sysdate,
693: LNS_UTILITY_PUB.CREATED_BY,
694: sysdate,
695: LNS_UTILITY_PUB.LAST_UPDATED_BY,
696: LNS_UTILITY_PUB.LAST_UPDATE_LOGIN);
697:
698: else
699:
700: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_loan_extensions...');

Line 729: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,

725: NEW_AMORT_TERM = l_NEW_TERM_REC.NEW_AMORT_TERM,
726: NEW_MATURITY_DATE = l_NEW_TERM_REC.NEW_MATURITY_DATE,
727: NEW_INSTALLMENTS = l_NEW_TERM_REC.NEW_INSTALLMENTS,
728: LAST_UPDATE_DATE = sysdate,
729: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
730: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
731: where LOAN_EXT_ID = P_LOAN_EXT_REC.LOAN_EXT_ID;
732:
733: end if;

Line 730: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

726: NEW_MATURITY_DATE = l_NEW_TERM_REC.NEW_MATURITY_DATE,
727: NEW_INSTALLMENTS = l_NEW_TERM_REC.NEW_INSTALLMENTS,
728: LAST_UPDATE_DATE = sysdate,
729: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
730: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
731: where LOAN_EXT_ID = P_LOAN_EXT_REC.LOAN_EXT_ID;
732:
733: end if;
734:

Line 1065: ,lns_utility_pub.created_by

1061: ,l_EXT_SPREAD
1062: ,(l_EXT_RATE+l_EXT_SPREAD)
1063: ,sysdate
1064: ,null
1065: ,lns_utility_pub.created_by
1066: ,sysdate
1067: ,lns_utility_pub.last_updated_by
1068: ,sysdate
1069: ,lns_utility_pub.LAST_UPDATE_LOGIN

Line 1067: ,lns_utility_pub.last_updated_by

1063: ,sysdate
1064: ,null
1065: ,lns_utility_pub.created_by
1066: ,sysdate
1067: ,lns_utility_pub.last_updated_by
1068: ,sysdate
1069: ,lns_utility_pub.LAST_UPDATE_LOGIN
1070: ,1
1071: ,l_EXT_INDEX_DATE

Line 1069: ,lns_utility_pub.LAST_UPDATE_LOGIN

1065: ,lns_utility_pub.created_by
1066: ,sysdate
1067: ,lns_utility_pub.last_updated_by
1068: ,sysdate
1069: ,lns_utility_pub.LAST_UPDATE_LOGIN
1070: ,1
1071: ,l_EXT_INDEX_DATE
1072: ,l_END_INSTALLMENT+1
1073: ,l_NEW_INSTALLMENTS

Line 1128: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,

1124:
1125: update LNS_LOAN_EXTENSIONS
1126: set STATUS = 'APPROVED',
1127: APPR_REJECT_DATE = sysdate,
1128: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,
1129: LAST_UPDATE_DATE = sysdate,
1130: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
1131: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
1132: LAST_BILLED_INSTALLMENT = l_last_billed_installment

Line 1130: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,

1126: set STATUS = 'APPROVED',
1127: APPR_REJECT_DATE = sysdate,
1128: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,
1129: LAST_UPDATE_DATE = sysdate,
1130: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
1131: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
1132: LAST_BILLED_INSTALLMENT = l_last_billed_installment
1133: where LOAN_EXT_ID = P_LOAN_EXT_ID;
1134:

Line 1131: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,

1127: APPR_REJECT_DATE = sysdate,
1128: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,
1129: LAST_UPDATE_DATE = sysdate,
1130: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
1131: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
1132: LAST_BILLED_INSTALLMENT = l_last_billed_installment
1133: where LOAN_EXT_ID = P_LOAN_EXT_ID;
1134:
1135: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');

Line 1283: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,

1279:
1280: update LNS_LOAN_EXTENSIONS
1281: set STATUS = 'REJECTED',
1282: APPR_REJECT_DATE = sysdate,
1283: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,
1284: LAST_UPDATE_DATE = sysdate,
1285: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
1286: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
1287: where LOAN_EXT_ID = P_LOAN_EXT_ID;

Line 1285: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,

1281: set STATUS = 'REJECTED',
1282: APPR_REJECT_DATE = sysdate,
1283: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,
1284: LAST_UPDATE_DATE = sysdate,
1285: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
1286: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
1287: where LOAN_EXT_ID = P_LOAN_EXT_ID;
1288:
1289: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');

Line 1286: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

1282: APPR_REJECT_DATE = sysdate,
1283: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,
1284: LAST_UPDATE_DATE = sysdate,
1285: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
1286: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
1287: where LOAN_EXT_ID = P_LOAN_EXT_ID;
1288:
1289: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');
1290: