DBA Data[Home] [Help]

APPS.OKL_PAY_CURE_REFUNDS_PVT dependencies on OKC_API

Line 10: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

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

Line 49: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

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

Line 50: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 60: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

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

Line 61: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 70: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

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

Line 71: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 80: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

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

Line 81: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 91: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

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

Line 92: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 101: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

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

Line 102: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 131: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

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

Line 132: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 142: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

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

Line 143: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 152: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

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

Line 153: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 162: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

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

Line 163: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 172: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

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

Line 173: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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