APPS.GMO_DISPENSE_PVT dependencies on GMO_DISPENSE_PVT

Line 1: PACKAGE BODY GMO_DISPENSE_PVT AS

1: PACKAGE BODY GMO_DISPENSE_PVT AS
2: /* $Header: GMOVDSPB.pls 120.18.12000000.4 2007/04/19 06:46:45 achawla ship $ */
3:
4: /* Used in Dispensing BC4J objects to getProduct */
5: /* Returns batch's primary product number */

Line 487: GMO_DISPENSE_PVT.GET_NET_DISP_DISPENSED_QTY(dispense_id) net_dispensed_qty

483: CURSOR C_GET_DISPENSES(p_reservation_id NUMBER) IS
484: SELECT Dispense_id,
485: dispensed_qty,
486: dispense_uom,
487: GMO_DISPENSE_PVT.GET_NET_DISP_DISPENSED_QTY(dispense_id) net_dispensed_qty
488: from gmo_material_dispenses
489: WHERE reservation_id = p_reservation_id
490: and material_status = 'DISPENSD'
491: and GMO_DISPENSE_PVT.GET_NET_DISP_DISPENSED_QTY(dispense_id) > 0;

Line 491: and GMO_DISPENSE_PVT.GET_NET_DISP_DISPENSED_QTY(dispense_id) > 0;

487: GMO_DISPENSE_PVT.GET_NET_DISP_DISPENSED_QTY(dispense_id) net_dispensed_qty
488: from gmo_material_dispenses
489: WHERE reservation_id = p_reservation_id
490: and material_status = 'DISPENSD'
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;

Line 974: 'gmo.plsql.GMO_DISPENSE_PVT.GET_TRANSACTION_XML',

970: FND_MESSAGE.SET_ENCODED(L_MSG_DATA);
971: --Diagnostics Start
972: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
973: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
974: 'gmo.plsql.GMO_DISPENSE_PVT.GET_TRANSACTION_XML',
975: FALSE
976: );
977: end if;
978: --Diagnostics End

Line 983: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_DISPENSE_PVT');

979: APP_EXCEPTION.RAISE_EXCEPTION;
980: WHEN OTHERS THEN
981: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
982: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
983: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_DISPENSE_PVT');
984: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_TRANSACTION_XML');
985: --Diagnostics Start
986: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
987: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 988: 'gmo.plsql.GMO_DISPENSE_PVT.GET_TRANSACTION_XML',

984: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_TRANSACTION_XML');
985: --Diagnostics Start
986: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
987: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
988: 'gmo.plsql.GMO_DISPENSE_PVT.GET_TRANSACTION_XML',
989: FALSE
990: );
991: end if;
992: --Diagnostics End

Line 1077: END GMO_DISPENSE_PVT;

1073: return 'No';
1074: end;
1075:
1076:
1077: END GMO_DISPENSE_PVT;