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 690: LNS_UTILITY_PUB.CREATED_BY,

686: null,
687: null,
688: 1,
689: sysdate,
690: LNS_UTILITY_PUB.CREATED_BY,
691: sysdate,
692: LNS_UTILITY_PUB.LAST_UPDATED_BY,
693: LNS_UTILITY_PUB.LAST_UPDATE_LOGIN);
694:

Line 692: LNS_UTILITY_PUB.LAST_UPDATED_BY,

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

Line 693: LNS_UTILITY_PUB.LAST_UPDATE_LOGIN);

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

Line 725: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,

721: NEW_AMORT_TERM = l_NEW_TERM_REC.NEW_AMORT_TERM,
722: NEW_MATURITY_DATE = l_NEW_TERM_REC.NEW_MATURITY_DATE,
723: NEW_INSTALLMENTS = l_NEW_TERM_REC.NEW_INSTALLMENTS,
724: LAST_UPDATE_DATE = sysdate,
725: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
726: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
727: where LOAN_EXT_ID = P_LOAN_EXT_REC.LOAN_EXT_ID;
728:
729: end if;

Line 726: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

722: NEW_MATURITY_DATE = l_NEW_TERM_REC.NEW_MATURITY_DATE,
723: NEW_INSTALLMENTS = l_NEW_TERM_REC.NEW_INSTALLMENTS,
724: LAST_UPDATE_DATE = sysdate,
725: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
726: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
727: where LOAN_EXT_ID = P_LOAN_EXT_REC.LOAN_EXT_ID;
728:
729: end if;
730:

Line 1064: ,lns_utility_pub.created_by

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

Line 1066: ,lns_utility_pub.last_updated_by

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

Line 1068: ,lns_utility_pub.LAST_UPDATE_LOGIN

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

Line 1126: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,

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

Line 1128: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,

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

Line 1129: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,

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

Line 1141: FND_MESSAGE.SET_TOKEN('EXT_TERM_PERIOD', lns_utility_pub.get_lookup_meaning('PERIOD', l_EXT_TERM_PERIOD));

1137: -- Retrieve agreement reason
1138: FND_MESSAGE.SET_NAME('LNS', 'LNS_TERM_EXT_AGR_REASON');
1139: FND_MESSAGE.SET_TOKEN('EXT', l_description);
1140: FND_MESSAGE.SET_TOKEN('EXT_TERM', l_EXT_TERM);
1141: FND_MESSAGE.SET_TOKEN('EXT_TERM_PERIOD', lns_utility_pub.get_lookup_meaning('PERIOD', l_EXT_TERM_PERIOD));
1142: FND_MESSAGE.SET_TOKEN('NEW_MATURITY_DATE', l_NEW_MATURITY_DATE);
1143: FND_MSG_PUB.Add;
1144: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');
1145: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);

Line 1275: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,

1271:
1272: update LNS_LOAN_EXTENSIONS
1273: set STATUS = 'REJECTED',
1274: APPR_REJECT_DATE = sysdate,
1275: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,
1276: LAST_UPDATE_DATE = sysdate,
1277: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
1278: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
1279: where LOAN_EXT_ID = P_LOAN_EXT_ID;

Line 1277: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,

1273: set STATUS = 'REJECTED',
1274: APPR_REJECT_DATE = sysdate,
1275: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,
1276: LAST_UPDATE_DATE = sysdate,
1277: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
1278: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
1279: where LOAN_EXT_ID = P_LOAN_EXT_ID;
1280:
1281: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');

Line 1278: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

1274: APPR_REJECT_DATE = sysdate,
1275: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,
1276: LAST_UPDATE_DATE = sysdate,
1277: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
1278: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
1279: where LOAN_EXT_ID = P_LOAN_EXT_ID;
1280:
1281: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');
1282: