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.GME_PENDING_PRODUCT_LOTS_PVT dependencies on MTL_LOT_NUMBERS

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

142:
143: PROCEDURE create_product_lot
144: (p_organization_id IN NUMBER
145: ,p_inventory_item_id IN NUMBER
146: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
147: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
148: ,p_generate_lot IN VARCHAR2
149: ,p_generate_parent_lot IN VARCHAR2
150: /* nsinghi bug#4486074 Added the p_expiration_Date parameter. */

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

147: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
148: ,p_generate_lot IN VARCHAR2
149: ,p_generate_parent_lot IN VARCHAR2
150: /* nsinghi bug#4486074 Added the p_expiration_Date parameter. */
151: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
152: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
153: ,x_return_status OUT NOCOPY VARCHAR2) IS
154:
155: l_parent_lot mtl_lot_numbers.lot_number%TYPE;

Line 155: l_parent_lot mtl_lot_numbers.lot_number%TYPE;

151: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
152: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
153: ,x_return_status OUT NOCOPY VARCHAR2) IS
154:
155: l_parent_lot mtl_lot_numbers.lot_number%TYPE;
156: l_gen_lot mtl_lot_numbers.lot_number%TYPE;
157: l_in_lot_rec mtl_lot_numbers%ROWTYPE;
158: l_lot_rec mtl_lot_numbers%ROWTYPE;
159: l_null_lot_number BOOLEAN;

Line 156: l_gen_lot mtl_lot_numbers.lot_number%TYPE;

152: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
153: ,x_return_status OUT NOCOPY VARCHAR2) IS
154:
155: l_parent_lot mtl_lot_numbers.lot_number%TYPE;
156: l_gen_lot mtl_lot_numbers.lot_number%TYPE;
157: l_in_lot_rec mtl_lot_numbers%ROWTYPE;
158: l_lot_rec mtl_lot_numbers%ROWTYPE;
159: l_null_lot_number BOOLEAN;
160:

Line 157: l_in_lot_rec mtl_lot_numbers%ROWTYPE;

153: ,x_return_status OUT NOCOPY VARCHAR2) IS
154:
155: l_parent_lot mtl_lot_numbers.lot_number%TYPE;
156: l_gen_lot mtl_lot_numbers.lot_number%TYPE;
157: l_in_lot_rec mtl_lot_numbers%ROWTYPE;
158: l_lot_rec mtl_lot_numbers%ROWTYPE;
159: l_null_lot_number BOOLEAN;
160:
161: l_msg_count NUMBER;

Line 158: l_lot_rec mtl_lot_numbers%ROWTYPE;

154:
155: l_parent_lot mtl_lot_numbers.lot_number%TYPE;
156: l_gen_lot mtl_lot_numbers.lot_number%TYPE;
157: l_in_lot_rec mtl_lot_numbers%ROWTYPE;
158: l_lot_rec mtl_lot_numbers%ROWTYPE;
159: l_null_lot_number BOOLEAN;
160:
161: l_msg_count NUMBER;
162: l_msg_data VARCHAR2 (2000);

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

667: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
668: ,p_create_lot IN VARCHAR2
669: ,p_generate_lot IN VARCHAR2
670: ,p_generate_parent_lot IN VARCHAR2
671: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
672: /* nsinghi bug#4486074 Added the p_expiration_Date parameter. */
673: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
674: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
675: ,x_return_status OUT NOCOPY VARCHAR2) IS

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

669: ,p_generate_lot IN VARCHAR2
670: ,p_generate_parent_lot IN VARCHAR2
671: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
672: /* nsinghi bug#4486074 Added the p_expiration_Date parameter. */
673: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
674: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
675: ,x_return_status OUT NOCOPY VARCHAR2) IS
676:
677: l_api_name CONSTANT VARCHAR2 (30) := 'validate_record_for_create';

Line 685: l_lot_number mtl_lot_numbers.lot_number%TYPE;

681: error_get_item EXCEPTION;
682:
683: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
684: l_in_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
685: l_lot_number mtl_lot_numbers.lot_number%TYPE;
686: l_dtl_qty NUMBER;
687: l_sec_qty NUMBER;
688: l_item_rec mtl_system_items_b%ROWTYPE;
689:

Line 1334: FROM mtl_lot_numbers

1330: CURSOR check_lot_exists(v_item_id NUMBER
1331: ,v_org_id NUMBER
1332: ,v_lot_no VARCHAR2) IS
1333: SELECT count( 1 )
1334: FROM mtl_lot_numbers
1335: WHERE inventory_item_id = v_item_id
1336: AND organization_id = v_org_id
1337: AND lot_number = v_lot_no;
1338: