[Home] [Help]
763: EXTENSION_ID NUMBER
764: ,TRANSACTION_TYPE VARCHAR2(30)
765: ,RETURN_STATUS VARCHAR2(1)
766: ,LANGUAGE_CODE VARCHAR2(4)
767: ,MANUFACTURER_GLN EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_GLN%TYPE
768: ,MANUFACTURER_ID NUMBER
769: ,BAR_CODE_TYPE EGO_ITM_GTN_MUL_ATTRS_VL.BAR_CODE_TYPE%TYPE
770: ,COLOR_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_LIST_AGENCY%TYPE
771: ,COLOR_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_VALUE%TYPE
765: ,RETURN_STATUS VARCHAR2(1)
766: ,LANGUAGE_CODE VARCHAR2(4)
767: ,MANUFACTURER_GLN EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_GLN%TYPE
768: ,MANUFACTURER_ID NUMBER
769: ,BAR_CODE_TYPE EGO_ITM_GTN_MUL_ATTRS_VL.BAR_CODE_TYPE%TYPE
770: ,COLOR_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_LIST_AGENCY%TYPE
771: ,COLOR_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_VALUE%TYPE
772: ,CLASS_OF_DANGEROUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.CLASS_OF_DANGEROUS_CODE%TYPE
773: ,DANGEROUS_GOODS_MARGIN_NUMBER EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE
766: ,LANGUAGE_CODE VARCHAR2(4)
767: ,MANUFACTURER_GLN EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_GLN%TYPE
768: ,MANUFACTURER_ID NUMBER
769: ,BAR_CODE_TYPE EGO_ITM_GTN_MUL_ATTRS_VL.BAR_CODE_TYPE%TYPE
770: ,COLOR_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_LIST_AGENCY%TYPE
771: ,COLOR_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_VALUE%TYPE
772: ,CLASS_OF_DANGEROUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.CLASS_OF_DANGEROUS_CODE%TYPE
773: ,DANGEROUS_GOODS_MARGIN_NUMBER EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE
774: ,DANGEROUS_GOODS_HAZARDOUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE
767: ,MANUFACTURER_GLN EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_GLN%TYPE
768: ,MANUFACTURER_ID NUMBER
769: ,BAR_CODE_TYPE EGO_ITM_GTN_MUL_ATTRS_VL.BAR_CODE_TYPE%TYPE
770: ,COLOR_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_LIST_AGENCY%TYPE
771: ,COLOR_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_VALUE%TYPE
772: ,CLASS_OF_DANGEROUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.CLASS_OF_DANGEROUS_CODE%TYPE
773: ,DANGEROUS_GOODS_MARGIN_NUMBER EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE
774: ,DANGEROUS_GOODS_HAZARDOUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE
775: ,DANGEROUS_GOODS_PACK_GROUP EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE
768: ,MANUFACTURER_ID NUMBER
769: ,BAR_CODE_TYPE EGO_ITM_GTN_MUL_ATTRS_VL.BAR_CODE_TYPE%TYPE
770: ,COLOR_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_LIST_AGENCY%TYPE
771: ,COLOR_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_VALUE%TYPE
772: ,CLASS_OF_DANGEROUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.CLASS_OF_DANGEROUS_CODE%TYPE
773: ,DANGEROUS_GOODS_MARGIN_NUMBER EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE
774: ,DANGEROUS_GOODS_HAZARDOUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE
775: ,DANGEROUS_GOODS_PACK_GROUP EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE
776: ,DANGEROUS_GOODS_REG_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE
769: ,BAR_CODE_TYPE EGO_ITM_GTN_MUL_ATTRS_VL.BAR_CODE_TYPE%TYPE
770: ,COLOR_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_LIST_AGENCY%TYPE
771: ,COLOR_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_VALUE%TYPE
772: ,CLASS_OF_DANGEROUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.CLASS_OF_DANGEROUS_CODE%TYPE
773: ,DANGEROUS_GOODS_MARGIN_NUMBER EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE
774: ,DANGEROUS_GOODS_HAZARDOUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE
775: ,DANGEROUS_GOODS_PACK_GROUP EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE
776: ,DANGEROUS_GOODS_REG_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE
777: ,DANGEROUS_GOODS_SHIPPING_NAME EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE
770: ,COLOR_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_LIST_AGENCY%TYPE
771: ,COLOR_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_VALUE%TYPE
772: ,CLASS_OF_DANGEROUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.CLASS_OF_DANGEROUS_CODE%TYPE
773: ,DANGEROUS_GOODS_MARGIN_NUMBER EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE
774: ,DANGEROUS_GOODS_HAZARDOUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE
775: ,DANGEROUS_GOODS_PACK_GROUP EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE
776: ,DANGEROUS_GOODS_REG_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE
777: ,DANGEROUS_GOODS_SHIPPING_NAME EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE
778: ,UNITED_NATIONS_DANG_GOODS_NO NUMBER
771: ,COLOR_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_VALUE%TYPE
772: ,CLASS_OF_DANGEROUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.CLASS_OF_DANGEROUS_CODE%TYPE
773: ,DANGEROUS_GOODS_MARGIN_NUMBER EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE
774: ,DANGEROUS_GOODS_HAZARDOUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE
775: ,DANGEROUS_GOODS_PACK_GROUP EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE
776: ,DANGEROUS_GOODS_REG_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE
777: ,DANGEROUS_GOODS_SHIPPING_NAME EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE
778: ,UNITED_NATIONS_DANG_GOODS_NO NUMBER
779: ,FLASH_POINT_TEMP NUMBER
772: ,CLASS_OF_DANGEROUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.CLASS_OF_DANGEROUS_CODE%TYPE
773: ,DANGEROUS_GOODS_MARGIN_NUMBER EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE
774: ,DANGEROUS_GOODS_HAZARDOUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE
775: ,DANGEROUS_GOODS_PACK_GROUP EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE
776: ,DANGEROUS_GOODS_REG_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE
777: ,DANGEROUS_GOODS_SHIPPING_NAME EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE
778: ,UNITED_NATIONS_DANG_GOODS_NO NUMBER
779: ,FLASH_POINT_TEMP NUMBER
780: ,UOM_FLASH_POINT_TEMP EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE
773: ,DANGEROUS_GOODS_MARGIN_NUMBER EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE
774: ,DANGEROUS_GOODS_HAZARDOUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE
775: ,DANGEROUS_GOODS_PACK_GROUP EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE
776: ,DANGEROUS_GOODS_REG_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE
777: ,DANGEROUS_GOODS_SHIPPING_NAME EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE
778: ,UNITED_NATIONS_DANG_GOODS_NO NUMBER
779: ,FLASH_POINT_TEMP NUMBER
780: ,UOM_FLASH_POINT_TEMP EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE
781: ,COUNTRY_OF_ORIGIN EGO_ITM_GTN_MUL_ATTRS_VL.COUNTRY_OF_ORIGIN%TYPE
776: ,DANGEROUS_GOODS_REG_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE
777: ,DANGEROUS_GOODS_SHIPPING_NAME EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE
778: ,UNITED_NATIONS_DANG_GOODS_NO NUMBER
779: ,FLASH_POINT_TEMP NUMBER
780: ,UOM_FLASH_POINT_TEMP EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE
781: ,COUNTRY_OF_ORIGIN EGO_ITM_GTN_MUL_ATTRS_VL.COUNTRY_OF_ORIGIN%TYPE
782: ,HARMONIZED_TARIFF_SYS_ID_CODE NUMBER
783: ,SIZE_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_LIST_AGENCY%TYPE
784: ,SIZE_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_VALUE%TYPE
777: ,DANGEROUS_GOODS_SHIPPING_NAME EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE
778: ,UNITED_NATIONS_DANG_GOODS_NO NUMBER
779: ,FLASH_POINT_TEMP NUMBER
780: ,UOM_FLASH_POINT_TEMP EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE
781: ,COUNTRY_OF_ORIGIN EGO_ITM_GTN_MUL_ATTRS_VL.COUNTRY_OF_ORIGIN%TYPE
782: ,HARMONIZED_TARIFF_SYS_ID_CODE NUMBER
783: ,SIZE_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_LIST_AGENCY%TYPE
784: ,SIZE_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_VALUE%TYPE
785: ,HANDLING_INSTRUCTIONS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.HANDLING_INSTRUCTIONS_CODE%TYPE
779: ,FLASH_POINT_TEMP NUMBER
780: ,UOM_FLASH_POINT_TEMP EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE
781: ,COUNTRY_OF_ORIGIN EGO_ITM_GTN_MUL_ATTRS_VL.COUNTRY_OF_ORIGIN%TYPE
782: ,HARMONIZED_TARIFF_SYS_ID_CODE NUMBER
783: ,SIZE_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_LIST_AGENCY%TYPE
784: ,SIZE_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_VALUE%TYPE
785: ,HANDLING_INSTRUCTIONS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.HANDLING_INSTRUCTIONS_CODE%TYPE
786: ,DANGEROUS_GOODS_TECHNICAL_NAME EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_TECHNICAL_NAME%TYPE
787: ,DELIVERY_METHOD_INDICATOR EGO_ITM_GTN_MUL_ATTRS_VL.DELIVERY_METHOD_INDICATOR%TYPE
780: ,UOM_FLASH_POINT_TEMP EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE
781: ,COUNTRY_OF_ORIGIN EGO_ITM_GTN_MUL_ATTRS_VL.COUNTRY_OF_ORIGIN%TYPE
782: ,HARMONIZED_TARIFF_SYS_ID_CODE NUMBER
783: ,SIZE_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_LIST_AGENCY%TYPE
784: ,SIZE_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_VALUE%TYPE
785: ,HANDLING_INSTRUCTIONS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.HANDLING_INSTRUCTIONS_CODE%TYPE
786: ,DANGEROUS_GOODS_TECHNICAL_NAME EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_TECHNICAL_NAME%TYPE
787: ,DELIVERY_METHOD_INDICATOR EGO_ITM_GTN_MUL_ATTRS_VL.DELIVERY_METHOD_INDICATOR%TYPE
788: );
781: ,COUNTRY_OF_ORIGIN EGO_ITM_GTN_MUL_ATTRS_VL.COUNTRY_OF_ORIGIN%TYPE
782: ,HARMONIZED_TARIFF_SYS_ID_CODE NUMBER
783: ,SIZE_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_LIST_AGENCY%TYPE
784: ,SIZE_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_VALUE%TYPE
785: ,HANDLING_INSTRUCTIONS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.HANDLING_INSTRUCTIONS_CODE%TYPE
786: ,DANGEROUS_GOODS_TECHNICAL_NAME EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_TECHNICAL_NAME%TYPE
787: ,DELIVERY_METHOD_INDICATOR EGO_ITM_GTN_MUL_ATTRS_VL.DELIVERY_METHOD_INDICATOR%TYPE
788: );
789:
782: ,HARMONIZED_TARIFF_SYS_ID_CODE NUMBER
783: ,SIZE_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_LIST_AGENCY%TYPE
784: ,SIZE_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_VALUE%TYPE
785: ,HANDLING_INSTRUCTIONS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.HANDLING_INSTRUCTIONS_CODE%TYPE
786: ,DANGEROUS_GOODS_TECHNICAL_NAME EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_TECHNICAL_NAME%TYPE
787: ,DELIVERY_METHOD_INDICATOR EGO_ITM_GTN_MUL_ATTRS_VL.DELIVERY_METHOD_INDICATOR%TYPE
788: );
789:
790: TYPE UCCnet_Attrs_Multi_Row_Tbl_Typ IS TABLE OF UCCnet_Attrs_Multi_Row_Rec_Typ INDEX BY BINARY_INTEGER;
783: ,SIZE_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_LIST_AGENCY%TYPE
784: ,SIZE_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_VALUE%TYPE
785: ,HANDLING_INSTRUCTIONS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.HANDLING_INSTRUCTIONS_CODE%TYPE
786: ,DANGEROUS_GOODS_TECHNICAL_NAME EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_TECHNICAL_NAME%TYPE
787: ,DELIVERY_METHOD_INDICATOR EGO_ITM_GTN_MUL_ATTRS_VL.DELIVERY_METHOD_INDICATOR%TYPE
788: );
789:
790: TYPE UCCnet_Attrs_Multi_Row_Tbl_Typ IS TABLE OF UCCnet_Attrs_Multi_Row_Rec_Typ INDEX BY BINARY_INTEGER;
791: