DBA Data[Home] [Help]

APPS.AMS_CAMPAIGN_PVT dependencies on FND_API

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

130: -- p_camp_rec: the new record to be inserted
131: -- x_camp_id: return the campaign_id of the new campaign
132: --
133: -- NOTES
134: -- 1. Please don't pass in any FND_API.g_mess_char/num/date.
135: -- 2. object_version_number will be set to 1.
136: -- 3. If campaign_id is passed in, the uniqueness will be checked.
137: -- Raise exception in case of duplicates. If campaign_id is not
138: -- passed in, generate a unique one from the sequence.

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

149: -- passed in.
150: ---------------------------------------------------------------------
151: PROCEDURE create_campaign(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
154: p_commit IN VARCHAR2 := FND_API.g_false,
155: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
156:
157: x_return_status OUT NOCOPY VARCHAR2,

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

150: ---------------------------------------------------------------------
151: PROCEDURE create_campaign(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
154: p_commit IN VARCHAR2 := FND_API.g_false,
155: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
156:
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,

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

151: PROCEDURE create_campaign(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
154: p_commit IN VARCHAR2 := FND_API.g_false,
155: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
156:
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,

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

181: -- from database.
182: --------------------------------------------------------------------
183: PROCEDURE delete_campaign(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
186: p_commit IN VARCHAR2 := FND_API.g_false,
187:
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,

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

182: --------------------------------------------------------------------
183: PROCEDURE delete_campaign(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
186: p_commit IN VARCHAR2 := FND_API.g_false,
187:
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,

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

209: -- 1. Raise exception if the object_version_number doesn't match.
210: --------------------------------------------------------------------
211: PROCEDURE lock_campaign(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
214:
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,

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

232: -- p_camp_rec: the record with new items
233: --
234: -- NOTES
235: -- 1. Raise exception if the object_version_number doesn't match.
236: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
237: -- that column won't be updated.
238: ----------------------------------------------------------------------
239: PROCEDURE update_campaign(
240: p_api_version IN NUMBER,

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

237: -- that column won't be updated.
238: ----------------------------------------------------------------------
239: PROCEDURE update_campaign(
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
242: p_commit IN VARCHAR2 := FND_API.g_false,
243: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
244:
245: x_return_status OUT NOCOPY VARCHAR2,

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

238: ----------------------------------------------------------------------
239: PROCEDURE update_campaign(
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
242: p_commit IN VARCHAR2 := FND_API.g_false,
243: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
244:
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,

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

239: PROCEDURE update_campaign(
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
242: p_commit IN VARCHAR2 := FND_API.g_false,
243: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
244:
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,

Line 265: -- any FND_API.g_miss_char/num/date items.

261: -- p_camp_rec: the record to be validated
262: --
263: -- NOTES
264: -- 1. p_camp_rec should be the complete campaign record wothout
265: -- any FND_API.g_miss_char/num/date items.
266: ----------------------------------------------------------------------
267: PROCEDURE validate_campaign(
268: p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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

265: -- any FND_API.g_miss_char/num/date items.
266: ----------------------------------------------------------------------
267: PROCEDURE validate_campaign(
268: p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
270: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
271:
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,

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

266: ----------------------------------------------------------------------
267: PROCEDURE validate_campaign(
268: p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
270: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
271:
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,

Line 308: -- as FND_API.g_miss_char/num/date

304: -- Check the record level business rules.
305: --
306: -- PARAMETERS
307: -- p_camp_rec: the record to be validated; may contain attributes
308: -- as FND_API.g_miss_char/num/date
309: -- p_complete_rec: the complete record after all "g_miss" items
310: -- have been replaced by current database values
311: ---------------------------------------------------------------------
312: PROCEDURE check_camp_record(

Line 328: -- as FND_API.g_miss_char/num/date

324: -- Check the inter-entity level business rules.
325: --
326: -- PARAMETERS
327: -- p_camp_rec: the record to be validated; may contain attributes
328: -- as FND_API.g_miss_char/num/date
329: -- p_complete_rec: the complete record after all "g_miss" items
330: -- have been replaced by current database values
331: -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
332: ---------------------------------------------------------------------

Line 346: -- Initialize all attributes to be FND_API.g_miss_char/num/date.

342: -- PROCEDURE
343: -- init_camp_rec
344: --
345: -- PURPOSE
346: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
347: ---------------------------------------------------------------------
348: PROCEDURE init_camp_rec(
349: x_camp_rec OUT NOCOPY camp_rec_type
350: );

Line 359: -- FND_API.g_miss_char/num/date if the user doesn't want to

355: -- complete_camp_rec
356: --
357: -- PURPOSE
358: -- For update_campaign, some attributes may be passed in as
359: -- FND_API.g_miss_char/num/date if the user doesn't want to
360: -- update those attributes. This procedure will replace the
361: -- "g_miss" attributes with current database values.
362: --
363: -- PARAMETERS

Line 365: -- FND_API.g_miss_char/num/date

361: -- "g_miss" attributes with current database values.
362: --
363: -- PARAMETERS
364: -- p_camp_rec: the record which may contain attributes as
365: -- FND_API.g_miss_char/num/date
366: -- x_complete_rec: the complete record after all "g_miss" items
367: -- have been replaced by current database values
368: --
369: -- NOTES