[Home] [Help]
PACKAGE: APPS.OKL_LA_PAYMENTS_PVT
Source
1 PACKAGE OKL_LA_PAYMENTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRPYTS.pls 120.6.12020000.2 2012/08/07 13:15:39 rpillay 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 | 09-May-2012 bkatraga BUG#13478101 : Added parameter p_update_type to procedure |
26 | calculate_details |
27 |-------------------------------------------------------------------------------------*/
28
29
30 TYPE pym_rec_type IS RECORD (
31 RULE_ID OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM,
32 STUB_DAYS OKC_RULES_V.RULE_INFORMATION7%TYPE := OKL_API.G_MISS_CHAR,
33 STUB_AMOUNT OKC_RULES_V.RULE_INFORMATION8%TYPE := OKL_API.G_MISS_CHAR,
34 PERIOD OKC_RULES_V.RULE_INFORMATION3%TYPE := OKL_API.G_MISS_CHAR,
35 AMOUNT OKC_RULES_V.RULE_INFORMATION4%TYPE := OKL_API.G_MISS_CHAR,
36 SORT_DATE OKC_RULES_V.RULE_INFORMATION2%TYPE := OKL_API.G_MISS_CHAR,
37 UPDATE_TYPE VARCHAR2(20) := OKL_API.G_MISS_CHAR
38 );
39
40
41 TYPE pym_del_rec_type IS RECORD (
42 CHR_ID OKC_K_HEADERS_B.ID%TYPE := OKL_API.G_MISS_NUM,
43 RGP_ID OKC_RULES_V.RGP_ID%TYPE := OKL_API.G_MISS_NUM,
44 SLH_ID OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM
45 );
46
47 TYPE pym_hdr_rec_type IS RECORD (
48 STRUCTURE VARCHAR2(1) DEFAULT NULL,
49 STRUCTURE_NAME VARCHAR2(2000) := OKL_API.G_MISS_CHAR,
50 FREQUENCY VARCHAR2(1) DEFAULT NULL,
51 FREQUENCY_NAME VARCHAR2(2000) := OKL_API.G_MISS_CHAR,
52 ARREARS VARCHAR2(1) DEFAULT NULL,
53 ARREARS_NAME VARCHAR2(2000) := OKL_API.G_MISS_CHAR
54 );
55
56
57 TYPE pym_tbl_type IS TABLE OF pym_rec_type INDEX BY BINARY_INTEGER;
58 TYPE pym_del_tbl_type IS TABLE OF pym_del_rec_type INDEX BY BINARY_INTEGER;
59 subtype rulv_rec_type is OKL_RULE_PUB.rulv_rec_type;
60 subtype rulv_tbl_type is OKL_RULE_PUB.rulv_tbl_type;
61
62
63 G_AK_REGION_NAME varchar2(19) := 'OKL_LA_PAYMENTS';
64
65
66 PROCEDURE process_payment(
67 p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
73 p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
74 p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
75 p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,
76 p_pym_hdr_rec IN pym_hdr_rec_type,
77 p_pym_tbl IN pym_tbl_type,
78 p_update_type IN VARCHAR2 DEFAULT 'UPDATE',
79 x_rulv_tbl OUT NOCOPY rulv_tbl_type);
80
81
82 PROCEDURE process_payment(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 p_chr_id OKC_K_HEADERS_B.ID%TYPE,
89 p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
90 p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
91 p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
92 p_update_type IN VARCHAR2,
93 x_rulv_tbl OUT NOCOPY rulv_tbl_type);
94
95
96 FUNCTION get_display_end_date(
97 p_start_date IN VARCHAR2,
98 p_stub_days IN VARCHAR2 DEFAULT NULL,
99 p_frequency IN VARCHAR2,
100 p_period IN VARCHAR2 DEFAULT NULL,
101 ---- mvasudev,06-02-2005,Bug#4392051
102 p_start_day IN NUMBER DEFAULT NULL,
103 p_contract_end_date IN DATE DEFAULT NULL --Bug#5441811
104 )
105 RETURN VARCHAR2;
106
107 FUNCTION get_order_sequence(
108 p_sequence IN VARCHAR2)
109 RETURN number;
110
111 --Added p_update_type by bkatraga for bug 13478101
112 PROCEDURE calculate_details(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_chr_id IN NUMBER,
119 p_rgp_id IN NUMBER,
120 p_slh_id IN VARCHAR2,
121 structure IN VARCHAR2 DEFAULT NULL,
122 frequency IN VARCHAR2 DEFAULT NULL,
123 arrears IN VARCHAR2 DEFAULT NULL,
124 -- Bug# 6438785
125 p_validate_date_yn IN VARCHAR2 DEFAULT 'Y',
126 p_update_type IN VARCHAR2 DEFAULT NULL);
127
128 PROCEDURE delete_payment(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_del_pym_tbl IN pym_del_tbl_type,
135 -- Bug # 7498330
136 p_source_trx IN VARCHAR2 DEFAULT 'NA');
137
138 FUNCTION get_start_day(
139 p_rule_id IN NUMBER
140 ,p_dnz_chr_id IN NUMBER
141 ,p_rgp_id IN NUMBER
142 ,p_slh_id IN NUMBER
143 ,p_start_date IN VARCHAR2)
144 RETURN NUMBER;
145
146 PROCEDURE variable_interest_schedule(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_chr_id IN NUMBER,
153 x_rulv_tbl OUT NOCOPY rulv_tbl_type
154 );
155
156 -- Bug# 6438785
157 -- Update the start dates for payments when the Contract start date
158 -- or Line start date is changed.
159 PROCEDURE update_pymt_start_date(
160 p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_chr_id IN NUMBER,
166 p_cle_id IN NUMBER DEFAULT NULL);
167
168
169 /* *************************************** */
170 END OKL_LA_PAYMENTS_PVT;