DBA Data[Home] [Help]

APPS.OKL_ACCT_EVENT_PVT dependencies on OKC_API

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

12:
13: ------------------------------------------------------------------------------
14: -- Global Variables
15: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACCT_EVENT_PVT';
16: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
17: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
18: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
19: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
20: ------------------------------------------------------------------------------

Line 30: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

26:
27: --Object type procedure for insert
28: PROCEDURE create_acct_event(
29: p_api_version IN NUMBER
30: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
31: ,x_return_status OUT NOCOPY VARCHAR2
32: ,x_msg_count OUT NOCOPY NUMBER
33: ,x_msg_data OUT NOCOPY VARCHAR2
34: ,p_aetv_rec IN aetv_rec_type

Line 47: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

43:
44: --Object type procedure for update
45: PROCEDURE update_acct_event(
46: p_api_version IN NUMBER
47: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
48: ,x_return_status OUT NOCOPY VARCHAR2
49: ,x_msg_count OUT NOCOPY NUMBER
50: ,x_msg_data OUT NOCOPY VARCHAR2
51: ,p_aetv_rec IN aetv_rec_type

Line 62: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

58:
59: --Object type procedure for validate
60: PROCEDURE validate_acct_event(
61: p_api_version IN NUMBER
62: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
63: ,x_return_status OUT NOCOPY VARCHAR2
64: ,x_msg_count OUT NOCOPY NUMBER
65: ,x_msg_data OUT NOCOPY VARCHAR2
66: ,p_aetv_rec IN aetv_rec_type

Line 74: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

70:
71:
72: PROCEDURE create_acct_event(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
77: x_msg_data OUT NOCOPY VARCHAR2,
78: p_aetv_tbl IN aetv_tbl_type,

Line 83: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

79: x_aetv_tbl OUT NOCOPY aetv_tbl_type);
80:
81: PROCEDURE create_acct_event(
82: p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_msg_count OUT NOCOPY NUMBER,
86: x_msg_data OUT NOCOPY VARCHAR2,
87: p_aetv_rec IN aetv_rec_type,

Line 92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

88: x_aetv_rec OUT NOCOPY aetv_rec_type);
89:
90: PROCEDURE lock_acct_event(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_aetv_tbl IN aetv_tbl_type);

Line 100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

96: p_aetv_tbl IN aetv_tbl_type);
97:
98: PROCEDURE lock_acct_event(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_aetv_rec IN aetv_rec_type);

Line 108: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

104: p_aetv_rec IN aetv_rec_type);
105:
106: PROCEDURE update_acct_event(
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
112: p_aetv_tbl IN aetv_tbl_type,

Line 117: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

113: x_aetv_tbl OUT NOCOPY aetv_tbl_type);
114:
115: PROCEDURE update_acct_event(
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_aetv_rec IN aetv_rec_type,

Line 126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

122: x_aetv_rec OUT NOCOPY aetv_rec_type);
123:
124: PROCEDURE delete_acct_event(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_aetv_tbl IN aetv_tbl_type);

Line 134: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

130: p_aetv_tbl IN aetv_tbl_type);
131:
132: PROCEDURE delete_acct_event(
133: p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,
138: p_aetv_rec IN aetv_rec_type);

Line 142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

138: p_aetv_rec IN aetv_rec_type);
139:
140: PROCEDURE validate_acct_event(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_aetv_tbl IN aetv_tbl_type);

Line 150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

146: p_aetv_tbl IN aetv_tbl_type);
147:
148: PROCEDURE validate_acct_event(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_aetv_rec IN aetv_rec_type);

Line 159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

155:
156:
157: PROCEDURE create_acct_header(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_aehv_tbl IN aehv_tbl_type,

Line 168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

164: x_aehv_tbl OUT NOCOPY aehv_tbl_type);
165:
166: PROCEDURE create_acct_header(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_aehv_rec IN aehv_rec_type,

Line 177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

173: x_aehv_rec OUT NOCOPY aehv_rec_type);
174:
175: PROCEDURE lock_acct_header(
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_aehv_tbl IN aehv_tbl_type);

Line 185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

181: p_aehv_tbl IN aehv_tbl_type);
182:
183: PROCEDURE lock_acct_header(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_aehv_rec IN aehv_rec_type);

Line 193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

189: p_aehv_rec IN aehv_rec_type);
190:
191: PROCEDURE update_acct_header(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_aehv_tbl IN aehv_tbl_type,

Line 202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

198: x_aehv_tbl OUT NOCOPY aehv_tbl_type);
199:
200: PROCEDURE update_acct_header(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_aehv_rec IN aehv_rec_type,

Line 211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

207: x_aehv_rec OUT NOCOPY aehv_rec_type);
208:
209: PROCEDURE delete_acct_header(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_aehv_tbl IN aehv_tbl_type);

Line 219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

215: p_aehv_tbl IN aehv_tbl_type);
216:
217: PROCEDURE delete_acct_header(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_aehv_rec IN aehv_rec_type);

Line 227: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

223: p_aehv_rec IN aehv_rec_type);
224:
225: PROCEDURE validate_acct_header(
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: p_aehv_tbl IN aehv_tbl_type);

Line 235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

231: p_aehv_tbl IN aehv_tbl_type);
232:
233: PROCEDURE validate_acct_header(
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2,
239: p_aehv_rec IN aehv_rec_type);

Line 244: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

240:
241:
242: PROCEDURE create_acct_lines(
243: p_api_version IN NUMBER,
244: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,
248: p_aelv_tbl IN aelv_tbl_type,

Line 253: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

249: x_aelv_tbl OUT NOCOPY aelv_tbl_type);
250:
251: PROCEDURE create_acct_lines(
252: p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: p_aelv_rec IN aelv_rec_type,

Line 262: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

258: x_aelv_rec OUT NOCOPY aelv_rec_type);
259:
260: PROCEDURE lock_acct_lines(
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2,
266: p_aelv_tbl IN aelv_tbl_type);

Line 270: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

266: p_aelv_tbl IN aelv_tbl_type);
267:
268: PROCEDURE lock_acct_lines(
269: p_api_version IN NUMBER,
270: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
271: x_return_status OUT NOCOPY VARCHAR2,
272: x_msg_count OUT NOCOPY NUMBER,
273: x_msg_data OUT NOCOPY VARCHAR2,
274: p_aelv_rec IN aelv_rec_type);

Line 278: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

274: p_aelv_rec IN aelv_rec_type);
275:
276: PROCEDURE update_acct_lines(
277: p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_msg_count OUT NOCOPY NUMBER,
281: x_msg_data OUT NOCOPY VARCHAR2,
282: p_aelv_tbl IN aelv_tbl_type,

Line 287: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

283: x_aelv_tbl OUT NOCOPY aelv_tbl_type);
284:
285: PROCEDURE update_acct_lines(
286: p_api_version IN NUMBER,
287: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
288: x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2,
291: p_aelv_rec IN aelv_rec_type,

Line 296: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

292: x_aelv_rec OUT NOCOPY aelv_rec_type);
293:
294: PROCEDURE delete_acct_lines(
295: p_api_version IN NUMBER,
296: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
297: x_return_status OUT NOCOPY VARCHAR2,
298: x_msg_count OUT NOCOPY NUMBER,
299: x_msg_data OUT NOCOPY VARCHAR2,
300: p_aelv_tbl IN aelv_tbl_type);

Line 304: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

300: p_aelv_tbl IN aelv_tbl_type);
301:
302: PROCEDURE delete_acct_lines(
303: p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
305: x_return_status OUT NOCOPY VARCHAR2,
306: x_msg_count OUT NOCOPY NUMBER,
307: x_msg_data OUT NOCOPY VARCHAR2,
308: p_aelv_rec IN aelv_rec_type);

Line 312: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

308: p_aelv_rec IN aelv_rec_type);
309:
310: PROCEDURE validate_acct_lines(
311: p_api_version IN NUMBER,
312: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
313: x_return_status OUT NOCOPY VARCHAR2,
314: x_msg_count OUT NOCOPY NUMBER,
315: x_msg_data OUT NOCOPY VARCHAR2,
316: p_aelv_tbl IN aelv_tbl_type);

Line 320: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

316: p_aelv_tbl IN aelv_tbl_type);
317:
318: PROCEDURE validate_acct_lines(
319: p_api_version IN NUMBER,
320: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
321: x_return_status OUT NOCOPY VARCHAR2,
322: x_msg_count OUT NOCOPY NUMBER,
323: x_msg_data OUT NOCOPY VARCHAR2,
324: p_aelv_rec IN aelv_rec_type);