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 242: -- Default is fnd_api.g_false.

238: --
239: -- p_init_msg_list VARCHAR2
240: -- Standard api parameter. Indicates whether to
241: -- re-initialize the message list.
242: -- Default is fnd_api.g_false.
243: --
244: -- p_validation_level NUMBER
245: -- Standard api parameter. Indicates validation level.
246: -- Use the default fnd_api.g_valid_level_full.

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

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

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

266: -- Default is NULL.
267: --
268: -- p_enabled_flag VARCHAR2
269: -- Indicates whether this element is enabled.
270: -- Values: fnd_api.g_true or fnd_api.g_false.
271: -- Default is fnd_api.g_true.
272: --
273: -- p_target_value VARCHAR2
274: -- Target value.

Line 271: -- Default is fnd_api.g_true.

267: --
268: -- p_enabled_flag VARCHAR2
269: -- Indicates whether this element is enabled.
270: -- Values: fnd_api.g_true or fnd_api.g_false.
271: -- Default is fnd_api.g_true.
272: --
273: -- p_target_value VARCHAR2
274: -- Target value.
275: -- Default is NULL.

Line 310: -- Values: fnd_api.g_ret_sts_success,

306: -- Standard api parameter. Messages returned.
307: --
308: -- x_return_status OUT VARCHAR2
309: -- Standard api return status parameter.
310: -- Values: fnd_api.g_ret_sts_success,
311: -- fnd_api.g_ret_sts_error,
312: -- fnd_api.g_ret_sts_unexp_error.
313: --
314: /*#

Line 311: -- fnd_api.g_ret_sts_error,

307: --
308: -- x_return_status OUT VARCHAR2
309: -- Standard api return status parameter.
310: -- Values: fnd_api.g_ret_sts_success,
311: -- fnd_api.g_ret_sts_error,
312: -- fnd_api.g_ret_sts_unexp_error.
313: --
314: /*#
315: * Add specification element to an existing specification

Line 312: -- fnd_api.g_ret_sts_unexp_error.

308: -- x_return_status OUT VARCHAR2
309: -- Standard api return status parameter.
310: -- Values: fnd_api.g_ret_sts_success,
311: -- fnd_api.g_ret_sts_error,
312: -- fnd_api.g_ret_sts_unexp_error.
313: --
314: /*#
315: * Add specification element to an existing specification
316: * @param p_api_version Should be 1.0

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

335: * @rep:displayname Add specification element
336: */
337: PROCEDURE add_spec_element(
338: p_api_version IN NUMBER,
339: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
340: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
341: p_user_name IN VARCHAR2 := NULL,
342: p_spec_name IN VARCHAR2,
343: p_organization_code IN VARCHAR2,

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

336: */
337: PROCEDURE add_spec_element(
338: p_api_version IN NUMBER,
339: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
340: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
341: p_user_name IN VARCHAR2 := NULL,
342: p_spec_name IN VARCHAR2,
343: p_organization_code IN VARCHAR2,
344: p_element_name IN VARCHAR2,

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

342: p_spec_name IN VARCHAR2,
343: p_organization_code IN VARCHAR2,
344: p_element_name IN VARCHAR2,
345: p_uom_code IN VARCHAR2 := NULL,
346: p_enabled_flag IN VARCHAR2 := fnd_api.g_true,
347: p_target_value IN VARCHAR2 := NULL,
348: p_upper_spec_limit IN VARCHAR2 := NULL,
349: p_lower_spec_limit IN VARCHAR2 := NULL,
350: p_upper_reasonable_limit IN VARCHAR2 := NULL,

Line 397: -- Default is fnd_api.g_false.

393: --
394: -- p_init_msg_list VARCHAR2
395: -- Standard api parameter. Indicates whether to
396: -- re-initialize the message list.
397: -- Default is fnd_api.g_false.
398: --
399: -- p_user_name VARCHAR2(100)
400: -- The user's name, as defined in fnd_user table.
401: -- This is used to record audit info in the WHO columns.

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

409: -- Organization code.
410: --
411: -- p_commit VARCHAR2
412: -- Indicates whether the API shall perform a
413: -- database commit. Specify fnd_api.g_true or
414: -- fnd_api.g_false.
415: -- Default is fnd_api.g_false.
416: --
417: -- x_msg_count OUT NUMBER

Line 414: -- fnd_api.g_false.

410: --
411: -- p_commit VARCHAR2
412: -- Indicates whether the API shall perform a
413: -- database commit. Specify fnd_api.g_true or
414: -- fnd_api.g_false.
415: -- Default is fnd_api.g_false.
416: --
417: -- x_msg_count OUT NUMBER
418: -- Standard api parameter. Indicates no. of messages

Line 415: -- Default is fnd_api.g_false.

411: -- p_commit VARCHAR2
412: -- Indicates whether the API shall perform a
413: -- database commit. Specify fnd_api.g_true or
414: -- fnd_api.g_false.
415: -- Default is fnd_api.g_false.
416: --
417: -- x_msg_count OUT NUMBER
418: -- Standard api parameter. Indicates no. of messages
419: -- put into the message stack.

Line 426: -- Values: fnd_api.g_ret_sts_success,

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

Line 427: -- fnd_api.g_ret_sts_error,

423: --
424: -- x_return_status OUT VARCHAR2
425: -- Standard api return status parameter.
426: -- Values: fnd_api.g_ret_sts_success,
427: -- fnd_api.g_ret_sts_error,
428: -- fnd_api.g_ret_sts_unexp_error.
429: --
430: /*#
431: * Complete definition of a new specification

Line 428: -- fnd_api.g_ret_sts_unexp_error.

424: -- x_return_status OUT VARCHAR2
425: -- Standard api return status parameter.
426: -- Values: fnd_api.g_ret_sts_success,
427: -- fnd_api.g_ret_sts_error,
428: -- fnd_api.g_ret_sts_unexp_error.
429: --
430: /*#
431: * Complete definition of a new specification
432: * @param p_api_version Should be 1.0

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

441: * @rep:displayname Complete specification processing
442: */
443: PROCEDURE complete_spec_processing(
444: p_api_version IN NUMBER,
445: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
446: p_user_name IN VARCHAR2 := NULL,
447: p_spec_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_init_msg_list IN VARCHAR2 := fnd_api.g_false,
446: p_user_name IN VARCHAR2 := NULL,
447: p_spec_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 474: -- Default is fnd_api.g_false.

470: --
471: -- p_init_msg_list VARCHAR2
472: -- Standard api parameter. Indicates whether to
473: -- re-initialize the message list.
474: -- Default is fnd_api.g_false.
475: --
476: -- p_user_name VARCHAR2(100)
477: -- The user's name, as defined in fnd_user table.
478: -- This is used to record audit info in the WHO columns.

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

486: -- Organization code.
487: --
488: -- p_commit VARCHAR2
489: -- Indicates whether the API shall perform a
490: -- database commit. Specify fnd_api.g_true or
491: -- fnd_api.g_false.
492: -- Default is fnd_api.g_false.
493: --
494: -- x_msg_count OUT NUMBER

Line 491: -- fnd_api.g_false.

487: --
488: -- p_commit VARCHAR2
489: -- Indicates whether the API shall perform a
490: -- database commit. Specify fnd_api.g_true or
491: -- fnd_api.g_false.
492: -- Default is fnd_api.g_false.
493: --
494: -- x_msg_count OUT NUMBER
495: -- Standard api parameter. Indicates no. of messages

Line 492: -- Default is fnd_api.g_false.

488: -- p_commit VARCHAR2
489: -- Indicates whether the API shall perform a
490: -- database commit. Specify fnd_api.g_true or
491: -- fnd_api.g_false.
492: -- Default is fnd_api.g_false.
493: --
494: -- x_msg_count OUT NUMBER
495: -- Standard api parameter. Indicates no. of messages
496: -- put into the message stack.

Line 503: -- Values: fnd_api.g_ret_sts_success,

499: -- Standard api parameter. Messages returned.
500: --
501: -- x_return_status OUT VARCHAR2
502: -- Standard api return status parameter.
503: -- Values: fnd_api.g_ret_sts_success,
504: -- fnd_api.g_ret_sts_error,
505: -- fnd_api.g_ret_sts_unexp_error.
506: --
507: /*#

Line 504: -- fnd_api.g_ret_sts_error,

500: --
501: -- x_return_status OUT VARCHAR2
502: -- Standard api return status parameter.
503: -- Values: fnd_api.g_ret_sts_success,
504: -- fnd_api.g_ret_sts_error,
505: -- fnd_api.g_ret_sts_unexp_error.
506: --
507: /*#
508: * Delete an existing specification

Line 505: -- fnd_api.g_ret_sts_unexp_error.

501: -- x_return_status OUT VARCHAR2
502: -- Standard api return status parameter.
503: -- Values: fnd_api.g_ret_sts_success,
504: -- fnd_api.g_ret_sts_error,
505: -- fnd_api.g_ret_sts_unexp_error.
506: --
507: /*#
508: * Delete an existing specification
509: * @param p_api_version Should be 1.0

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

518: * @rep:displayname Delete Specification
519: */
520: PROCEDURE delete_specification(
521: p_api_version IN NUMBER,
522: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
523: p_user_name IN VARCHAR2 := NULL,
524: p_spec_name IN VARCHAR2,
525: p_organization_code IN VARCHAR2,
526: p_commit IN VARCHAR2 := fnd_api.g_false,

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

522: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
523: p_user_name IN VARCHAR2 := NULL,
524: p_spec_name IN VARCHAR2,
525: p_organization_code IN VARCHAR2,
526: p_commit IN VARCHAR2 := fnd_api.g_false,
527: x_msg_count OUT NOCOPY NUMBER,
528: x_msg_data OUT NOCOPY VARCHAR2,
529: x_return_status OUT NOCOPY VARCHAR2);
530:

Line 551: -- Default is fnd_api.g_false.

547: --
548: -- p_init_msg_list VARCHAR2
549: -- Standard api parameter. Indicates whether to
550: -- re-initialize the message list.
551: -- Default is fnd_api.g_false.
552: --
553: -- p_user_name VARCHAR2(100)
554: -- The user's name, as defined in fnd_user table.
555: -- This is used to record audit info in the WHO columns.

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

566: -- The specification element name to be deleted.
567: --
568: -- p_commit VARCHAR2
569: -- Indicates whether the API shall perform a
570: -- database commit. Specify fnd_api.g_true or
571: -- fnd_api.g_false.
572: -- Default is fnd_api.g_false.
573: --
574: -- x_msg_count OUT NUMBER

Line 571: -- fnd_api.g_false.

567: --
568: -- p_commit VARCHAR2
569: -- Indicates whether the API shall perform a
570: -- database commit. Specify fnd_api.g_true or
571: -- fnd_api.g_false.
572: -- Default is fnd_api.g_false.
573: --
574: -- x_msg_count OUT NUMBER
575: -- Standard api parameter. Indicates no. of messages

Line 572: -- Default is fnd_api.g_false.

568: -- p_commit VARCHAR2
569: -- Indicates whether the API shall perform a
570: -- database commit. Specify fnd_api.g_true or
571: -- fnd_api.g_false.
572: -- Default is fnd_api.g_false.
573: --
574: -- x_msg_count OUT NUMBER
575: -- Standard api parameter. Indicates no. of messages
576: -- put into the message stack.

Line 583: -- Values: fnd_api.g_ret_sts_success,

579: -- Standard api parameter. Messages returned.
580: --
581: -- x_return_status OUT VARCHAR2
582: -- Standard api return status parameter.
583: -- Values: fnd_api.g_ret_sts_success,
584: -- fnd_api.g_ret_sts_error,
585: -- fnd_api.g_ret_sts_unexp_error.
586: --
587: /*#

Line 584: -- fnd_api.g_ret_sts_error,

580: --
581: -- x_return_status OUT VARCHAR2
582: -- Standard api return status parameter.
583: -- Values: fnd_api.g_ret_sts_success,
584: -- fnd_api.g_ret_sts_error,
585: -- fnd_api.g_ret_sts_unexp_error.
586: --
587: /*#
588: * Delete an element from a specification

Line 585: -- fnd_api.g_ret_sts_unexp_error.

581: -- x_return_status OUT VARCHAR2
582: -- Standard api return status parameter.
583: -- Values: fnd_api.g_ret_sts_success,
584: -- fnd_api.g_ret_sts_error,
585: -- fnd_api.g_ret_sts_unexp_error.
586: --
587: /*#
588: * Delete an element from a specification
589: * @param p_api_version Should be 1.0

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

599: * @rep:displayname Delete specification element
600: */
601: PROCEDURE delete_spec_element(
602: p_api_version IN NUMBER,
603: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
604: p_user_name IN VARCHAR2 := NULL,
605: p_spec_name IN VARCHAR2,
606: p_organization_code IN VARCHAR2,
607: p_element_name IN VARCHAR2,

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

604: p_user_name IN VARCHAR2 := NULL,
605: p_spec_name IN VARCHAR2,
606: p_organization_code IN VARCHAR2,
607: p_element_name IN VARCHAR2,
608: p_commit IN VARCHAR2 := fnd_api.g_false,
609: x_msg_count OUT NOCOPY NUMBER,
610: x_msg_data OUT NOCOPY VARCHAR2,
611: x_return_status OUT NOCOPY VARCHAR2);
612:

Line 636: -- Default is fnd_api.g_false.

632: --
633: -- p_init_msg_list VARCHAR2
634: -- Standard api parameter. Indicates whether to
635: -- re-initialize the message list.
636: -- Default is fnd_api.g_false.
637: --
638: -- p_user_name VARCHAR2(100)
639: -- The user's name, as defined in fnd_user table.
640: -- This is used to record audit info in the WHO columns.

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

662: -- Default is NULL.
663: --
664: -- p_commit VARCHAR2
665: -- Indicates whether the API shall perform a
666: -- database commit. Specify fnd_api.g_true or
667: -- fnd_api.g_false.
668: -- Default is fnd_api.g_false.
669: --
670: -- x_spec_id OUT NUMBER

Line 667: -- fnd_api.g_false.

663: --
664: -- p_commit VARCHAR2
665: -- Indicates whether the API shall perform a
666: -- database commit. Specify fnd_api.g_true or
667: -- fnd_api.g_false.
668: -- Default is fnd_api.g_false.
669: --
670: -- x_spec_id OUT NUMBER
671: -- Specification ID of the created specification.

Line 668: -- Default is fnd_api.g_false.

664: -- p_commit VARCHAR2
665: -- Indicates whether the API shall perform a
666: -- database commit. Specify fnd_api.g_true or
667: -- fnd_api.g_false.
668: -- Default is fnd_api.g_false.
669: --
670: -- x_spec_id OUT NUMBER
671: -- Specification ID of the created specification.
672: --

Line 682: -- Values: fnd_api.g_ret_sts_success,

678: -- Standard api parameter. Messages returned.
679: --
680: -- x_return_status OUT VARCHAR2
681: -- Standard api return status parameter.
682: -- Values: fnd_api.g_ret_sts_success,
683: -- fnd_api.g_ret_sts_error,
684: -- fnd_api.g_ret_sts_unexp_error.
685: --
686: /*#

Line 683: -- fnd_api.g_ret_sts_error,

679: --
680: -- x_return_status OUT VARCHAR2
681: -- Standard api return status parameter.
682: -- Values: fnd_api.g_ret_sts_success,
683: -- fnd_api.g_ret_sts_error,
684: -- fnd_api.g_ret_sts_unexp_error.
685: --
686: /*#
687: * Create a new specification by copying definition of an existing specification

Line 684: -- fnd_api.g_ret_sts_unexp_error.

680: -- x_return_status OUT VARCHAR2
681: -- Standard api return status parameter.
682: -- Values: fnd_api.g_ret_sts_success,
683: -- fnd_api.g_ret_sts_error,
684: -- fnd_api.g_ret_sts_unexp_error.
685: --
686: /*#
687: * Create a new specification by copying definition of an existing specification
688: * @param p_api_version Should be 1.0

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

702: * @rep:displayname Copy Specification
703: */
704: PROCEDURE copy_specification(
705: p_api_version IN NUMBER,
706: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
707: p_user_name IN VARCHAR2 := NULL,
708: p_spec_name IN VARCHAR2,
709: p_organization_code IN VARCHAR2,
710: p_to_spec_name IN VARCHAR2,

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

710: p_to_spec_name IN VARCHAR2,
711: p_to_organization_code IN VARCHAR2,
712: p_to_item_name IN VARCHAR2,
713: p_to_item_revision IN VARCHAR2 := NULL,
714: p_commit IN VARCHAR2 := fnd_api.g_false,
715: x_spec_id OUT NOCOPY NUMBER,
716: x_msg_count OUT NOCOPY NUMBER,
717: x_msg_data OUT NOCOPY VARCHAR2,
718: x_return_status OUT NOCOPY VARCHAR2);