DBA Data[Home] [Help]

APPS.GMO_DISP_CON_PKG dependencies on GMO_DISP_CON_PKG

Line 1: PACKAGE BODY GMO_DISP_CON_PKG AS

1: PACKAGE BODY GMO_DISP_CON_PKG AS
2: /* $Header: GMOVDCPB.pls 120.8 2006/03/28 02:30 srpuri noship $ */
3: FUNCTION GET_HAZARD_CLASS_NAME(P_INVENTORY_ITEM_ID NUMBER,
4: P_ORGANIZATION_ID NUMBER)
5: RETURN VARCHAR2

Line 82: GMO_DISP_CON_PKG.GET_HAZARD_CLASS_NAME (GMDL.ORGANIZATION_ID,

78: MSI.CONCATENATED_SEGMENTS as ITEM ,
79: MSI.description as Description ,
80: flYesNo.meaning AS HAZARDOUS_MATERIAL_FLAG,
81: decode(nvl(MSI.HAZARD_CLASS_ID,-1),-1,null,
82: GMO_DISP_CON_PKG.GET_HAZARD_CLASS_NAME (GMDL.ORGANIZATION_ID,
83: GMDL.INVENTORY_ITEM_ID)) AS HAZARD_CLASS,
84: RES.reservation_id as RESERVATION_ID ,
85: RES.LOT_NUMBER as LOT,
86: GBH.BATCH_NO as BatchNo,

Line 371: END GMO_DISP_CON_PKG;

367: fnd_file.new_line(fnd_file.log,2);
368: fnd_file.put_line(fnd_file.log, fnd_message.get_string('GMO', 'GMO_DISPENSE_HISTORY_XML_ERR') );
369: RETURN;
370: END GENERATE_DISPHIST_XML;
371: END GMO_DISP_CON_PKG;