eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_FORMULA_PVT dependencies on FND_API

Line 75: -- Default := FND_API.G_FALSE

71: -- result in the the Ams_Act_Metric_Facts table.
72: -- Parameters
73: -- IN p_api_version IN NUMBER Required
74: -- p_init_msg_list IN VARCHAR2 Optional
75: -- Default := FND_API.G_FALSE
76: -- p_commit IN VARCHAR2 Optional
77: -- Default := FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional
79: -- Default := FND_API.G_VALID_LEVEL_FULL

Line 77: -- Default := FND_API.G_FALSE

73: -- IN p_api_version IN NUMBER Required
74: -- p_init_msg_list IN VARCHAR2 Optional
75: -- Default := FND_API.G_FALSE
76: -- p_commit IN VARCHAR2 Optional
77: -- Default := FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional
79: -- Default := FND_API.G_VALID_LEVEL_FULL
80: -- p_fornula_id IN NUMBER Required
81: -- OUT x_return_status OUT VARCHAR2

Line 79: -- Default := FND_API.G_VALID_LEVEL_FULL

75: -- Default := FND_API.G_FALSE
76: -- p_commit IN VARCHAR2 Optional
77: -- Default := FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional
79: -- Default := FND_API.G_VALID_LEVEL_FULL
80: -- p_fornula_id IN NUMBER Required
81: -- OUT x_return_status OUT VARCHAR2
82: -- x_msg_count OUT NUMBER
83: -- x_msg_data OUT VARCHAR2

Line 92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

88: -- End of comments
89: ---------------------------------------------------------------------
90: PROCEDURE Execute_Formula (
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE,
94: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
95:
96: x_return_status OUT NOCOPY VARCHAR2,

Line 93: p_commit IN VARCHAR2 := FND_API.G_FALSE,

89: ---------------------------------------------------------------------
90: PROCEDURE Execute_Formula (
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE,
94: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
95:
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,

Line 94: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,

90: PROCEDURE Execute_Formula (
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE,
94: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
95:
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,

Line 116: -- Default := FND_API.G_FALSE

112: -- Function Creates an Activity Metric Formula.
113: -- Parameters
114: -- IN p_api_version IN NUMBER Required
115: -- p_init_msg_list IN VARCHAR2 Optional
116: -- Default := FND_API.G_FALSE
117: -- p_commit IN VARCHAR2 Optional
118: -- Default := FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional
120: -- Default := FND_API.G_VALID_LEVEL_FULL

Line 118: -- Default := FND_API.G_FALSE

114: -- IN p_api_version IN NUMBER Required
115: -- p_init_msg_list IN VARCHAR2 Optional
116: -- Default := FND_API.G_FALSE
117: -- p_commit IN VARCHAR2 Optional
118: -- Default := FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional
120: -- Default := FND_API.G_VALID_LEVEL_FULL
121: -- p_act_forecast_rec IN ams_formula_rec_type Required
122: -- OUT x_return_status OUT VARCHAR2

Line 120: -- Default := FND_API.G_VALID_LEVEL_FULL

116: -- Default := FND_API.G_FALSE
117: -- p_commit IN VARCHAR2 Optional
118: -- Default := FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional
120: -- Default := FND_API.G_VALID_LEVEL_FULL
121: -- p_act_forecast_rec IN ams_formula_rec_type Required
122: -- OUT x_return_status OUT VARCHAR2
123: -- x_msg_count OUT NUMBER
124: -- x_msg_data OUT VARCHAR2

Line 133: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

129: ---------------------------------------------------------------------
130:
131: PROCEDURE Create_Formula (
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
134: p_commit IN VARCHAR2 := FND_API.G_FALSE,
135: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
136:
137: x_return_status OUT NOCOPY VARCHAR2,

Line 134: p_commit IN VARCHAR2 := FND_API.G_FALSE,

130:
131: PROCEDURE Create_Formula (
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
134: p_commit IN VARCHAR2 := FND_API.G_FALSE,
135: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
136:
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,

Line 135: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,

131: PROCEDURE Create_Formula (
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
134: p_commit IN VARCHAR2 := FND_API.G_FALSE,
135: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
136:
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,

Line 155: -- Default := FND_API.G_FALSE

151: -- Function Updates the activity metric formula.
152: -- Parameters
153: -- IN p_api_version IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional
155: -- Default := FND_API.G_FALSE
156: -- p_commit IN VARCHAR2 Optional
157: -- Default := FND_API.G_FALSE
158: -- p_validation_level IN NUMBER Optional
159: -- Default := FND_API.G_VALID_LEVEL_FULL

Line 157: -- Default := FND_API.G_FALSE

153: -- IN p_api_version IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional
155: -- Default := FND_API.G_FALSE
156: -- p_commit IN VARCHAR2 Optional
157: -- Default := FND_API.G_FALSE
158: -- p_validation_level IN NUMBER Optional
159: -- Default := FND_API.G_VALID_LEVEL_FULL
160: -- p_formula_rec IN ams_formula_rec_type Required
161: -- OUT x_return_status OUT VARCHAR2

Line 159: -- Default := FND_API.G_VALID_LEVEL_FULL

155: -- Default := FND_API.G_FALSE
156: -- p_commit IN VARCHAR2 Optional
157: -- Default := FND_API.G_FALSE
158: -- p_validation_level IN NUMBER Optional
159: -- Default := FND_API.G_VALID_LEVEL_FULL
160: -- p_formula_rec IN ams_formula_rec_type Required
161: -- OUT x_return_status OUT VARCHAR2
162: -- x_msg_count OUT NUMBER
163: -- x_msg_data OUT VARCHAR2

Line 171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

167: -- End of comments
168:
169: PROCEDURE Update_Formula (
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174:
175: x_return_status OUT NOCOPY VARCHAR2,

Line 172: p_commit IN VARCHAR2 := FND_API.G_FALSE,

168:
169: PROCEDURE Update_Formula (
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174:
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,

Line 173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

169: PROCEDURE Update_Formula (
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174:
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,

Line 191: -- Default := FND_API.G_FALSE

187: -- Function Deletes the Activity Metric Formula.
188: -- Parameters
189: -- IN p_api_version IN NUMBER Required
190: -- p_init_msg_list IN VARCHAR2 Optional
191: -- Default := FND_API.G_FALSE
192: -- p_commit IN VARCHAR2 Optional
193: -- Default := FND_API.G_FALSE
194: -- p_forecast_id IN NUMBER Required
195: -- p_object_version_number IN NUMBER

Line 193: -- Default := FND_API.G_FALSE

189: -- IN p_api_version IN NUMBER Required
190: -- p_init_msg_list IN VARCHAR2 Optional
191: -- Default := FND_API.G_FALSE
192: -- p_commit IN VARCHAR2 Optional
193: -- Default := FND_API.G_FALSE
194: -- p_forecast_id IN NUMBER Required
195: -- p_object_version_number IN NUMBER
196: -- OUT x_return_status OUT VARCHAR2
197: -- x_msg_count OUT NUMBER

Line 206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

202: -- End of comments
203:
204: PROCEDURE Delete_Formula (
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
208:
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,

Line 207: p_commit IN VARCHAR2 := FND_API.G_FALSE,

203:
204: PROCEDURE Delete_Formula (
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
208:
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,

Line 227: -- Default := FND_API.G_FALSE

223: -- Function Lock the given row in AMS_ACT_METRIC_FORMULAS table.
224: -- Parameters
225: -- IN p_api_version IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional
227: -- Default := FND_API.G_FALSE
228: -- p_commit IN VARCHAR2 Optional
229: -- Default := FND_API.G_FALSE
230: -- p_formula_id IN NUMBER Required
231: -- p_object_version_number IN NUMBER Required

Line 229: -- Default := FND_API.G_FALSE

225: -- IN p_api_version IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional
227: -- Default := FND_API.G_FALSE
228: -- p_commit IN VARCHAR2 Optional
229: -- Default := FND_API.G_FALSE
230: -- p_formula_id IN NUMBER Required
231: -- p_object_version_number IN NUMBER Required
232: -- OUT x_return_status OUT VARCHAR2
233: -- x_msg_count OUT NUMBER

Line 243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

239:
240:
241: PROCEDURE Lock_Formula (
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
244:
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,

Line 264: -- Default := FND_API.G_FALSE

260:
261: -- Parameters
262: -- IN p_api_version IN NUMBER Required
263: -- p_init_msg_list IN VARCHAR2 Optional
264: -- Default := FND_API.G_FALSE
265: -- p_commit IN VARCHAR2 Optional
266: -- Default := FND_API.G_FALSE
267: -- p_validation_level IN NUMBER Optional
268: -- Default := FND_API.G_VALID_LEVEL_FULL

Line 266: -- Default := FND_API.G_FALSE

262: -- IN p_api_version IN NUMBER Required
263: -- p_init_msg_list IN VARCHAR2 Optional
264: -- Default := FND_API.G_FALSE
265: -- p_commit IN VARCHAR2 Optional
266: -- Default := FND_API.G_FALSE
267: -- p_validation_level IN NUMBER Optional
268: -- Default := FND_API.G_VALID_LEVEL_FULL
269: -- p_formula_rec IN ams_formula_rec_type Required
270: -- OUT x_return_status OUT VARCHAR2

Line 268: -- Default := FND_API.G_VALID_LEVEL_FULL

264: -- Default := FND_API.G_FALSE
265: -- p_commit IN VARCHAR2 Optional
266: -- Default := FND_API.G_FALSE
267: -- p_validation_level IN NUMBER Optional
268: -- Default := FND_API.G_VALID_LEVEL_FULL
269: -- p_formula_rec IN ams_formula_rec_type Required
270: -- OUT x_return_status OUT VARCHAR2
271: -- x_msg_count OUT NUMBER
272: -- x_msg_data OUT VARCHAR2

Line 281: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

277:
278:
279: PROCEDURE Validate_Formula (
280: p_api_version IN NUMBER,
281: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
282: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
283:
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,

Line 282: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,

278:
279: PROCEDURE Validate_Formula (
280: p_api_version IN NUMBER,
281: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
282: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
283:
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2,

Line 366: -- Default := FND_API.G_FALSE

362: -- Function Creates an Activity Metric Formula_Entry.
363: -- Parameters
364: -- IN p_api_version IN NUMBER Required
365: -- p_init_msg_list IN VARCHAR2 Optional
366: -- Default := FND_API.G_FALSE
367: -- p_commit IN VARCHAR2 Optional
368: -- Default := FND_API.G_FALSE
369: -- p_validation_level IN NUMBER Optional
370: -- Default := FND_API.G_VALID_LEVEL_FULL

Line 368: -- Default := FND_API.G_FALSE

364: -- IN p_api_version IN NUMBER Required
365: -- p_init_msg_list IN VARCHAR2 Optional
366: -- Default := FND_API.G_FALSE
367: -- p_commit IN VARCHAR2 Optional
368: -- Default := FND_API.G_FALSE
369: -- p_validation_level IN NUMBER Optional
370: -- Default := FND_API.G_VALID_LEVEL_FULL
371: -- p_formula_entry_rec IN ams_formula_entry_rec_type Required
372: -- OUT x_return_status OUT VARCHAR2

Line 370: -- Default := FND_API.G_VALID_LEVEL_FULL

366: -- Default := FND_API.G_FALSE
367: -- p_commit IN VARCHAR2 Optional
368: -- Default := FND_API.G_FALSE
369: -- p_validation_level IN NUMBER Optional
370: -- Default := FND_API.G_VALID_LEVEL_FULL
371: -- p_formula_entry_rec IN ams_formula_entry_rec_type Required
372: -- OUT x_return_status OUT VARCHAR2
373: -- x_msg_count OUT NUMBER
374: -- x_msg_data OUT VARCHAR2

Line 383: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

379: ---------------------------------------------------------------------
380:
381: PROCEDURE Create_Formula_Entry (
382: p_api_version IN NUMBER,
383: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
384: p_commit IN VARCHAR2 := FND_API.G_FALSE,
385: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
386:
387: x_return_status OUT NOCOPY VARCHAR2,

Line 384: p_commit IN VARCHAR2 := FND_API.G_FALSE,

380:
381: PROCEDURE Create_Formula_Entry (
382: p_api_version IN NUMBER,
383: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
384: p_commit IN VARCHAR2 := FND_API.G_FALSE,
385: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
386:
387: x_return_status OUT NOCOPY VARCHAR2,
388: x_msg_count OUT NOCOPY NUMBER,

Line 385: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,

381: PROCEDURE Create_Formula_Entry (
382: p_api_version IN NUMBER,
383: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
384: p_commit IN VARCHAR2 := FND_API.G_FALSE,
385: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
386:
387: x_return_status OUT NOCOPY VARCHAR2,
388: x_msg_count OUT NOCOPY NUMBER,
389: x_msg_data OUT NOCOPY VARCHAR2,

Line 405: -- Default := FND_API.G_FALSE

401: -- Function Updates the activity metric formula_entry.
402: -- Parameters
403: -- IN p_api_version IN NUMBER Required
404: -- p_init_msg_list IN VARCHAR2 Optional
405: -- Default := FND_API.G_FALSE
406: -- p_commit IN VARCHAR2 Optional
407: -- Default := FND_API.G_FALSE
408: -- p_validation_level IN NUMBER Optional
409: -- Default := FND_API.G_VALID_LEVEL_FULL

Line 407: -- Default := FND_API.G_FALSE

403: -- IN p_api_version IN NUMBER Required
404: -- p_init_msg_list IN VARCHAR2 Optional
405: -- Default := FND_API.G_FALSE
406: -- p_commit IN VARCHAR2 Optional
407: -- Default := FND_API.G_FALSE
408: -- p_validation_level IN NUMBER Optional
409: -- Default := FND_API.G_VALID_LEVEL_FULL
410: -- p_formula_entry_rec IN ams_formula_entry_rec_type Required
411: -- OUT x_return_status OUT VARCHAR2

Line 409: -- Default := FND_API.G_VALID_LEVEL_FULL

405: -- Default := FND_API.G_FALSE
406: -- p_commit IN VARCHAR2 Optional
407: -- Default := FND_API.G_FALSE
408: -- p_validation_level IN NUMBER Optional
409: -- Default := FND_API.G_VALID_LEVEL_FULL
410: -- p_formula_entry_rec IN ams_formula_entry_rec_type Required
411: -- OUT x_return_status OUT VARCHAR2
412: -- x_msg_count OUT NUMBER
413: -- x_msg_data OUT VARCHAR2

Line 421: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

417: -- End of comments
418:
419: PROCEDURE Update_formula_entry (
420: p_api_version IN NUMBER,
421: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
422: p_commit IN VARCHAR2 := FND_API.G_FALSE,
423: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
424:
425: x_return_status OUT NOCOPY VARCHAR2,

Line 422: p_commit IN VARCHAR2 := FND_API.G_FALSE,

418:
419: PROCEDURE Update_formula_entry (
420: p_api_version IN NUMBER,
421: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
422: p_commit IN VARCHAR2 := FND_API.G_FALSE,
423: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
424:
425: x_return_status OUT NOCOPY VARCHAR2,
426: x_msg_count OUT NOCOPY NUMBER,

Line 423: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

419: PROCEDURE Update_formula_entry (
420: p_api_version IN NUMBER,
421: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
422: p_commit IN VARCHAR2 := FND_API.G_FALSE,
423: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
424:
425: x_return_status OUT NOCOPY VARCHAR2,
426: x_msg_count OUT NOCOPY NUMBER,
427: x_msg_data OUT NOCOPY VARCHAR2,

Line 441: -- Default := FND_API.G_FALSE

437: -- Function Deletes the Activity Metric formula_entry.
438: -- Parameters
439: -- IN p_api_version IN NUMBER Required
440: -- p_init_msg_list IN VARCHAR2 Optional
441: -- Default := FND_API.G_FALSE
442: -- p_commit IN VARCHAR2 Optional
443: -- Default := FND_API.G_FALSE
444: -- p_forecast_id IN NUMBER Required
445: -- p_object_version_number IN NUMBER

Line 443: -- Default := FND_API.G_FALSE

439: -- IN p_api_version IN NUMBER Required
440: -- p_init_msg_list IN VARCHAR2 Optional
441: -- Default := FND_API.G_FALSE
442: -- p_commit IN VARCHAR2 Optional
443: -- Default := FND_API.G_FALSE
444: -- p_forecast_id IN NUMBER Required
445: -- p_object_version_number IN NUMBER
446: -- OUT x_return_status OUT VARCHAR2
447: -- x_msg_count OUT NUMBER

Line 456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

452: -- End of comments
453:
454: PROCEDURE Delete_formula_entry (
455: p_api_version IN NUMBER,
456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
457: p_commit IN VARCHAR2 := FND_API.G_FALSE,
458:
459: x_return_status OUT NOCOPY VARCHAR2,
460: x_msg_count OUT NOCOPY NUMBER,

Line 457: p_commit IN VARCHAR2 := FND_API.G_FALSE,

453:
454: PROCEDURE Delete_formula_entry (
455: p_api_version IN NUMBER,
456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
457: p_commit IN VARCHAR2 := FND_API.G_FALSE,
458:
459: x_return_status OUT NOCOPY VARCHAR2,
460: x_msg_count OUT NOCOPY NUMBER,
461: x_msg_data OUT NOCOPY VARCHAR2,

Line 477: -- Default := FND_API.G_FALSE

473: -- Function Lock the given row in AMS_ACT_METRIC_formula_entries table.
474: -- Parameters
475: -- IN p_api_version IN NUMBER Required
476: -- p_init_msg_list IN VARCHAR2 Optional
477: -- Default := FND_API.G_FALSE
478: -- p_commit IN VARCHAR2 Optional
479: -- Default := FND_API.G_FALSE
480: -- p_formula_entry_id IN NUMBER Required
481: -- p_object_version_number IN NUMBER Required

Line 479: -- Default := FND_API.G_FALSE

475: -- IN p_api_version IN NUMBER Required
476: -- p_init_msg_list IN VARCHAR2 Optional
477: -- Default := FND_API.G_FALSE
478: -- p_commit IN VARCHAR2 Optional
479: -- Default := FND_API.G_FALSE
480: -- p_formula_entry_id IN NUMBER Required
481: -- p_object_version_number IN NUMBER Required
482: -- OUT x_return_status OUT VARCHAR2
483: -- x_msg_count OUT NUMBER

Line 493: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

489:
490:
491: PROCEDURE Lock_formula_entry (
492: p_api_version IN NUMBER,
493: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
494:
495: x_return_status OUT NOCOPY VARCHAR2,
496: x_msg_count OUT NOCOPY NUMBER,
497: x_msg_data OUT NOCOPY VARCHAR2,

Line 514: -- Default := FND_API.G_FALSE

510:
511: -- Parameters
512: -- IN p_api_version IN NUMBER Required
513: -- p_init_msg_list IN VARCHAR2 Optional
514: -- Default := FND_API.G_FALSE
515: -- p_commit IN VARCHAR2 Optional
516: -- Default := FND_API.G_FALSE
517: -- p_validation_level IN NUMBER Optional
518: -- Default := FND_API.G_VALID_LEVEL_FULL

Line 516: -- Default := FND_API.G_FALSE

512: -- IN p_api_version IN NUMBER Required
513: -- p_init_msg_list IN VARCHAR2 Optional
514: -- Default := FND_API.G_FALSE
515: -- p_commit IN VARCHAR2 Optional
516: -- Default := FND_API.G_FALSE
517: -- p_validation_level IN NUMBER Optional
518: -- Default := FND_API.G_VALID_LEVEL_FULL
519: -- p_formula_entry_rec IN ams_formula_entry_rec_type Required
520: -- OUT x_return_status OUT VARCHAR2

Line 518: -- Default := FND_API.G_VALID_LEVEL_FULL

514: -- Default := FND_API.G_FALSE
515: -- p_commit IN VARCHAR2 Optional
516: -- Default := FND_API.G_FALSE
517: -- p_validation_level IN NUMBER Optional
518: -- Default := FND_API.G_VALID_LEVEL_FULL
519: -- p_formula_entry_rec IN ams_formula_entry_rec_type Required
520: -- OUT x_return_status OUT VARCHAR2
521: -- x_msg_count OUT NUMBER
522: -- x_msg_data OUT VARCHAR2

Line 531: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

527:
528:
529: PROCEDURE Validate_formula_entry (
530: p_api_version IN NUMBER,
531: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
532: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
533:
534: x_return_status OUT NOCOPY VARCHAR2,
535: x_msg_count OUT NOCOPY NUMBER,

Line 532: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,

528:
529: PROCEDURE Validate_formula_entry (
530: p_api_version IN NUMBER,
531: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
532: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
533:
534: x_return_status OUT NOCOPY VARCHAR2,
535: x_msg_count OUT NOCOPY NUMBER,
536: x_msg_data OUT NOCOPY VARCHAR2,