1 PACKAGE LNS_DEFAULT_HOOKS_PVT AUTHID CURRENT_USER as
2 /* $Header: LNS_DEF_HOOKS_S.pls 120.0.12010000.1 2009/07/02 17:41:28 scherkas noship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8
9 /*========================================================================
10 | PUBLIC PROCEDURE SHIFT_PAY_START_DATES
11 |
12 | DESCRIPTION
13 | This procedure implements default algorithm for shifting first interest payment and first principal payment dates
14 | on full disbursement payment in AP. New dates are returned back to caller.
15 |
16 | PSEUDO CODE/LOGIC
17 | NEW_INT_START_DATE = NEW_LOAN_START_DATE + diff in days between ORIG_INT_START_DATE and ORIG_LOAN_START_DATE
18 | NEW_PRIN_START_DATE = NEW_LOAN_START_DATE + diff in months between ORIG_PRIN_START_DATE and ORIG_LOAN_START_DATE
19 |
20 | PARAMETERS
21 | P_LOAN_ID IN Loan ID
22 | P_DISBURSEMENT_DATE IN Disbursement Date
23 | P_ORIG_LOAN_START_DATE IN Original loan start date
24 | P_ORIG_INT_START_DATE IN Original interest payment start date. Passed for all amortization methods.
25 | P_ORIG_PRIN_START_DATE IN Original principal payment start date. Passed only for Seperate Schedule method.
26 | P_ORIG_LOAN_MATUR_DATE IN Original loan maturity date
27 | P_NEW_LOAN_START_DATE IN New loan start date
28 | P_NEW_LOAN_MATUR_DATE IN OUT NOCOPY New loan maturity date. If changed - new value will be stored
29 | X_NEW_INT_START_DATE OUT NOCOPY New/calculated interest payment start date. Must be returned for all amortization methods.
30 | X_NEW_PRIN_START_DATE OUT NOCOPY New/calculated principal payment start date. Must be returned only for Seperate Schedule method.
31 |
32 | KNOWN ISSUES
33 | None
34 |
35 | NOTES
36 | Any interesting aspect of the code in the package body which needs
37 | to be stated.
38 |
39 | MODIFICATION HISTORY
40 | Date Author Description of Changes
41 | 12-23-2004 scherkas Created
42 |
43 *=======================================================================*/
44 PROCEDURE SHIFT_PAY_START_DATES(
45 P_LOAN_ID IN NUMBER,
46 P_DISBURSEMENT_DATE IN DATE,
47 P_ORIG_LOAN_START_DATE IN DATE,
48 P_ORIG_INT_START_DATE IN DATE,
49 P_ORIG_PRIN_START_DATE IN DATE,
50 P_ORIG_LOAN_MATUR_DATE IN DATE,
51 P_NEW_LOAN_START_DATE IN DATE,
52 P_NEW_LOAN_MATUR_DATE IN OUT NOCOPY DATE,
53 X_NEW_INT_START_DATE OUT NOCOPY DATE,
54 X_NEW_PRIN_START_DATE OUT NOCOPY DATE);
55
56
57 END;