DBA Data[Home] [Help]

APPS.GMO_DISPENSE_PVT dependencies on GME_COMMON_PVT

Line 468: x_dispense_data OUT NOCOPY GME_COMMON_PVT.reservations_tab)

464: END GET_REVERSE_DISPENSE_DATA;
465: -- Kiosk : End
466: /* Used by group API */
467: PROCEDURE GET_MATERIAL_DISPENSE_DATA(p_material_detail_id IN NUMBER,
468: x_dispense_data OUT NOCOPY GME_COMMON_PVT.reservations_tab)
469: IS
470: CURSOR C_GET_RESERVATIONS IS
471: SELECT res.*
472: FROM MTL_RESERVATIONS res,

Line 495: l_Pending_reservations_tab GME_COMMON_PVT.reservations_tab;

491: and GMO_DISPENSE_PVT.GET_NET_DISP_DISPENSED_QTY(dispense_id) > 0;
492: l_reservation_record mtl_reservations%ROWTYPE;
493: l_dispense_record C_GET_DISPENSES%ROWTYPE;
494: l_result_record mtl_reservations%ROWTYPE;
495: l_Pending_reservations_tab GME_COMMON_PVT.reservations_tab;
496: CURSOR C_GET_MATERIAL_LINE IS
497: SELECT gmd.organization_id
498: FROM gme_material_details gmd
499: WHERE gmd.material_detail_id = p_material_detail_id;