[Home] [Help]
PACKAGE: APPS.OKL_LA_PAYMENTS_PVT
Source
1 PACKAGE OKL_LA_PAYMENTS_PVT AS
2 /* $Header: OKLRPYTS.pls 120.5.12010000.2 2009/01/05 20:35:55 rkuttiya ship $ */
3 /* *************************************** */
4 /* 2003-OCT-15 Payment Details Enhancement bug 2757289 */
5 /* 2003-NOV-14 bug 3253989 */
6 /*-------------------------------------------------------------------------------------+
7 | --start of comments |
8 | --Description : ashariff - Created |
9 | -- History : 2003-OCT-15 ashariff - bug 2757289 |
10 | -- History : 2003-NOV-14 ashariff - bug 3253989 |
11 | -- end of comments |
12 | 06-02-2005 cklee/mvasudev -- Fixed Bug#4392051/okl.h 4437938 |
13 | 15-Sep-05 apaul 4542290 |
14 | Variable interest schedules made public with ICB and RRM to be called from |
15 | OKL_CONTRACT_PVT create API |
16 | 24-Aug-2006 cklee/rajose R12 bug#5514073-OKL.H bug#5441811 for incorrect payment |
17 | structure when adding stub days. |
18 | 24-Oct-2007 rpillay Bug# 6438785: Added procedure update_pymt_start_date to |
19 | update the payment start dates when the contract or |
20 | line start dates are changed. |
21 | 25-Oct-2007 rpillay Bug# 6438785: Added parameter p_validate_date_yn to procedure |
22 | calculate_details |
23 | 05-JAN-09 rkuttiya Bug # 7498330 Added parameter p_source_trx to procedure|
24 | delete_payment |
25 |-------------------------------------------------------------------------------------*/
26
27
28 TYPE pym_rec_type IS RECORD (
29 RULE_ID OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM,
30 STUB_DAYS OKC_RULES_V.RULE_INFORMATION7%TYPE := OKL_API.G_MISS_CHAR,
31 STUB_AMOUNT OKC_RULES_V.RULE_INFORMATION8%TYPE := OKL_API.G_MISS_CHAR,
32 PERIOD OKC_RULES_V.RULE_INFORMATION3%TYPE := OKL_API.G_MISS_CHAR,
33 AMOUNT OKC_RULES_V.RULE_INFORMATION4%TYPE := OKL_API.G_MISS_CHAR,
34 SORT_DATE OKC_RULES_V.RULE_INFORMATION2%TYPE := OKL_API.G_MISS_CHAR,
35 UPDATE_TYPE VARCHAR2(20) := OKL_API.G_MISS_CHAR
36 );
37
38
39 TYPE pym_del_rec_type IS RECORD (
40 CHR_ID OKC_K_HEADERS_B.ID%TYPE := OKL_API.G_MISS_NUM,
41 RGP_ID OKC_RULES_V.RGP_ID%TYPE := OKL_API.G_MISS_NUM,
42 SLH_ID OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM
43 );
44
45 TYPE pym_hdr_rec_type IS RECORD (
46 STRUCTURE VARCHAR2(1) DEFAULT NULL,
47 STRUCTURE_NAME VARCHAR2(2000) := OKL_API.G_MISS_CHAR,
48 FREQUENCY VARCHAR2(1) DEFAULT NULL,
49 FREQUENCY_NAME VARCHAR2(2000) := OKL_API.G_MISS_CHAR,
50 ARREARS VARCHAR2(1) DEFAULT NULL,
51 ARREARS_NAME VARCHAR2(2000) := OKL_API.G_MISS_CHAR
52 );
53
54
55 TYPE pym_tbl_type IS TABLE OF pym_rec_type INDEX BY BINARY_INTEGER;
56 TYPE pym_del_tbl_type IS TABLE OF pym_del_rec_type INDEX BY BINARY_INTEGER;
57 subtype rulv_rec_type is OKL_RULE_PUB.rulv_rec_type;
58 subtype rulv_tbl_type is OKL_RULE_PUB.rulv_tbl_type;
59
60
61 G_AK_REGION_NAME varchar2(19) := 'OKL_LA_PAYMENTS';
62
63
64 PROCEDURE process_payment(
65 p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
71 p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
72 p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
73 p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,
74 p_pym_hdr_rec IN pym_hdr_rec_type,
75 p_pym_tbl IN pym_tbl_type,
76 p_update_type IN VARCHAR2 DEFAULT 'UPDATE',
77 x_rulv_tbl OUT NOCOPY rulv_tbl_type);
78
79
80 PROCEDURE process_payment(
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_chr_id OKC_K_HEADERS_B.ID%TYPE,
87 p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
88 p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
89 p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
90 p_update_type IN VARCHAR2,
91 x_rulv_tbl OUT NOCOPY rulv_tbl_type);
92
93
94 FUNCTION get_display_end_date(
95 p_start_date IN VARCHAR2,
96 p_stub_days IN VARCHAR2 DEFAULT NULL,
97 p_frequency IN VARCHAR2,
98 p_period IN VARCHAR2 DEFAULT NULL,
99 ---- mvasudev,06-02-2005,Bug#4392051
100 p_start_day IN NUMBER DEFAULT NULL,
101 p_contract_end_date IN DATE DEFAULT NULL --Bug#5441811
102 )
103 RETURN VARCHAR2;
104
105 FUNCTION get_order_sequence(
106 p_sequence IN VARCHAR2)
107 RETURN number;
108
109 PROCEDURE calculate_details(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_chr_id IN NUMBER,
116 p_rgp_id IN NUMBER,
117 p_slh_id IN VARCHAR2,
118 structure IN VARCHAR2 DEFAULT NULL,
119 frequency IN VARCHAR2 DEFAULT NULL,
120 arrears IN VARCHAR2 DEFAULT NULL,
121 -- Bug# 6438785
122 p_validate_date_yn IN VARCHAR2 DEFAULT 'Y');
123
124 PROCEDURE delete_payment(
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_del_pym_tbl IN pym_del_tbl_type,
131 -- Bug # 7498330
132 p_source_trx IN VARCHAR2 DEFAULT 'NA');
133
134 FUNCTION get_start_day(
135 p_rule_id IN NUMBER
136 ,p_dnz_chr_id IN NUMBER
137 ,p_rgp_id IN NUMBER
138 ,p_slh_id IN NUMBER
139 ,p_start_date IN VARCHAR2)
140 RETURN NUMBER;
141
142 PROCEDURE variable_interest_schedule(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_chr_id IN NUMBER,
149 x_rulv_tbl OUT NOCOPY rulv_tbl_type
150 );
151
152 -- Bug# 6438785
153 -- Update the start dates for payments when the Contract start date
154 -- or Line start date is changed.
155 PROCEDURE update_pymt_start_date(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_chr_id IN NUMBER,
162 p_cle_id IN NUMBER DEFAULT NULL);
163
164
165 /* *************************************** */
166 END OKL_LA_PAYMENTS_PVT;