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.QA_PLANS_PUB dependencies on FND_API

Line 72: -- Default is fnd_api.g_false.

68: --
69: -- p_init_msg_list VARCHAR2
70: -- Standard api parameter. Indicates whether to
71: -- re-initialize the message list.
72: -- Default is fnd_api.g_false.
73: --
74: -- p_validation_level NUMBER
75: -- Standard api parameter. Indicates validation level.
76: -- Use the default fnd_api.g_valid_level_full.

Line 76: -- Use the default fnd_api.g_valid_level_full.

72: -- Default is fnd_api.g_false.
73: --
74: -- p_validation_level NUMBER
75: -- Standard api parameter. Indicates validation level.
76: -- Use the default fnd_api.g_valid_level_full.
77: --
78: -- p_user_name VARCHAR2(100)
79: -- The user's name, as defined in fnd_user table.
80: -- This is used to record audit info in the WHO columns.

Line 136: -- Values: fnd_api.g_ret_sts_success,

132: -- Standard api parameter. Messages returned.
133: --
134: -- x_return_status OUT VARCHAR2
135: -- Standard api return status parameter.
136: -- Values: fnd_api.g_ret_sts_success,
137: -- fnd_api.g_ret_sts_error,
138: -- fnd_api.g_ret_sts_unexp_error.
139: --
140: /*#

Line 137: -- fnd_api.g_ret_sts_error,

133: --
134: -- x_return_status OUT VARCHAR2
135: -- Standard api return status parameter.
136: -- Values: fnd_api.g_ret_sts_success,
137: -- fnd_api.g_ret_sts_error,
138: -- fnd_api.g_ret_sts_unexp_error.
139: --
140: /*#
141: * Creates a header of a Collection Plan.

Line 138: -- fnd_api.g_ret_sts_unexp_error.

134: -- x_return_status OUT VARCHAR2
135: -- Standard api return status parameter.
136: -- Values: fnd_api.g_ret_sts_success,
137: -- fnd_api.g_ret_sts_error,
138: -- fnd_api.g_ret_sts_unexp_error.
139: --
140: /*#
141: * Creates a header of a Collection Plan.
142: * After calling this procedure, the user should call add_plan_element consecutively

Line 164: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

160: * @rep:displayname Create a Collection Plan
161: */
162: PROCEDURE create_collection_plan(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
165: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
166: p_user_name IN VARCHAR2 := NULL,
167: p_plan_name IN VARCHAR2,
168: p_organization_code IN VARCHAR2,

Line 165: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

161: */
162: PROCEDURE create_collection_plan(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
165: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
166: p_user_name IN VARCHAR2 := NULL,
167: p_plan_name IN VARCHAR2,
168: p_organization_code IN VARCHAR2,
169: p_plan_type IN VARCHAR2,

Line 205: -- Default is fnd_api.g_false.

201: --
202: -- p_init_msg_list VARCHAR2
203: -- Standard api parameter. Indicates whether to
204: -- re-initialize the message list.
205: -- Default is fnd_api.g_false.
206: --
207: -- p_validation_level NUMBER
208: -- Standard api parameter. Indicates validation level.
209: -- Use the default fnd_api.g_valid_level_full.

Line 209: -- Use the default fnd_api.g_valid_level_full.

205: -- Default is fnd_api.g_false.
206: --
207: -- p_validation_level NUMBER
208: -- Standard api parameter. Indicates validation level.
209: -- Use the default fnd_api.g_valid_level_full.
210: --
211: -- p_user_name VARCHAR2(100)
212: -- The user's name, as defined in fnd_user table.
213: -- This is used to record audit info in the WHO columns.

Line 244: -- Valid values are fnd_api.g_true or fnd_api.g_false.

240: -- default value.
241: --
242: -- p_enabled_flag VARCHAR2
243: -- Enabled flag.
244: -- Valid values are fnd_api.g_true or fnd_api.g_false.
245: -- Default is fnd_api.g_true.
246: --
247: -- p_mandatory_flag VARCHAR2
248: -- Mandatory flag.

Line 245: -- Default is fnd_api.g_true.

241: --
242: -- p_enabled_flag VARCHAR2
243: -- Enabled flag.
244: -- Valid values are fnd_api.g_true or fnd_api.g_false.
245: -- Default is fnd_api.g_true.
246: --
247: -- p_mandatory_flag VARCHAR2
248: -- Mandatory flag.
249: -- Valid values are fnd_api.g_true or fnd_api.g_false

Line 249: -- Valid values are fnd_api.g_true or fnd_api.g_false

245: -- Default is fnd_api.g_true.
246: --
247: -- p_mandatory_flag VARCHAR2
248: -- Mandatory flag.
249: -- Valid values are fnd_api.g_true or fnd_api.g_false
250: -- and g_inherit.
251: -- Default is g_inherit which will inherit the value
252: -- set up for the collection element.
253: --

Line 257: -- Valid values are fnd_api.g_true or fnd_api.g_false.

253: --
254: -- p_displayed_flag VARCHAR2
255: -- Display flag. Specify whether this element will
256: -- be displayed during transaction entry form.
257: -- Valid values are fnd_api.g_true or fnd_api.g_false.
258: -- Default is fnd_api.g_true.
259: --
260: -- p_result_column_name VARCHAR2
261: -- This parameter is intended for use by experienced

Line 258: -- Default is fnd_api.g_true.

254: -- p_displayed_flag VARCHAR2
255: -- Display flag. Specify whether this element will
256: -- be displayed during transaction entry form.
257: -- Valid values are fnd_api.g_true or fnd_api.g_false.
258: -- Default is fnd_api.g_true.
259: --
260: -- p_result_column_name VARCHAR2
261: -- This parameter is intended for use by experienced
262: -- users who are familiar with the underlying QA data

Line 277: -- Values: fnd_api.g_ret_sts_success,

273: -- Standard api parameter. Messages returned.
274: --
275: -- x_return_status OUT VARCHAR2
276: -- Standard api return status parameter.
277: -- Values: fnd_api.g_ret_sts_success,
278: -- fnd_api.g_ret_sts_error,
279: -- fnd_api.g_ret_sts_unexp_error.
280: --
281: -- Bug 3709284. Added three new flags for Read Only Plan elements

Line 278: -- fnd_api.g_ret_sts_error,

274: --
275: -- x_return_status OUT VARCHAR2
276: -- Standard api return status parameter.
277: -- Values: fnd_api.g_ret_sts_success,
278: -- fnd_api.g_ret_sts_error,
279: -- fnd_api.g_ret_sts_unexp_error.
280: --
281: -- Bug 3709284. Added three new flags for Read Only Plan elements
282: -- description given below.

Line 279: -- fnd_api.g_ret_sts_unexp_error.

275: -- x_return_status OUT VARCHAR2
276: -- Standard api return status parameter.
277: -- Values: fnd_api.g_ret_sts_success,
278: -- fnd_api.g_ret_sts_error,
279: -- fnd_api.g_ret_sts_unexp_error.
280: --
281: -- Bug 3709284. Added three new flags for Read Only Plan elements
282: -- description given below.
283: -- saugupta Mon, 21 Jun 2004 02:22:47 -0700 PDT

Line 288: -- Valid values are fnd_api.g_true or fnd_api.g_false.

284: --
285: -- p_read_only_flag
286: -- Read Only Flag. Specify whether this element will be
287: -- displayed as non editable and non updateable.
288: -- Valid values are fnd_api.g_true or fnd_api.g_false.
289: -- Default is NULL.
290: --
291: -- p_ss_poplist_flag
292: -- Display as poplist on Workbench. Displays the element

Line 295: -- Valid values are fnd_api.g_true or fnd_api.g_false.

291: -- p_ss_poplist_flag
292: -- Display as poplist on Workbench. Displays the element
293: -- values as a poplist instead of default LOV for faster
294: -- working of wrokbench application.
295: -- Valid values are fnd_api.g_true or fnd_api.g_false.
296: -- Default is NULL.
297: --
298: -- p_information_flag
299: -- Information flag. Dispalys a information icon for the

Line 301: -- Valid values are fnd_api.g_true or fnd_api.g_false.

297: --
298: -- p_information_flag
299: -- Information flag. Dispalys a information icon for the
300: -- element in workbench application.
301: -- Valid values are fnd_api.g_true or fnd_api.g_false.
302: -- Default is NULL.
303: --
304: -- saugupta Thu Aug 28 08:59:59 PDT 2003
305: --

Line 336: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

332: * @rep:displayname Add collection element to a plan
333: */
334: PROCEDURE add_plan_element(
335: p_api_version IN NUMBER,
336: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
337: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
338: p_user_name IN VARCHAR2 := NULL,
339: p_plan_name IN VARCHAR2,
340: p_organization_code IN VARCHAR2,

Line 337: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

333: */
334: PROCEDURE add_plan_element(
335: p_api_version IN NUMBER,
336: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
337: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
338: p_user_name IN VARCHAR2 := NULL,
339: p_plan_name IN VARCHAR2,
340: p_organization_code IN VARCHAR2,
341: p_element_name IN VARCHAR2,

Line 345: p_enabled_flag IN VARCHAR2 := fnd_api.g_true,

341: p_element_name IN VARCHAR2,
342: p_prompt_sequence IN NUMBER := NULL,
343: p_prompt IN VARCHAR2 := g_inherit,
344: p_default_value IN VARCHAR2 := g_inherit,
345: p_enabled_flag IN VARCHAR2 := fnd_api.g_true,
346: p_mandatory_flag IN VARCHAR2 := g_inherit,
347: p_displayed_flag IN VARCHAR2 := fnd_api.g_true,
348: p_read_only_flag IN VARCHAR2 := NULL,
349: p_ss_poplist_flag IN VARCHAR2 := NULL,

Line 347: p_displayed_flag IN VARCHAR2 := fnd_api.g_true,

343: p_prompt IN VARCHAR2 := g_inherit,
344: p_default_value IN VARCHAR2 := g_inherit,
345: p_enabled_flag IN VARCHAR2 := fnd_api.g_true,
346: p_mandatory_flag IN VARCHAR2 := g_inherit,
347: p_displayed_flag IN VARCHAR2 := fnd_api.g_true,
348: p_read_only_flag IN VARCHAR2 := NULL,
349: p_ss_poplist_flag IN VARCHAR2 := NULL,
350: p_information_flag IN VARCHAR2 := NULL,
351: p_result_column_name IN VARCHAR2 := NULL,

Line 384: -- Default is fnd_api.g_false.

380: --
381: -- p_init_msg_list VARCHAR2
382: -- Standard api parameter. Indicates whether to
383: -- re-initialize the message list.
384: -- Default is fnd_api.g_false.
385: --
386: -- p_validation_level NUMBER
387: -- Standard api parameter. Indicates validation level.
388: -- Use the default fnd_api.g_valid_level_full.

Line 388: -- Use the default fnd_api.g_valid_level_full.

384: -- Default is fnd_api.g_false.
385: --
386: -- p_validation_level NUMBER
387: -- Standard api parameter. Indicates validation level.
388: -- Use the default fnd_api.g_valid_level_full.
389: --
390: -- p_user_name VARCHAR2(100)
391: -- The user's name, as defined in fnd_user table.
392: -- This is used to record audit info in the WHO columns.

Line 404: -- database commit. Specify fnd_api.g_true or

400: -- Organization code.
401: --
402: -- p_commit VARCHAR2
403: -- Indicates whether the API shall perform a
404: -- database commit. Specify fnd_api.g_true or
405: -- fnd_api.g_false.
406: -- Default is fnd_api.g_false.
407: --
408: -- It is recommended a commit is performed (even

Line 405: -- fnd_api.g_false.

401: --
402: -- p_commit VARCHAR2
403: -- Indicates whether the API shall perform a
404: -- database commit. Specify fnd_api.g_true or
405: -- fnd_api.g_false.
406: -- Default is fnd_api.g_false.
407: --
408: -- It is recommended a commit is performed (even
409: -- though the standard requires us to use g_false

Line 406: -- Default is fnd_api.g_false.

402: -- p_commit VARCHAR2
403: -- Indicates whether the API shall perform a
404: -- database commit. Specify fnd_api.g_true or
405: -- fnd_api.g_false.
406: -- Default is fnd_api.g_false.
407: --
408: -- It is recommended a commit is performed (even
409: -- though the standard requires us to use g_false
410: -- as the default value.) The dynamic plan views

Line 424: -- Values: fnd_api.g_ret_sts_success,

420: -- Standard api parameter. Messages returned.
421: --
422: -- x_return_status OUT VARCHAR2
423: -- Standard api return status parameter.
424: -- Values: fnd_api.g_ret_sts_success,
425: -- fnd_api.g_ret_sts_error,
426: -- fnd_api.g_ret_sts_unexp_error.
427: --
428: /*#

Line 425: -- fnd_api.g_ret_sts_error,

421: --
422: -- x_return_status OUT VARCHAR2
423: -- Standard api return status parameter.
424: -- Values: fnd_api.g_ret_sts_success,
425: -- fnd_api.g_ret_sts_error,
426: -- fnd_api.g_ret_sts_unexp_error.
427: --
428: /*#
429: * Complete processing of collection plan definition

Line 426: -- fnd_api.g_ret_sts_unexp_error.

422: -- x_return_status OUT VARCHAR2
423: -- Standard api return status parameter.
424: -- Values: fnd_api.g_ret_sts_success,
425: -- fnd_api.g_ret_sts_error,
426: -- fnd_api.g_ret_sts_unexp_error.
427: --
428: /*#
429: * Complete processing of collection plan definition
430: * @param p_api_version Should be 1.0

Line 444: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

440: * @rep:displayname Complete the definition of collection plan
441: */
442: PROCEDURE complete_plan_processing(
443: p_api_version IN NUMBER,
444: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
445: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
446: p_user_name IN VARCHAR2 := NULL,
447: p_plan_name IN VARCHAR2,
448: p_organization_code IN VARCHAR2,

Line 445: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

441: */
442: PROCEDURE complete_plan_processing(
443: p_api_version IN NUMBER,
444: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
445: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
446: p_user_name IN VARCHAR2 := NULL,
447: p_plan_name IN VARCHAR2,
448: p_organization_code IN VARCHAR2,
449: p_commit IN VARCHAR2 := fnd_api.g_false,

Line 449: p_commit IN VARCHAR2 := fnd_api.g_false,

445: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
446: p_user_name IN VARCHAR2 := NULL,
447: p_plan_name IN VARCHAR2,
448: p_organization_code IN VARCHAR2,
449: p_commit IN VARCHAR2 := fnd_api.g_false,
450: x_msg_count OUT NOCOPY NUMBER,
451: x_msg_data OUT NOCOPY VARCHAR2,
452: x_return_status OUT NOCOPY VARCHAR2);
453:

Line 475: -- Default is fnd_api.g_false.

471: --
472: -- p_init_msg_list VARCHAR2
473: -- Standard api parameter. Indicates whether to
474: -- re-initialize the message list.
475: -- Default is fnd_api.g_false.
476: --
477: -- p_validation_level NUMBER
478: -- Standard api parameter. Indicates validation level.
479: -- Use the default fnd_api.g_valid_level_full.

Line 479: -- Use the default fnd_api.g_valid_level_full.

475: -- Default is fnd_api.g_false.
476: --
477: -- p_validation_level NUMBER
478: -- Standard api parameter. Indicates validation level.
479: -- Use the default fnd_api.g_valid_level_full.
480: --
481: -- p_user_name VARCHAR2(100)
482: -- The user's name, as defined in fnd_user table.
483: -- This is used to record audit info in the WHO columns.

Line 495: -- database commit. Specify fnd_api.g_true or

491: -- Organization code.
492: --
493: -- p_commit VARCHAR2
494: -- Indicates whether the API shall perform a
495: -- database commit. Specify fnd_api.g_true or
496: -- fnd_api.g_false.
497: -- Default is fnd_api.g_false.
498: --
499: -- x_msg_count OUT NUMBER

Line 496: -- fnd_api.g_false.

492: --
493: -- p_commit VARCHAR2
494: -- Indicates whether the API shall perform a
495: -- database commit. Specify fnd_api.g_true or
496: -- fnd_api.g_false.
497: -- Default is fnd_api.g_false.
498: --
499: -- x_msg_count OUT NUMBER
500: -- Standard api parameter. Indicates no. of messages

Line 497: -- Default is fnd_api.g_false.

493: -- p_commit VARCHAR2
494: -- Indicates whether the API shall perform a
495: -- database commit. Specify fnd_api.g_true or
496: -- fnd_api.g_false.
497: -- Default is fnd_api.g_false.
498: --
499: -- x_msg_count OUT NUMBER
500: -- Standard api parameter. Indicates no. of messages
501: -- put into the message stack.

Line 508: -- Values: fnd_api.g_ret_sts_success,

504: -- Standard api parameter. Messages returned.
505: --
506: -- x_return_status OUT VARCHAR2
507: -- Standard api return status parameter.
508: -- Values: fnd_api.g_ret_sts_success,
509: -- fnd_api.g_ret_sts_error,
510: -- fnd_api.g_ret_sts_unexp_error.
511: --
512: /*#

Line 509: -- fnd_api.g_ret_sts_error,

505: --
506: -- x_return_status OUT VARCHAR2
507: -- Standard api return status parameter.
508: -- Values: fnd_api.g_ret_sts_success,
509: -- fnd_api.g_ret_sts_error,
510: -- fnd_api.g_ret_sts_unexp_error.
511: --
512: /*#
513: * Delete an existing collection plan

Line 510: -- fnd_api.g_ret_sts_unexp_error.

506: -- x_return_status OUT VARCHAR2
507: -- Standard api return status parameter.
508: -- Values: fnd_api.g_ret_sts_success,
509: -- fnd_api.g_ret_sts_error,
510: -- fnd_api.g_ret_sts_unexp_error.
511: --
512: /*#
513: * Delete an existing collection plan
514: * @param p_api_version Should be 1.0

Line 528: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

524: * @rep:displayname Delete an existing collection plan
525: */
526: PROCEDURE delete_collection_plan(
527: p_api_version IN NUMBER,
528: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
529: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
530: p_user_name IN VARCHAR2 := NULL,
531: p_plan_name IN VARCHAR2,
532: p_organization_code IN VARCHAR2,

Line 529: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

525: */
526: PROCEDURE delete_collection_plan(
527: p_api_version IN NUMBER,
528: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
529: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
530: p_user_name IN VARCHAR2 := NULL,
531: p_plan_name IN VARCHAR2,
532: p_organization_code IN VARCHAR2,
533: p_commit IN VARCHAR2 := fnd_api.g_false,

Line 533: p_commit IN VARCHAR2 := fnd_api.g_false,

529: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
530: p_user_name IN VARCHAR2 := NULL,
531: p_plan_name IN VARCHAR2,
532: p_organization_code IN VARCHAR2,
533: p_commit IN VARCHAR2 := fnd_api.g_false,
534: x_msg_count OUT NOCOPY NUMBER,
535: x_msg_data OUT NOCOPY VARCHAR2,
536: x_return_status OUT NOCOPY VARCHAR2);
537:

Line 559: -- Default is fnd_api.g_false.

555: --
556: -- p_init_msg_list VARCHAR2
557: -- Standard api parameter. Indicates whether to
558: -- re-initialize the message list.
559: -- Default is fnd_api.g_false.
560: --
561: -- p_validation_level NUMBER
562: -- Standard api parameter. Indicates validation level.
563: -- Use the default fnd_api.g_valid_level_full.

Line 563: -- Use the default fnd_api.g_valid_level_full.

559: -- Default is fnd_api.g_false.
560: --
561: -- p_validation_level NUMBER
562: -- Standard api parameter. Indicates validation level.
563: -- Use the default fnd_api.g_valid_level_full.
564: --
565: -- p_user_name VARCHAR2(100)
566: -- The user's name, as defined in fnd_user table.
567: -- This is used to record audit info in the WHO columns.

Line 582: -- database commit. Specify fnd_api.g_true or

578: -- The element to be deleted. Mixed case.
579: --
580: -- p_commit VARCHAR2
581: -- Indicates whether the API shall perform a
582: -- database commit. Specify fnd_api.g_true or
583: -- fnd_api.g_false.
584: -- Default is fnd_api.g_false.
585: --
586: -- x_msg_count OUT NUMBER

Line 583: -- fnd_api.g_false.

579: --
580: -- p_commit VARCHAR2
581: -- Indicates whether the API shall perform a
582: -- database commit. Specify fnd_api.g_true or
583: -- fnd_api.g_false.
584: -- Default is fnd_api.g_false.
585: --
586: -- x_msg_count OUT NUMBER
587: -- Standard api parameter. Indicates no. of messages

Line 584: -- Default is fnd_api.g_false.

580: -- p_commit VARCHAR2
581: -- Indicates whether the API shall perform a
582: -- database commit. Specify fnd_api.g_true or
583: -- fnd_api.g_false.
584: -- Default is fnd_api.g_false.
585: --
586: -- x_msg_count OUT NUMBER
587: -- Standard api parameter. Indicates no. of messages
588: -- put into the message stack.

Line 595: -- Values: fnd_api.g_ret_sts_success,

591: -- Standard api parameter. Messages returned.
592: --
593: -- x_return_status OUT VARCHAR2
594: -- Standard api return status parameter.
595: -- Values: fnd_api.g_ret_sts_success,
596: -- fnd_api.g_ret_sts_error,
597: -- fnd_api.g_ret_sts_unexp_error.
598: --
599: /*#

Line 596: -- fnd_api.g_ret_sts_error,

592: --
593: -- x_return_status OUT VARCHAR2
594: -- Standard api return status parameter.
595: -- Values: fnd_api.g_ret_sts_success,
596: -- fnd_api.g_ret_sts_error,
597: -- fnd_api.g_ret_sts_unexp_error.
598: --
599: /*#
600: * Delete an element from a collection plan

Line 597: -- fnd_api.g_ret_sts_unexp_error.

593: -- x_return_status OUT VARCHAR2
594: -- Standard api return status parameter.
595: -- Values: fnd_api.g_ret_sts_success,
596: -- fnd_api.g_ret_sts_error,
597: -- fnd_api.g_ret_sts_unexp_error.
598: --
599: /*#
600: * Delete an element from a collection plan
601: * @param p_api_version Should be 1.0

Line 616: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

612: * @rep:displayname Delete an element from a collection plan
613: */
614: PROCEDURE delete_plan_element(
615: p_api_version IN NUMBER,
616: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
617: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
618: p_user_name IN VARCHAR2 := NULL,
619: p_plan_name IN VARCHAR2,
620: p_organization_code IN VARCHAR2,

Line 617: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

613: */
614: PROCEDURE delete_plan_element(
615: p_api_version IN NUMBER,
616: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
617: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
618: p_user_name IN VARCHAR2 := NULL,
619: p_plan_name IN VARCHAR2,
620: p_organization_code IN VARCHAR2,
621: p_element_name IN VARCHAR2,

Line 622: p_commit IN VARCHAR2 := fnd_api.g_false,

618: p_user_name IN VARCHAR2 := NULL,
619: p_plan_name IN VARCHAR2,
620: p_organization_code IN VARCHAR2,
621: p_element_name IN VARCHAR2,
622: p_commit IN VARCHAR2 := fnd_api.g_false,
623: x_msg_count OUT NOCOPY NUMBER,
624: x_msg_data OUT NOCOPY VARCHAR2,
625: x_return_status OUT NOCOPY VARCHAR2);
626:

Line 655: -- Default is fnd_api.g_false.

651: --
652: -- p_init_msg_list VARCHAR2
653: -- Standard api parameter. Indicates whether to
654: -- re-initialize the message list.
655: -- Default is fnd_api.g_false.
656: --
657: -- p_validation_level NUMBER
658: -- Standard api parameter. Indicates validation level.
659: -- Use the default fnd_api.g_valid_level_full.

Line 659: -- Use the default fnd_api.g_valid_level_full.

655: -- Default is fnd_api.g_false.
656: --
657: -- p_validation_level NUMBER
658: -- Standard api parameter. Indicates validation level.
659: -- Use the default fnd_api.g_valid_level_full.
660: --
661: -- p_user_name VARCHAR2(100)
662: -- The user's name, as defined in fnd_user table.
663: -- This is used to record audit info in the WHO columns.

Line 685: -- Valid values are fnd_api.g_true or fnd_api.g_false.

681: --
682: -- p_copy_actions_flag VARCHAR2
683: -- Specifies whether to copy all actions associated
684: -- with each plan element.
685: -- Valid values are fnd_api.g_true or fnd_api.g_false.
686: -- Default is fnd_api.g_true.
687: --
688: -- p_copy_values_flag VARCHAR2
689: -- Specifies whether to copy all lookup values

Line 686: -- Default is fnd_api.g_true.

682: -- p_copy_actions_flag VARCHAR2
683: -- Specifies whether to copy all actions associated
684: -- with each plan element.
685: -- Valid values are fnd_api.g_true or fnd_api.g_false.
686: -- Default is fnd_api.g_true.
687: --
688: -- p_copy_values_flag VARCHAR2
689: -- Specifies whether to copy all lookup values
690: -- associated with each plan element.

Line 691: -- Valid values are fnd_api.g_true or fnd_api.g_false.

687: --
688: -- p_copy_values_flag VARCHAR2
689: -- Specifies whether to copy all lookup values
690: -- associated with each plan element.
691: -- Valid values are fnd_api.g_true or fnd_api.g_false.
692: -- Default is fnd_api.g_true.
693: --
694: -- p_copy_transactions_flag VARCHAR2
695: -- Specifies whether to copy all transactions and

Line 692: -- Default is fnd_api.g_true.

688: -- p_copy_values_flag VARCHAR2
689: -- Specifies whether to copy all lookup values
690: -- associated with each plan element.
691: -- Valid values are fnd_api.g_true or fnd_api.g_false.
692: -- Default is fnd_api.g_true.
693: --
694: -- p_copy_transactions_flag VARCHAR2
695: -- Specifies whether to copy all transactions and
696: -- collection triggers associated with each plan element.

Line 697: -- Valid values are fnd_api.g_true or fnd_api.g_false.

693: --
694: -- p_copy_transactions_flag VARCHAR2
695: -- Specifies whether to copy all transactions and
696: -- collection triggers associated with each plan element.
697: -- Valid values are fnd_api.g_true or fnd_api.g_false.
698: -- Default is fnd_api.g_true.
699: --
700: -- p_commit VARCHAR2
701: -- Indicates whether the API shall perform a

Line 698: -- Default is fnd_api.g_true.

694: -- p_copy_transactions_flag VARCHAR2
695: -- Specifies whether to copy all transactions and
696: -- collection triggers associated with each plan element.
697: -- Valid values are fnd_api.g_true or fnd_api.g_false.
698: -- Default is fnd_api.g_true.
699: --
700: -- p_commit VARCHAR2
701: -- Indicates whether the API shall perform a
702: -- database commit. Specify fnd_api.g_true or

Line 702: -- database commit. Specify fnd_api.g_true or

698: -- Default is fnd_api.g_true.
699: --
700: -- p_commit VARCHAR2
701: -- Indicates whether the API shall perform a
702: -- database commit. Specify fnd_api.g_true or
703: -- fnd_api.g_false.
704: -- Default is fnd_api.g_false.
705: --
706: -- x_msg_count OUT NUMBER

Line 703: -- fnd_api.g_false.

699: --
700: -- p_commit VARCHAR2
701: -- Indicates whether the API shall perform a
702: -- database commit. Specify fnd_api.g_true or
703: -- fnd_api.g_false.
704: -- Default is fnd_api.g_false.
705: --
706: -- x_msg_count OUT NUMBER
707: -- Standard api parameter. Indicates no. of messages

Line 704: -- Default is fnd_api.g_false.

700: -- p_commit VARCHAR2
701: -- Indicates whether the API shall perform a
702: -- database commit. Specify fnd_api.g_true or
703: -- fnd_api.g_false.
704: -- Default is fnd_api.g_false.
705: --
706: -- x_msg_count OUT NUMBER
707: -- Standard api parameter. Indicates no. of messages
708: -- put into the message stack.

Line 715: -- Values: fnd_api.g_ret_sts_success,

711: -- Standard api parameter. Messages returned.
712: --
713: -- x_return_status OUT VARCHAR2
714: -- Standard api return status parameter.
715: -- Values: fnd_api.g_ret_sts_success,
716: -- fnd_api.g_ret_sts_error,
717: -- fnd_api.g_ret_sts_unexp_error.
718: --
719: /*#

Line 716: -- fnd_api.g_ret_sts_error,

712: --
713: -- x_return_status OUT VARCHAR2
714: -- Standard api return status parameter.
715: -- Values: fnd_api.g_ret_sts_success,
716: -- fnd_api.g_ret_sts_error,
717: -- fnd_api.g_ret_sts_unexp_error.
718: --
719: /*#
720: * Create a new collection plan by copying definition of an existing collection plan

Line 717: -- fnd_api.g_ret_sts_unexp_error.

713: -- x_return_status OUT VARCHAR2
714: -- Standard api return status parameter.
715: -- Values: fnd_api.g_ret_sts_success,
716: -- fnd_api.g_ret_sts_error,
717: -- fnd_api.g_ret_sts_unexp_error.
718: --
719: /*#
720: * Create a new collection plan by copying definition of an existing collection plan
721: * @param p_api_version Should be 1.0

Line 741: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

737: * @rep:displayname Copy Collection Plan
738: */
739: PROCEDURE copy_collection_plan(
740: p_api_version IN NUMBER,
741: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
742: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
743: p_user_name IN VARCHAR2 := NULL,
744: p_plan_name IN VARCHAR2,
745: p_organization_code IN VARCHAR2,

Line 742: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

738: */
739: PROCEDURE copy_collection_plan(
740: p_api_version IN NUMBER,
741: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
742: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
743: p_user_name IN VARCHAR2 := NULL,
744: p_plan_name IN VARCHAR2,
745: p_organization_code IN VARCHAR2,
746: p_to_plan_name IN VARCHAR2,

Line 748: p_copy_actions_flag IN VARCHAR2 := fnd_api.g_true,

744: p_plan_name IN VARCHAR2,
745: p_organization_code IN VARCHAR2,
746: p_to_plan_name IN VARCHAR2,
747: p_to_organization_code IN VARCHAR2,
748: p_copy_actions_flag IN VARCHAR2 := fnd_api.g_true,
749: p_copy_values_flag IN VARCHAR2 := fnd_api.g_true,
750: p_copy_transactions_flag IN VARCHAR2 := fnd_api.g_true,
751: p_commit IN VARCHAR2 := fnd_api.g_false,
752: x_to_plan_id OUT NOCOPY NUMBER,

Line 749: p_copy_values_flag IN VARCHAR2 := fnd_api.g_true,

745: p_organization_code IN VARCHAR2,
746: p_to_plan_name IN VARCHAR2,
747: p_to_organization_code IN VARCHAR2,
748: p_copy_actions_flag IN VARCHAR2 := fnd_api.g_true,
749: p_copy_values_flag IN VARCHAR2 := fnd_api.g_true,
750: p_copy_transactions_flag IN VARCHAR2 := fnd_api.g_true,
751: p_commit IN VARCHAR2 := fnd_api.g_false,
752: x_to_plan_id OUT NOCOPY NUMBER,
753: x_msg_count OUT NOCOPY NUMBER,

Line 750: p_copy_transactions_flag IN VARCHAR2 := fnd_api.g_true,

746: p_to_plan_name IN VARCHAR2,
747: p_to_organization_code IN VARCHAR2,
748: p_copy_actions_flag IN VARCHAR2 := fnd_api.g_true,
749: p_copy_values_flag IN VARCHAR2 := fnd_api.g_true,
750: p_copy_transactions_flag IN VARCHAR2 := fnd_api.g_true,
751: p_commit IN VARCHAR2 := fnd_api.g_false,
752: x_to_plan_id OUT NOCOPY NUMBER,
753: x_msg_count OUT NOCOPY NUMBER,
754: x_msg_data OUT NOCOPY VARCHAR2,

Line 751: p_commit IN VARCHAR2 := fnd_api.g_false,

747: p_to_organization_code IN VARCHAR2,
748: p_copy_actions_flag IN VARCHAR2 := fnd_api.g_true,
749: p_copy_values_flag IN VARCHAR2 := fnd_api.g_true,
750: p_copy_transactions_flag IN VARCHAR2 := fnd_api.g_true,
751: p_commit IN VARCHAR2 := fnd_api.g_false,
752: x_to_plan_id OUT NOCOPY NUMBER,
753: x_msg_count OUT NOCOPY NUMBER,
754: x_msg_data OUT NOCOPY VARCHAR2,
755: x_return_status OUT NOCOPY VARCHAR2);