1 PACKAGE LNS_SAMPLE_HOOKS AUTHID CURRENT_USER as
2 /* $Header: LNS_SMPL_HOOKS_S.pls 120.1 2010/07/07 20:55:03 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 sample algorithm for shifting first interest payment and
14 | first principal payment dates on full disbursement payment in AP. New dates are returned back to caller.
15 |
16 | PSEUDO CODE/LOGIC
17 | NEW_INT_START_DATE = ORIG_INT_START_DATE + diff in months between ORIG_LOAN_START_DATE and NEW_LOAN_START_DATE
18 | NEW_PRIN_START_DATE = ORIG_PRIN_START_DATE + diff in months between ORIG_LOAN_START_DATE and NEW_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 /*========================================================================
58 | PUBLIC PROCEDURE CUSTOM_FEE_CALC
59 |
60 | DESCRIPTION
61 | This procedure implements sample custom fee calculation.
62 |
63 | PSEUDO CODE/LOGIC
64 |
65 |
66 | PARAMETERS
67 | P_LOAN_ID IN Input Loan ID
68 | P_FEE_ID IN Input fee id from lns_fees_all table
69 | P_INSTALLMENT IN Input installment number
70 | X_AMOUNT OUT NOCOPY Returned fee amount value
71 | X_ERROR OUT NOCOPY Returned error message.
72 |
73 | KNOWN ISSUES
74 | None
75 |
76 | NOTES
77 | Any interesting aspect of the code in the package body which needs
78 | to be stated.
79 |
80 | MODIFICATION HISTORY
81 | Date Author Description of Changes
82 | 07-01-2010 scherkas Created
83 |
84 *=======================================================================*/
85 PROCEDURE CUSTOM_FEE_CALC(
86 P_LOAN_ID IN NUMBER,
87 P_FEE_ID IN NUMBER,
88 P_INSTALLMENT IN NUMBER,
89 X_AMOUNT OUT NOCOPY VARCHAR2,
90 X_ERROR OUT NOCOPY VARCHAR2);
91
92
93 END ;