APPS.GME_API_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 213: l_item_rec mtl_system_items_b%ROWTYPE;

209: l_object_type VARCHAR2 (10);
210: l_total_input NUMBER;
211: l_total_output NUMBER;
212: l_item_id NUMBER;
213: l_item_rec mtl_system_items_b%ROWTYPE;
214: l_product_qty NUMBER;
215: l_recipe_use NUMBER;
216: l_status_type VARCHAR2 (10);
217: l_return_code NUMBER (5);

Line 5056: FROM mtl_system_items_b

5052: IS
5053: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)
5054: IS
5055: SELECT *
5056: FROM mtl_system_items_b
5057: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
5058:
5059: CURSOR cur_get_trans (v_header_id IN NUMBER)
5060: IS

Line 5071: l_item_rec mtl_system_items_b%ROWTYPE;

5067: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
5068: l_mat_dtl_rec gme_material_details%ROWTYPE;
5069: l_mat_dtl_rec_out gme_material_details%ROWTYPE;
5070: l_batch_header_rec gme_batch_header%ROWTYPE;
5071: l_item_rec mtl_system_items_b%ROWTYPE;
5072: l_lot_rec mtl_lot_numbers%ROWTYPE;
5073: l_parent_gen_lot VARCHAR2 (2000) DEFAULT NULL;
5074: l_gen_lot VARCHAR2 (80) DEFAULT NULL;
5075: l_msg_count NUMBER;

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

5178: IF cur_get_item_rec%NOTFOUND THEN
5179: CLOSE cur_get_item_rec;
5180: gme_common_pvt.log_message ('PM_INVALID_ITEM');
5181: IF (g_debug = gme_debug.g_log_statement) THEN
5182: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
5183: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (l_mmti_rec.inventory_item_id) );
5184: gme_debug.put_line('organization_id = '|| TO_CHAR (l_mmti_rec.organization_id) );
5185: END IF;
5186: RAISE fnd_api.g_exc_error;

Line 5608: FROM mtl_system_items_b

5604: IS
5605: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)
5606: IS
5607: SELECT *
5608: FROM mtl_system_items_b
5609: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
5610:
5611: CURSOR cur_get_trans (v_header_id IN NUMBER)
5612: IS

Line 5630: l_item_rec mtl_system_items_b%ROWTYPE;

5626: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
5627: l_mmti_rec mtl_transactions_interface%ROWTYPE;
5628: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
5629: l_mat_dtl_rec gme_material_details%ROWTYPE;
5630: l_item_rec mtl_system_items_b%ROWTYPE;
5631: l_msg_count NUMBER;
5632: l_msg_data VARCHAR2 (2000);
5633: l_msg_index NUMBER (5);
5634: l_txn_count NUMBER;

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

5722: gme_common_pvt.log_message ('PM_INVALID_ITEM');
5723:
5724: IF (g_debug = gme_debug.g_log_statement) THEN
5725: gme_debug.put_line
5726: ('Item cursor fetch no record in mtl_system_items_b: ');
5727: gme_debug.put_line ( 'inventory_item_id = '
5728: || TO_CHAR (l_mmti_rec.inventory_item_id) );
5729: gme_debug.put_line ( 'organization_id = '
5730: || TO_CHAR (l_mmti_rec.organization_id) );