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 138: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL

134:
135: PROCEDURE create_product_lot
136: (p_organization_id IN NUMBER
137: ,p_inventory_item_id IN NUMBER
138: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
139: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
140: ,p_generate_lot IN VARCHAR2
141: ,p_generate_parent_lot IN VARCHAR2
142: /* nsinghi bug#4486074 Added the p_expiration_Date parameter. */

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

139: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
140: ,p_generate_lot IN VARCHAR2
141: ,p_generate_parent_lot IN VARCHAR2
142: /* nsinghi bug#4486074 Added the p_expiration_Date parameter. */
143: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
144: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
145: ,x_return_status OUT NOCOPY VARCHAR2) IS
146:
147: l_parent_lot mtl_lot_numbers.lot_number%TYPE;

Line 147: l_parent_lot mtl_lot_numbers.lot_number%TYPE;

143: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
144: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
145: ,x_return_status OUT NOCOPY VARCHAR2) IS
146:
147: l_parent_lot mtl_lot_numbers.lot_number%TYPE;
148: l_gen_lot mtl_lot_numbers.lot_number%TYPE;
149: l_in_lot_rec mtl_lot_numbers%ROWTYPE;
150: l_lot_rec mtl_lot_numbers%ROWTYPE;
151: l_null_lot_number BOOLEAN;

Line 148: l_gen_lot mtl_lot_numbers.lot_number%TYPE;

144: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
145: ,x_return_status OUT NOCOPY VARCHAR2) IS
146:
147: l_parent_lot mtl_lot_numbers.lot_number%TYPE;
148: l_gen_lot mtl_lot_numbers.lot_number%TYPE;
149: l_in_lot_rec mtl_lot_numbers%ROWTYPE;
150: l_lot_rec mtl_lot_numbers%ROWTYPE;
151: l_null_lot_number BOOLEAN;
152:

Line 149: l_in_lot_rec mtl_lot_numbers%ROWTYPE;

145: ,x_return_status OUT NOCOPY VARCHAR2) IS
146:
147: l_parent_lot mtl_lot_numbers.lot_number%TYPE;
148: l_gen_lot mtl_lot_numbers.lot_number%TYPE;
149: l_in_lot_rec mtl_lot_numbers%ROWTYPE;
150: l_lot_rec mtl_lot_numbers%ROWTYPE;
151: l_null_lot_number BOOLEAN;
152:
153: l_msg_count NUMBER;

Line 150: l_lot_rec mtl_lot_numbers%ROWTYPE;

146:
147: l_parent_lot mtl_lot_numbers.lot_number%TYPE;
148: l_gen_lot mtl_lot_numbers.lot_number%TYPE;
149: l_in_lot_rec mtl_lot_numbers%ROWTYPE;
150: l_lot_rec mtl_lot_numbers%ROWTYPE;
151: l_null_lot_number BOOLEAN;
152:
153: l_msg_count NUMBER;
154: l_msg_data VARCHAR2 (2000);

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

654: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
655: ,p_create_lot IN VARCHAR2
656: ,p_generate_lot IN VARCHAR2
657: ,p_generate_parent_lot IN VARCHAR2
658: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
659: /* nsinghi bug#4486074 Added the p_expiration_Date parameter. */
660: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
661: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
662: ,x_return_status OUT NOCOPY VARCHAR2) IS

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

656: ,p_generate_lot IN VARCHAR2
657: ,p_generate_parent_lot IN VARCHAR2
658: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
659: /* nsinghi bug#4486074 Added the p_expiration_Date parameter. */
660: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
661: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
662: ,x_return_status OUT NOCOPY VARCHAR2) IS
663:
664: l_api_name CONSTANT VARCHAR2 (30) := 'validate_record_for_create';

Line 672: l_lot_number mtl_lot_numbers.lot_number%TYPE;

668: error_get_item EXCEPTION;
669:
670: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
671: l_in_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
672: l_lot_number mtl_lot_numbers.lot_number%TYPE;
673: l_dtl_qty NUMBER;
674: l_sec_qty NUMBER;
675: l_item_rec mtl_system_items_b%ROWTYPE;
676:

Line 1321: FROM mtl_lot_numbers

1317: CURSOR check_lot_exists(v_item_id NUMBER
1318: ,v_org_id NUMBER
1319: ,v_lot_no VARCHAR2) IS
1320: SELECT count( 1 )
1321: FROM mtl_lot_numbers
1322: WHERE inventory_item_id = v_item_id
1323: AND organization_id = v_org_id
1324: AND lot_number = v_lot_no;
1325: