DBA Data[Home] [Help]

APPS.GME_PENDING_PRODUCT_LOTS_PVT dependencies on MTL_LOT_NUMBERS

Line 25: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL

21:
22: PROCEDURE create_product_lot
23: (p_organization_id IN NUMBER
24: ,p_inventory_item_id IN NUMBER
25: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
26: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
27: ,p_generate_lot IN VARCHAR2
28: ,p_generate_parent_lot IN VARCHAR2
29: /* nsinghi bug#4486074 Added the p_expiration_Date parameter. */

Line 30: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL

26: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
27: ,p_generate_lot IN VARCHAR2
28: ,p_generate_parent_lot IN VARCHAR2
29: /* nsinghi bug#4486074 Added the p_expiration_Date parameter. */
30: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
31: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
32: ,x_return_status OUT NOCOPY VARCHAR2);
33:
34: PROCEDURE create_pending_product_lot

Line 64: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL

60: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
61: ,p_create_lot IN VARCHAR2
62: ,p_generate_lot IN VARCHAR2
63: ,p_generate_parent_lot IN VARCHAR2
64: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
65: /* nsinghi bug#4486074 Added the p_expiration_Date parameter. */
66: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
67: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
68: ,x_return_status OUT NOCOPY VARCHAR2);

Line 66: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL

62: ,p_generate_lot IN VARCHAR2
63: ,p_generate_parent_lot IN VARCHAR2
64: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
65: /* nsinghi bug#4486074 Added the p_expiration_Date parameter. */
66: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
67: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
68: ,x_return_status OUT NOCOPY VARCHAR2);
69:
70: PROCEDURE validate_material_for_update