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_SPECS_PUB dependencies on FND_API

Line 46: -- Default is fnd_api.g_false.

42: --
43: -- p_init_msg_list VARCHAR2
44: -- Standard api parameter. Indicates whether to
45: -- re-initialize the message list.
46: -- Default is fnd_api.g_false.
47: --
48: -- p_validation_level NUMBER
49: -- Standard api parameter. Indicates validation level.
50: -- Use the default fnd_api.g_valid_level_full.

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

46: -- Default is fnd_api.g_false.
47: --
48: -- p_validation_level NUMBER
49: -- Standard api parameter. Indicates validation level.
50: -- Use the default fnd_api.g_valid_level_full.
51: --
52: -- p_user_name VARCHAR2(100)
53: -- The user's name, as defined in fnd_user table.
54: -- This is used to record audit info in the WHO columns.

Line 140: -- Values: fnd_api.g_ret_sts_success,

136: -- Standard api parameter. Messages returned.
137: --
138: -- x_return_status OUT VARCHAR2
139: -- Standard api return status parameter.
140: -- Values: fnd_api.g_ret_sts_success,
141: -- fnd_api.g_ret_sts_error,
142: -- fnd_api.g_ret_sts_unexp_error.
143: --
144: /*#

Line 141: -- fnd_api.g_ret_sts_error,

137: --
138: -- x_return_status OUT VARCHAR2
139: -- Standard api return status parameter.
140: -- Values: fnd_api.g_ret_sts_success,
141: -- fnd_api.g_ret_sts_error,
142: -- fnd_api.g_ret_sts_unexp_error.
143: --
144: /*#
145: * Creates a header of a specification.

Line 142: -- fnd_api.g_ret_sts_unexp_error.

138: -- x_return_status OUT VARCHAR2
139: -- Standard api return status parameter.
140: -- Values: fnd_api.g_ret_sts_success,
141: -- fnd_api.g_ret_sts_error,
142: -- fnd_api.g_ret_sts_unexp_error.
143: --
144: /*#
145: * Creates a header of a specification.
146: * After calling this procedure, the user should call add_spec_element consecutively

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

171: * @rep:displayname Create Specification
172: */
173: PROCEDURE create_specification(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
176: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
177: p_user_name IN VARCHAR2 := NULL,
178: p_spec_name IN VARCHAR2,
179: p_organization_code IN VARCHAR2,

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

172: */
173: PROCEDURE create_specification(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
176: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
177: p_user_name IN VARCHAR2 := NULL,
178: p_spec_name IN VARCHAR2,
179: p_organization_code IN VARCHAR2,
180: p_reference_spec IN VARCHAR2 := NULL,

Line 249: -- Default is fnd_api.g_false.

245: --
246: -- p_init_msg_list VARCHAR2
247: -- Standard api parameter. Indicates whether to
248: -- re-initialize the message list.
249: -- Default is fnd_api.g_false.
250: --
251: -- p_validation_level NUMBER
252: -- Standard api parameter. Indicates validation level.
253: -- Use the default fnd_api.g_valid_level_full.

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

249: -- Default is fnd_api.g_false.
250: --
251: -- p_validation_level NUMBER
252: -- Standard api parameter. Indicates validation level.
253: -- Use the default fnd_api.g_valid_level_full.
254: --
255: -- p_user_name VARCHAR2(100)
256: -- The user's name, as defined in fnd_user table.
257: -- This is used to record audit info in the WHO columns.

Line 277: -- Values: fnd_api.g_true or fnd_api.g_false.

273: -- Default is NULL.
274: --
275: -- p_enabled_flag VARCHAR2
276: -- Indicates whether this element is enabled.
277: -- Values: fnd_api.g_true or fnd_api.g_false.
278: -- Default is fnd_api.g_true.
279: --
280: -- p_target_value VARCHAR2
281: -- Target value.

Line 278: -- Default is fnd_api.g_true.

274: --
275: -- p_enabled_flag VARCHAR2
276: -- Indicates whether this element is enabled.
277: -- Values: fnd_api.g_true or fnd_api.g_false.
278: -- Default is fnd_api.g_true.
279: --
280: -- p_target_value VARCHAR2
281: -- Target value.
282: -- Default is NULL.

Line 317: -- Values: fnd_api.g_ret_sts_success,

313: -- Standard api parameter. Messages returned.
314: --
315: -- x_return_status OUT VARCHAR2
316: -- Standard api return status parameter.
317: -- Values: fnd_api.g_ret_sts_success,
318: -- fnd_api.g_ret_sts_error,
319: -- fnd_api.g_ret_sts_unexp_error.
320: --
321: /*#

Line 318: -- fnd_api.g_ret_sts_error,

314: --
315: -- x_return_status OUT VARCHAR2
316: -- Standard api return status parameter.
317: -- Values: fnd_api.g_ret_sts_success,
318: -- fnd_api.g_ret_sts_error,
319: -- fnd_api.g_ret_sts_unexp_error.
320: --
321: /*#
322: * Add specification element to an existing specification

Line 319: -- fnd_api.g_ret_sts_unexp_error.

315: -- x_return_status OUT VARCHAR2
316: -- Standard api return status parameter.
317: -- Values: fnd_api.g_ret_sts_success,
318: -- fnd_api.g_ret_sts_error,
319: -- fnd_api.g_ret_sts_unexp_error.
320: --
321: /*#
322: * Add specification element to an existing specification
323: * @param p_api_version Should be 1.0

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

342: * @rep:displayname Add specification element
343: */
344: PROCEDURE add_spec_element(
345: p_api_version IN NUMBER,
346: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
347: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
348: p_user_name IN VARCHAR2 := NULL,
349: p_spec_name IN VARCHAR2,
350: p_organization_code IN VARCHAR2,

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

343: */
344: PROCEDURE add_spec_element(
345: p_api_version IN NUMBER,
346: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
347: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
348: p_user_name IN VARCHAR2 := NULL,
349: p_spec_name IN VARCHAR2,
350: p_organization_code IN VARCHAR2,
351: p_element_name IN VARCHAR2,

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

349: p_spec_name IN VARCHAR2,
350: p_organization_code IN VARCHAR2,
351: p_element_name IN VARCHAR2,
352: p_uom_code IN VARCHAR2 := NULL,
353: p_enabled_flag IN VARCHAR2 := fnd_api.g_true,
354: p_target_value IN VARCHAR2 := NULL,
355: p_upper_spec_limit IN VARCHAR2 := NULL,
356: p_lower_spec_limit IN VARCHAR2 := NULL,
357: p_upper_reasonable_limit IN VARCHAR2 := NULL,

Line 404: -- Default is fnd_api.g_false.

400: --
401: -- p_init_msg_list VARCHAR2
402: -- Standard api parameter. Indicates whether to
403: -- re-initialize the message list.
404: -- Default is fnd_api.g_false.
405: --
406: -- p_user_name VARCHAR2(100)
407: -- The user's name, as defined in fnd_user table.
408: -- This is used to record audit info in the WHO columns.

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

416: -- Organization code.
417: --
418: -- p_commit VARCHAR2
419: -- Indicates whether the API shall perform a
420: -- database commit. Specify fnd_api.g_true or
421: -- fnd_api.g_false.
422: -- Default is fnd_api.g_false.
423: --
424: -- x_msg_count OUT NUMBER

Line 421: -- fnd_api.g_false.

417: --
418: -- p_commit VARCHAR2
419: -- Indicates whether the API shall perform a
420: -- database commit. Specify fnd_api.g_true or
421: -- fnd_api.g_false.
422: -- Default is fnd_api.g_false.
423: --
424: -- x_msg_count OUT NUMBER
425: -- Standard api parameter. Indicates no. of messages

Line 422: -- Default is fnd_api.g_false.

418: -- p_commit VARCHAR2
419: -- Indicates whether the API shall perform a
420: -- database commit. Specify fnd_api.g_true or
421: -- fnd_api.g_false.
422: -- Default is fnd_api.g_false.
423: --
424: -- x_msg_count OUT NUMBER
425: -- Standard api parameter. Indicates no. of messages
426: -- put into the message stack.

Line 433: -- Values: fnd_api.g_ret_sts_success,

429: -- Standard api parameter. Messages returned.
430: --
431: -- x_return_status OUT VARCHAR2
432: -- Standard api return status parameter.
433: -- Values: fnd_api.g_ret_sts_success,
434: -- fnd_api.g_ret_sts_error,
435: -- fnd_api.g_ret_sts_unexp_error.
436: --
437: /*#

Line 434: -- fnd_api.g_ret_sts_error,

430: --
431: -- x_return_status OUT VARCHAR2
432: -- Standard api return status parameter.
433: -- Values: fnd_api.g_ret_sts_success,
434: -- fnd_api.g_ret_sts_error,
435: -- fnd_api.g_ret_sts_unexp_error.
436: --
437: /*#
438: * Complete definition of a new specification

Line 435: -- fnd_api.g_ret_sts_unexp_error.

431: -- x_return_status OUT VARCHAR2
432: -- Standard api return status parameter.
433: -- Values: fnd_api.g_ret_sts_success,
434: -- fnd_api.g_ret_sts_error,
435: -- fnd_api.g_ret_sts_unexp_error.
436: --
437: /*#
438: * Complete definition of a new specification
439: * @param p_api_version Should be 1.0

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

448: * @rep:displayname Complete specification processing
449: */
450: PROCEDURE complete_spec_processing(
451: p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
453: p_user_name IN VARCHAR2 := NULL,
454: p_spec_name IN VARCHAR2,
455: p_organization_code IN VARCHAR2,
456: p_commit IN VARCHAR2 := fnd_api.g_false,

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

452: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
453: p_user_name IN VARCHAR2 := NULL,
454: p_spec_name IN VARCHAR2,
455: p_organization_code IN VARCHAR2,
456: p_commit IN VARCHAR2 := fnd_api.g_false,
457: x_msg_count OUT NOCOPY NUMBER,
458: x_msg_data OUT NOCOPY VARCHAR2,
459: x_return_status OUT NOCOPY VARCHAR2);
460:

Line 481: -- Default is fnd_api.g_false.

477: --
478: -- p_init_msg_list VARCHAR2
479: -- Standard api parameter. Indicates whether to
480: -- re-initialize the message list.
481: -- Default is fnd_api.g_false.
482: --
483: -- p_user_name VARCHAR2(100)
484: -- The user's name, as defined in fnd_user table.
485: -- This is used to record audit info in the WHO columns.

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

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

Line 498: -- fnd_api.g_false.

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

Line 499: -- Default is fnd_api.g_false.

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

Line 510: -- Values: fnd_api.g_ret_sts_success,

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

Line 511: -- fnd_api.g_ret_sts_error,

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

Line 512: -- fnd_api.g_ret_sts_unexp_error.

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

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

525: * @rep:displayname Delete Specification
526: */
527: PROCEDURE delete_specification(
528: p_api_version IN NUMBER,
529: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
530: p_user_name IN VARCHAR2 := NULL,
531: p_spec_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_init_msg_list IN VARCHAR2 := fnd_api.g_false,
530: p_user_name IN VARCHAR2 := NULL,
531: p_spec_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 558: -- Default is fnd_api.g_false.

554: --
555: -- p_init_msg_list VARCHAR2
556: -- Standard api parameter. Indicates whether to
557: -- re-initialize the message list.
558: -- Default is fnd_api.g_false.
559: --
560: -- p_user_name VARCHAR2(100)
561: -- The user's name, as defined in fnd_user table.
562: -- This is used to record audit info in the WHO columns.

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

573: -- The specification element name to be deleted.
574: --
575: -- p_commit VARCHAR2
576: -- Indicates whether the API shall perform a
577: -- database commit. Specify fnd_api.g_true or
578: -- fnd_api.g_false.
579: -- Default is fnd_api.g_false.
580: --
581: -- x_msg_count OUT NUMBER

Line 578: -- fnd_api.g_false.

574: --
575: -- p_commit VARCHAR2
576: -- Indicates whether the API shall perform a
577: -- database commit. Specify fnd_api.g_true or
578: -- fnd_api.g_false.
579: -- Default is fnd_api.g_false.
580: --
581: -- x_msg_count OUT NUMBER
582: -- Standard api parameter. Indicates no. of messages

Line 579: -- Default is fnd_api.g_false.

575: -- p_commit VARCHAR2
576: -- Indicates whether the API shall perform a
577: -- database commit. Specify fnd_api.g_true or
578: -- fnd_api.g_false.
579: -- Default is fnd_api.g_false.
580: --
581: -- x_msg_count OUT NUMBER
582: -- Standard api parameter. Indicates no. of messages
583: -- put into the message stack.

Line 590: -- Values: fnd_api.g_ret_sts_success,

586: -- Standard api parameter. Messages returned.
587: --
588: -- x_return_status OUT VARCHAR2
589: -- Standard api return status parameter.
590: -- Values: fnd_api.g_ret_sts_success,
591: -- fnd_api.g_ret_sts_error,
592: -- fnd_api.g_ret_sts_unexp_error.
593: --
594: /*#

Line 591: -- fnd_api.g_ret_sts_error,

587: --
588: -- x_return_status OUT VARCHAR2
589: -- Standard api return status parameter.
590: -- Values: fnd_api.g_ret_sts_success,
591: -- fnd_api.g_ret_sts_error,
592: -- fnd_api.g_ret_sts_unexp_error.
593: --
594: /*#
595: * Delete an element from a specification

Line 592: -- fnd_api.g_ret_sts_unexp_error.

588: -- x_return_status OUT VARCHAR2
589: -- Standard api return status parameter.
590: -- Values: fnd_api.g_ret_sts_success,
591: -- fnd_api.g_ret_sts_error,
592: -- fnd_api.g_ret_sts_unexp_error.
593: --
594: /*#
595: * Delete an element from a specification
596: * @param p_api_version Should be 1.0

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

606: * @rep:displayname Delete specification element
607: */
608: PROCEDURE delete_spec_element(
609: p_api_version IN NUMBER,
610: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
611: p_user_name IN VARCHAR2 := NULL,
612: p_spec_name IN VARCHAR2,
613: p_organization_code IN VARCHAR2,
614: p_element_name IN VARCHAR2,

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

611: p_user_name IN VARCHAR2 := NULL,
612: p_spec_name IN VARCHAR2,
613: p_organization_code IN VARCHAR2,
614: p_element_name IN VARCHAR2,
615: p_commit IN VARCHAR2 := fnd_api.g_false,
616: x_msg_count OUT NOCOPY NUMBER,
617: x_msg_data OUT NOCOPY VARCHAR2,
618: x_return_status OUT NOCOPY VARCHAR2);
619:

Line 643: -- Default is fnd_api.g_false.

639: --
640: -- p_init_msg_list VARCHAR2
641: -- Standard api parameter. Indicates whether to
642: -- re-initialize the message list.
643: -- Default is fnd_api.g_false.
644: --
645: -- p_user_name VARCHAR2(100)
646: -- The user's name, as defined in fnd_user table.
647: -- This is used to record audit info in the WHO columns.

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

669: -- Default is NULL.
670: --
671: -- p_commit VARCHAR2
672: -- Indicates whether the API shall perform a
673: -- database commit. Specify fnd_api.g_true or
674: -- fnd_api.g_false.
675: -- Default is fnd_api.g_false.
676: --
677: -- x_spec_id OUT NUMBER

Line 674: -- fnd_api.g_false.

670: --
671: -- p_commit VARCHAR2
672: -- Indicates whether the API shall perform a
673: -- database commit. Specify fnd_api.g_true or
674: -- fnd_api.g_false.
675: -- Default is fnd_api.g_false.
676: --
677: -- x_spec_id OUT NUMBER
678: -- Specification ID of the created specification.

Line 675: -- Default is fnd_api.g_false.

671: -- p_commit VARCHAR2
672: -- Indicates whether the API shall perform a
673: -- database commit. Specify fnd_api.g_true or
674: -- fnd_api.g_false.
675: -- Default is fnd_api.g_false.
676: --
677: -- x_spec_id OUT NUMBER
678: -- Specification ID of the created specification.
679: --

Line 689: -- Values: fnd_api.g_ret_sts_success,

685: -- Standard api parameter. Messages returned.
686: --
687: -- x_return_status OUT VARCHAR2
688: -- Standard api return status parameter.
689: -- Values: fnd_api.g_ret_sts_success,
690: -- fnd_api.g_ret_sts_error,
691: -- fnd_api.g_ret_sts_unexp_error.
692: --
693: /*#

Line 690: -- fnd_api.g_ret_sts_error,

686: --
687: -- x_return_status OUT VARCHAR2
688: -- Standard api return status parameter.
689: -- Values: fnd_api.g_ret_sts_success,
690: -- fnd_api.g_ret_sts_error,
691: -- fnd_api.g_ret_sts_unexp_error.
692: --
693: /*#
694: * Create a new specification by copying definition of an existing specification

Line 691: -- fnd_api.g_ret_sts_unexp_error.

687: -- x_return_status OUT VARCHAR2
688: -- Standard api return status parameter.
689: -- Values: fnd_api.g_ret_sts_success,
690: -- fnd_api.g_ret_sts_error,
691: -- fnd_api.g_ret_sts_unexp_error.
692: --
693: /*#
694: * Create a new specification by copying definition of an existing specification
695: * @param p_api_version Should be 1.0

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

709: * @rep:displayname Copy Specification
710: */
711: PROCEDURE copy_specification(
712: p_api_version IN NUMBER,
713: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
714: p_user_name IN VARCHAR2 := NULL,
715: p_spec_name IN VARCHAR2,
716: p_organization_code IN VARCHAR2,
717: p_to_spec_name IN VARCHAR2,

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

717: p_to_spec_name IN VARCHAR2,
718: p_to_organization_code IN VARCHAR2,
719: p_to_item_name IN VARCHAR2,
720: p_to_item_revision IN VARCHAR2 := NULL,
721: p_commit IN VARCHAR2 := fnd_api.g_false,
722: x_spec_id OUT NOCOPY NUMBER,
723: x_msg_count OUT NOCOPY NUMBER,
724: x_msg_data OUT NOCOPY VARCHAR2,
725: x_return_status OUT NOCOPY VARCHAR2);