[Home] [Help]
PACKAGE: APPS.OKL_PAY_CURE_REFUNDS_PUB
Source
1 PACKAGE OKL_PAY_CURE_REFUNDS_PUB AUTHID CURRENT_USER as
2 /* $Header: OKLPPCRS.pls 115.7 2003/04/19 16:41:14 jsanju noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL EXCEPTIONS
6 ---------------------------------------------------------------------------
7 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
8
9 ---------------------------------------------------------------------------
10 -- GLOBAL VARIABLES
11 ---------------------------------------------------------------------------
12 G_PKG_NAME CONSTANT VARCHAR2(200)
13 := 'OKL_PAY_CURE_REFUNDS_PUB';
14 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200)
16 := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
17 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
18 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
19 PG_DEBUG NUMBER := TO_NUMBER(NVL(FND_PROFILE.value('OKL_DEBUG_LEVEL'), '20'));
20 ---------------------------------------------------------------------------
21 ------------------------------------------------------------------------------
22 -- Global Record Type
23 ------------------------------------------------------------------------------
24 SUBTYPE pay_cure_refunds_rec_type IS
25 okl_pay_cure_refunds_pvt.pay_cure_refunds_rec_type;
26
27 SUBTYPE pay_cure_refunds_tbl_type IS
28 okl_pay_cure_refunds_pvt.pay_cure_refunds_tbl_type;
29
30 PROCEDURE create_refund_hdr
31 ( p_api_version IN NUMBER
32 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
33 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
34 ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
35 ,x_cure_refund_header_id OUT NOCOPY NUMBER
36 ,x_return_status OUT NOCOPY VARCHAR2
37 ,x_msg_count OUT NOCOPY NUMBER
38 ,x_msg_data OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE update_refund_hdr
42 ( p_api_version IN NUMBER
43 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
44 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
45 ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
46 ,x_return_status OUT NOCOPY VARCHAR2
47 ,x_msg_count OUT NOCOPY NUMBER
48 ,x_msg_data OUT NOCOPY VARCHAR2
49 );
50
51 PROCEDURE submit_cure_refund_hdr
52 ( p_api_version IN NUMBER
53 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
54 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
55 ,p_refund_header_id IN NUMBER
56 ,x_return_status OUT NOCOPY VARCHAR2
57 ,x_msg_count OUT NOCOPY NUMBER
58 ,x_msg_data OUT NOCOPY VARCHAR2
59 );
60
61 PROCEDURE delete_refund_hdr
62 ( p_api_version IN NUMBER
63 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
64 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
65 ,p_refund_header_id IN NUMBER
66 ,x_return_status OUT NOCOPY VARCHAR2
67 ,x_msg_count OUT NOCOPY NUMBER
68 ,x_msg_data OUT NOCOPY VARCHAR2
69 );
70
71 PROCEDURE approve_cure_refunds
72 ( p_api_version IN NUMBER
73 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
74 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
75 ,p_refund_header_id IN NUMBER
76 ,x_return_status OUT NOCOPY VARCHAR2
77 ,x_msg_count OUT NOCOPY NUMBER
78 ,x_msg_data OUT NOCOPY VARCHAR2
79 );
80
81
82
83
84 PROCEDURE create_refund_headers
85 ( p_api_version IN NUMBER
86 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
87 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
88 ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
89 ,x_cure_refund_header_id OUT NOCOPY NUMBER
90 ,x_return_status OUT NOCOPY VARCHAR2
91 ,x_msg_count OUT NOCOPY NUMBER
92 ,x_msg_data OUT NOCOPY VARCHAR2
93 );
94
95 PROCEDURE update_refund_headers
96 ( p_api_version IN NUMBER
97 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
98 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
99 ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
100 ,x_return_status OUT NOCOPY VARCHAR2
101 ,x_msg_count OUT NOCOPY NUMBER
102 ,x_msg_data OUT NOCOPY VARCHAR2
103 );
104
105 PROCEDURE create_refund_details
106 ( p_api_version IN NUMBER
107 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
108 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
109 ,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
110 ,x_return_status OUT NOCOPY VARCHAR2
111 ,x_msg_count OUT NOCOPY NUMBER
112 ,x_msg_data OUT NOCOPY VARCHAR2
113 );
114
115 PROCEDURE update_refund_details
116 ( p_api_version IN NUMBER
117 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
118 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
119 ,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
120 ,x_return_status OUT NOCOPY VARCHAR2
121 ,x_msg_count OUT NOCOPY NUMBER
122 ,x_msg_data OUT NOCOPY VARCHAR2
123 );
124
125 PROCEDURE delete_refund_details
126 ( p_api_version IN NUMBER
127 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
128 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
129 ,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
130 ,x_return_status OUT NOCOPY VARCHAR2
131 ,x_msg_count OUT NOCOPY NUMBER
132 ,x_msg_data OUT NOCOPY VARCHAR2
133 );
134
135
136 end OKL_PAY_CURE_REFUNDS_PUB;