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_TERMS_PUB dependencies on LNS_TERMS

Line 1: PACKAGE BODY LNS_TERMS_PUB AS

1: PACKAGE BODY LNS_TERMS_PUB AS
2: /*$Header: LNS_TERMS_PUBP_B.pls 120.8.12010000.6 2008/12/31 14:02:41 gparuchu ship $ */
3:
4: --------------------------------------------
5: -- declaration of global variables and types

Line 2: /$Header: LNS_TERMS_PUBP_B.pls 120.8.12010000.6 2008/12/31 14:02:41 gparuchu ship $ /

1: PACKAGE BODY LNS_TERMS_PUB AS
2: /*$Header: LNS_TERMS_PUBP_B.pls 120.8.12010000.6 2008/12/31 14:02:41 gparuchu ship $ */
3:
4: --------------------------------------------
5: -- declaration of global variables and types
6: --------------------------------------------

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'LNS_TERMS_PUB';

4: --------------------------------------------
5: -- declaration of global variables and types
6: --------------------------------------------
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'LNS_TERMS_PUB';
9:
10: --------------------------------------------------
11: -- declaration of private procedures and functions
12: --------------------------------------------------

Line 93: FROM LNS_TERMS

89: THEN
90: BEGIN
91: SELECT 'Y'
92: INTO l_dummy
93: FROM LNS_TERMS
94: WHERE term_id = l_term_id;
95:
96: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
97: FND_MESSAGE.SET_TOKEN('COLUMN', 'term_id');

Line 146: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_create_term procedure: Before call to LNS_TERMS_PKG.Insert_Row');

142: IF (p_loan_term_rec.next_payment_due_date is null) THEN
143: p_loan_term_rec.next_payment_due_date := p_loan_term_rec.first_payment_date;
144: END IF;
145:
146: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_create_term procedure: Before call to LNS_TERMS_PKG.Insert_Row');
147:
148: -- call table-handler.
149: LNS_TERMS_PKG.Insert_Row (X_TERM_ID => p_loan_term_rec.term_id
150: ,X_LOAN_ID => p_loan_term_rec.loan_id

Line 149: LNS_TERMS_PKG.Insert_Row (X_TERM_ID => p_loan_term_rec.term_id

145:
146: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_create_term procedure: Before call to LNS_TERMS_PKG.Insert_Row');
147:
148: -- call table-handler.
149: LNS_TERMS_PKG.Insert_Row (X_TERM_ID => p_loan_term_rec.term_id
150: ,X_LOAN_ID => p_loan_term_rec.loan_id
151: ,X_OBJECT_VERSION_NUMBER => 1
152: ,X_DAY_COUNT_METHOD => p_loan_term_rec.day_count_method
153: ,X_BASED_ON_BALANCE => p_loan_term_rec.based_on_balance

Line 211: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_create_term procedure: After call to LNS_TERMS.Insert_Row');

207: );
208:
209: x_term_id := p_loan_term_rec.term_id;
210:
211: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_create_term procedure: After call to LNS_TERMS.Insert_Row');
212:
213: END do_create_term;
214:
215:

Line 263: FROM LNS_TERMS

259: SELECT OBJECT_VERSION_NUMBER,
260: ROWID
261: INTO l_object_version_number,
262: l_rowid
263: FROM LNS_TERMS
264: WHERE TERM_ID = p_loan_term_rec.term_id
265: FOR UPDATE OF TERM_ID NOWAIT;
266:
267: IF NOT

Line 278: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_terms');

274: )
275: )
276: THEN
277: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
278: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_terms');
279: FND_MSG_PUB.ADD;
280: RAISE FND_API.G_EXC_ERROR;
281: END IF;
282:

Line 305: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_update_term procedure: Before call to LNS_TERMS_PKG.Update_Row');

301: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
303: END IF;
304:
305: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_update_term procedure: Before call to LNS_TERMS_PKG.Update_Row');
306:
307: p_object_version_number := nvl(l_object_version_number, 1) + 1;
308:
309: --Call to table-handler

Line 310: LNS_TERMS_PKG.Update_Row (

306:
307: p_object_version_number := nvl(l_object_version_number, 1) + 1;
308:
309: --Call to table-handler
310: LNS_TERMS_PKG.Update_Row (
311: X_Rowid => l_rowid,
312: X_TERM_ID => p_loan_term_rec.term_id,
313: X_LOAN_ID => p_loan_term_rec.loan_id,
314: X_OBJECT_VERSION_NUMBER => p_object_version_number,

Line 372: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_update_term procedure: After call to LNS_TERMS_PKG.Update_Row');

368: X_PENAL_INT_RATE => p_loan_term_rec.PENAL_INT_RATE,
369: X_PENAL_INT_GRACE_DAYS => p_loan_term_rec.PENAL_INT_GRACE_DAYS
370: );
371:
372: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_update_term procedure: After call to LNS_TERMS_PKG.Update_Row');
373:
374: END do_update_term;
375:
376: PROCEDURE default_delinquency_amount(

Line 419: LNS_TERMS_PUB.update_term(

415: l_loan_term_rec.delinquency_threshold_amount := l_delinq_amt;
416: l_loan_term_rec.loan_id := p_loan_id;
417: l_loan_term_rec.term_id := p_term_id;
418:
419: LNS_TERMS_PUB.update_term(
420: p_init_msg_list => FND_API.G_FALSE,
421: p_loan_term_rec => l_loan_term_rec,
422: p_object_version_number => p_object_version_number,
423: X_RETURN_STATUS => x_return_status,

Line 697: from lns_terms

693: /*
694: cursor c_validate_day_count(p_loan_id in number) is
695: select day_count_method
696: ,amortization_frequency
697: from lns_terms
698: where loan_id = p_loan_id;
699: */
700: BEGIN
701: l_loan_term_rec := p_loan_term_rec;

Line 825: LNS_TERMS_PKG.Select_Row (

821:
822: x_loan_term_rec.term_id := p_term_id;
823:
824: --Call to table-handler
825: LNS_TERMS_PKG.Select_Row (
826: X_TERM_ID => x_loan_term_rec.term_id,
827: X_LOAN_ID => x_loan_term_rec.loan_id,
828: X_DAY_COUNT_METHOD => x_loan_term_rec.day_count_method,
829: X_BASED_ON_BALANCE => x_loan_term_rec.based_on_balance,

Line 974: lns_terms term

970:
971: cursor c_interest_only_exists (p_loan_id number) is
972: select count(1)
973: from lns_rate_schedules rs,
974: lns_terms term
975: where term.loan_id = p_loan_id
976: and term.term_id = rs.term_id
977: and rs.interest_only_flag = 'Y'
978: and rs.phase <> 'OPEN';

Line 983: lns_terms term

979:
980: cursor c_max_int_installment(p_loan_id number) is
981: select max(end_installment_number)
982: from lns_rate_schedules rs,
983: lns_terms term
984: where term.loan_id = p_loan_id
985: and term.term_id = rs.term_id
986: and rs.interest_only_flag = 'Y'
987: and rs.phase <> 'OPEN';

Line 991: from lns_terms

987: and rs.phase <> 'OPEN';
988:
989: cursor c_reamortization(p_loan_id number) is
990: select nvl(reamortize_over_payment, 'N')
991: from lns_terms
992: where loan_id = p_loan_id;
993:
994: cursor c_first_payment_date(p_loan_id number) is
995: select first_payment_date

Line 996: from lns_terms

992: where loan_id = p_loan_id;
993:
994: cursor c_first_payment_date(p_loan_id number) is
995: select first_payment_date
996: from lns_terms
997: where loan_id = p_loan_id;
998:
999: begin
1000: l_api_name := 'validate_rate_schedule';

Line 1081: END LNS_TERMS_PUB;

1077:
1078: end validate_rate_schedule;
1079:
1080:
1081: END LNS_TERMS_PUB;