APPS.GME_MOBILE_TXN dependencies on GME_MATERIAL_DISPENSING_GTMP

Line 2471: DELETE FROM GME_MATERIAL_DISPENSING_GTMP;

2467: x_return_status := FND_API.G_RET_STS_SUCCESS;
2468: x_error_msg := ' ';
2469:
2470: -- clear out temp table
2471: DELETE FROM GME_MATERIAL_DISPENSING_GTMP;
2472:
2473: -- Fetch dispensing data for the given material line
2474:
2475: GMO_DISPENSE_GRP.GET_MATERIAL_DISPENSE_DATA (

Line 2510: INSERT INTO GME_MATERIAL_DISPENSING_GTMP

2506: l_rsrv_tab(l_index).lot_number);
2507: gme_debug.put_line('Revision = ' ||
2508: l_rsrv_tab(l_index).revision);
2509:
2510: INSERT INTO GME_MATERIAL_DISPENSING_GTMP
2511: (
2512: DISPENSE_ID
2513: ,SUBINVENTORY_CODE
2514: ,LOCATOR_ID

Line 2582: DELETE FROM GME_MATERIAL_DISPENSING_GTMP

2578:
2579: x_return_status := FND_API.G_RET_STS_SUCCESS;
2580: x_error_msg := ' ';
2581:
2582: DELETE FROM GME_MATERIAL_DISPENSING_GTMP
2583: WHERE dispense_id = p_dispense_id;
2584:
2585: EXCEPTION
2586: WHEN OTHERS THEN

Line 2620: FROM GME_MATERIAL_DISPENSING_GTMP

2616: IS
2617:
2618: CURSOR lot_count IS
2619: SELECT count(*)
2620: FROM GME_MATERIAL_DISPENSING_GTMP
2621: WHERE subinventory_code = p_subinv_code AND
2622: NVL(locator_id, -1) = NVL(p_locator_id, -1);
2623: BEGIN
2624: