DBA Data[Home] [Help]

APPS.AHL_APPROVALS_PVT dependencies on FND_API

Line 146: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

142: ---------------------------------------------------------------------
143:
144: PROCEDURE Process_Approvals (
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
147: p_commit IN VARCHAR2,
148: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
149:
150: p_x_Approval_Rules_Rec IN OUT NOCOPY Approval_Rules_Rec_Type,

Line 148: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

144: PROCEDURE Process_Approvals (
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
147: p_commit IN VARCHAR2,
148: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
149:
150: p_x_Approval_Rules_Rec IN OUT NOCOPY Approval_Rules_Rec_Type,
151: p_x_Approvers_Tbl IN OUT NOCOPY Approvers_Tbl,
152:

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

176: -- Raise exception in case of duplicates.
177: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
178: -- Raise exception for invalid flag.
179: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
180: -- 6. Please don't pass in any FND_API.g_miss_char/num/date.
181: -------------------------------------------------------------------
182: PROCEDURE Create_Approval_Rules (
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

Line 184: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

180: -- 6. Please don't pass in any FND_API.g_miss_char/num/date.
181: -------------------------------------------------------------------
182: PROCEDURE Create_Approval_Rules (
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
185: p_commit IN VARCHAR2,
186: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
187:
188: x_return_status OUT NOCOPY VARCHAR2,

Line 186: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

182: PROCEDURE Create_Approval_Rules (
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
185: p_commit IN VARCHAR2,
186: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
187:
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,

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

204: -- p_Approval_Rules_rec: the record representing AHL_Approval_Rules_VL (without the ROW_ID column).
205: --
206: -- NOTES
207: -- 1. Raise exception if the object_version_number doesn't match.
208: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
209: -- that column won't be updated.
210: --------------------------------------------------------------------
211: PROCEDURE Update_Approval_Rules (
212: p_api_version IN NUMBER,

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

209: -- that column won't be updated.
210: --------------------------------------------------------------------
211: PROCEDURE Update_Approval_Rules (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
214: p_commit IN VARCHAR2,
215: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
216:
217: x_return_status OUT NOCOPY VARCHAR2,

Line 215: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

211: PROCEDURE Update_Approval_Rules (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
214: p_commit IN VARCHAR2,
215: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
216:
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,

Line 242: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

238: -- 1. Raise exception if the object_version_number doesn't match.
239: --------------------------------------------------------------------
240: PROCEDURE Delete_Approval_Rules (
241: p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
243: p_commit IN VARCHAR2,
244: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
245:
246: x_return_status OUT NOCOPY VARCHAR2,

Line 244: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

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

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

262: -- p_Approval_rec: the record representing AHL_Approval_Rules_VL (without ROW_ID).
263: --
264: -- NOTES
265: -- 1. p_Approval_Rules_rec should be the complete Approval Rules record. There
266: -- should not be any FND_API.g_miss_char/num/date in it.
267: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
268: -- an exception, as those values are not handled.
269: --------------------------------------------------------------------
270: PROCEDURE Validate_Approval_Rules (

Line 267: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise

263: --
264: -- NOTES
265: -- 1. p_Approval_Rules_rec should be the complete Approval Rules record. There
266: -- should not be any FND_API.g_miss_char/num/date in it.
267: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
268: -- an exception, as those values are not handled.
269: --------------------------------------------------------------------
270: PROCEDURE Validate_Approval_Rules (
271: p_api_version IN NUMBER,

Line 272: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

268: -- an exception, as those values are not handled.
269: --------------------------------------------------------------------
270: PROCEDURE Validate_Approval_Rules (
271: p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
273: p_commit IN VARCHAR2,
274: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
275:
276: x_return_status OUT NOCOPY VARCHAR2,

Line 274: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

270: PROCEDURE Validate_Approval_Rules (
271: p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
273: p_commit IN VARCHAR2,
274: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
275:
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2,

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

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

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

321: -- PROCEDURE
322: -- Init_Approval_Rules_Rec
323: --
324: -- PURPOSE
325: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
326: ---------------------------------------------------------------------
327: /*PROCEDURE Init_Approval_Rules_Rec (
328: x_Approval_Rules_rec OUT NOCOPY Approval_Rules_Rec_Type
329: );

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

333: -- Complete_Approval_Rules_Rec
334: --
335: -- PURPOSE
336: -- For Update_Approval_Rules, some attributes may be passed in as
337: -- FND_API.g_miss_char/num/date if the user doesn't want to
338: -- update those attributes. This procedure will replace the
339: -- "g_miss" attributes with current database values.
340: --
341: -- PARAMETERS

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

339: -- "g_miss" attributes with current database values.
340: --
341: -- PARAMETERS
342: -- p_Approval_Rules_rec: the record which may contain attributes as
343: -- FND_API.g_miss_char/num/date
344: -- x_complete_rec: the complete record after all "g_miss" items
345: -- have been replaced by current database values
346: ---------------------------------------------------------------------
347: PROCEDURE Complete_Approval_Rules_Rec (

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

367: -- NOTES
368: -- 1. object_version_number will be set to 1.
369: -- 2. If Approvers_Id is passed in, the uniqueness will be checked.
370: -- Raise exception in case of duplicates.
371: -- 3. Please don't pass in any FND_API.g_mess_char/num/date.
372: ---------------------------------------------------------------------
373:
374: PROCEDURE Create_Approvers (
375: p_api_version IN NUMBER,

Line 376: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

372: ---------------------------------------------------------------------
373:
374: PROCEDURE Create_Approvers (
375: p_api_version IN NUMBER,
376: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
377: p_commit IN VARCHAR2,
378: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
379: x_return_status OUT NOCOPY VARCHAR2,
380: x_msg_count OUT NOCOPY NUMBER,

Line 378: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

374: PROCEDURE Create_Approvers (
375: p_api_version IN NUMBER,
376: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
377: p_commit IN VARCHAR2,
378: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
379: x_return_status OUT NOCOPY VARCHAR2,
380: x_msg_count OUT NOCOPY NUMBER,
381: x_msg_data OUT NOCOPY VARCHAR2,
382:

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

397: -- p_Approvers_rec: the record representing AHL_Approvers_V (without the ROW_ID column).
398: --
399: -- NOTES
400: -- 1. Raise exception if the object_version_number doesn't match.
401: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
402: -- that column won't be updated.
403: --------------------------------------------------------------------
404: PROCEDURE Update_Approvers (
405: p_api_version IN NUMBER,

Line 406: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

402: -- that column won't be updated.
403: --------------------------------------------------------------------
404: PROCEDURE Update_Approvers (
405: p_api_version IN NUMBER,
406: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
407: p_commit IN VARCHAR2,
408: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
409: p_Approvers_rec IN Approvers_Rec_Type,
410:

Line 408: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

404: PROCEDURE Update_Approvers (
405: p_api_version IN NUMBER,
406: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
407: p_commit IN VARCHAR2,
408: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
409: p_Approvers_rec IN Approvers_Rec_Type,
410:
411: x_return_status OUT NOCOPY VARCHAR2,
412: x_msg_count OUT NOCOPY NUMBER,

Line 436: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

432: --------------------------------------------------------------------
433:
434: PROCEDURE Delete_Approvers (
435: p_api_version IN NUMBER,
436: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
437: p_commit IN VARCHAR2,
438: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
439: p_Approval_Approver_Id IN NUMBER,
440: p_object_version IN NUMBER,

Line 438: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

434: PROCEDURE Delete_Approvers (
435: p_api_version IN NUMBER,
436: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
437: p_commit IN VARCHAR2,
438: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
439: p_Approval_Approver_Id IN NUMBER,
440: p_object_version IN NUMBER,
441: x_return_status OUT NOCOPY VARCHAR2,
442: x_msg_count OUT NOCOPY NUMBER,

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

454: -- p_Approvers_rec: the record representing AHL_Approvers_V (without ROW_ID).
455: --
456: -- NOTES
457: -- 1. p_Approvers_rec should be the complete Approvers record. There
458: -- should not be any FND_API.g_miss_char/num/date in it.
459: -- 2. If FND_API.g_miss_char/num/date is in the record, the raise
460: -- an exception, as those values are not handled.
461: --------------------------------------------------------------------
462: PROCEDURE Validate_Approvers (

Line 459: -- 2. If FND_API.g_miss_char/num/date is in the record, the raise

455: --
456: -- NOTES
457: -- 1. p_Approvers_rec should be the complete Approvers record. There
458: -- should not be any FND_API.g_miss_char/num/date in it.
459: -- 2. If FND_API.g_miss_char/num/date is in the record, the raise
460: -- an exception, as those values are not handled.
461: --------------------------------------------------------------------
462: PROCEDURE Validate_Approvers (
463: p_api_version IN NUMBER,

Line 464: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

460: -- an exception, as those values are not handled.
461: --------------------------------------------------------------------
462: PROCEDURE Validate_Approvers (
463: p_api_version IN NUMBER,
464: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
465: p_commit IN VARCHAR2,
466: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
467:
468: x_return_status OUT NOCOPY VARCHAR2,

Line 466: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

462: PROCEDURE Validate_Approvers (
463: p_api_version IN NUMBER,
464: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
465: p_commit IN VARCHAR2,
466: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
467:
468: x_return_status OUT NOCOPY VARCHAR2,
469: x_msg_count OUT NOCOPY NUMBER,
470: x_msg_data OUT NOCOPY VARCHAR2,

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

499: -- Check the record level business rules.
500: --
501: -- PARAMETERS
502: -- p_Approvers_rec: the record to be validated; may contain attributes
503: -- as FND_API.g_miss_char/num/date
504: -- p_complete_rec: the complete record after all "g_miss" items
505: -- have been replaced by current database values
506: ---------------------------------------------------------------------
507: --PROCEDURE Check_Approvers_Record (

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

515: -- PROCEDURE
516: -- Init_Approvers_Rec
517: --
518: -- PURPOSE
519: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
520: ---------------------------------------------------------------------
521: /*PROCEDURE Init_Approvers_Rec (
522: x_Approvers_rec OUT NOCOPY Approvers_Rec_Type
523: );

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

528: -- Complete_Approvers_Rec
529: --
530: -- PURPOSE
531: -- For Update_Approvers, some attributes may be passed in as
532: -- FND_API.g_miss_char/num/date if the user doesn't want to
533: -- update those attributes. This procedure will replace the
534: -- "g_miss" attributes with current database values.
535: --
536: -- PARAMETERS

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

534: -- "g_miss" attributes with current database values.
535: --
536: -- PARAMETERS
537: -- p_Approvers_rec: the record which may contain attributes as
538: -- FND_API.g_miss_char/num/date
539: -- x_complete_rec: the complete record after all "g_miss" items
540: -- have been replaced by current database values
541: ---------------------------------------------------------------------
542: PROCEDURE Complete_Approvers_Rec (