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 180: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

176: * @rep:displayname Create a Collection Plan
177: */
178: PROCEDURE create_collection_plan(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
181: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
182: p_user_name IN VARCHAR2 := NULL,
183: p_plan_name IN VARCHAR2,
184: p_organization_code IN VARCHAR2,

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

177: */
178: PROCEDURE create_collection_plan(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
181: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
182: p_user_name IN VARCHAR2 := NULL,
183: p_plan_name IN VARCHAR2,
184: p_organization_code IN VARCHAR2,
185: p_plan_type IN VARCHAR2,

Line 237: -- Default is fnd_api.g_false.

233: --
234: -- p_init_msg_list VARCHAR2
235: -- Standard api parameter. Indicates whether to
236: -- re-initialize the message list.
237: -- Default is fnd_api.g_false.
238: --
239: -- p_validation_level NUMBER
240: -- Standard api parameter. Indicates validation level.
241: -- Use the default fnd_api.g_valid_level_full.

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

237: -- Default is fnd_api.g_false.
238: --
239: -- p_validation_level NUMBER
240: -- Standard api parameter. Indicates validation level.
241: -- Use the default fnd_api.g_valid_level_full.
242: --
243: -- p_user_name VARCHAR2(100)
244: -- The user's name, as defined in fnd_user table.
245: -- This is used to record audit info in the WHO columns.

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

272: -- default value.
273: --
274: -- p_enabled_flag VARCHAR2
275: -- Enabled flag.
276: -- Valid values are fnd_api.g_true or fnd_api.g_false.
277: -- Default is fnd_api.g_true.
278: --
279: -- p_mandatory_flag VARCHAR2
280: -- Mandatory flag.

Line 277: -- Default is fnd_api.g_true.

273: --
274: -- p_enabled_flag VARCHAR2
275: -- Enabled flag.
276: -- Valid values are fnd_api.g_true or fnd_api.g_false.
277: -- Default is fnd_api.g_true.
278: --
279: -- p_mandatory_flag VARCHAR2
280: -- Mandatory flag.
281: -- Valid values are fnd_api.g_true or fnd_api.g_false

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

277: -- Default is fnd_api.g_true.
278: --
279: -- p_mandatory_flag VARCHAR2
280: -- Mandatory flag.
281: -- Valid values are fnd_api.g_true or fnd_api.g_false
282: -- and g_inherit.
283: -- Default is g_inherit which will inherit the value
284: -- set up for the collection element.
285: --

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

285: --
286: -- p_displayed_flag VARCHAR2
287: -- Display flag. Specify whether this element will
288: -- be displayed during transaction entry form.
289: -- Valid values are fnd_api.g_true or fnd_api.g_false.
290: -- Default is fnd_api.g_true.
291: --
292: -- p_result_column_name VARCHAR2
293: -- This parameter is intended for use by experienced

Line 290: -- Default is fnd_api.g_true.

286: -- p_displayed_flag VARCHAR2
287: -- Display flag. Specify whether this element will
288: -- be displayed during transaction entry form.
289: -- Valid values are fnd_api.g_true or fnd_api.g_false.
290: -- Default is fnd_api.g_true.
291: --
292: -- p_result_column_name VARCHAR2
293: -- This parameter is intended for use by experienced
294: -- users who are familiar with the underlying QA data

Line 309: -- Values: fnd_api.g_ret_sts_success,

305: -- Standard api parameter. Messages returned.
306: --
307: -- x_return_status OUT VARCHAR2
308: -- Standard api return status parameter.
309: -- Values: fnd_api.g_ret_sts_success,
310: -- fnd_api.g_ret_sts_error,
311: -- fnd_api.g_ret_sts_unexp_error.
312: --
313: -- Bug 3709284. Added three new flags for Read Only Plan elements

Line 310: -- fnd_api.g_ret_sts_error,

306: --
307: -- x_return_status OUT VARCHAR2
308: -- Standard api return status parameter.
309: -- Values: fnd_api.g_ret_sts_success,
310: -- fnd_api.g_ret_sts_error,
311: -- fnd_api.g_ret_sts_unexp_error.
312: --
313: -- Bug 3709284. Added three new flags for Read Only Plan elements
314: -- description given below.

Line 311: -- fnd_api.g_ret_sts_unexp_error.

307: -- x_return_status OUT VARCHAR2
308: -- Standard api return status parameter.
309: -- Values: fnd_api.g_ret_sts_success,
310: -- fnd_api.g_ret_sts_error,
311: -- fnd_api.g_ret_sts_unexp_error.
312: --
313: -- Bug 3709284. Added three new flags for Read Only Plan elements
314: -- description given below.
315: -- saugupta Mon, 21 Jun 2004 02:22:47 -0700 PDT

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

316: --
317: -- p_read_only_flag
318: -- Read Only Flag. Specify whether this element will be
319: -- displayed as non editable and non updateable.
320: -- Valid values are fnd_api.g_true or fnd_api.g_false.
321: -- Default is NULL.
322: --
323: -- p_ss_poplist_flag
324: -- Display as poplist on Workbench. Displays the element

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

323: -- p_ss_poplist_flag
324: -- Display as poplist on Workbench. Displays the element
325: -- values as a poplist instead of default LOV for faster
326: -- working of wrokbench application.
327: -- Valid values are fnd_api.g_true or fnd_api.g_false.
328: -- Default is NULL.
329: --
330: -- p_information_flag
331: -- Information flag. Dispalys a information icon for the

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

329: --
330: -- p_information_flag
331: -- Information flag. Dispalys a information icon for the
332: -- element in workbench application.
333: -- Valid values are fnd_api.g_true or fnd_api.g_false.
334: -- Default is NULL.
335: --
336: -- saugupta Thu Aug 28 08:59:59 PDT 2003
337: --

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

380: * @rep:displayname Add collection element to a plan
381: */
382: PROCEDURE add_plan_element(
383: p_api_version IN NUMBER,
384: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
385: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
386: p_user_name IN VARCHAR2 := NULL,
387: p_plan_name IN VARCHAR2,
388: p_organization_code IN VARCHAR2,

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

381: */
382: PROCEDURE add_plan_element(
383: p_api_version IN NUMBER,
384: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
385: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
386: p_user_name IN VARCHAR2 := NULL,
387: p_plan_name IN VARCHAR2,
388: p_organization_code IN VARCHAR2,
389: p_element_name IN VARCHAR2,

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

389: p_element_name IN VARCHAR2,
390: p_prompt_sequence IN NUMBER := NULL,
391: p_prompt IN VARCHAR2 := g_inherit,
392: p_default_value IN VARCHAR2 := g_inherit,
393: p_enabled_flag IN VARCHAR2 := fnd_api.g_true,
394: p_mandatory_flag IN VARCHAR2 := g_inherit,
395: p_displayed_flag IN VARCHAR2 := fnd_api.g_true,
396: p_read_only_flag IN VARCHAR2 := NULL,
397: p_ss_poplist_flag IN VARCHAR2 := NULL,

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

391: p_prompt IN VARCHAR2 := g_inherit,
392: p_default_value IN VARCHAR2 := g_inherit,
393: p_enabled_flag IN VARCHAR2 := fnd_api.g_true,
394: p_mandatory_flag IN VARCHAR2 := g_inherit,
395: p_displayed_flag IN VARCHAR2 := fnd_api.g_true,
396: p_read_only_flag IN VARCHAR2 := NULL,
397: p_ss_poplist_flag IN VARCHAR2 := NULL,
398: p_information_flag IN VARCHAR2 := NULL,
399: p_result_column_name IN VARCHAR2 := NULL,

Line 448: -- Default is fnd_api.g_false.

444: --
445: -- p_init_msg_list VARCHAR2
446: -- Standard api parameter. Indicates whether to
447: -- re-initialize the message list.
448: -- Default is fnd_api.g_false.
449: --
450: -- p_validation_level NUMBER
451: -- Standard api parameter. Indicates validation level.
452: -- Use the default fnd_api.g_valid_level_full.

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

448: -- Default is fnd_api.g_false.
449: --
450: -- p_validation_level NUMBER
451: -- Standard api parameter. Indicates validation level.
452: -- Use the default fnd_api.g_valid_level_full.
453: --
454: -- p_user_name VARCHAR2(100)
455: -- The user's name, as defined in fnd_user table.
456: -- This is used to record audit info in the WHO columns.

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

464: -- Organization code.
465: --
466: -- p_commit VARCHAR2
467: -- Indicates whether the API shall perform a
468: -- database commit. Specify fnd_api.g_true or
469: -- fnd_api.g_false.
470: -- Default is fnd_api.g_false.
471: --
472: -- It is recommended a commit is performed (even

Line 469: -- fnd_api.g_false.

465: --
466: -- p_commit VARCHAR2
467: -- Indicates whether the API shall perform a
468: -- database commit. Specify fnd_api.g_true or
469: -- fnd_api.g_false.
470: -- Default is fnd_api.g_false.
471: --
472: -- It is recommended a commit is performed (even
473: -- though the standard requires us to use g_false

Line 470: -- Default is fnd_api.g_false.

466: -- p_commit VARCHAR2
467: -- Indicates whether the API shall perform a
468: -- database commit. Specify fnd_api.g_true or
469: -- fnd_api.g_false.
470: -- Default is fnd_api.g_false.
471: --
472: -- It is recommended a commit is performed (even
473: -- though the standard requires us to use g_false
474: -- as the default value.) The dynamic plan views

Line 488: -- Values: fnd_api.g_ret_sts_success,

484: -- Standard api parameter. Messages returned.
485: --
486: -- x_return_status OUT VARCHAR2
487: -- Standard api return status parameter.
488: -- Values: fnd_api.g_ret_sts_success,
489: -- fnd_api.g_ret_sts_error,
490: -- fnd_api.g_ret_sts_unexp_error.
491: --
492: /*#

Line 489: -- fnd_api.g_ret_sts_error,

485: --
486: -- x_return_status OUT VARCHAR2
487: -- Standard api return status parameter.
488: -- Values: fnd_api.g_ret_sts_success,
489: -- fnd_api.g_ret_sts_error,
490: -- fnd_api.g_ret_sts_unexp_error.
491: --
492: /*#
493: * Complete processing of collection plan definition

Line 490: -- fnd_api.g_ret_sts_unexp_error.

486: -- x_return_status OUT VARCHAR2
487: -- Standard api return status parameter.
488: -- Values: fnd_api.g_ret_sts_success,
489: -- fnd_api.g_ret_sts_error,
490: -- fnd_api.g_ret_sts_unexp_error.
491: --
492: /*#
493: * Complete processing of collection plan definition
494: * @param p_api_version Should be 1.0

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

504: * @rep:displayname Complete the definition of collection plan
505: */
506: PROCEDURE complete_plan_processing(
507: p_api_version IN NUMBER,
508: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
509: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
510: p_user_name IN VARCHAR2 := NULL,
511: p_plan_name IN VARCHAR2,
512: p_organization_code IN VARCHAR2,

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

505: */
506: PROCEDURE complete_plan_processing(
507: p_api_version IN NUMBER,
508: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
509: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
510: p_user_name IN VARCHAR2 := NULL,
511: p_plan_name IN VARCHAR2,
512: p_organization_code IN VARCHAR2,
513: p_commit IN VARCHAR2 := fnd_api.g_false,

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

509: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
510: p_user_name IN VARCHAR2 := NULL,
511: p_plan_name IN VARCHAR2,
512: p_organization_code IN VARCHAR2,
513: p_commit IN VARCHAR2 := fnd_api.g_false,
514: x_msg_count OUT NOCOPY NUMBER,
515: x_msg_data OUT NOCOPY VARCHAR2,
516: x_return_status OUT NOCOPY VARCHAR2);
517:

Line 539: -- Default is fnd_api.g_false.

535: --
536: -- p_init_msg_list VARCHAR2
537: -- Standard api parameter. Indicates whether to
538: -- re-initialize the message list.
539: -- Default is fnd_api.g_false.
540: --
541: -- p_validation_level NUMBER
542: -- Standard api parameter. Indicates validation level.
543: -- Use the default fnd_api.g_valid_level_full.

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

539: -- Default is fnd_api.g_false.
540: --
541: -- p_validation_level NUMBER
542: -- Standard api parameter. Indicates validation level.
543: -- Use the default fnd_api.g_valid_level_full.
544: --
545: -- p_user_name VARCHAR2(100)
546: -- The user's name, as defined in fnd_user table.
547: -- This is used to record audit info in the WHO columns.

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

555: -- Organization code.
556: --
557: -- p_commit VARCHAR2
558: -- Indicates whether the API shall perform a
559: -- database commit. Specify fnd_api.g_true or
560: -- fnd_api.g_false.
561: -- Default is fnd_api.g_false.
562: --
563: -- x_msg_count OUT NUMBER

Line 560: -- fnd_api.g_false.

556: --
557: -- p_commit VARCHAR2
558: -- Indicates whether the API shall perform a
559: -- database commit. Specify fnd_api.g_true or
560: -- fnd_api.g_false.
561: -- Default is fnd_api.g_false.
562: --
563: -- x_msg_count OUT NUMBER
564: -- Standard api parameter. Indicates no. of messages

Line 561: -- Default is fnd_api.g_false.

557: -- p_commit VARCHAR2
558: -- Indicates whether the API shall perform a
559: -- database commit. Specify fnd_api.g_true or
560: -- fnd_api.g_false.
561: -- Default is fnd_api.g_false.
562: --
563: -- x_msg_count OUT NUMBER
564: -- Standard api parameter. Indicates no. of messages
565: -- put into the message stack.

Line 572: -- Values: fnd_api.g_ret_sts_success,

568: -- Standard api parameter. Messages returned.
569: --
570: -- x_return_status OUT VARCHAR2
571: -- Standard api return status parameter.
572: -- Values: fnd_api.g_ret_sts_success,
573: -- fnd_api.g_ret_sts_error,
574: -- fnd_api.g_ret_sts_unexp_error.
575: --
576: /*#

Line 573: -- fnd_api.g_ret_sts_error,

569: --
570: -- x_return_status OUT VARCHAR2
571: -- Standard api return status parameter.
572: -- Values: fnd_api.g_ret_sts_success,
573: -- fnd_api.g_ret_sts_error,
574: -- fnd_api.g_ret_sts_unexp_error.
575: --
576: /*#
577: * Delete an existing collection plan

Line 574: -- fnd_api.g_ret_sts_unexp_error.

570: -- x_return_status OUT VARCHAR2
571: -- Standard api return status parameter.
572: -- Values: fnd_api.g_ret_sts_success,
573: -- fnd_api.g_ret_sts_error,
574: -- fnd_api.g_ret_sts_unexp_error.
575: --
576: /*#
577: * Delete an existing collection plan
578: * @param p_api_version Should be 1.0

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

588: * @rep:displayname Delete an existing collection plan
589: */
590: PROCEDURE delete_collection_plan(
591: p_api_version IN NUMBER,
592: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
593: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
594: p_user_name IN VARCHAR2 := NULL,
595: p_plan_name IN VARCHAR2,
596: p_organization_code IN VARCHAR2,

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

589: */
590: PROCEDURE delete_collection_plan(
591: p_api_version IN NUMBER,
592: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
593: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
594: p_user_name IN VARCHAR2 := NULL,
595: p_plan_name IN VARCHAR2,
596: p_organization_code IN VARCHAR2,
597: p_commit IN VARCHAR2 := fnd_api.g_false,

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

593: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
594: p_user_name IN VARCHAR2 := NULL,
595: p_plan_name IN VARCHAR2,
596: p_organization_code IN VARCHAR2,
597: p_commit IN VARCHAR2 := fnd_api.g_false,
598: x_msg_count OUT NOCOPY NUMBER,
599: x_msg_data OUT NOCOPY VARCHAR2,
600: x_return_status OUT NOCOPY VARCHAR2);
601:

Line 623: -- Default is fnd_api.g_false.

619: --
620: -- p_init_msg_list VARCHAR2
621: -- Standard api parameter. Indicates whether to
622: -- re-initialize the message list.
623: -- Default is fnd_api.g_false.
624: --
625: -- p_validation_level NUMBER
626: -- Standard api parameter. Indicates validation level.
627: -- Use the default fnd_api.g_valid_level_full.

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

623: -- Default is fnd_api.g_false.
624: --
625: -- p_validation_level NUMBER
626: -- Standard api parameter. Indicates validation level.
627: -- Use the default fnd_api.g_valid_level_full.
628: --
629: -- p_user_name VARCHAR2(100)
630: -- The user's name, as defined in fnd_user table.
631: -- This is used to record audit info in the WHO columns.

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

642: -- The element to be deleted. Mixed case.
643: --
644: -- p_commit VARCHAR2
645: -- Indicates whether the API shall perform a
646: -- database commit. Specify fnd_api.g_true or
647: -- fnd_api.g_false.
648: -- Default is fnd_api.g_false.
649: --
650: -- x_msg_count OUT NUMBER

Line 647: -- fnd_api.g_false.

643: --
644: -- p_commit VARCHAR2
645: -- Indicates whether the API shall perform a
646: -- database commit. Specify fnd_api.g_true or
647: -- fnd_api.g_false.
648: -- Default is fnd_api.g_false.
649: --
650: -- x_msg_count OUT NUMBER
651: -- Standard api parameter. Indicates no. of messages

Line 648: -- Default is fnd_api.g_false.

644: -- p_commit VARCHAR2
645: -- Indicates whether the API shall perform a
646: -- database commit. Specify fnd_api.g_true or
647: -- fnd_api.g_false.
648: -- Default is fnd_api.g_false.
649: --
650: -- x_msg_count OUT NUMBER
651: -- Standard api parameter. Indicates no. of messages
652: -- put into the message stack.

Line 659: -- Values: fnd_api.g_ret_sts_success,

655: -- Standard api parameter. Messages returned.
656: --
657: -- x_return_status OUT VARCHAR2
658: -- Standard api return status parameter.
659: -- Values: fnd_api.g_ret_sts_success,
660: -- fnd_api.g_ret_sts_error,
661: -- fnd_api.g_ret_sts_unexp_error.
662: --
663: /*#

Line 660: -- fnd_api.g_ret_sts_error,

656: --
657: -- x_return_status OUT VARCHAR2
658: -- Standard api return status parameter.
659: -- Values: fnd_api.g_ret_sts_success,
660: -- fnd_api.g_ret_sts_error,
661: -- fnd_api.g_ret_sts_unexp_error.
662: --
663: /*#
664: * Delete an element from a collection plan

Line 661: -- fnd_api.g_ret_sts_unexp_error.

657: -- x_return_status OUT VARCHAR2
658: -- Standard api return status parameter.
659: -- Values: fnd_api.g_ret_sts_success,
660: -- fnd_api.g_ret_sts_error,
661: -- fnd_api.g_ret_sts_unexp_error.
662: --
663: /*#
664: * Delete an element from a collection plan
665: * @param p_api_version Should be 1.0

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

676: * @rep:displayname Delete an element from a collection plan
677: */
678: PROCEDURE delete_plan_element(
679: p_api_version IN NUMBER,
680: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
681: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
682: p_user_name IN VARCHAR2 := NULL,
683: p_plan_name IN VARCHAR2,
684: p_organization_code IN VARCHAR2,

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

677: */
678: PROCEDURE delete_plan_element(
679: p_api_version IN NUMBER,
680: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
681: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
682: p_user_name IN VARCHAR2 := NULL,
683: p_plan_name IN VARCHAR2,
684: p_organization_code IN VARCHAR2,
685: p_element_name IN VARCHAR2,

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

682: p_user_name IN VARCHAR2 := NULL,
683: p_plan_name IN VARCHAR2,
684: p_organization_code IN VARCHAR2,
685: p_element_name IN VARCHAR2,
686: p_commit IN VARCHAR2 := fnd_api.g_false,
687: x_msg_count OUT NOCOPY NUMBER,
688: x_msg_data OUT NOCOPY VARCHAR2,
689: x_return_status OUT NOCOPY VARCHAR2);
690:

Line 719: -- Default is fnd_api.g_false.

715: --
716: -- p_init_msg_list VARCHAR2
717: -- Standard api parameter. Indicates whether to
718: -- re-initialize the message list.
719: -- Default is fnd_api.g_false.
720: --
721: -- p_validation_level NUMBER
722: -- Standard api parameter. Indicates validation level.
723: -- Use the default fnd_api.g_valid_level_full.

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

719: -- Default is fnd_api.g_false.
720: --
721: -- p_validation_level NUMBER
722: -- Standard api parameter. Indicates validation level.
723: -- Use the default fnd_api.g_valid_level_full.
724: --
725: -- p_user_name VARCHAR2(100)
726: -- The user's name, as defined in fnd_user table.
727: -- This is used to record audit info in the WHO columns.

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

745: --
746: -- p_copy_actions_flag VARCHAR2
747: -- Specifies whether to copy all actions associated
748: -- with each plan element.
749: -- Valid values are fnd_api.g_true or fnd_api.g_false.
750: -- Default is fnd_api.g_true.
751: --
752: -- p_copy_values_flag VARCHAR2
753: -- Specifies whether to copy all lookup values

Line 750: -- Default is fnd_api.g_true.

746: -- p_copy_actions_flag VARCHAR2
747: -- Specifies whether to copy all actions associated
748: -- with each plan element.
749: -- Valid values are fnd_api.g_true or fnd_api.g_false.
750: -- Default is fnd_api.g_true.
751: --
752: -- p_copy_values_flag VARCHAR2
753: -- Specifies whether to copy all lookup values
754: -- associated with each plan element.

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

751: --
752: -- p_copy_values_flag VARCHAR2
753: -- Specifies whether to copy all lookup values
754: -- associated with each plan element.
755: -- Valid values are fnd_api.g_true or fnd_api.g_false.
756: -- Default is fnd_api.g_true.
757: --
758: -- p_copy_transactions_flag VARCHAR2
759: -- Specifies whether to copy all transactions and

Line 756: -- Default is fnd_api.g_true.

752: -- p_copy_values_flag VARCHAR2
753: -- Specifies whether to copy all lookup values
754: -- associated with each plan element.
755: -- Valid values are fnd_api.g_true or fnd_api.g_false.
756: -- Default is fnd_api.g_true.
757: --
758: -- p_copy_transactions_flag VARCHAR2
759: -- Specifies whether to copy all transactions and
760: -- collection triggers associated with each plan element.

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

757: --
758: -- p_copy_transactions_flag VARCHAR2
759: -- Specifies whether to copy all transactions and
760: -- collection triggers associated with each plan element.
761: -- Valid values are fnd_api.g_true or fnd_api.g_false.
762: -- Default is fnd_api.g_true.
763: --
764: -- p_commit VARCHAR2
765: -- Indicates whether the API shall perform a

Line 762: -- Default is fnd_api.g_true.

758: -- p_copy_transactions_flag VARCHAR2
759: -- Specifies whether to copy all transactions and
760: -- collection triggers associated with each plan element.
761: -- Valid values are fnd_api.g_true or fnd_api.g_false.
762: -- Default is fnd_api.g_true.
763: --
764: -- p_commit VARCHAR2
765: -- Indicates whether the API shall perform a
766: -- database commit. Specify fnd_api.g_true or

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

762: -- Default is fnd_api.g_true.
763: --
764: -- p_commit VARCHAR2
765: -- Indicates whether the API shall perform a
766: -- database commit. Specify fnd_api.g_true or
767: -- fnd_api.g_false.
768: -- Default is fnd_api.g_false.
769: --
770: -- x_msg_count OUT NUMBER

Line 767: -- fnd_api.g_false.

763: --
764: -- p_commit VARCHAR2
765: -- Indicates whether the API shall perform a
766: -- database commit. Specify fnd_api.g_true or
767: -- fnd_api.g_false.
768: -- Default is fnd_api.g_false.
769: --
770: -- x_msg_count OUT NUMBER
771: -- Standard api parameter. Indicates no. of messages

Line 768: -- Default is fnd_api.g_false.

764: -- p_commit VARCHAR2
765: -- Indicates whether the API shall perform a
766: -- database commit. Specify fnd_api.g_true or
767: -- fnd_api.g_false.
768: -- Default is fnd_api.g_false.
769: --
770: -- x_msg_count OUT NUMBER
771: -- Standard api parameter. Indicates no. of messages
772: -- put into the message stack.

Line 779: -- Values: fnd_api.g_ret_sts_success,

775: -- Standard api parameter. Messages returned.
776: --
777: -- x_return_status OUT VARCHAR2
778: -- Standard api return status parameter.
779: -- Values: fnd_api.g_ret_sts_success,
780: -- fnd_api.g_ret_sts_error,
781: -- fnd_api.g_ret_sts_unexp_error.
782: --
783: /*#

Line 780: -- fnd_api.g_ret_sts_error,

776: --
777: -- x_return_status OUT VARCHAR2
778: -- Standard api return status parameter.
779: -- Values: fnd_api.g_ret_sts_success,
780: -- fnd_api.g_ret_sts_error,
781: -- fnd_api.g_ret_sts_unexp_error.
782: --
783: /*#
784: * Create a new collection plan by copying definition of an existing collection plan

Line 781: -- fnd_api.g_ret_sts_unexp_error.

777: -- x_return_status OUT VARCHAR2
778: -- Standard api return status parameter.
779: -- Values: fnd_api.g_ret_sts_success,
780: -- fnd_api.g_ret_sts_error,
781: -- fnd_api.g_ret_sts_unexp_error.
782: --
783: /*#
784: * Create a new collection plan by copying definition of an existing collection plan
785: * @param p_api_version Should be 1.0

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

801: * @rep:displayname Copy Collection Plan
802: */
803: PROCEDURE copy_collection_plan(
804: p_api_version IN NUMBER,
805: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
806: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
807: p_user_name IN VARCHAR2 := NULL,
808: p_plan_name IN VARCHAR2,
809: p_organization_code IN VARCHAR2,

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

802: */
803: PROCEDURE copy_collection_plan(
804: p_api_version IN NUMBER,
805: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
806: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
807: p_user_name IN VARCHAR2 := NULL,
808: p_plan_name IN VARCHAR2,
809: p_organization_code IN VARCHAR2,
810: p_to_plan_name IN VARCHAR2,

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

808: p_plan_name IN VARCHAR2,
809: p_organization_code IN VARCHAR2,
810: p_to_plan_name IN VARCHAR2,
811: p_to_organization_code IN VARCHAR2,
812: p_copy_actions_flag IN VARCHAR2 := fnd_api.g_true,
813: p_copy_values_flag IN VARCHAR2 := fnd_api.g_true,
814: p_copy_transactions_flag IN VARCHAR2 := fnd_api.g_true,
815: p_commit IN VARCHAR2 := fnd_api.g_false,
816: x_to_plan_id OUT NOCOPY NUMBER,

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

809: p_organization_code IN VARCHAR2,
810: p_to_plan_name IN VARCHAR2,
811: p_to_organization_code IN VARCHAR2,
812: p_copy_actions_flag IN VARCHAR2 := fnd_api.g_true,
813: p_copy_values_flag IN VARCHAR2 := fnd_api.g_true,
814: p_copy_transactions_flag IN VARCHAR2 := fnd_api.g_true,
815: p_commit IN VARCHAR2 := fnd_api.g_false,
816: x_to_plan_id OUT NOCOPY NUMBER,
817: x_msg_count OUT NOCOPY NUMBER,

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

810: p_to_plan_name IN VARCHAR2,
811: p_to_organization_code IN VARCHAR2,
812: p_copy_actions_flag IN VARCHAR2 := fnd_api.g_true,
813: p_copy_values_flag IN VARCHAR2 := fnd_api.g_true,
814: p_copy_transactions_flag IN VARCHAR2 := fnd_api.g_true,
815: p_commit IN VARCHAR2 := fnd_api.g_false,
816: x_to_plan_id OUT NOCOPY NUMBER,
817: x_msg_count OUT NOCOPY NUMBER,
818: x_msg_data OUT NOCOPY VARCHAR2,

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

811: p_to_organization_code IN VARCHAR2,
812: p_copy_actions_flag IN VARCHAR2 := fnd_api.g_true,
813: p_copy_values_flag IN VARCHAR2 := fnd_api.g_true,
814: p_copy_transactions_flag IN VARCHAR2 := fnd_api.g_true,
815: p_commit IN VARCHAR2 := fnd_api.g_false,
816: x_to_plan_id OUT NOCOPY NUMBER,
817: x_msg_count OUT NOCOPY NUMBER,
818: x_msg_data OUT NOCOPY VARCHAR2,
819: x_return_status OUT NOCOPY VARCHAR2);