1 PACKAGE OKL_PAY_CURE_REFUNDS_PVT AUTHID CURRENT_USER as
2 /* $Header: OKLRPCRS.pls 115.12 2003/10/16 19:31:23 jsanju noship $ */
3
4
5 ---------------------------------------------------------------------------
6 -- GLOBAL VARIABLES
7 ---------------------------------------------------------------------------
8 G_PKG_NAME CONSTANT VARCHAR2(200)
9 := 'OKL_PAY_CURE_REFUNDS_PVT';
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
11 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200)
12 := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15 PG_DEBUG NUMBER := TO_NUMBER(NVL(FND_PROFILE.value('OKL_DEBUG_LEVEL'), '20'));
16 ---------------------------------------------------------------------------
17 ------------------------------------------------------------------------------
18 -- Global Record Type
19 ------------------------------------------------------------------------------
20 TYPE pay_cure_refunds_rec_type IS RECORD (
21 refund_number okl_cure_refunds.refund_number%type
22 ,vendor_site_id okl_cure_refunds.vendor_site_id%type
23 ,chr_id okl_cure_refunds.chr_id%type
24 ,invoice_date DATE
25 ,pay_terms okl_trx_ap_invoices_b.ippt_id%type
26 ,payment_method_code okl_trx_ap_invoices_b.payment_method_code%type
27 ,currency okl_trx_ap_invoices_b.currency_code%type
28 ,refund_header_id okl_cure_refund_headers_b.cure_refund_header_id%type
29 ,refund_id okl_cure_refunds.cure_refund_id%type
30 ,description okl_cure_refund_headers_tl.description%type
31 ,received_amount okl_cure_refund_headers_b.received_amount%type
32 ,negotiated_amount okl_cure_refund_headers_b.negotiated_amount%type
33 ,offset_amount okl_cure_refunds.offset_amount%type
34 ,offset_contract okl_cure_refunds.offset_contract%type
35 ,refund_amount_due okl_cure_refunds.total_refund_due%type
36 ,refund_amount okl_cure_refunds.disbursement_amount%type
37 ,refund_type okl_cure_refund_headers_b.refund_type%type
38 ,vendor_id po_vendor_sites_all.vendor_id%type
39 ,vendor_site_cure_due okl_cure_refund_headers_b.vendor_site_cure_due%type
40 ,vendor_cure_due okl_cure_refund_headers_b.vendor_cure_due%type
41 );
42 g_miss_pay_crf_rec_type pay_cure_refunds_rec_type;
43
44 TYPE pay_cure_refunds_tbl_type IS TABLE OF pay_cure_refunds_rec_type
45 INDEX BY BINARY_INTEGER;
46
47 PROCEDURE create_refund_hdr
48 ( p_api_version IN NUMBER
49 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
50 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
51 ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
52 ,x_cure_refund_header_id OUT NOCOPY NUMBER
53 ,x_return_status OUT NOCOPY VARCHAR2
54 ,x_msg_count OUT NOCOPY NUMBER
55 ,x_msg_data OUT NOCOPY VARCHAR2
56 );
57
58 PROCEDURE update_refund_hdr
59 ( p_api_version IN NUMBER
60 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
61 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
62 ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
63 ,x_return_status OUT NOCOPY VARCHAR2
64 ,x_msg_count OUT NOCOPY NUMBER
65 ,x_msg_data OUT NOCOPY VARCHAR2
66 );
67
68 PROCEDURE submit_cure_refund_hdr
69 ( p_api_version IN NUMBER
70 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
71 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
72 ,p_refund_header_id IN NUMBER
73 ,x_return_status OUT NOCOPY VARCHAR2
74 ,x_msg_count OUT NOCOPY NUMBER
75 ,x_msg_data OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE delete_refund_hdr
79 ( p_api_version IN NUMBER
80 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
81 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
82 ,p_refund_header_id IN NUMBER
83 ,x_return_status OUT NOCOPY VARCHAR2
84 ,x_msg_count OUT NOCOPY NUMBER
85 ,x_msg_data OUT NOCOPY VARCHAR2
86 );
87
88
89 PROCEDURE approve_cure_refunds
90 ( p_api_version IN NUMBER
91 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
92 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
93 ,p_refund_header_id IN NUMBER
94 ,x_return_status OUT NOCOPY VARCHAR2
95 ,x_msg_count OUT NOCOPY NUMBER
96 ,x_msg_data OUT NOCOPY VARCHAR2
97 );
98
99 PROCEDURE submit_cure_refunds
100 ( p_api_version IN NUMBER
101 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
102 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
103 ,p_status IN VARCHAR2
104 ,p_refund_header_id IN NUMBER
105 ,x_return_status OUT NOCOPY VARCHAR2
106 ,x_msg_count OUT NOCOPY NUMBER
107 ,x_msg_data OUT NOCOPY VARCHAR2
108 );
109
110
111
112 /**
113 called from the workflow to update cure refunds based on
114 the approval
115 **/
116
117 PROCEDURE set_approval_status (itemtype in varchar2,
118 itemkey in varchar2,
119 actid in number,
120 funcmode in varchar2,
121 result out nocopy varchar2);
122
123
124 PROCEDURE set_reject_status (itemtype in varchar2,
125 itemkey in varchar2,
126 actid in number,
127 funcmode in varchar2,
128 result out nocopy varchar2);
129 PROCEDURE create_refund_headers
130 ( p_api_version IN NUMBER
131 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
132 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
133 ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
134 ,x_cure_refund_header_id OUT NOCOPY NUMBER
135 ,x_return_status OUT NOCOPY VARCHAR2
136 ,x_msg_count OUT NOCOPY NUMBER
137 ,x_msg_data OUT NOCOPY VARCHAR2
138 );
139
140 PROCEDURE update_refund_headers
141 ( p_api_version IN NUMBER
142 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
143 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
144 ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
145 ,x_return_status OUT NOCOPY VARCHAR2
146 ,x_msg_count OUT NOCOPY NUMBER
147 ,x_msg_data OUT NOCOPY VARCHAR2
148 );
149
150 PROCEDURE create_refund_details
151 ( p_api_version IN NUMBER
152 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
153 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
154 ,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
155 ,x_return_status OUT NOCOPY VARCHAR2
156 ,x_msg_count OUT NOCOPY NUMBER
157 ,x_msg_data OUT NOCOPY VARCHAR2
158 );
159
160 PROCEDURE update_refund_details
161 ( p_api_version IN NUMBER
162 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
163 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
164 ,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
165 ,x_return_status OUT NOCOPY VARCHAR2
166 ,x_msg_count OUT NOCOPY NUMBER
167 ,x_msg_data OUT NOCOPY VARCHAR2
168 );
169
170 PROCEDURE delete_refund_details
171 ( p_api_version IN NUMBER
172 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
173 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
174 ,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
175 ,x_return_status OUT NOCOPY VARCHAR2
176 ,x_msg_count OUT NOCOPY NUMBER
177 ,x_msg_data OUT NOCOPY VARCHAR2
178 );
179
180 -- to generate a table of Offset contracts
181 PROCEDURE gen_doc (document_id IN VARCHAR2
182 ,display_type IN VARCHAR2
183 ,document IN OUT NOCOPY VARCHAR2
184 ,document_type IN OUT NOCOPY VARCHAR2);
185
186 end OKL_PAY_CURE_REFUNDS_PVT;