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_CUSTOM_PUB dependencies on LNS_CUSTOM_PAYMNT_SCHEDS

Line 180: from lns_custom_paymnt_scheds

176: end if;
177:
178: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - deleting custom rows');
179: delete
180: from lns_custom_paymnt_scheds
181: where loan_id = p_loan_id;
182:
183: end if;
184:

Line 634: from lns_custom_paymnt_scheds

630:
631: -- we will need to get the PK since runAmortization API does not reutrn PKs
632: cursor c_cust_sched_id (p_loan_id number, p_payment_number number) is
633: select custom_schedule_id, object_version_number
634: from lns_custom_paymnt_scheds
635: where loan_id = p_loan_id
636: and payment_number = p_payment_number;
637:
638: begin

Line 1042: LNS_CUSTOM_PAYMNT_SCHEDS_PKG.INSERT_ROW(x_custom_schedule_id => l_custom_id

1038: l_api_name := 'createCustomSched';
1039: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1040:
1041: -- dbms_output.put_line('createCustomAPI' );
1042: LNS_CUSTOM_PAYMNT_SCHEDS_PKG.INSERT_ROW(x_custom_schedule_id => l_custom_id
1043: ,P_LOAN_ID => P_CUSTOM_REC.LOAN_ID
1044: ,P_PAYMENT_NUMBER => P_CUSTOM_REC.PAYMENT_NUMBER
1045: ,P_DUE_DATE => P_CUSTOM_REC.DUE_DATE
1046: ,P_PRINCIPAL_AMOUNT => P_CUSTOM_REC.PRINCIPAL_AMOUNT

Line 1103: LNS_UTILITY_PUB.GETOBJECTVERSION(P_TABLE_NAME => 'LNS_CUSTOM_PAYMNT_SCHEDS'

1099: BEGIN
1100: l_api_name := 'updateCustomSched';
1101: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1102:
1103: LNS_UTILITY_PUB.GETOBJECTVERSION(P_TABLE_NAME => 'LNS_CUSTOM_PAYMNT_SCHEDS'
1104: ,P_PRIMARY_KEY_NAME => 'CUSTOM_SCHEDULE_ID'
1105: ,P_PRIMARY_KEY_VALUE => P_CUSTOM_REC.CUSTOM_SCHEDULE_ID
1106: ,P_OBJECT_VERSION_NUMBER => P_CUSTOM_REC.OBJECT_VERSION_NUMBER
1107: ,X_OBJECT_VERSION_NUMBER => l_object_version

Line 1112: LNS_CUSTOM_PAYMNT_SCHEDS_PKG.Update_Row(p_CUSTOM_SCHEDULE_ID => P_CUSTOM_REC.CUSTOM_SCHEDULE_ID

1108: ,X_MSG_COUNT => l_msg_count
1109: ,X_MSG_DATA => l_msg_data
1110: ,X_RETURN_STATUS => l_return_status);
1111:
1112: LNS_CUSTOM_PAYMNT_SCHEDS_PKG.Update_Row(p_CUSTOM_SCHEDULE_ID => P_CUSTOM_REC.CUSTOM_SCHEDULE_ID
1113: ,p_LOAN_ID => P_CUSTOM_REC.LOAN_ID
1114: ,p_PAYMENT_NUMBER => P_CUSTOM_REC.PAYMENT_NUMBER
1115: ,p_DUE_DATE => P_CUSTOM_REC.DUE_DATE
1116: ,p_PRINCIPAL_AMOUNT => P_CUSTOM_REC.PRINCIPAL_AMOUNT

Line 1849: from LNS_CUSTOM_PAYMNT_SCHEDS

1845: nvl(FEE_AMOUNT, 0),
1846: nvl(OTHER_AMOUNT, 0),
1847: nvl(LOCK_PRIN, 'Y'),
1848: nvl(LOCK_INT, 'Y')
1849: from LNS_CUSTOM_PAYMNT_SCHEDS
1850: where loan_id = p_loan_id
1851: and PAYMENT_NUMBER > p_begin_installment
1852: order by PAYMENT_NUMBER;
1853:

Line 1981: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Loading custom schedule from LNS_CUSTOM_PAYMNT_SCHEDS:');

1977:
1978: i := 0;
1979: OPEN c_load_sched(p_loan_id, l_loan_details.LAST_INSTALLMENT_BILLED);
1980:
1981: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Loading custom schedule from LNS_CUSTOM_PAYMNT_SCHEDS:');
1982: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PN DD PRIN(%) LP INT LI FEE OTH ID');
1983: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, '--- -------- ------- -- ------- -- ----- ----- ------');
1984:
1985: LOOP

Line 3626: -- invalidate all existent rows in LNS_CUSTOM_PAYMNT_SCHEDS greater than l_loan_details.LAST_INSTALLMENT_BILLED

3622:
3623: l_loan_details := getLoanDetails(p_loan_Id => p_loan_id
3624: ,p_based_on_terms => P_BASED_ON_TERMS);
3625:
3626: -- invalidate all existent rows in LNS_CUSTOM_PAYMNT_SCHEDS greater than l_loan_details.LAST_INSTALLMENT_BILLED
3627: update LNS_CUSTOM_PAYMNT_SCHEDS
3628: set PAYMENT_NUMBER = -1
3629: where loan_id = p_loan_id
3630: and PAYMENT_NUMBER > l_loan_details.LAST_INSTALLMENT_BILLED;

Line 3627: update LNS_CUSTOM_PAYMNT_SCHEDS

3623: l_loan_details := getLoanDetails(p_loan_Id => p_loan_id
3624: ,p_based_on_terms => P_BASED_ON_TERMS);
3625:
3626: -- invalidate all existent rows in LNS_CUSTOM_PAYMNT_SCHEDS greater than l_loan_details.LAST_INSTALLMENT_BILLED
3627: update LNS_CUSTOM_PAYMNT_SCHEDS
3628: set PAYMENT_NUMBER = -1
3629: where loan_id = p_loan_id
3630: and PAYMENT_NUMBER > l_loan_details.LAST_INSTALLMENT_BILLED;
3631:

Line 3648: from LNS_CUSTOM_PAYMNT_SCHEDS

3644:
3645: -- getting info from lns_loan_headers_all
3646: select object_version_number
3647: into l_custom_rec.OBJECT_VERSION_NUMBER
3648: from LNS_CUSTOM_PAYMNT_SCHEDS
3649: where loan_id = p_loan_id and
3650: CUSTOM_SCHEDULE_ID = l_custom_tbl(i).CUSTOM_SCHEDULE_ID;
3651:
3652:

Line 3706: delete from LNS_CUSTOM_PAYMNT_SCHEDS where loan_id = p_loan_id and PAYMENT_NUMBER = -1;

3702:
3703: end if;
3704:
3705: -- deleting all invalid rows
3706: delete from LNS_CUSTOM_PAYMNT_SCHEDS where loan_id = p_loan_id and PAYMENT_NUMBER = -1;
3707: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Deleted records with -1');
3708:
3709: -- update all rows with action null
3710: for i in 1..l_custom_tbl.count loop

Line 3933: delete from LNS_CUSTOM_PAYMNT_SCHEDS

3929: -- allow to save initial custom schedule only if this loan is in INCOMPLETE status and is not customized yet
3930: -- if l_loan_details.loan_status = 'INCOMPLETE' and l_loan_details.CUSTOM_SCHEDULE = 'Y' then
3931: if l_loan_details.loan_status = 'INCOMPLETE' then
3932:
3933: delete from LNS_CUSTOM_PAYMNT_SCHEDS
3934: where loan_id = p_loan_id;
3935: /*
3936: -- getting info from lns_loan_headers_all
3937: select object_version_number

Line 4591: delete from LNS_CUSTOM_PAYMNT_SCHEDS

4587: -- allow to reBuild custom schedule only if this loan is in INCOMPLETE status
4588: --if l_loan_details.loan_status = 'INCOMPLETE' then
4589: if l_loan_details.loan_status = 'INCOMPLETE' and l_loan_details.CUSTOM_SCHEDULE = 'Y' then
4590:
4591: delete from LNS_CUSTOM_PAYMNT_SCHEDS
4592: where loan_id = p_loan_id
4593: and due_date > l_maturity_date;
4594:
4595: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Cust Rows might be deleted.');

Line 4669: from LNS_CUSTOM_PAYMNT_SCHEDS

4665:
4666: -- cursor to load custom schedule
4667: cursor c_load_sched(p_loan_id NUMBER, p_min_payment NUMBER) IS
4668: select PAYMENT_NUMBER, DUE_DATE
4669: from LNS_CUSTOM_PAYMNT_SCHEDS
4670: where loan_id = p_loan_id
4671: and PAYMENT_NUMBER >= p_min_payment
4672: order by PAYMENT_NUMBER;
4673:

Line 4717: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Loading dates from LNS_CUSTOM_PAYMNT_SCHEDS:');

4713: CLOSE c_built_payments;
4714:
4715: end if;
4716:
4717: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Loading dates from LNS_CUSTOM_PAYMNT_SCHEDS:');
4718: OPEN c_load_sched(p_loan_id, i);
4719: LOOP
4720:
4721: FETCH c_load_sched INTO l_payment_number, l_due_date;

Line 4782: from lns_custom_paymnt_scheds

4778:
4779: -- check is such payment already exist
4780: cursor c_exist_installment(p_loan_id NUMBER, p_payment_number NUMBER) IS
4781: select custom_schedule_id
4782: from lns_custom_paymnt_scheds
4783: where loan_id = p_loan_id
4784: and payment_number = p_payment_number;
4785:
4786: BEGIN