8: -- End of Comments
9:
10: PROCEDURE CREATE_CTR_GRP_TEMPLATE_PRE(
11: P_Api_Version IN NUMBER,
12: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
13: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
14: X_Return_Status OUT NOCOPY VARCHAR2,
15: X_Msg_Count OUT NOCOPY NUMBER,
16: X_Msg_Data OUT NOCOPY VARCHAR2,
9:
10: PROCEDURE CREATE_CTR_GRP_TEMPLATE_PRE(
11: P_Api_Version IN NUMBER,
12: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
13: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
14: X_Return_Status OUT NOCOPY VARCHAR2,
15: X_Msg_Count OUT NOCOPY NUMBER,
16: X_Msg_Data OUT NOCOPY VARCHAR2,
17: p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
20: );
21:
22: PROCEDURE CREATE_CTR_GRP_TEMPLATE_POST(
23: P_Api_Version IN NUMBER,
24: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
25: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
26: X_Return_Status OUT NOCOPY VARCHAR2,
27: X_Msg_Count OUT NOCOPY NUMBER,
28: X_Msg_Data OUT NOCOPY VARCHAR2,
21:
22: PROCEDURE CREATE_CTR_GRP_TEMPLATE_POST(
23: P_Api_Version IN NUMBER,
24: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
25: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
26: X_Return_Status OUT NOCOPY VARCHAR2,
27: X_Msg_Count OUT NOCOPY NUMBER,
28: X_Msg_Data OUT NOCOPY VARCHAR2,
29: p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
32: );
33:
34: PROCEDURE CREATE_CTR_GRP_INSTANCE_PRE(
35: P_Api_Version IN NUMBER,
36: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
37: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
38: X_Return_Status OUT NOCOPY VARCHAR2,
39: X_Msg_Count OUT NOCOPY NUMBER,
40: X_Msg_Data OUT NOCOPY VARCHAR2,
33:
34: PROCEDURE CREATE_CTR_GRP_INSTANCE_PRE(
35: P_Api_Version IN NUMBER,
36: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
37: P_Commit IN VARCHAR2 := FND_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_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
46: );
47:
48: PROCEDURE CREATE_CTR_GRP_INSTANCE_POST(
49: P_Api_Version IN NUMBER,
50: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
51: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
52: X_Return_Status OUT NOCOPY VARCHAR2,
53: X_Msg_Count OUT NOCOPY NUMBER,
54: X_Msg_Data OUT NOCOPY VARCHAR2,
47:
48: PROCEDURE CREATE_CTR_GRP_INSTANCE_POST(
49: P_Api_Version IN NUMBER,
50: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
51: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
52: X_Return_Status OUT NOCOPY VARCHAR2,
53: X_Msg_Count OUT NOCOPY NUMBER,
54: X_Msg_Data OUT NOCOPY VARCHAR2,
55: p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
60: );
61:
62: PROCEDURE CREATE_COUNTER_PRE(
63: P_Api_Version IN NUMBER,
64: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
65: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
66: X_Return_Status OUT NOCOPY VARCHAR2,
67: X_Msg_Count OUT NOCOPY NUMBER,
68: X_Msg_Data OUT NOCOPY VARCHAR2,
61:
62: PROCEDURE CREATE_COUNTER_PRE(
63: P_Api_Version IN NUMBER,
64: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
65: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
66: X_Return_Status OUT NOCOPY VARCHAR2,
67: X_Msg_Count OUT NOCOPY NUMBER,
68: X_Msg_Data OUT NOCOPY VARCHAR2,
69: p_ctr_rec IN CS_COUNTERS_PUB.Ctr_Rec_Type,
72: );
73:
74: PROCEDURE CREATE_COUNTER_POST(
75: P_Api_Version IN NUMBER,
76: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
77: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
78: X_Return_Status OUT NOCOPY VARCHAR2,
79: X_Msg_Count OUT NOCOPY NUMBER,
80: X_Msg_Data OUT NOCOPY VARCHAR2,
73:
74: PROCEDURE CREATE_COUNTER_POST(
75: P_Api_Version IN NUMBER,
76: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
77: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
78: X_Return_Status OUT NOCOPY VARCHAR2,
79: X_Msg_Count OUT NOCOPY NUMBER,
80: X_Msg_Data OUT NOCOPY VARCHAR2,
81: p_ctr_rec IN CS_COUNTERS_PUB.Ctr_Rec_Type,
84: );
85:
86: PROCEDURE CREATE_CTR_PROP_PRE(
87: P_Api_Version IN NUMBER,
88: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
89: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
90: X_Return_Status OUT NOCOPY VARCHAR2,
91: X_Msg_Count OUT NOCOPY NUMBER,
92: X_Msg_Data OUT NOCOPY VARCHAR2,
85:
86: PROCEDURE CREATE_CTR_PROP_PRE(
87: P_Api_Version IN NUMBER,
88: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
89: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
90: X_Return_Status OUT NOCOPY VARCHAR2,
91: X_Msg_Count OUT NOCOPY NUMBER,
92: X_Msg_Data OUT NOCOPY VARCHAR2,
93: p_ctr_prop_rec IN CS_COUNTERS_PUB.Ctr_Prop_Rec_Type,
96: );
97:
98: PROCEDURE CREATE_CTR_PROP_POST(
99: P_Api_Version IN NUMBER,
100: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
101: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
102: X_Return_Status OUT NOCOPY VARCHAR2,
103: X_Msg_Count OUT NOCOPY NUMBER,
104: X_Msg_Data OUT NOCOPY VARCHAR2,
97:
98: PROCEDURE CREATE_CTR_PROP_POST(
99: P_Api_Version IN NUMBER,
100: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
101: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
102: X_Return_Status OUT NOCOPY VARCHAR2,
103: X_Msg_Count OUT NOCOPY NUMBER,
104: X_Msg_Data OUT NOCOPY VARCHAR2,
105: p_ctr_prop_rec IN CS_COUNTERS_PUB.Ctr_Prop_Rec_Type,
108: );
109:
110: PROCEDURE CREATE_FORMULA_REF_PRE(
111: P_Api_Version IN NUMBER,
112: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
113: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
114: X_Return_Status OUT NOCOPY VARCHAR2,
115: X_Msg_Count OUT NOCOPY NUMBER,
116: X_Msg_Data OUT NOCOPY VARCHAR2,
109:
110: PROCEDURE CREATE_FORMULA_REF_PRE(
111: P_Api_Version IN NUMBER,
112: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
113: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
114: X_Return_Status OUT NOCOPY VARCHAR2,
115: X_Msg_Count OUT NOCOPY NUMBER,
116: X_Msg_Data OUT NOCOPY VARCHAR2,
117: p_counter_id IN NUMBER,
124: );
125:
126: PROCEDURE CREATE_FORMULA_REF_POST(
127: P_Api_Version IN NUMBER,
128: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
129: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
130: X_Return_Status OUT NOCOPY VARCHAR2,
131: X_Msg_Count OUT NOCOPY NUMBER,
132: X_Msg_Data OUT NOCOPY VARCHAR2,
125:
126: PROCEDURE CREATE_FORMULA_REF_POST(
127: P_Api_Version IN NUMBER,
128: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
129: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
130: X_Return_Status OUT NOCOPY VARCHAR2,
131: X_Msg_Count OUT NOCOPY NUMBER,
132: X_Msg_Data OUT NOCOPY VARCHAR2,
133: p_counter_id IN NUMBER,
140: );
141:
142: PROCEDURE CREATE_GRPOP_FILTER_PRE(
143: P_Api_Version IN NUMBER,
144: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
145: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
146: X_Return_Status OUT NOCOPY VARCHAR2,
147: X_Msg_Count OUT NOCOPY NUMBER,
148: X_Msg_Data OUT NOCOPY VARCHAR2,
141:
142: PROCEDURE CREATE_GRPOP_FILTER_PRE(
143: P_Api_Version IN NUMBER,
144: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
145: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
146: X_Return_Status OUT NOCOPY VARCHAR2,
147: X_Msg_Count OUT NOCOPY NUMBER,
148: X_Msg_Data OUT NOCOPY VARCHAR2,
149: p_seq_no IN NUMBER,
159: );
160:
161: PROCEDURE CREATE_GRPOP_FILTER_POST(
162: P_Api_Version IN NUMBER,
163: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
164: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
165: X_Return_Status OUT NOCOPY VARCHAR2,
166: X_Msg_Count OUT NOCOPY NUMBER,
167: X_Msg_Data OUT NOCOPY VARCHAR2,
160:
161: PROCEDURE CREATE_GRPOP_FILTER_POST(
162: P_Api_Version IN NUMBER,
163: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
164: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
165: X_Return_Status OUT NOCOPY VARCHAR2,
166: X_Msg_Count OUT NOCOPY NUMBER,
167: X_Msg_Data OUT NOCOPY VARCHAR2,
168: p_seq_no IN NUMBER,
178: );
179:
180: PROCEDURE CREATE_CTR_ASSOCIATION_PRE(
181: P_Api_Version IN NUMBER,
182: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
184: X_Return_Status OUT NOCOPY VARCHAR2,
185: X_Msg_Count OUT NOCOPY NUMBER,
186: X_Msg_Data OUT NOCOPY VARCHAR2,
179:
180: PROCEDURE CREATE_CTR_ASSOCIATION_PRE(
181: P_Api_Version IN NUMBER,
182: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
184: X_Return_Status OUT NOCOPY VARCHAR2,
185: X_Msg_Count OUT NOCOPY NUMBER,
186: X_Msg_Data OUT NOCOPY VARCHAR2,
187: p_ctr_grp_id IN NUMBER,
191: );
192:
193: PROCEDURE CREATE_CTR_ASSOCIATION_POST(
194: P_Api_Version IN NUMBER,
195: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
196: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
197: X_Return_Status OUT NOCOPY VARCHAR2,
198: X_Msg_Count OUT NOCOPY NUMBER,
199: X_Msg_Data OUT NOCOPY VARCHAR2,
192:
193: PROCEDURE CREATE_CTR_ASSOCIATION_POST(
194: P_Api_Version IN NUMBER,
195: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
196: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
197: X_Return_Status OUT NOCOPY VARCHAR2,
198: X_Msg_Count OUT NOCOPY NUMBER,
199: X_Msg_Data OUT NOCOPY VARCHAR2,
200: p_ctr_grp_id IN NUMBER,
204: );
205:
206: PROCEDURE AUTOINSTANTIATE_COUNTERS_PRE(
207: P_Api_Version IN NUMBER,
208: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
209: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
210: X_Return_Status OUT NOCOPY VARCHAR2,
211: X_Msg_Count OUT NOCOPY NUMBER,
212: X_Msg_Data OUT NOCOPY VARCHAR2,
205:
206: PROCEDURE AUTOINSTANTIATE_COUNTERS_PRE(
207: P_Api_Version IN NUMBER,
208: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
209: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
210: X_Return_Status OUT NOCOPY VARCHAR2,
211: X_Msg_Count OUT NOCOPY NUMBER,
212: X_Msg_Data OUT NOCOPY VARCHAR2,
213: p_source_object_id_template IN NUMBER,
217: );
218:
219: PROCEDURE AUTOINSTANTIATE_COUNTERS_POST(
220: P_Api_Version IN NUMBER,
221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
223: X_Return_Status OUT NOCOPY VARCHAR2,
224: X_Msg_Count OUT NOCOPY NUMBER,
225: X_Msg_Data OUT NOCOPY VARCHAR2,
218:
219: PROCEDURE AUTOINSTANTIATE_COUNTERS_POST(
220: P_Api_Version IN NUMBER,
221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
223: X_Return_Status OUT NOCOPY VARCHAR2,
224: X_Msg_Count OUT NOCOPY NUMBER,
225: X_Msg_Data OUT NOCOPY VARCHAR2,
226: p_source_object_id_template IN NUMBER,
230: );
231:
232: PROCEDURE INSTANTIATE_COUNTERS_PRE(
233: P_Api_Version IN NUMBER,
234: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
235: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
236: X_Return_Status OUT NOCOPY VARCHAR2,
237: X_Msg_Count OUT NOCOPY NUMBER,
238: X_Msg_Data OUT NOCOPY VARCHAR2,
231:
232: PROCEDURE INSTANTIATE_COUNTERS_PRE(
233: P_Api_Version IN NUMBER,
234: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
235: P_Commit IN VARCHAR2 := FND_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_counter_group_id_template IN NUMBER,
244: );
245:
246: PROCEDURE INSTANTIATE_COUNTERS_POST(
247: P_Api_Version IN NUMBER,
248: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
249: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
250: X_Return_Status OUT NOCOPY VARCHAR2,
251: X_Msg_Count OUT NOCOPY NUMBER,
252: X_Msg_Data OUT NOCOPY VARCHAR2,
245:
246: PROCEDURE INSTANTIATE_COUNTERS_POST(
247: P_Api_Version IN NUMBER,
248: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
249: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
250: X_Return_Status OUT NOCOPY VARCHAR2,
251: X_Msg_Count OUT NOCOPY NUMBER,
252: X_Msg_Data OUT NOCOPY VARCHAR2,
253: p_counter_group_id_template IN NUMBER,
258: );
259:
260: PROCEDURE UPDATE_CTR_GRP_PRE(
261: P_Api_Version IN NUMBER,
262: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
263: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
264: X_Return_Status OUT NOCOPY VARCHAR2,
265: X_Msg_Count OUT NOCOPY NUMBER,
266: X_Msg_Data OUT NOCOPY VARCHAR2,
259:
260: PROCEDURE UPDATE_CTR_GRP_PRE(
261: P_Api_Version IN NUMBER,
262: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
263: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
264: X_Return_Status OUT NOCOPY VARCHAR2,
265: X_Msg_Count OUT NOCOPY NUMBER,
266: X_Msg_Data OUT NOCOPY VARCHAR2,
267: p_ctr_grp_id IN NUMBER,
266: X_Msg_Data OUT NOCOPY VARCHAR2,
267: p_ctr_grp_id IN NUMBER,
268: p_object_version_number IN NUMBER,
269: p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
270: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
271: x_object_version_number OUT NOCOPY NUMBER
272: );
273:
274: PROCEDURE UPDATE_CTR_GRP_POST(
272: );
273:
274: PROCEDURE UPDATE_CTR_GRP_POST(
275: P_Api_Version IN NUMBER,
276: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
277: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
278: X_Return_Status OUT NOCOPY VARCHAR2,
279: X_Msg_Count OUT NOCOPY NUMBER,
280: X_Msg_Data OUT NOCOPY VARCHAR2,
273:
274: PROCEDURE UPDATE_CTR_GRP_POST(
275: P_Api_Version IN NUMBER,
276: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
277: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
278: X_Return_Status OUT NOCOPY VARCHAR2,
279: X_Msg_Count OUT NOCOPY NUMBER,
280: X_Msg_Data OUT NOCOPY VARCHAR2,
281: p_ctr_grp_id IN NUMBER,
280: X_Msg_Data OUT NOCOPY VARCHAR2,
281: p_ctr_grp_id IN NUMBER,
282: p_object_version_number IN NUMBER,
283: p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
284: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
285: x_object_version_number OUT NOCOPY NUMBER
286: );
287:
288: PROCEDURE UPDATE_COUNTER_PRE(
286: );
287:
288: PROCEDURE UPDATE_COUNTER_PRE(
289: P_Api_Version IN NUMBER,
290: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
291: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
292: X_Return_Status OUT NOCOPY VARCHAR2,
293: X_Msg_Count OUT NOCOPY NUMBER,
294: X_Msg_Data OUT NOCOPY VARCHAR2,
287:
288: PROCEDURE UPDATE_COUNTER_PRE(
289: P_Api_Version IN NUMBER,
290: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
291: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
292: X_Return_Status OUT NOCOPY VARCHAR2,
293: X_Msg_Count OUT NOCOPY NUMBER,
294: X_Msg_Data OUT NOCOPY VARCHAR2,
295: p_ctr_id IN NUMBER,
294: X_Msg_Data OUT NOCOPY VARCHAR2,
295: p_ctr_id IN NUMBER,
296: p_object_version_number IN NUMBER,
297: p_ctr_rec IN CS_COUNTERS_PUB.Ctr_Rec_Type,
298: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
299: x_object_version_number OUT NOCOPY NUMBER
300: );
301:
302: PROCEDURE UPDATE_COUNTER_POST(
300: );
301:
302: PROCEDURE UPDATE_COUNTER_POST(
303: P_Api_Version IN NUMBER,
304: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
305: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
306: X_Return_Status OUT NOCOPY VARCHAR2,
307: X_Msg_Count OUT NOCOPY NUMBER,
308: X_Msg_Data OUT NOCOPY VARCHAR2,
301:
302: PROCEDURE UPDATE_COUNTER_POST(
303: P_Api_Version IN NUMBER,
304: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
305: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
306: X_Return_Status OUT NOCOPY VARCHAR2,
307: X_Msg_Count OUT NOCOPY NUMBER,
308: X_Msg_Data OUT NOCOPY VARCHAR2,
309: p_ctr_id IN NUMBER,
308: X_Msg_Data OUT NOCOPY VARCHAR2,
309: p_ctr_id IN NUMBER,
310: p_object_version_number IN NUMBER,
311: p_ctr_rec IN CS_COUNTERS_PUB.Ctr_Rec_Type,
312: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
313: x_object_version_number OUT NOCOPY NUMBER
314: );
315:
316: PROCEDURE UPDATE_CTR_PROP_PRE(
314: );
315:
316: PROCEDURE UPDATE_CTR_PROP_PRE(
317: P_Api_Version IN NUMBER,
318: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
319: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
320: X_Return_Status OUT NOCOPY VARCHAR2,
321: X_Msg_Count OUT NOCOPY NUMBER,
322: X_Msg_Data OUT NOCOPY VARCHAR2,
315:
316: PROCEDURE UPDATE_CTR_PROP_PRE(
317: P_Api_Version IN NUMBER,
318: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
319: P_Commit IN VARCHAR2 := FND_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_ctr_prop_id IN NUMBER,
322: X_Msg_Data OUT NOCOPY VARCHAR2,
323: p_ctr_prop_id IN NUMBER,
324: p_object_version_number IN NUMBER,
325: p_ctr_prop_rec IN CS_COUNTERS_PUB.Ctr_Prop_Rec_Type,
326: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
327: x_object_version_number OUT NOCOPY NUMBER
328: );
329:
330: PROCEDURE UPDATE_CTR_PROP_POST(
328: );
329:
330: PROCEDURE UPDATE_CTR_PROP_POST(
331: P_Api_Version IN NUMBER,
332: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
333: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
334: X_Return_Status OUT NOCOPY VARCHAR2,
335: X_Msg_Count OUT NOCOPY NUMBER,
336: X_Msg_Data OUT NOCOPY VARCHAR2,
329:
330: PROCEDURE UPDATE_CTR_PROP_POST(
331: P_Api_Version IN NUMBER,
332: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
333: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
334: X_Return_Status OUT NOCOPY VARCHAR2,
335: X_Msg_Count OUT NOCOPY NUMBER,
336: X_Msg_Data OUT NOCOPY VARCHAR2,
337: p_ctr_prop_id IN NUMBER,
336: X_Msg_Data OUT NOCOPY VARCHAR2,
337: p_ctr_prop_id IN NUMBER,
338: p_object_version_number IN NUMBER,
339: p_ctr_prop_rec IN CS_COUNTERS_PUB.Ctr_Prop_Rec_Type,
340: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
341: x_object_version_number OUT NOCOPY NUMBER
342: );
343:
344: PROCEDURE UPDATE_FORMULA_REF_PRE(
342: );
343:
344: PROCEDURE UPDATE_FORMULA_REF_PRE(
345: P_Api_Version IN NUMBER,
346: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
347: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
348: X_Return_Status OUT NOCOPY VARCHAR2,
349: X_Msg_Count OUT NOCOPY NUMBER,
350: X_Msg_Data OUT NOCOPY VARCHAR2,
343:
344: PROCEDURE UPDATE_FORMULA_REF_PRE(
345: P_Api_Version IN NUMBER,
346: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
347: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
348: X_Return_Status OUT NOCOPY VARCHAR2,
349: X_Msg_Count OUT NOCOPY NUMBER,
350: X_Msg_Data OUT NOCOPY VARCHAR2,
351: p_ctr_formula_bvar_id IN NUMBER,
353: p_counter_id IN NUMBER,
354: p_bind_var_name IN VARCHAR2,
355: p_mapped_item_id IN NUMBER,
356: p_mapped_counter_id IN NUMBER,
357: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
358: x_object_version_number OUT NOCOPY NUMBER,
359: p_reading_type IN VARCHAR2
360: );
361:
360: );
361:
362: PROCEDURE UPDATE_FORMULA_REF_POST(
363: P_Api_Version IN NUMBER,
364: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
365: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
366: X_Return_Status OUT NOCOPY VARCHAR2,
367: X_Msg_Count OUT NOCOPY NUMBER,
368: X_Msg_Data OUT NOCOPY VARCHAR2,
361:
362: PROCEDURE UPDATE_FORMULA_REF_POST(
363: P_Api_Version IN NUMBER,
364: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
365: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
366: X_Return_Status OUT NOCOPY VARCHAR2,
367: X_Msg_Count OUT NOCOPY NUMBER,
368: X_Msg_Data OUT NOCOPY VARCHAR2,
369: p_ctr_formula_bvar_id IN NUMBER,
371: p_counter_id IN NUMBER,
372: p_bind_var_name IN VARCHAR2,
373: p_mapped_item_id IN NUMBER,
374: p_mapped_counter_id IN NUMBER,
375: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
376: x_object_version_number OUT NOCOPY NUMBER,
377: p_reading_type IN VARCHAR2
378: );
379:
378: );
379:
380: PROCEDURE UPDATE_GRPOP_FILTER_PRE(
381: P_Api_Version IN NUMBER,
382: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
383: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
384: X_Return_Status OUT NOCOPY VARCHAR2,
385: X_Msg_Count OUT NOCOPY NUMBER,
386: X_Msg_Data OUT NOCOPY VARCHAR2,
379:
380: PROCEDURE UPDATE_GRPOP_FILTER_PRE(
381: P_Api_Version IN NUMBER,
382: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
383: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
384: X_Return_Status OUT NOCOPY VARCHAR2,
385: X_Msg_Count OUT NOCOPY NUMBER,
386: X_Msg_Data OUT NOCOPY VARCHAR2,
387: p_ctr_der_filter_id IN NUMBER,
393: p_rel_op IN VARCHAR2,
394: p_right_val IN VARCHAR2,
395: p_right_paren IN VARCHAR2,
396: p_log_op IN VARCHAR2,
397: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
398: x_object_version_number OUT NOCOPY NUMBER
399: );
400:
401: PROCEDURE UPDATE_GRPOP_FILTER_POST(
399: );
400:
401: PROCEDURE UPDATE_GRPOP_FILTER_POST(
402: P_Api_Version IN NUMBER,
403: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
404: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
405: X_Return_Status OUT NOCOPY VARCHAR2,
406: X_Msg_Count OUT NOCOPY NUMBER,
407: X_Msg_Data OUT NOCOPY VARCHAR2,
400:
401: PROCEDURE UPDATE_GRPOP_FILTER_POST(
402: P_Api_Version IN NUMBER,
403: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
404: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
405: X_Return_Status OUT NOCOPY VARCHAR2,
406: X_Msg_Count OUT NOCOPY NUMBER,
407: X_Msg_Data OUT NOCOPY VARCHAR2,
408: p_ctr_der_filter_id IN NUMBER,
414: p_rel_op IN VARCHAR2,
415: p_right_val IN VARCHAR2,
416: p_right_paren IN VARCHAR2,
417: p_log_op IN VARCHAR2,
418: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
419: x_object_version_number OUT NOCOPY NUMBER
420: );
421:
422: PROCEDURE UPDATE_CTR_ASSOCIATION_PRE(
420: );
421:
422: PROCEDURE UPDATE_CTR_ASSOCIATION_PRE(
423: P_Api_Version IN NUMBER,
424: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
425: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
426: X_Return_Status OUT NOCOPY VARCHAR2,
427: X_Msg_Count OUT NOCOPY NUMBER,
428: X_Msg_Data OUT NOCOPY VARCHAR2,
421:
422: PROCEDURE UPDATE_CTR_ASSOCIATION_PRE(
423: P_Api_Version IN NUMBER,
424: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
425: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
426: X_Return_Status OUT NOCOPY VARCHAR2,
427: X_Msg_Count OUT NOCOPY NUMBER,
428: X_Msg_Data OUT NOCOPY VARCHAR2,
429: p_ctr_association_id IN NUMBER,
434: );
435:
436: PROCEDURE UPDATE_CTR_ASSOCIATION_POST(
437: P_Api_Version IN NUMBER,
438: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
439: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
440: X_Return_Status OUT NOCOPY VARCHAR2,
441: X_Msg_Count OUT NOCOPY NUMBER,
442: X_Msg_Data OUT NOCOPY VARCHAR2,
435:
436: PROCEDURE UPDATE_CTR_ASSOCIATION_POST(
437: P_Api_Version IN NUMBER,
438: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
439: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
440: X_Return_Status OUT NOCOPY VARCHAR2,
441: X_Msg_Count OUT NOCOPY NUMBER,
442: X_Msg_Data OUT NOCOPY VARCHAR2,
443: p_ctr_association_id IN NUMBER,
448: );
449:
450: PROCEDURE DELETE_COUNTER_PRE(
451: P_Api_Version IN NUMBER,
452: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
453: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
454: X_Return_Status OUT NOCOPY VARCHAR2,
455: X_Msg_Count OUT NOCOPY NUMBER,
456: X_Msg_Data OUT NOCOPY VARCHAR2,
449:
450: PROCEDURE DELETE_COUNTER_PRE(
451: P_Api_Version IN NUMBER,
452: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
453: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
454: X_Return_Status OUT NOCOPY VARCHAR2,
455: X_Msg_Count OUT NOCOPY NUMBER,
456: X_Msg_Data OUT NOCOPY VARCHAR2,
457: p_ctr_id IN NUMBER
458: );
459:
460: PROCEDURE DELETE_COUNTER_POST(
461: P_Api_Version IN NUMBER,
462: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
463: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
464: X_Return_Status OUT NOCOPY VARCHAR2,
465: X_Msg_Count OUT NOCOPY NUMBER,
466: X_Msg_Data OUT NOCOPY VARCHAR2,
459:
460: PROCEDURE DELETE_COUNTER_POST(
461: P_Api_Version IN NUMBER,
462: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
463: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
464: X_Return_Status OUT NOCOPY VARCHAR2,
465: X_Msg_Count OUT NOCOPY NUMBER,
466: X_Msg_Data OUT NOCOPY VARCHAR2,
467: p_ctr_id IN NUMBER
468: );
469:
470: PROCEDURE DELETE_CTR_PROP_PRE(
471: P_Api_Version IN NUMBER,
472: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
473: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
474: X_Return_Status OUT NOCOPY VARCHAR2,
475: X_Msg_Count OUT NOCOPY NUMBER,
476: X_Msg_Data OUT NOCOPY VARCHAR2,
469:
470: PROCEDURE DELETE_CTR_PROP_PRE(
471: P_Api_Version IN NUMBER,
472: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
473: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
474: X_Return_Status OUT NOCOPY VARCHAR2,
475: X_Msg_Count OUT NOCOPY NUMBER,
476: X_Msg_Data OUT NOCOPY VARCHAR2,
477: p_ctr_prop_id IN NUMBER
477: p_ctr_prop_id IN NUMBER
478: );
479: PROCEDURE DELETE_CTR_PROP_POST(
480: P_Api_Version IN NUMBER,
481: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
482: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
483: X_Return_Status OUT NOCOPY VARCHAR2,
484: X_Msg_Count OUT NOCOPY NUMBER,
485: X_Msg_Data OUT NOCOPY VARCHAR2,
478: );
479: PROCEDURE DELETE_CTR_PROP_POST(
480: P_Api_Version IN NUMBER,
481: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
482: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
483: X_Return_Status OUT NOCOPY VARCHAR2,
484: X_Msg_Count OUT NOCOPY NUMBER,
485: X_Msg_Data OUT NOCOPY VARCHAR2,
486: p_ctr_prop_id IN NUMBER
487: );
488:
489: PROCEDURE DELETE_FORMULA_REF_PRE(
490: P_Api_Version IN NUMBER,
491: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
492: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
493: X_Return_Status OUT NOCOPY VARCHAR2,
494: X_Msg_Count OUT NOCOPY NUMBER,
495: X_Msg_Data OUT NOCOPY VARCHAR2,
488:
489: PROCEDURE DELETE_FORMULA_REF_PRE(
490: P_Api_Version IN NUMBER,
491: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
492: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
493: X_Return_Status OUT NOCOPY VARCHAR2,
494: X_Msg_Count OUT NOCOPY NUMBER,
495: X_Msg_Data OUT NOCOPY VARCHAR2,
496: p_ctr_formula_bvar_id IN NUMBER
497: );
498:
499: PROCEDURE DELETE_FORMULA_REF_POST(
500: P_Api_Version IN NUMBER,
501: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
502: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
503: X_Return_Status OUT NOCOPY VARCHAR2,
504: X_Msg_Count OUT NOCOPY NUMBER,
505: X_Msg_Data OUT NOCOPY VARCHAR2,
498:
499: PROCEDURE DELETE_FORMULA_REF_POST(
500: P_Api_Version IN NUMBER,
501: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
502: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
503: X_Return_Status OUT NOCOPY VARCHAR2,
504: X_Msg_Count OUT NOCOPY NUMBER,
505: X_Msg_Data OUT NOCOPY VARCHAR2,
506: p_ctr_formula_bvar_id IN NUMBER
507: );
508:
509: PROCEDURE DELETE_GRPOP_FILTER_PRE(
510: P_Api_Version IN NUMBER,
511: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
512: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
513: X_Return_Status OUT NOCOPY VARCHAR2,
514: X_Msg_Count OUT NOCOPY NUMBER,
515: X_Msg_Data OUT NOCOPY VARCHAR2,
508:
509: PROCEDURE DELETE_GRPOP_FILTER_PRE(
510: P_Api_Version IN NUMBER,
511: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
512: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
513: X_Return_Status OUT NOCOPY VARCHAR2,
514: X_Msg_Count OUT NOCOPY NUMBER,
515: X_Msg_Data OUT NOCOPY VARCHAR2,
516: p_ctr_der_filter_id IN NUMBER
517: );
518:
519: PROCEDURE DELETE_GRPOP_FILTER_POST(
520: P_Api_Version IN NUMBER,
521: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
522: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
523: X_Return_Status OUT NOCOPY VARCHAR2,
524: X_Msg_Count OUT NOCOPY NUMBER,
525: X_Msg_Data OUT NOCOPY VARCHAR2,
518:
519: PROCEDURE DELETE_GRPOP_FILTER_POST(
520: P_Api_Version IN NUMBER,
521: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
522: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
523: X_Return_Status OUT NOCOPY VARCHAR2,
524: X_Msg_Count OUT NOCOPY NUMBER,
525: X_Msg_Data OUT NOCOPY VARCHAR2,
526: p_ctr_der_filter_id IN NUMBER
527: );
528:
529: PROCEDURE DELETE_CTR_ASSOCIATION_PRE(
530: P_Api_Version IN NUMBER,
531: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
532: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
533: X_Return_Status OUT NOCOPY VARCHAR2,
534: X_Msg_Count OUT NOCOPY NUMBER,
535: X_Msg_Data OUT NOCOPY VARCHAR2,
528:
529: PROCEDURE DELETE_CTR_ASSOCIATION_PRE(
530: P_Api_Version IN NUMBER,
531: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
532: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
533: X_Return_Status OUT NOCOPY VARCHAR2,
534: X_Msg_Count OUT NOCOPY NUMBER,
535: X_Msg_Data OUT NOCOPY VARCHAR2,
536: p_ctr_association_id IN NUMBER
536: p_ctr_association_id IN NUMBER
537: );
538: PROCEDURE DELETE_CTR_ASSOCIATION_POST(
539: P_Api_Version IN NUMBER,
540: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
541: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
542: X_Return_Status OUT NOCOPY VARCHAR2,
543: X_Msg_Count OUT NOCOPY NUMBER,
544: X_Msg_Data OUT NOCOPY VARCHAR2,
537: );
538: PROCEDURE DELETE_CTR_ASSOCIATION_POST(
539: P_Api_Version IN NUMBER,
540: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
541: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
542: X_Return_Status OUT NOCOPY VARCHAR2,
543: X_Msg_Count OUT NOCOPY NUMBER,
544: X_Msg_Data OUT NOCOPY VARCHAR2,
545: p_ctr_association_id IN NUMBER
546: );
547:
548: PROCEDURE DELETE_COUNTER_INSTANCE_PRE (
549: p_api_version IN NUMBER,
550: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
551: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
552: p_SOURCE_OBJECT_ID IN NUMBER,
553: p_SOURCE_OBJECT_CODE IN VARCHAR2,
554: x_Return_status OUT NOCOPY VARCHAR2,
547:
548: PROCEDURE DELETE_COUNTER_INSTANCE_PRE (
549: p_api_version IN NUMBER,
550: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
551: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
552: p_SOURCE_OBJECT_ID IN NUMBER,
553: p_SOURCE_OBJECT_CODE IN VARCHAR2,
554: x_Return_status OUT NOCOPY VARCHAR2,
555: x_Msg_Count OUT NOCOPY NUMBER,
557: );
558:
559: PROCEDURE DELETE_COUNTER_INSTANCE_POST (
560: p_api_version IN NUMBER,
561: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
562: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
563: p_SOURCE_OBJECT_ID IN NUMBER,
564: p_SOURCE_OBJECT_CODE IN VARCHAR2,
565: x_Return_status OUT NOCOPY VARCHAR2,
558:
559: PROCEDURE DELETE_COUNTER_INSTANCE_POST (
560: p_api_version IN NUMBER,
561: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
562: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
563: p_SOURCE_OBJECT_ID IN NUMBER,
564: p_SOURCE_OBJECT_CODE IN VARCHAR2,
565: x_Return_status OUT NOCOPY VARCHAR2,
566: x_Msg_Count OUT NOCOPY NUMBER,