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';
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
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
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
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
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
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
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
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
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
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
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
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
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
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