DBA Data[Home] [Help]

APPS.AMS_ACTMETRIC_PUB dependencies on FND_API

Line 121: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.

117: -- the sequence.
118: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
119: -- Raise exception for invalid flag.
120: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
121: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
122: ---------------------------------------------------------------------
123: /*#
124: * This procedure creates a marketing activity metric. Details of the
125: * activity metric are passed as p_act_metric_rec record type. Check

Line 141: * are one of the following: FND_API.G_RET_SUCCESS:

137: * @param p_validation_level Level of validation required. None: No
138: * validation will be performed. Full: Item and record
139: * level validation will be performed.
140: * @param x_return_status Indicates the return status of the API. The values
141: * are one of the following: FND_API.G_RET_SUCCESS:
142: * Indicates the API call was successful,
143: * FND_API.G_RET_ERROR: indicates an error has occured,
144: * FND_API.G_RET_UNEXPECTED: indicates an unexpected
145: * error has occurred.

Line 143: * FND_API.G_RET_ERROR: indicates an error has occured,

139: * level validation will be performed.
140: * @param x_return_status Indicates the return status of the API. The values
141: * are one of the following: FND_API.G_RET_SUCCESS:
142: * Indicates the API call was successful,
143: * FND_API.G_RET_ERROR: indicates an error has occured,
144: * FND_API.G_RET_UNEXPECTED: indicates an unexpected
145: * error has occurred.
146: * @param x_msg_count Count of the number of error messages in the list.
147: * @param x_msg_data Error messages returned by the API. If more than

Line 144: * FND_API.G_RET_UNEXPECTED: indicates an unexpected

140: * @param x_return_status Indicates the return status of the API. The values
141: * are one of the following: FND_API.G_RET_SUCCESS:
142: * Indicates the API call was successful,
143: * FND_API.G_RET_ERROR: indicates an error has occured,
144: * FND_API.G_RET_UNEXPECTED: indicates an unexpected
145: * error has occurred.
146: * @param x_msg_count Count of the number of error messages in the list.
147: * @param x_msg_data Error messages returned by the API. If more than
148: * one message is returned, this parameter is null and

Line 160: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

156: * @rep:displayname Create Activity Metric
157: */
158: PROCEDURE Create_ActMetric(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
161: p_commit IN VARCHAR2 := FND_API.g_false,
162: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
163:
164: x_return_status OUT NOCOPY VARCHAR2,

Line 161: p_commit IN VARCHAR2 := FND_API.g_false,

157: */
158: PROCEDURE Create_ActMetric(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
161: p_commit IN VARCHAR2 := FND_API.g_false,
162: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
163:
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,

Line 162: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

158: PROCEDURE Create_ActMetric(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
161: p_commit IN VARCHAR2 := FND_API.g_false,
162: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
163:
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,

Line 202: * are one of the following: FND_API.G_RET_SUCCESS:

198: * initialized.
199: * @param p_commit Flag to indicate if changes should be commited on
200: * success.
201: * @param x_return_status Indicates the return status of the API. The values
202: * are one of the following: FND_API.G_RET_SUCCESS:
203: * Indicates the API call was successful,
204: * FND_API.G_RET_ERROR: indicates an error has occured,
205: * FND_API.G_RET_UNEXPECTED: indicates an unexpected
206: * error has occurred.

Line 204: * FND_API.G_RET_ERROR: indicates an error has occured,

200: * success.
201: * @param x_return_status Indicates the return status of the API. The values
202: * are one of the following: FND_API.G_RET_SUCCESS:
203: * Indicates the API call was successful,
204: * FND_API.G_RET_ERROR: indicates an error has occured,
205: * FND_API.G_RET_UNEXPECTED: indicates an unexpected
206: * error has occurred.
207: * @param x_msg_count Count of the number of error messages in the list.
208: * @param x_msg_data Error messages returned by the API. If more than

Line 205: * FND_API.G_RET_UNEXPECTED: indicates an unexpected

201: * @param x_return_status Indicates the return status of the API. The values
202: * are one of the following: FND_API.G_RET_SUCCESS:
203: * Indicates the API call was successful,
204: * FND_API.G_RET_ERROR: indicates an error has occured,
205: * FND_API.G_RET_UNEXPECTED: indicates an unexpected
206: * error has occurred.
207: * @param x_msg_count Count of the number of error messages in the list.
208: * @param x_msg_data Error messages returned by the API. If more than
209: * one message is returned, this parameter is null and

Line 219: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

215: * @rep:displayname Delete Activity Metric
216: */
217: PROCEDURE Delete_ActMetric(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
220: p_commit IN VARCHAR2 := FND_API.g_false,
221:
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,

Line 220: p_commit IN VARCHAR2 := FND_API.g_false,

216: */
217: PROCEDURE Delete_ActMetric(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
220: p_commit IN VARCHAR2 := FND_API.g_false,
221:
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,

Line 247: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

243: -- 1. Raise exception if the object_version_number doesn't match.
244: --------------------------------------------------------------------
245: PROCEDURE Lock_ActMetric(
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
248:
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
251: x_msg_data OUT NOCOPY VARCHAR2,

Line 270: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

266: -- p_ActMetric_rec: the record with new items
267: --
268: -- NOTES
269: -- 1. Raise exception if the object_version_number doesn't match.
270: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
271: -- that column won't be updated.
272: ----------------------------------------------------------------------
273: /*#
274: * This procedure updates a marketing activity metric. Details of the

Line 279: * FND_API.G_MISS_... if they are not to be changed.

275: * activity metric are passed as p_act_metric_rec record type. Check
276: * the x_return_status output to see if the update was successful. The record
277: * requires the Activity_metric_id and the current object_version_number
278: * to be filled in. Other fields are optional, but must be set to
279: * FND_API.G_MISS_... if they are not to be changed.
280: * @param p_api_version This must match the version number of the API. An
281: * unexpected error is returned if the calling program
282: * version number is incompatible with the current API
283: * version number.

Line 292: * are one of the following: FND_API.G_RET_SUCCESS:

288: * @param p_validation_level Level of validation required. None: No validation
289: * will be performed. Full: Item and record level
290: * validation will be performed.
291: * @param x_return_status Indicates the return status of the API. The values
292: * are one of the following: FND_API.G_RET_SUCCESS:
293: * Indicates the API call was successful,
294: * FND_API.G_RET_ERROR: indicates an error has occured,
295: * FND_API.G_RET_UNEXPECTED: indicates an unexpected
296: * error has occurred.

Line 294: * FND_API.G_RET_ERROR: indicates an error has occured,

290: * validation will be performed.
291: * @param x_return_status Indicates the return status of the API. The values
292: * are one of the following: FND_API.G_RET_SUCCESS:
293: * Indicates the API call was successful,
294: * FND_API.G_RET_ERROR: indicates an error has occured,
295: * FND_API.G_RET_UNEXPECTED: indicates an unexpected
296: * error has occurred.
297: * @param x_msg_count Count of the number of error messages in the list.
298: * @param x_msg_data Error messages returned by the API. If more than one

Line 295: * FND_API.G_RET_UNEXPECTED: indicates an unexpected

291: * @param x_return_status Indicates the return status of the API. The values
292: * are one of the following: FND_API.G_RET_SUCCESS:
293: * Indicates the API call was successful,
294: * FND_API.G_RET_ERROR: indicates an error has occured,
295: * FND_API.G_RET_UNEXPECTED: indicates an unexpected
296: * error has occurred.
297: * @param x_msg_count Count of the number of error messages in the list.
298: * @param x_msg_data Error messages returned by the API. If more than one
299: * message is returned, this parameter is null and

Line 309: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

305: * @rep:displayname Update Activity Metric
306: */
307: PROCEDURE Update_ActMetric(
308: p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
310: p_commit IN VARCHAR2 := FND_API.g_false,
311: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
312:
313: x_return_status OUT NOCOPY VARCHAR2,

Line 310: p_commit IN VARCHAR2 := FND_API.g_false,

306: */
307: PROCEDURE Update_ActMetric(
308: p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
310: p_commit IN VARCHAR2 := FND_API.g_false,
311: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
312:
313: x_return_status OUT NOCOPY VARCHAR2,
314: x_msg_count OUT NOCOPY NUMBER,

Line 311: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

307: PROCEDURE Update_ActMetric(
308: p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
310: p_commit IN VARCHAR2 := FND_API.g_false,
311: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
312:
313: x_return_status OUT NOCOPY VARCHAR2,
314: x_msg_count OUT NOCOPY NUMBER,
315: x_msg_data OUT NOCOPY VARCHAR2,

Line 333: -- should not be any FND_API.g_miss_char/num/date in it.

329: -- p_act_metric_rec: the Activity Metric record to be validated
330: --
331: -- NOTES
332: -- 1. p_act_metric_rec should be the complete metric record. There
333: -- should not be any FND_API.g_miss_char/num/date in it.
334: ----------------------------------------------------------------------
335: PROCEDURE Validate_ActMetric(
336: p_api_version IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 337: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

333: -- should not be any FND_API.g_miss_char/num/date in it.
334: ----------------------------------------------------------------------
335: PROCEDURE Validate_ActMetric(
336: p_api_version IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
338: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
339:
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,

Line 338: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

334: ----------------------------------------------------------------------
335: PROCEDURE Validate_ActMetric(
336: p_api_version IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
338: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
339:
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,

Line 359: -- should not be any FND_API.g_miss_char/num/date in it.

355: -- p_act_metric_rec: the Activity Metric record to be validated
356: --
357: -- NOTES
358: -- 1. p_act_metric_rec should be the complete metric record. There
359: -- should not be any FND_API.g_miss_char/num/date in it.
360: ----------------------------------------------------------------------
361: PROCEDURE Invalidate_Rollup(
362: p_api_version IN NUMBER,
363: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 363: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

359: -- should not be any FND_API.g_miss_char/num/date in it.
360: ----------------------------------------------------------------------
361: PROCEDURE Invalidate_Rollup(
362: p_api_version IN NUMBER,
363: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
364: p_commit IN VARCHAR2 := FND_API.g_false,
365:
366: x_return_status OUT NOCOPY VARCHAR2,
367: x_msg_count OUT NOCOPY NUMBER,

Line 364: p_commit IN VARCHAR2 := FND_API.g_false,

360: ----------------------------------------------------------------------
361: PROCEDURE Invalidate_Rollup(
362: p_api_version IN NUMBER,
363: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
364: p_commit IN VARCHAR2 := FND_API.g_false,
365:
366: x_return_status OUT NOCOPY VARCHAR2,
367: x_msg_count OUT NOCOPY NUMBER,
368: x_msg_data OUT NOCOPY VARCHAR2,