eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_GTIN_ATTRS_PVT dependencies on EGO_ITM_GTN_MUL_ATTRS_VL

Line 329: -- these are all NUMBER columns in EGO_ITM_GTN_MUL_ATTRS_VL. The record EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ

325: l_nesting_increment EGO_ITEM_GTN_ATTRS_VL.NESTING_INCREMENT%TYPE;
326: l_pieces_per_trade_item EGO_ITEM_GTN_ATTRS_VL.PIECES_PER_TRADE_ITEM%TYPE;
327:
328:
329: -- these are all NUMBER columns in EGO_ITM_GTN_MUL_ATTRS_VL. The record EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ
330: -- contains the type of these columns as NUMBER
331: -- so these variables are used to find out any precesion problem in these attributes
332: l_manufacturer_id EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_ID%TYPE;
333: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;

Line 332: l_manufacturer_id EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_ID%TYPE;

328:
329: -- these are all NUMBER columns in EGO_ITM_GTN_MUL_ATTRS_VL. The record EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ
330: -- contains the type of these columns as NUMBER
331: -- so these variables are used to find out any precesion problem in these attributes
332: l_manufacturer_id EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_ID%TYPE;
333: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;
334: l_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.FLASH_POINT_TEMP%TYPE;
335: l_harmonized_tariff_sys_id_cd EGO_ITM_GTN_MUL_ATTRS_VL.HARMONIZED_TARIFF_SYS_ID_CODE%TYPE;
336: BEGIN

Line 333: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;

329: -- these are all NUMBER columns in EGO_ITM_GTN_MUL_ATTRS_VL. The record EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ
330: -- contains the type of these columns as NUMBER
331: -- so these variables are used to find out any precesion problem in these attributes
332: l_manufacturer_id EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_ID%TYPE;
333: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;
334: l_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.FLASH_POINT_TEMP%TYPE;
335: l_harmonized_tariff_sys_id_cd EGO_ITM_GTN_MUL_ATTRS_VL.HARMONIZED_TARIFF_SYS_ID_CODE%TYPE;
336: BEGIN
337: Debug_Msg('Started Get_Gdsn_Intf_Rows');

Line 334: l_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.FLASH_POINT_TEMP%TYPE;

330: -- contains the type of these columns as NUMBER
331: -- so these variables are used to find out any precesion problem in these attributes
332: l_manufacturer_id EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_ID%TYPE;
333: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;
334: l_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.FLASH_POINT_TEMP%TYPE;
335: l_harmonized_tariff_sys_id_cd EGO_ITM_GTN_MUL_ATTRS_VL.HARMONIZED_TARIFF_SYS_ID_CODE%TYPE;
336: BEGIN
337: Debug_Msg('Started Get_Gdsn_Intf_Rows');
338: Debug_Msg('Initializing the fnd error stack');

Line 335: l_harmonized_tariff_sys_id_cd EGO_ITM_GTN_MUL_ATTRS_VL.HARMONIZED_TARIFF_SYS_ID_CODE%TYPE;

331: -- so these variables are used to find out any precesion problem in these attributes
332: l_manufacturer_id EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_ID%TYPE;
333: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;
334: l_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.FLASH_POINT_TEMP%TYPE;
335: l_harmonized_tariff_sys_id_cd EGO_ITM_GTN_MUL_ATTRS_VL.HARMONIZED_TARIFF_SYS_ID_CODE%TYPE;
336: BEGIN
337: Debug_Msg('Started Get_Gdsn_Intf_Rows');
338: Debug_Msg('Initializing the fnd error stack');
339: -- initializing the fnd error stack

Line 1864: FROM EGO_ITM_GTN_MUL_ATTRS_VL

1860: ,FLASH_POINT_TEMP
1861: ,DANGEROUS_GOODS_TECHNICAL_NAME
1862: ,COUNTRY_OF_ORIGIN
1863: ,HANDLING_INSTRUCTIONS_CODE
1864: FROM EGO_ITM_GTN_MUL_ATTRS_VL
1865: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1866: AND ORGANIZATION_ID = p_organization_id;
1867:
1868: l_prod_single_row_attrs c_prod_single_row_values%ROWTYPE;

Line 1929: l_dngr_goods_margin_number EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE;

1925: EANUCC_CODE_UN_LENGTH CONSTANT NUMBER := 12;
1926: EANUCC_CODE_U2_LENGTH CONSTANT NUMBER := 13;
1927:
1928: -- variables to hold production values
1929: l_dngr_goods_margin_number EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE;
1930: l_dngr_goods_hazardous_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE;
1931: l_dngr_goods_pack_group EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE;
1932: l_dngr_goods_reg_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE;
1933: l_dngr_goods_shipping_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE;

Line 1930: l_dngr_goods_hazardous_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE;

1926: EANUCC_CODE_U2_LENGTH CONSTANT NUMBER := 13;
1927:
1928: -- variables to hold production values
1929: l_dngr_goods_margin_number EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE;
1930: l_dngr_goods_hazardous_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE;
1931: l_dngr_goods_pack_group EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE;
1932: l_dngr_goods_reg_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE;
1933: l_dngr_goods_shipping_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE;
1934: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;

Line 1931: l_dngr_goods_pack_group EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE;

1927:
1928: -- variables to hold production values
1929: l_dngr_goods_margin_number EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE;
1930: l_dngr_goods_hazardous_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE;
1931: l_dngr_goods_pack_group EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE;
1932: l_dngr_goods_reg_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE;
1933: l_dngr_goods_shipping_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE;
1934: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;
1935: l_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.FLASH_POINT_TEMP%TYPE;

Line 1932: l_dngr_goods_reg_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE;

1928: -- variables to hold production values
1929: l_dngr_goods_margin_number EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE;
1930: l_dngr_goods_hazardous_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE;
1931: l_dngr_goods_pack_group EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE;
1932: l_dngr_goods_reg_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE;
1933: l_dngr_goods_shipping_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE;
1934: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;
1935: l_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.FLASH_POINT_TEMP%TYPE;
1936: l_uom_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE;

Line 1933: l_dngr_goods_shipping_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE;

1929: l_dngr_goods_margin_number EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE;
1930: l_dngr_goods_hazardous_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE;
1931: l_dngr_goods_pack_group EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE;
1932: l_dngr_goods_reg_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE;
1933: l_dngr_goods_shipping_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE;
1934: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;
1935: l_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.FLASH_POINT_TEMP%TYPE;
1936: l_uom_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE;
1937: l_dngr_goods_technical_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_TECHNICAL_NAME%TYPE;

Line 1934: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;

1930: l_dngr_goods_hazardous_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE;
1931: l_dngr_goods_pack_group EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE;
1932: l_dngr_goods_reg_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE;
1933: l_dngr_goods_shipping_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE;
1934: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;
1935: l_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.FLASH_POINT_TEMP%TYPE;
1936: l_uom_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE;
1937: l_dngr_goods_technical_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_TECHNICAL_NAME%TYPE;
1938: l_manufacturer_id EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_ID%TYPE;

Line 1935: l_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.FLASH_POINT_TEMP%TYPE;

1931: l_dngr_goods_pack_group EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE;
1932: l_dngr_goods_reg_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE;
1933: l_dngr_goods_shipping_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE;
1934: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;
1935: l_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.FLASH_POINT_TEMP%TYPE;
1936: l_uom_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE;
1937: l_dngr_goods_technical_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_TECHNICAL_NAME%TYPE;
1938: l_manufacturer_id EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_ID%TYPE;
1939: l_manufacturer_gln EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_GLN%TYPE;

Line 1936: l_uom_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE;

1932: l_dngr_goods_reg_code EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE;
1933: l_dngr_goods_shipping_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE;
1934: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;
1935: l_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.FLASH_POINT_TEMP%TYPE;
1936: l_uom_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE;
1937: l_dngr_goods_technical_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_TECHNICAL_NAME%TYPE;
1938: l_manufacturer_id EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_ID%TYPE;
1939: l_manufacturer_gln EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_GLN%TYPE;
1940: BEGIN

Line 1937: l_dngr_goods_technical_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_TECHNICAL_NAME%TYPE;

1933: l_dngr_goods_shipping_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE;
1934: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;
1935: l_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.FLASH_POINT_TEMP%TYPE;
1936: l_uom_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE;
1937: l_dngr_goods_technical_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_TECHNICAL_NAME%TYPE;
1938: l_manufacturer_id EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_ID%TYPE;
1939: l_manufacturer_gln EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_GLN%TYPE;
1940: BEGIN
1941: l_continue := true;

Line 1938: l_manufacturer_id EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_ID%TYPE;

1934: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;
1935: l_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.FLASH_POINT_TEMP%TYPE;
1936: l_uom_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE;
1937: l_dngr_goods_technical_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_TECHNICAL_NAME%TYPE;
1938: l_manufacturer_id EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_ID%TYPE;
1939: l_manufacturer_gln EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_GLN%TYPE;
1940: BEGIN
1941: l_continue := true;
1942: Debug_Msg('Starting GDSN Attributes Validations for Item,Org='||p_inventory_item_id||','||p_organization_id);

Line 1939: l_manufacturer_gln EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_GLN%TYPE;

1935: l_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.FLASH_POINT_TEMP%TYPE;
1936: l_uom_flash_point_temp EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE;
1937: l_dngr_goods_technical_name EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_TECHNICAL_NAME%TYPE;
1938: l_manufacturer_id EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_ID%TYPE;
1939: l_manufacturer_gln EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_GLN%TYPE;
1940: BEGIN
1941: l_continue := true;
1942: Debug_Msg('Starting GDSN Attributes Validations for Item,Org='||p_inventory_item_id||','||p_organization_id);
1943: Debug_Msg('Initializing the fnd error stack');

Line 2825: FROM EGO_ITM_GTN_MUL_ATTRS_VL eigmav, EGO_ATTR_GROUPS_V eagv

2821: l_united_nations_dang_goods_no,
2822: l_flash_point_temp,
2823: l_uom_flash_point_temp,
2824: l_dngr_goods_technical_name
2825: FROM EGO_ITM_GTN_MUL_ATTRS_VL eigmav, EGO_ATTR_GROUPS_V eagv
2826: WHERE eigmav.INVENTORY_ITEM_ID = p_inventory_item_id
2827: AND eigmav.ORGANIZATION_ID = p_organization_id
2828: AND eigmav.ATTR_GROUP_ID = eagv.ATTR_GROUP_ID
2829: AND eagv.ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_MULTI_ATTRS'

Line 2997: FROM EGO_ITM_GTN_MUL_ATTRS_VL eigmav, EGO_ATTR_GROUPS_V eagv

2993: l_manufacturer_id := NULL;
2994: IF p_multi_row_attrs_tbl(l_index).MANUFACTURER_GLN IS NOT NULL THEN
2995: BEGIN
2996: SELECT MANUFACTURER_ID INTO l_manufacturer_id
2997: FROM EGO_ITM_GTN_MUL_ATTRS_VL eigmav, EGO_ATTR_GROUPS_V eagv
2998: WHERE eigmav.INVENTORY_ITEM_ID = p_inventory_item_id
2999: AND eigmav.ORGANIZATION_ID = p_organization_id
3000: AND eigmav.ATTR_GROUP_ID = eagv.ATTR_GROUP_ID
3001: AND eagv.ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_MULTI_ATTRS'