DBA Data[Home] [Help]

APPS.GMO_DISPENSE_PVT dependencies on GMO_DISPENSE_CONFIG

Line 234: l_dispense_config_rec GMO_DISPENSE_CONFIG%ROWTYPE;

230: X_RESERVATION_UOM_CONVERTIBLE OUT NOCOPY VARCHAR2,
231: X_SECURITY_FLAG OUT NOCOPY VARCHAR2
232: )
233: IS
234: l_dispense_config_rec GMO_DISPENSE_CONFIG%ROWTYPE;
235: l_mtl_dispensed_quantity NUMBER;
236: l_mtl_undispensed_quantity NUMBER;
237: l_net_dispensed_quantity NUMBER;
238: l_net_mtl_dispensed_quantity NUMBER;

Line 413: l_dispense_config_rec GMO_DISPENSE_CONFIG%ROWTYPE;

409: IS
410: l_inventory_item_id NUMBER;
411: l_organization_id NUMBER;
412: l_material_details_id NUMBER;
413: l_dispense_config_rec GMO_DISPENSE_CONFIG%ROWTYPE;
414: l_net_dispensed_quantity NUMBER;
415: CURSOR C_GET_DISP_DETAILS IS
416: SELECT GMO.MATERIAL_DETAIL_ID, GMO.INVENTORY_ITEM_ID, GMO.ORGANIZATION_ID
417: FROM GMO_MATERIAL_DISPENSES GMO

Line 506: l_dispense_config_row GMO_DISPENSE_CONFIG%ROWTYPE;

502: DISP_NOT_REQ_EXCEPTION EXCEPTION;
503: NO_MATERIAL_LINE_EXCEPTION EXCEPTION;
504: INSTRUNCTION_EXCEPTION EXCEPTION;
505: l_dispense_uom VARCHAR2(10);
506: l_dispense_config_row GMO_DISPENSE_CONFIG%ROWTYPE;
507: l_organization_id NUMBER;
508: l_RESERVED_QUANTITY NUMBER;
509: l_DISPENSE_CONFIG_ID NUMBER;
510: l_MAX_ALLOWED_QUANTITY NUMBER;