DBA Data[Home] [Help]

APPS.OKC_PRICE_ADJUSTMENT_PUB dependencies on OKC_API

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

21: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
22: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
24: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_GROUP_PUB';
25: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
26: PROCEDURE create_price_adjustment(
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
29: x_return_status OUT NOCOPY VARCHAR2,

Line 28: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

24: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_GROUP_PUB';
25: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
26: PROCEDURE create_price_adjustment(
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32: p_patv_rec IN patv_rec_type,

Line 37: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

33: x_patv_rec OUT NOCOPY patv_rec_type);
34:
35: PROCEDURE create_price_adjustment(
36: p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: p_patv_tbl IN patv_tbl_type,

Line 46: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

42: x_patv_tbl OUT NOCOPY patv_tbl_type);
43:
44: PROCEDURE update_price_adjustment(
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_count OUT NOCOPY NUMBER,
49: x_msg_data OUT NOCOPY VARCHAR2,
50: p_patv_rec IN patv_rec_type,

Line 55: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

51: x_patv_rec OUT NOCOPY patv_rec_type);
52:
53: PROCEDURE update_price_adjustment(
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2,
59: p_patv_tbl IN patv_tbl_type,

Line 64: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

60: x_patv_tbl OUT NOCOPY patv_tbl_type);
61:
62: PROCEDURE delete_price_adjustment(
63: p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2,
68: p_patv_rec IN patv_rec_type);

Line 72: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

68: p_patv_rec IN patv_rec_type);
69:
70: PROCEDURE delete_price_adjustment(
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,
76: p_patv_tbl IN patv_tbl_type);

Line 80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

76: p_patv_tbl IN patv_tbl_type);
77:
78: PROCEDURE validate_price_adjustment(
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_patv_rec IN patv_rec_type);

Line 88: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

84: p_patv_rec IN patv_rec_type);
85:
86: PROCEDURE validate_price_adjustment(
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
92: p_patv_tbl IN patv_tbl_type);

Line 96: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

92: p_patv_tbl IN patv_tbl_type);
93:
94: PROCEDURE lock_price_adjustment(
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_patv_rec IN patv_rec_type);

Line 104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

100: p_patv_rec IN patv_rec_type);
101:
102: PROCEDURE lock_price_adjustment(
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_patv_tbl IN patv_tbl_type);

Line 114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

110:
111:
112: PROCEDURE create_price_adj_assoc(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_pacv_rec IN pacv_rec_type,

Line 123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

119: x_pacv_rec OUT NOCOPY pacv_rec_type);
120:
121: PROCEDURE create_price_adj_assoc(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_pacv_tbl IN pacv_tbl_type,

Line 132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

128: x_pacv_tbl OUT NOCOPY pacv_tbl_type);
129:
130: PROCEDURE update_price_adj_assoc(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_pacv_rec IN pacv_rec_type,

Line 141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

137: x_pacv_rec OUT NOCOPY pacv_rec_type);
138:
139: PROCEDURE update_price_adj_assoc(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_pacv_tbl IN pacv_tbl_type,

Line 150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

146: x_pacv_tbl OUT NOCOPY pacv_tbl_type);
147:
148: PROCEDURE delete_price_adj_assoc(
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_pacv_rec IN pacv_rec_type);

Line 158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

154: p_pacv_rec IN pacv_rec_type);
155:
156: PROCEDURE delete_price_adj_assoc(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_pacv_tbl IN pacv_tbl_type );

Line 166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

162: p_pacv_tbl IN pacv_tbl_type );
163:
164: PROCEDURE validate_price_adj_assoc(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_pacv_rec IN pacv_rec_type);

Line 174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

170: p_pacv_rec IN pacv_rec_type);
171:
172: PROCEDURE validate_price_adj_assoc(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_pacv_tbl IN pacv_tbl_type);

Line 182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

178: p_pacv_tbl IN pacv_tbl_type);
179:
180: PROCEDURE lock_price_adj_assoc(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_pacv_rec IN pacv_rec_type );

Line 190: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

186: p_pacv_rec IN pacv_rec_type );
187:
188: PROCEDURE lock_price_adj_assoc(
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
194: p_pacv_tbl IN pacv_tbl_type );

Line 198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

194: p_pacv_tbl IN pacv_tbl_type );
195:
196: PROCEDURE create_price_att_value(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_pavv_rec IN pavv_rec_type,

Line 207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

203: x_pavv_rec OUT NOCOPY pavv_rec_type);
204:
205: PROCEDURE create_price_att_value(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_pavv_tbl IN pavv_tbl_type,

Line 217: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

213:
214:
215: PROCEDURE update_price_att_value(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_pavv_rec IN pavv_rec_type,

Line 226: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

222: x_pavv_rec OUT NOCOPY pavv_rec_type);
223:
224: PROCEDURE update_price_att_value(
225: p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2,
230: p_pavv_tbl IN pavv_tbl_type,

Line 235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

231: x_pavv_tbl OUT NOCOPY pavv_tbl_type);
232:
233: PROCEDURE delete_price_att_value(
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_pavv_rec IN pavv_rec_type);

Line 243: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

239: p_pavv_rec IN pavv_rec_type);
240:
241: PROCEDURE delete_price_att_value(
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
247: p_pavv_tbl IN pavv_tbl_type );

Line 251: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

247: p_pavv_tbl IN pavv_tbl_type );
248:
249: PROCEDURE validate_price_att_value(
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
255: p_pavv_rec IN pavv_rec_type);

Line 259: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

255: p_pavv_rec IN pavv_rec_type);
256:
257: PROCEDURE validate_price_att_value(
258: p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
260: x_return_status OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,
262: x_msg_data OUT NOCOPY VARCHAR2,
263: p_pavv_tbl IN pavv_tbl_type );

Line 267: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

263: p_pavv_tbl IN pavv_tbl_type );
264:
265: PROCEDURE lock_price_att_value(
266: p_api_version IN NUMBER,
267: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
268: x_return_status OUT NOCOPY VARCHAR2,
269: x_msg_count OUT NOCOPY NUMBER,
270: x_msg_data OUT NOCOPY VARCHAR2,
271: p_pavv_rec IN pavv_rec_type );

Line 275: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

271: p_pavv_rec IN pavv_rec_type );
272:
273: PROCEDURE lock_price_att_value(
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2,
279: p_pavv_tbl IN pavv_tbl_type);

Line 283: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

279: p_pavv_tbl IN pavv_tbl_type);
280:
281: PROCEDURE create_price_adj_attrib(
282: p_api_version IN NUMBER,
283: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2,
287: p_paav_rec IN paav_rec_type,

Line 292: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

288: x_paav_rec OUT NOCOPY paav_rec_type);
289:
290: PROCEDURE create_price_adj_attrib(
291: p_api_version IN NUMBER,
292: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,
295: x_msg_data OUT NOCOPY VARCHAR2,
296: p_paav_tbl IN paav_tbl_type,

Line 301: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

297: x_paav_tbl OUT NOCOPY paav_tbl_type);
298:
299: PROCEDURE update_price_adj_attrib(
300: p_api_version IN NUMBER,
301: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
302: x_return_status OUT NOCOPY VARCHAR2,
303: x_msg_count OUT NOCOPY NUMBER,
304: x_msg_data OUT NOCOPY VARCHAR2,
305: p_paav_rec IN paav_rec_type,

Line 310: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

306: x_paav_rec OUT NOCOPY paav_rec_type);
307:
308: PROCEDURE update_price_adj_attrib(
309: p_api_version IN NUMBER,
310: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
311: x_return_status OUT NOCOPY VARCHAR2,
312: x_msg_count OUT NOCOPY NUMBER,
313: x_msg_data OUT NOCOPY VARCHAR2,
314: p_paav_tbl IN paav_tbl_type,

Line 319: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

315: x_paav_tbl OUT NOCOPY paav_tbl_type);
316:
317: PROCEDURE delete_price_adj_attrib(
318: p_api_version IN NUMBER,
319: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
320: x_return_status OUT NOCOPY VARCHAR2,
321: x_msg_count OUT NOCOPY NUMBER,
322: x_msg_data OUT NOCOPY VARCHAR2,
323: p_paav_rec IN paav_rec_type);

Line 327: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

323: p_paav_rec IN paav_rec_type);
324:
325: PROCEDURE delete_price_adj_attrib(
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
328: x_return_status OUT NOCOPY VARCHAR2,
329: x_msg_count OUT NOCOPY NUMBER,
330: x_msg_data OUT NOCOPY VARCHAR2,
331: p_paav_tbl IN paav_tbl_type);

Line 335: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

331: p_paav_tbl IN paav_tbl_type);
332:
333: PROCEDURE validate_price_adj_attrib(
334: p_api_version IN NUMBER,
335: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
336: x_return_status OUT NOCOPY VARCHAR2,
337: x_msg_count OUT NOCOPY NUMBER,
338: x_msg_data OUT NOCOPY VARCHAR2,
339: p_paav_rec IN paav_rec_type);

Line 343: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

339: p_paav_rec IN paav_rec_type);
340:
341: PROCEDURE validate_price_adj_attrib(
342: p_api_version IN NUMBER,
343: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
344: x_return_status OUT NOCOPY VARCHAR2,
345: x_msg_count OUT NOCOPY NUMBER,
346: x_msg_data OUT NOCOPY VARCHAR2,
347: p_paav_tbl IN paav_tbl_type );

Line 351: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

347: p_paav_tbl IN paav_tbl_type );
348:
349: PROCEDURE lock_price_adj_attrib(
350: p_api_version IN NUMBER,
351: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
352: x_return_status OUT NOCOPY VARCHAR2,
353: x_msg_count OUT NOCOPY NUMBER,
354: x_msg_data OUT NOCOPY VARCHAR2,
355: p_paav_rec IN paav_rec_type);

Line 359: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

355: p_paav_rec IN paav_rec_type);
356:
357: PROCEDURE lock_price_adj_attrib(
358: p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
360: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_count OUT NOCOPY NUMBER,
362: x_msg_data OUT NOCOPY VARCHAR2,
363: p_paav_tbl IN paav_tbl_type);