APPS.GME_API_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 177: l_item_rec mtl_system_items_b%ROWTYPE;

173: l_object_type VARCHAR2 (10);
174: l_total_input NUMBER;
175: l_total_output NUMBER;
176: l_item_id NUMBER;
177: l_item_rec mtl_system_items_b%ROWTYPE;
178: l_product_qty NUMBER;
179: l_recipe_use NUMBER;
180: l_status_type VARCHAR2 (10);
181: l_return_code NUMBER (5);

Line 4918: FROM mtl_system_items_b

4914: IS
4915: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)
4916: IS
4917: SELECT *
4918: FROM mtl_system_items_b
4919: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
4920:
4921: CURSOR cur_get_trans (v_header_id IN NUMBER)
4922: IS

Line 4933: l_item_rec mtl_system_items_b%ROWTYPE;

4929: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
4930: l_mat_dtl_rec gme_material_details%ROWTYPE;
4931: l_mat_dtl_rec_out gme_material_details%ROWTYPE;
4932: l_batch_header_rec gme_batch_header%ROWTYPE;
4933: l_item_rec mtl_system_items_b%ROWTYPE;
4934: l_lot_rec mtl_lot_numbers%ROWTYPE;
4935: l_parent_gen_lot VARCHAR2 (2000) DEFAULT NULL;
4936: l_gen_lot VARCHAR2 (80) DEFAULT NULL;
4937: l_msg_count NUMBER;

Line 5030: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');

5026: IF cur_get_item_rec%NOTFOUND THEN
5027: CLOSE cur_get_item_rec;
5028: gme_common_pvt.log_message ('PM_INVALID_ITEM');
5029: IF (g_debug = gme_debug.g_log_statement) THEN
5030: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
5031: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (l_mmti_rec.inventory_item_id) );
5032: gme_debug.put_line('organization_id = '|| TO_CHAR (l_mmti_rec.organization_id) );
5033: END IF;
5034: RAISE fnd_api.g_exc_error;

Line 5277: FROM mtl_system_items_b

5273: IS
5274: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)
5275: IS
5276: SELECT *
5277: FROM mtl_system_items_b
5278: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
5279:
5280: CURSOR cur_get_trans (v_header_id IN NUMBER)
5281: IS

Line 5299: l_item_rec mtl_system_items_b%ROWTYPE;

5295: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
5296: l_mmti_rec mtl_transactions_interface%ROWTYPE;
5297: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
5298: l_mat_dtl_rec gme_material_details%ROWTYPE;
5299: l_item_rec mtl_system_items_b%ROWTYPE;
5300: l_msg_count NUMBER;
5301: l_msg_data VARCHAR2 (2000);
5302: l_msg_index NUMBER (5);
5303: l_txn_count NUMBER;

Line 5395: ('Item cursor fetch no record in mtl_system_items_b: ');

5391: gme_common_pvt.log_message ('PM_INVALID_ITEM');
5392:
5393: IF (g_debug = gme_debug.g_log_statement) THEN
5394: gme_debug.put_line
5395: ('Item cursor fetch no record in mtl_system_items_b: ');
5396: gme_debug.put_line ( 'inventory_item_id = '
5397: || TO_CHAR (l_mmti_rec.inventory_item_id) );
5398: gme_debug.put_line ( 'organization_id = '
5399: || TO_CHAR (l_mmti_rec.organization_id) );