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

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

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

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

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

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

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

192: , p_transaction_action_id IN NUMBER := NULL
193: , p_transaction_source_type_id IN NUMBER := NULL
194: , p_lot_number IN VARCHAR2 := NULL
195: , p_api_version IN NUMBER
196: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
197: , p_commit IN VARCHAR2 := fnd_api.g_false
198: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
199: , p_parent_lot_number IN VARCHAR2
200: , x_return_status OUT NOCOPY VARCHAR2

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

193: , p_transaction_source_type_id IN NUMBER := NULL
194: , p_lot_number IN VARCHAR2 := NULL
195: , p_api_version IN NUMBER
196: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
197: , p_commit IN VARCHAR2 := fnd_api.g_false
198: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
199: , p_parent_lot_number IN VARCHAR2
200: , x_return_status OUT NOCOPY VARCHAR2
201: , x_msg_count OUT NOCOPY NUMBER

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

194: , p_lot_number IN VARCHAR2 := NULL
195: , p_api_version IN NUMBER
196: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
197: , p_commit IN VARCHAR2 := fnd_api.g_false
198: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
199: , p_parent_lot_number IN VARCHAR2
200: , x_return_status OUT NOCOPY VARCHAR2
201: , x_msg_count OUT NOCOPY NUMBER
202: , x_msg_data OUT NOCOPY VARCHAR2

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

297: , p_territory_code IN VARCHAR2
298: , p_supplier_lot_number IN VARCHAR2
299: , p_vendor_name IN VARCHAR2
300: , p_source IN NUMBER
301: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false -- bug 7513308
302: );
303:
304: /*
305: This is a procedure that validates the input parameters to the API.

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

414: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
415: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
416: , p_source IN NUMBER
417: , p_api_version IN NUMBER
418: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
419: , p_commit IN VARCHAR2 := fnd_api.g_false);
420: -- nsinghi bug#5209065 END.
421:
422: /*

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

415: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
416: , p_source IN NUMBER
417: , p_api_version IN NUMBER
418: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
419: , p_commit IN VARCHAR2 := fnd_api.g_false);
420: -- nsinghi bug#5209065 END.
421:
422: /*
423: This is a procedure that accepts all the unnamed and named WMS attributes and

Line 475: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

471:
472:
473: PROCEDURE validate_child_lot
474: ( p_api_version IN NUMBER
475: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
476: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
477: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
478: , p_organization_id IN NUMBER
479: , p_inventory_item_id IN NUMBER

Line 476: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

472:
473: PROCEDURE validate_child_lot
474: ( p_api_version IN NUMBER
475: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
476: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
477: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
478: , p_organization_id IN NUMBER
479: , p_inventory_item_id IN NUMBER
480: , p_parent_lot_number IN VARCHAR2

Line 477: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

473: PROCEDURE validate_child_lot
474: ( p_api_version IN NUMBER
475: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
476: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
477: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
478: , p_organization_id IN NUMBER
479: , p_inventory_item_id IN NUMBER
480: , p_parent_lot_number IN VARCHAR2
481: , p_child_lot_number IN VARCHAR2

Line 492: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

488: -- whether a lot transaction can be added into the inventory
489: -- regarding the lot definition.
490: FUNCTION validate_lot_indivisible
491: ( p_api_version IN NUMBER
492: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
493: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
494: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
495: , p_transaction_type_id IN NUMBER
496: , p_organization_id IN NUMBER

Line 493: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

489: -- regarding the lot definition.
490: FUNCTION validate_lot_indivisible
491: ( p_api_version IN NUMBER
492: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
493: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
494: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
495: , p_transaction_type_id IN NUMBER
496: , p_organization_id IN NUMBER
497: , p_inventory_item_id IN NUMBER

Line 494: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

490: FUNCTION validate_lot_indivisible
491: ( p_api_version IN NUMBER
492: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
493: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
494: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
495: , p_transaction_type_id IN NUMBER
496: , p_organization_id IN NUMBER
497: , p_inventory_item_id IN NUMBER
498: , p_revision IN VARCHAR2

Line 514: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

510: --Overloaded function which returns
511: --the Quantity as well
512: FUNCTION validate_lot_indivisible
513: ( p_api_version IN NUMBER
514: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
515: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
516: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
517: , p_transaction_type_id IN NUMBER
518: , p_organization_id IN NUMBER

Line 515: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

511: --the Quantity as well
512: FUNCTION validate_lot_indivisible
513: ( p_api_version IN NUMBER
514: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
515: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
516: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
517: , p_transaction_type_id IN NUMBER
518: , p_organization_id IN NUMBER
519: , p_inventory_item_id IN NUMBER

Line 516: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

512: FUNCTION validate_lot_indivisible
513: ( p_api_version IN NUMBER
514: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
515: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
516: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
517: , p_transaction_type_id IN NUMBER
518: , p_organization_id IN NUMBER
519: , p_inventory_item_id IN NUMBER
520: , p_revision IN VARCHAR2

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

544: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
545: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
546: , p_source IN NUMBER
547: , p_api_version IN NUMBER
548: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
549: , p_commit IN VARCHAR2 := fnd_api.g_false
550: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
551: , p_origin_txn_id IN NUMBER
552: ) ;

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

545: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
546: , p_source IN NUMBER
547: , p_api_version IN NUMBER
548: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
549: , p_commit IN VARCHAR2 := fnd_api.g_false
550: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
551: , p_origin_txn_id IN NUMBER
552: ) ;
553:

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

546: , p_source IN NUMBER
547: , p_api_version IN NUMBER
548: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
549: , p_commit IN VARCHAR2 := fnd_api.g_false
550: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
551: , p_origin_txn_id IN NUMBER
552: ) ;
553:
554: /* INVCONV, NSRIVAST, End*/

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

571: , p_transaction_action_id IN NUMBER := NULL
572: , p_transaction_source_type_id IN NUMBER := NULL
573: , p_lot_number IN VARCHAR2 := NULL
574: , p_api_version IN NUMBER
575: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
576: , p_commit IN VARCHAR2 := fnd_api.g_false
577: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
578: , x_return_status OUT NOCOPY VARCHAR2
579: , x_msg_count OUT NOCOPY NUMBER

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

572: , p_transaction_source_type_id IN NUMBER := NULL
573: , p_lot_number IN VARCHAR2 := NULL
574: , p_api_version IN NUMBER
575: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
576: , p_commit IN VARCHAR2 := fnd_api.g_false
577: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
578: , x_return_status OUT NOCOPY VARCHAR2
579: , x_msg_count OUT NOCOPY NUMBER
580: , x_msg_data OUT NOCOPY VARCHAR2

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

573: , p_lot_number IN VARCHAR2 := NULL
574: , p_api_version IN NUMBER
575: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
576: , p_commit IN VARCHAR2 := fnd_api.g_false
577: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
578: , x_return_status OUT NOCOPY VARCHAR2
579: , x_msg_count OUT NOCOPY NUMBER
580: , x_msg_data OUT NOCOPY VARCHAR2
581: )

Line 589: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

585:
586: /*INVCONV, Punit Kumar*/
587:
588: PROCEDURE CHECK_LOT_INDIVISIBILITY ( p_api_version IN NUMBER DEFAULT 1.0
589: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
590: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
591: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
592: ,p_rti_id IN NUMBER
593: ,p_transaction_type_id IN NUMBER

Line 590: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

586: /*INVCONV, Punit Kumar*/
587:
588: PROCEDURE CHECK_LOT_INDIVISIBILITY ( p_api_version IN NUMBER DEFAULT 1.0
589: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
590: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
591: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
592: ,p_rti_id IN NUMBER
593: ,p_transaction_type_id IN NUMBER
594: ,p_lot_number IN VARCHAR2

Line 591: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

587:
588: PROCEDURE CHECK_LOT_INDIVISIBILITY ( p_api_version IN NUMBER DEFAULT 1.0
589: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
590: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
591: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
592: ,p_rti_id IN NUMBER
593: ,p_transaction_type_id IN NUMBER
594: ,p_lot_number IN VARCHAR2
595: ,p_lot_quantity IN NUMBER

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

620: --
621: -----------------------------------------------------------------------
622: FUNCTION validate_quantities(
623: p_api_version IN NUMBER
624: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
625: , p_transaction_type_id IN NUMBER
626: , p_organization_id IN NUMBER
627: , p_inventory_item_id IN NUMBER
628: , p_revision IN VARCHAR2