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

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

78: * Standard WHO information is used from the fnd_global api.
79: */
80: PROCEDURE insertlot(
81: p_api_version IN NUMBER
82: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
83: , p_commit IN VARCHAR2 := fnd_api.g_false
84: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
85: , p_inventory_item_id IN NUMBER
86: , p_organization_id IN NUMBER

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

79: */
80: PROCEDURE insertlot(
81: p_api_version IN NUMBER
82: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
83: , p_commit IN VARCHAR2 := fnd_api.g_false
84: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
85: , p_inventory_item_id IN NUMBER
86: , p_organization_id IN NUMBER
87: , p_lot_number IN VARCHAR2

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

80: PROCEDURE insertlot(
81: p_api_version IN NUMBER
82: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
83: , p_commit IN VARCHAR2 := fnd_api.g_false
84: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
85: , p_inventory_item_id IN NUMBER
86: , p_organization_id IN NUMBER
87: , p_lot_number IN VARCHAR2
88: , p_expiration_date IN OUT NOCOPY DATE

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

98: );
99:
100: PROCEDURE inserttrxlot(
101: p_api_version IN NUMBER
102: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
103: , p_commit IN VARCHAR2 := fnd_api.g_false
104: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
105: , p_primary_quantity IN NUMBER DEFAULT NULL
106: , p_transaction_id IN NUMBER

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

99:
100: PROCEDURE inserttrxlot(
101: p_api_version IN NUMBER
102: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
103: , p_commit IN VARCHAR2 := fnd_api.g_false
104: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
105: , p_primary_quantity IN NUMBER DEFAULT NULL
106: , p_transaction_id IN NUMBER
107: , p_inventory_item_id IN NUMBER

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

100: PROCEDURE inserttrxlot(
101: p_api_version IN NUMBER
102: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
103: , p_commit IN VARCHAR2 := fnd_api.g_false
104: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
105: , p_primary_quantity IN NUMBER DEFAULT NULL
106: , p_transaction_id IN NUMBER
107: , p_inventory_item_id IN NUMBER
108: , p_organization_id IN NUMBER

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

197: , p_transaction_action_id IN NUMBER := NULL
198: , p_transaction_source_type_id IN NUMBER := NULL
199: , p_lot_number IN VARCHAR2 := NULL
200: , p_api_version IN NUMBER
201: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
202: , p_commit IN VARCHAR2 := fnd_api.g_false
203: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
204: , p_parent_lot_number IN VARCHAR2
205: , x_return_status OUT NOCOPY VARCHAR2

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

198: , p_transaction_source_type_id IN NUMBER := NULL
199: , p_lot_number IN VARCHAR2 := NULL
200: , p_api_version IN NUMBER
201: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
202: , p_commit IN VARCHAR2 := fnd_api.g_false
203: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
204: , p_parent_lot_number IN VARCHAR2
205: , x_return_status OUT NOCOPY VARCHAR2
206: , x_msg_count OUT NOCOPY NUMBER

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

199: , p_lot_number IN VARCHAR2 := NULL
200: , p_api_version IN NUMBER
201: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
202: , p_commit IN VARCHAR2 := fnd_api.g_false
203: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
204: , p_parent_lot_number IN VARCHAR2
205: , x_return_status OUT NOCOPY VARCHAR2
206: , x_msg_count OUT NOCOPY NUMBER
207: , x_msg_data OUT NOCOPY VARCHAR2

Line 308: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false -- bug 7513308

304: , p_territory_code IN VARCHAR2
305: , p_supplier_lot_number IN VARCHAR2
306: , p_vendor_name IN VARCHAR2
307: , p_source IN NUMBER
308: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false -- bug 7513308
309: );
310:
311: /*
312: This is a procedure that validates the input parameters to the API.

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

422: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
423: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
424: , p_source IN NUMBER
425: , p_api_version IN NUMBER
426: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
427: , p_commit IN VARCHAR2 := fnd_api.g_false);
428: -- nsinghi bug#5209065 END.
429:
430: /*

Line 427: , p_commit IN VARCHAR2 := fnd_api.g_false);

423: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
424: , p_source IN NUMBER
425: , p_api_version IN NUMBER
426: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
427: , p_commit IN VARCHAR2 := fnd_api.g_false);
428: -- nsinghi bug#5209065 END.
429:
430: /*
431: This is a procedure that accepts all the unnamed and named WMS attributes and

Line 483: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

479:
480:
481: PROCEDURE validate_child_lot
482: ( p_api_version IN NUMBER
483: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
484: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
485: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
486: , p_organization_id IN NUMBER
487: , p_inventory_item_id IN NUMBER

Line 484: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

480:
481: PROCEDURE validate_child_lot
482: ( p_api_version IN NUMBER
483: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
484: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
485: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
486: , p_organization_id IN NUMBER
487: , p_inventory_item_id IN NUMBER
488: , p_parent_lot_number IN VARCHAR2

Line 485: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

481: PROCEDURE validate_child_lot
482: ( p_api_version IN NUMBER
483: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
484: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
485: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
486: , p_organization_id IN NUMBER
487: , p_inventory_item_id IN NUMBER
488: , p_parent_lot_number IN VARCHAR2
489: , p_child_lot_number IN VARCHAR2

Line 500: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

496: -- whether a lot transaction can be added into the inventory
497: -- regarding the lot definition.
498: FUNCTION validate_lot_indivisible
499: ( p_api_version IN NUMBER
500: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
501: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
502: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
503: , p_transaction_type_id IN NUMBER
504: , p_organization_id IN NUMBER

Line 501: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

497: -- regarding the lot definition.
498: FUNCTION validate_lot_indivisible
499: ( p_api_version IN NUMBER
500: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
501: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
502: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
503: , p_transaction_type_id IN NUMBER
504: , p_organization_id IN NUMBER
505: , p_inventory_item_id IN NUMBER

Line 502: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

498: FUNCTION validate_lot_indivisible
499: ( p_api_version IN NUMBER
500: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
501: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
502: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
503: , p_transaction_type_id IN NUMBER
504: , p_organization_id IN NUMBER
505: , p_inventory_item_id IN NUMBER
506: , p_revision IN VARCHAR2

Line 522: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

518: --Overloaded function which returns
519: --the Quantity as well
520: FUNCTION validate_lot_indivisible
521: ( p_api_version IN NUMBER
522: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
523: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
524: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
525: , p_transaction_type_id IN NUMBER
526: , p_organization_id IN NUMBER

Line 523: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

519: --the Quantity as well
520: FUNCTION validate_lot_indivisible
521: ( p_api_version IN NUMBER
522: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
523: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
524: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
525: , p_transaction_type_id IN NUMBER
526: , p_organization_id IN NUMBER
527: , p_inventory_item_id IN NUMBER

Line 524: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

520: FUNCTION validate_lot_indivisible
521: ( p_api_version IN NUMBER
522: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
523: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
524: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
525: , p_transaction_type_id IN NUMBER
526: , p_organization_id IN NUMBER
527: , p_inventory_item_id IN NUMBER
528: , p_revision IN VARCHAR2

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

555: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
556: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
557: , p_source IN NUMBER
558: , p_api_version IN NUMBER
559: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
560: , p_commit IN VARCHAR2 := fnd_api.g_false
561: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
562: , p_origin_txn_id IN NUMBER
563: ) ;

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

556: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
557: , p_source IN NUMBER
558: , p_api_version IN NUMBER
559: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
560: , p_commit IN VARCHAR2 := fnd_api.g_false
561: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
562: , p_origin_txn_id IN NUMBER
563: ) ;
564:

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

557: , p_source IN NUMBER
558: , p_api_version IN NUMBER
559: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
560: , p_commit IN VARCHAR2 := fnd_api.g_false
561: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
562: , p_origin_txn_id IN NUMBER
563: ) ;
564:
565:

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

572: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
573: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
574: , p_source IN NUMBER
575: , p_api_version IN NUMBER
576: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
577: , p_commit IN VARCHAR2 := fnd_api.g_false
578: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
579: , p_origin_txn_id IN NUMBER
580: , p_caculate_flag IN VARCHAR2 -- 14192172

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

573: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
574: , p_source IN NUMBER
575: , p_api_version IN NUMBER
576: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
577: , p_commit IN VARCHAR2 := fnd_api.g_false
578: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
579: , p_origin_txn_id IN NUMBER
580: , p_caculate_flag IN VARCHAR2 -- 14192172
581: ) ;

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

574: , p_source IN NUMBER
575: , p_api_version IN NUMBER
576: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
577: , p_commit IN VARCHAR2 := fnd_api.g_false
578: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
579: , p_origin_txn_id IN NUMBER
580: , p_caculate_flag IN VARCHAR2 -- 14192172
581: ) ;
582:

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

603: , p_transaction_action_id IN NUMBER := NULL
604: , p_transaction_source_type_id IN NUMBER := NULL
605: , p_lot_number IN VARCHAR2 := NULL
606: , p_api_version IN NUMBER
607: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
608: , p_commit IN VARCHAR2 := fnd_api.g_false
609: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
610: , x_return_status OUT NOCOPY VARCHAR2
611: , x_msg_count OUT NOCOPY NUMBER

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

604: , p_transaction_source_type_id IN NUMBER := NULL
605: , p_lot_number IN VARCHAR2 := NULL
606: , p_api_version IN NUMBER
607: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
608: , p_commit IN VARCHAR2 := fnd_api.g_false
609: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
610: , x_return_status OUT NOCOPY VARCHAR2
611: , x_msg_count OUT NOCOPY NUMBER
612: , x_msg_data OUT NOCOPY VARCHAR2

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

605: , p_lot_number IN VARCHAR2 := NULL
606: , p_api_version IN NUMBER
607: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
608: , p_commit IN VARCHAR2 := fnd_api.g_false
609: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
610: , x_return_status OUT NOCOPY VARCHAR2
611: , x_msg_count OUT NOCOPY NUMBER
612: , x_msg_data OUT NOCOPY VARCHAR2
613: , p_transaction_source_id IN NUMBER DEFAULT NULL /* 13368816 */

Line 623: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

619:
620: /*INVCONV, Punit Kumar*/
621:
622: PROCEDURE CHECK_LOT_INDIVISIBILITY ( p_api_version IN NUMBER DEFAULT 1.0
623: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
624: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
625: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
626: ,p_rti_id IN NUMBER
627: ,p_transaction_type_id IN NUMBER

Line 624: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

620: /*INVCONV, Punit Kumar*/
621:
622: PROCEDURE CHECK_LOT_INDIVISIBILITY ( p_api_version IN NUMBER DEFAULT 1.0
623: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
624: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
625: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
626: ,p_rti_id IN NUMBER
627: ,p_transaction_type_id IN NUMBER
628: ,p_lot_number IN VARCHAR2

Line 625: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

621:
622: PROCEDURE CHECK_LOT_INDIVISIBILITY ( p_api_version IN NUMBER DEFAULT 1.0
623: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
624: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
625: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
626: ,p_rti_id IN NUMBER
627: ,p_transaction_type_id IN NUMBER
628: ,p_lot_number IN VARCHAR2
629: ,p_lot_quantity IN NUMBER

Line 658: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

654: --
655: -----------------------------------------------------------------------
656: FUNCTION validate_quantities(
657: p_api_version IN NUMBER
658: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
659: , p_transaction_type_id IN NUMBER
660: , p_organization_id IN NUMBER
661: , p_inventory_item_id IN NUMBER
662: , p_revision IN VARCHAR2