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 177: from lns_custom_paymnt_scheds

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

Line 629: from lns_custom_paymnt_scheds

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

Line 1037: LNS_CUSTOM_PAYMNT_SCHEDS_PKG.INSERT_ROW(x_custom_schedule_id => l_custom_id

1033: l_api_name := 'createCustomSched';
1034: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1035:
1036: -- dbms_output.put_line('createCustomAPI' );
1037: LNS_CUSTOM_PAYMNT_SCHEDS_PKG.INSERT_ROW(x_custom_schedule_id => l_custom_id
1038: ,P_LOAN_ID => P_CUSTOM_REC.LOAN_ID
1039: ,P_PAYMENT_NUMBER => P_CUSTOM_REC.PAYMENT_NUMBER
1040: ,P_DUE_DATE => P_CUSTOM_REC.DUE_DATE
1041: ,P_PRINCIPAL_AMOUNT => P_CUSTOM_REC.PRINCIPAL_AMOUNT

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

1093: BEGIN
1094: l_api_name := 'updateCustomSched';
1095: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1096:
1097: LNS_UTILITY_PUB.GETOBJECTVERSION(P_TABLE_NAME => 'LNS_CUSTOM_PAYMNT_SCHEDS'
1098: ,P_PRIMARY_KEY_NAME => 'CUSTOM_SCHEDULE_ID'
1099: ,P_PRIMARY_KEY_VALUE => P_CUSTOM_REC.CUSTOM_SCHEDULE_ID
1100: ,P_OBJECT_VERSION_NUMBER => P_CUSTOM_REC.OBJECT_VERSION_NUMBER
1101: ,X_OBJECT_VERSION_NUMBER => l_object_version

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

1102: ,X_MSG_COUNT => l_msg_count
1103: ,X_MSG_DATA => l_msg_data
1104: ,X_RETURN_STATUS => l_return_status);
1105:
1106: LNS_CUSTOM_PAYMNT_SCHEDS_PKG.Update_Row(p_CUSTOM_SCHEDULE_ID => P_CUSTOM_REC.CUSTOM_SCHEDULE_ID
1107: ,p_LOAN_ID => P_CUSTOM_REC.LOAN_ID
1108: ,p_PAYMENT_NUMBER => P_CUSTOM_REC.PAYMENT_NUMBER
1109: ,p_DUE_DATE => P_CUSTOM_REC.DUE_DATE
1110: ,p_PRINCIPAL_AMOUNT => P_CUSTOM_REC.PRINCIPAL_AMOUNT

Line 1676: from LNS_CUSTOM_PAYMNT_SCHEDS

1672: nvl(FEE_AMOUNT, 0),
1673: nvl(OTHER_AMOUNT, 0),
1674: nvl(LOCK_PRIN, 'Y'),
1675: nvl(LOCK_INT, 'Y')
1676: from LNS_CUSTOM_PAYMNT_SCHEDS
1677: where loan_id = p_loan_id
1678: and PAYMENT_NUMBER > p_begin_installment
1679: order by PAYMENT_NUMBER;
1680:

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

1783:
1784: i := 0;
1785: OPEN c_load_sched(p_loan_id, l_loan_details.LAST_INSTALLMENT_BILLED);
1786:
1787: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Loading custom schedule from LNS_CUSTOM_PAYMNT_SCHEDS:');
1788: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PN DD PRIN LP INT LI FEE OTH ID');
1789: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, '--- -------- ------- -- ------- -- ----- ----- ------');
1790:
1791: LOOP

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

2916:
2917: l_loan_details := getLoanDetails(p_loan_Id => p_loan_id
2918: ,p_based_on_terms => P_BASED_ON_TERMS);
2919:
2920: -- invalidate all existent rows in LNS_CUSTOM_PAYMNT_SCHEDS greater than l_loan_details.LAST_INSTALLMENT_BILLED
2921: update LNS_CUSTOM_PAYMNT_SCHEDS
2922: set PAYMENT_NUMBER = -1
2923: where loan_id = p_loan_id
2924: and PAYMENT_NUMBER > l_loan_details.LAST_INSTALLMENT_BILLED;

Line 2921: update LNS_CUSTOM_PAYMNT_SCHEDS

2917: l_loan_details := getLoanDetails(p_loan_Id => p_loan_id
2918: ,p_based_on_terms => P_BASED_ON_TERMS);
2919:
2920: -- invalidate all existent rows in LNS_CUSTOM_PAYMNT_SCHEDS greater than l_loan_details.LAST_INSTALLMENT_BILLED
2921: update LNS_CUSTOM_PAYMNT_SCHEDS
2922: set PAYMENT_NUMBER = -1
2923: where loan_id = p_loan_id
2924: and PAYMENT_NUMBER > l_loan_details.LAST_INSTALLMENT_BILLED;
2925:

Line 2936: from LNS_CUSTOM_PAYMNT_SCHEDS

2932:
2933: -- getting info from lns_loan_headers_all
2934: select object_version_number
2935: into l_custom_rec.OBJECT_VERSION_NUMBER
2936: from LNS_CUSTOM_PAYMNT_SCHEDS
2937: where loan_id = p_loan_id and
2938: CUSTOM_SCHEDULE_ID = l_custom_tbl(i).CUSTOM_SCHEDULE_ID;
2939:
2940:

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

2973:
2974: end loop;
2975:
2976: -- deleting all invalid rows
2977: delete from LNS_CUSTOM_PAYMNT_SCHEDS where loan_id = p_loan_id and PAYMENT_NUMBER = -1;
2978:
2979: -- update all rows with action null
2980: for i in 1..l_custom_tbl.count loop
2981: l_custom_tbl(i).ACTION := null;

Line 3180: delete from LNS_CUSTOM_PAYMNT_SCHEDS

3176: -- allow to save initial custom schedule only if this loan is in INCOMPLETE status and is not customized yet
3177: -- if l_loan_details.loan_status = 'INCOMPLETE' and l_loan_details.CUSTOM_SCHEDULE = 'Y' then
3178: if l_loan_details.loan_status = 'INCOMPLETE' then
3179:
3180: delete from LNS_CUSTOM_PAYMNT_SCHEDS
3181: where loan_id = p_loan_id;
3182: /*
3183: -- getting info from lns_loan_headers_all
3184: select object_version_number

Line 3776: delete from LNS_CUSTOM_PAYMNT_SCHEDS

3772: -- allow to reBuild custom schedule only if this loan is in INCOMPLETE status
3773: --if l_loan_details.loan_status = 'INCOMPLETE' then
3774: if l_loan_details.loan_status = 'INCOMPLETE' and l_loan_details.CUSTOM_SCHEDULE = 'Y' then
3775:
3776: delete from LNS_CUSTOM_PAYMNT_SCHEDS
3777: where loan_id = p_loan_id
3778: and due_date > l_maturity_date;
3779:
3780: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Cust Rows might be deleted.');

Line 3857: from LNS_CUSTOM_PAYMNT_SCHEDS

3853:
3854: -- cursor to load custom schedule
3855: cursor c_load_sched(p_loan_id NUMBER, p_min_payment NUMBER) IS
3856: select PAYMENT_NUMBER, DUE_DATE
3857: from LNS_CUSTOM_PAYMNT_SCHEDS
3858: where loan_id = p_loan_id
3859: and PAYMENT_NUMBER >= p_min_payment
3860: order by PAYMENT_NUMBER;
3861:

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

3901: CLOSE c_built_payments;
3902:
3903: end if;
3904:
3905: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Loading dates from LNS_CUSTOM_PAYMNT_SCHEDS:');
3906: OPEN c_load_sched(p_loan_id, i);
3907: LOOP
3908:
3909: FETCH c_load_sched INTO l_payment_number, l_due_date;

Line 3970: from lns_custom_paymnt_scheds

3966:
3967: -- check is such payment already exist
3968: cursor c_exist_installment(p_loan_id NUMBER, p_payment_number NUMBER) IS
3969: select custom_schedule_id
3970: from lns_custom_paymnt_scheds
3971: where loan_id = p_loan_id
3972: and payment_number = p_payment_number;
3973:
3974: BEGIN