The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW (
X_ROWID in out nocopy VARCHAR2,
X_EXTENSION_ID in NUMBER,
X_REQUEST_ID in NUMBER,
X_DELIVERY_TO_MRKT_TEMP_MIN in NUMBER,
X_UOM_DELIVERY_TO_MRKT_TEMP_MI in VARCHAR2,
X_SUB_BRAND in VARCHAR2,
X_UOM_DEL_TO_DIST_CNTR_TEMP_MI in VARCHAR2,
X_DELIVERY_TO_MRKT_TEMP_MAX in NUMBER,
X_UOM_DELIVERY_TO_MRKT_TEMP_MA in VARCHAR2,
X_INVENTORY_ITEM_ID in NUMBER,
X_ORGANIZATION_ID in NUMBER,
X_ITEM_CATALOG_GROUP_ID in NUMBER,
X_REVISION_ID in NUMBER,
X_IS_TRADE_ITEM_A_CONSUMER_UNI in VARCHAR2,
X_IS_TRADE_ITEM_INFO_PRIVATE in VARCHAR2,
X_GROSS_WEIGHT in NUMBER,
X_UOM_GROSS_WEIGHT in VARCHAR2,
X_EFFECTIVE_DATE in DATE,
X_CANCELED_DATE in DATE,
X_DISCONTINUED_DATE in DATE,
X_END_AVAILABILITY_DATE_TIME in DATE,
X_START_AVAILABILITY_DATE_TIME in DATE,
X_BRAND_NAME in VARCHAR2,
X_IS_TRADE_ITEM_A_BASE_UNIT in VARCHAR2,
X_IS_TRADE_ITEM_A_VARIABLE_UNI in VARCHAR2,
X_IS_PACK_MARKED_WITH_EXP_DATE in VARCHAR2,
X_IS_PACK_MARKED_WITH_GREEN_DO in VARCHAR2,
X_IS_PACK_MARKED_WITH_INGRED in VARCHAR2,
X_IS_PACKAGE_MARKED_AS_REC in VARCHAR2,
X_IS_PACKAGE_MARKED_RET in VARCHAR2,
X_STACKING_FACTOR in NUMBER,
X_STACKING_WEIGHT_MAXIMUM in NUMBER,
X_UOM_STACKING_WEIGHT_MAXIMUM in VARCHAR2,
X_ORDERING_LEAD_TIME in NUMBER,
X_UOM_ORDERING_LEAD_TIME in VARCHAR2,
X_ORDER_QUANTITY_MAX in NUMBER,
X_ORDER_QUANTITY_MIN in NUMBER,
X_ORDER_QUANTITY_MULTIPLE in NUMBER,
X_ORDER_SIZING_FACTOR in NUMBER,
X_EFFECTIVE_START_DATE in DATE,
X_CATALOG_PRICE in NUMBER,
X_EFFECTIVE_END_DATE in DATE,
X_SUGGESTED_RETAIL_PRICE in NUMBER,
X_MATERIAL_SAFETY_DATA_SHEET_N in VARCHAR2,
X_HAS_BATCH_NUMBER in VARCHAR2,
X_IS_NON_SOLD_TRADE_RET_FLAG in VARCHAR2,
X_IS_TRADE_ITEM_MAR_REC_FLAG in VARCHAR2,
X_DIAMETER in NUMBER,
X_UOM_DIAMETER in VARCHAR2,
X_DRAINED_WEIGHT in NUMBER,
X_UOM_DRAINED_WEIGHT in VARCHAR2,
X_GENERIC_INGREDIENT in VARCHAR2,
X_GENERIC_INGREDIENT_STRGTH in NUMBER,
X_UOM_GENERIC_INGREDIENT_STRGT in VARCHAR2,
X_INGREDIENT_STRENGTH in VARCHAR2,
X_IS_NET_CONTENT_DEC_FLAG in VARCHAR2,
X_NET_CONTENT in NUMBER,
X_UOM_NET_CONTENT in VARCHAR2,
X_PEG_HORIZONTAL in NUMBER,
X_UOM_PEG_HORIZONTAL in VARCHAR2,
X_PEG_VERTICAL in NUMBER,
X_UOM_PEG_VERTICAL in VARCHAR2,
X_CONSUMER_AVAIL_DATE_TIME in DATE,
X_DEL_TO_DIST_CNTR_TEMP_MAX in NUMBER,
X_UOM_DEL_TO_DIST_CNTR_TEMP_MA in VARCHAR2,
X_DEL_TO_DIST_CNTR_TEMP_MIN in NUMBER,
X_TRADE_ITEM_DESCRIPTOR in VARCHAR2,
X_EANUCC_CODE in VARCHAR2,
X_EANUCC_TYPE in VARCHAR2,
X_RETAIL_PRICE_ON_TRADE_ITEM in NUMBER,
X_QUANTITY_OF_COMP_LAY_ITEM in NUMBER,
X_QUANITY_OF_ITEM_IN_LAYER in NUMBER,
X_QUANTITY_OF_ITEM_INNER_PACK in NUMBER,
X_TARGET_MARKET_DESC in VARCHAR2,
X_QUANTITY_OF_INNER_PACK in NUMBER,
X_BRAND_OWNER_GLN in VARCHAR2,
X_BRAND_OWNER_NAME in VARCHAR2,
X_STORAGE_HANDLING_TEMP_MAX in NUMBER,
X_UOM_STORAGE_HANDLING_TEMP_MA in VARCHAR2,
X_STORAGE_HANDLING_TEMP_MIN in NUMBER,
X_UOM_STORAGE_HANDLING_TEMP_MI in VARCHAR2,
X_TRADE_ITEM_COUPON in NUMBER,
X_DEGREE_OF_ORIGINAL_WORT in VARCHAR2,
X_FAT_PERCENT_IN_DRY_MATTER in NUMBER,
X_PERCENT_OF_ALCOHOL_BY_VOL in NUMBER,
X_ISBN_NUMBER in VARCHAR2,
X_ISSN_NUMBER in VARCHAR2,
X_IS_INGREDIENT_IRRADIATED in VARCHAR2,
X_IS_RAW_MATERIAL_IRRADIATED in VARCHAR2,
X_IS_TRADE_ITEM_GENETICALLY_MO in VARCHAR2,
X_IS_TRADE_ITEM_IRRADIATED in VARCHAR2,
X_PUBLICATION_STATUS in NUMBER,
X_TOP_GTIN in VARCHAR2,
X_SECURITY_TAG_LOCATION in VARCHAR2,
X_URL_FOR_WARRANTY in VARCHAR2,
X_NESTING_INCREMENT in NUMBER,
X_UOM_NESTING_INCREMENT in VARCHAR2,
X_IS_TRADE_ITEM_RECALLED in VARCHAR2,
X_MODEL_NUMBER in VARCHAR2,
X_PIECES_PER_TRADE_ITEM in NUMBER,
X_UOM_PIECES_PER_TRADE_ITEM in VARCHAR2,
X_DEPT_OF_TRNSPRT_DANG_GOODS_N in VARCHAR2,
X_RETURN_GOODS_POLICY in VARCHAR2,
X_IS_OUT_OF_BOX_PROVIDED in VARCHAR2,
X_REGISTRATION_UPDATE_DATE in DATE,
X_TP_NEUTRAL_UPDATE_DATE in DATE,
X_IS_BARCODE_SYMBOLOGY_DERIVAB in VARCHAR2,
X_INVOICE_NAME in VARCHAR2,
X_DESCRIPTIVE_SIZE in VARCHAR2,
X_FUNCTIONAL_NAME in VARCHAR2,
X_TRADE_ITEM_FORM_DESCRIPTION in VARCHAR2,
X_WARRANTY_DESCRIPTION in VARCHAR2,
X_TRADE_ITEM_FINISH_DESCRIPTIO in VARCHAR2,
X_DESCRIPTION_SHORT in VARCHAR2,
X_CREATION_DATE in DATE,
X_CREATED_BY in NUMBER,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER
) is
cursor C is select ROWID from EGO_ITEM_GTN_ATTRS_B
where EXTENSION_ID = X_EXTENSION_ID
;
insert into EGO_ITEM_GTN_ATTRS_B (
REQUEST_ID,
DELIVERY_TO_MRKT_TEMP_MIN,
UOM_DELIVERY_TO_MRKT_TEMP_MIN,
SUB_BRAND,
UOM_DEL_TO_DIST_CNTR_TEMP_MIN,
DELIVERY_TO_MRKT_TEMP_MAX,
UOM_DELIVERY_TO_MRKT_TEMP_MAX,
EXTENSION_ID,
INVENTORY_ITEM_ID,
ORGANIZATION_ID,
ITEM_CATALOG_GROUP_ID,
REVISION_ID,
IS_TRADE_ITEM_A_CONSUMER_UNIT,
IS_TRADE_ITEM_INFO_PRIVATE,
GROSS_WEIGHT,
UOM_GROSS_WEIGHT,
EFFECTIVE_DATE,
CANCELED_DATE,
DISCONTINUED_DATE,
END_AVAILABILITY_DATE_TIME,
START_AVAILABILITY_DATE_TIME,
BRAND_NAME,
IS_TRADE_ITEM_A_BASE_UNIT,
IS_TRADE_ITEM_A_VARIABLE_UNIT,
IS_PACK_MARKED_WITH_EXP_DATE,
IS_PACK_MARKED_WITH_GREEN_DOT,
IS_PACK_MARKED_WITH_INGRED,
IS_PACKAGE_MARKED_AS_REC,
IS_PACKAGE_MARKED_RET,
STACKING_FACTOR,
STACKING_WEIGHT_MAXIMUM,
UOM_STACKING_WEIGHT_MAXIMUM,
ORDERING_LEAD_TIME,
UOM_ORDERING_LEAD_TIME,
ORDER_QUANTITY_MAX,
ORDER_QUANTITY_MIN,
ORDER_QUANTITY_MULTIPLE,
ORDER_SIZING_FACTOR,
EFFECTIVE_START_DATE,
CATALOG_PRICE,
EFFECTIVE_END_DATE,
SUGGESTED_RETAIL_PRICE,
MATERIAL_SAFETY_DATA_SHEET_NO,
HAS_BATCH_NUMBER,
IS_NON_SOLD_TRADE_RET_FLAG,
IS_TRADE_ITEM_MAR_REC_FLAG,
DIAMETER,
UOM_DIAMETER,
DRAINED_WEIGHT,
UOM_DRAINED_WEIGHT,
GENERIC_INGREDIENT,
GENERIC_INGREDIENT_STRGTH,
UOM_GENERIC_INGREDIENT_STRGTH,
INGREDIENT_STRENGTH,
IS_NET_CONTENT_DEC_FLAG,
NET_CONTENT,
UOM_NET_CONTENT,
PEG_HORIZONTAL,
UOM_PEG_HORIZONTAL,
PEG_VERTICAL,
UOM_PEG_VERTICAL,
CONSUMER_AVAIL_DATE_TIME,
DEL_TO_DIST_CNTR_TEMP_MAX,
UOM_DEL_TO_DIST_CNTR_TEMP_MAX,
DEL_TO_DIST_CNTR_TEMP_MIN,
TRADE_ITEM_DESCRIPTOR,
EANUCC_CODE,
EANUCC_TYPE,
RETAIL_PRICE_ON_TRADE_ITEM,
QUANTITY_OF_COMP_LAY_ITEM,
QUANITY_OF_ITEM_IN_LAYER,
QUANTITY_OF_ITEM_INNER_PACK,
TARGET_MARKET_DESC,
QUANTITY_OF_INNER_PACK,
BRAND_OWNER_GLN,
BRAND_OWNER_NAME,
STORAGE_HANDLING_TEMP_MAX,
UOM_STORAGE_HANDLING_TEMP_MAX,
STORAGE_HANDLING_TEMP_MIN,
UOM_STORAGE_HANDLING_TEMP_MIN,
TRADE_ITEM_COUPON,
DEGREE_OF_ORIGINAL_WORT,
FAT_PERCENT_IN_DRY_MATTER,
PERCENT_OF_ALCOHOL_BY_VOL,
ISBN_NUMBER,
ISSN_NUMBER,
IS_INGREDIENT_IRRADIATED,
IS_RAW_MATERIAL_IRRADIATED,
IS_TRADE_ITEM_GENETICALLY_MOD,
IS_TRADE_ITEM_IRRADIATED,
PUBLICATION_STATUS,
TOP_GTIN,
SECURITY_TAG_LOCATION,
URL_FOR_WARRANTY,
NESTING_INCREMENT,
UOM_NESTING_INCREMENT,
IS_TRADE_ITEM_RECALLED,
MODEL_NUMBER,
PIECES_PER_TRADE_ITEM,
UOM_PIECES_PER_TRADE_ITEM,
DEPT_OF_TRNSPRT_DANG_GOODS_NUM,
RETURN_GOODS_POLICY,
IS_OUT_OF_BOX_PROVIDED,
REGISTRATION_UPDATE_DATE,
TP_NEUTRAL_UPDATE_DATE,
IS_BARCODE_SYMBOLOGY_DERIVABLE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
X_REQUEST_ID,
X_DELIVERY_TO_MRKT_TEMP_MIN,
X_UOM_DELIVERY_TO_MRKT_TEMP_MI,
X_SUB_BRAND,
X_UOM_DEL_TO_DIST_CNTR_TEMP_MI,
X_DELIVERY_TO_MRKT_TEMP_MAX,
X_UOM_DELIVERY_TO_MRKT_TEMP_MA,
X_EXTENSION_ID,
X_INVENTORY_ITEM_ID,
X_ORGANIZATION_ID,
X_ITEM_CATALOG_GROUP_ID,
X_REVISION_ID,
X_IS_TRADE_ITEM_A_CONSUMER_UNI,
X_IS_TRADE_ITEM_INFO_PRIVATE,
X_GROSS_WEIGHT,
X_UOM_GROSS_WEIGHT,
X_EFFECTIVE_DATE,
X_CANCELED_DATE,
X_DISCONTINUED_DATE,
X_END_AVAILABILITY_DATE_TIME,
X_START_AVAILABILITY_DATE_TIME,
X_BRAND_NAME,
X_IS_TRADE_ITEM_A_BASE_UNIT,
X_IS_TRADE_ITEM_A_VARIABLE_UNI,
X_IS_PACK_MARKED_WITH_EXP_DATE,
X_IS_PACK_MARKED_WITH_GREEN_DO,
X_IS_PACK_MARKED_WITH_INGRED,
X_IS_PACKAGE_MARKED_AS_REC,
X_IS_PACKAGE_MARKED_RET,
X_STACKING_FACTOR,
X_STACKING_WEIGHT_MAXIMUM,
X_UOM_STACKING_WEIGHT_MAXIMUM,
X_ORDERING_LEAD_TIME,
X_UOM_ORDERING_LEAD_TIME,
X_ORDER_QUANTITY_MAX,
X_ORDER_QUANTITY_MIN,
X_ORDER_QUANTITY_MULTIPLE,
X_ORDER_SIZING_FACTOR,
X_EFFECTIVE_START_DATE,
X_CATALOG_PRICE,
X_EFFECTIVE_END_DATE,
X_SUGGESTED_RETAIL_PRICE,
X_MATERIAL_SAFETY_DATA_SHEET_N,
X_HAS_BATCH_NUMBER,
X_IS_NON_SOLD_TRADE_RET_FLAG,
X_IS_TRADE_ITEM_MAR_REC_FLAG,
X_DIAMETER,
X_UOM_DIAMETER,
X_DRAINED_WEIGHT,
X_UOM_DRAINED_WEIGHT,
X_GENERIC_INGREDIENT,
X_GENERIC_INGREDIENT_STRGTH,
X_UOM_GENERIC_INGREDIENT_STRGT,
X_INGREDIENT_STRENGTH,
X_IS_NET_CONTENT_DEC_FLAG,
X_NET_CONTENT,
X_UOM_NET_CONTENT,
X_PEG_HORIZONTAL,
X_UOM_PEG_HORIZONTAL,
X_PEG_VERTICAL,
X_UOM_PEG_VERTICAL,
X_CONSUMER_AVAIL_DATE_TIME,
X_DEL_TO_DIST_CNTR_TEMP_MAX,
X_UOM_DEL_TO_DIST_CNTR_TEMP_MA,
X_DEL_TO_DIST_CNTR_TEMP_MIN,
X_TRADE_ITEM_DESCRIPTOR,
X_EANUCC_CODE,
X_EANUCC_TYPE,
X_RETAIL_PRICE_ON_TRADE_ITEM,
X_QUANTITY_OF_COMP_LAY_ITEM,
X_QUANITY_OF_ITEM_IN_LAYER,
X_QUANTITY_OF_ITEM_INNER_PACK,
X_TARGET_MARKET_DESC,
X_QUANTITY_OF_INNER_PACK,
X_BRAND_OWNER_GLN,
X_BRAND_OWNER_NAME,
X_STORAGE_HANDLING_TEMP_MAX,
X_UOM_STORAGE_HANDLING_TEMP_MA,
X_STORAGE_HANDLING_TEMP_MIN,
X_UOM_STORAGE_HANDLING_TEMP_MI,
X_TRADE_ITEM_COUPON,
X_DEGREE_OF_ORIGINAL_WORT,
X_FAT_PERCENT_IN_DRY_MATTER,
X_PERCENT_OF_ALCOHOL_BY_VOL,
X_ISBN_NUMBER,
X_ISSN_NUMBER,
X_IS_INGREDIENT_IRRADIATED,
X_IS_RAW_MATERIAL_IRRADIATED,
X_IS_TRADE_ITEM_GENETICALLY_MO,
X_IS_TRADE_ITEM_IRRADIATED,
X_PUBLICATION_STATUS,
X_TOP_GTIN,
X_SECURITY_TAG_LOCATION,
X_URL_FOR_WARRANTY,
X_NESTING_INCREMENT,
X_UOM_NESTING_INCREMENT,
X_IS_TRADE_ITEM_RECALLED,
X_MODEL_NUMBER,
X_PIECES_PER_TRADE_ITEM,
X_UOM_PIECES_PER_TRADE_ITEM,
X_DEPT_OF_TRNSPRT_DANG_GOODS_N,
X_RETURN_GOODS_POLICY,
X_IS_OUT_OF_BOX_PROVIDED,
X_REGISTRATION_UPDATE_DATE,
X_TP_NEUTRAL_UPDATE_DATE,
X_IS_BARCODE_SYMBOLOGY_DERIVAB,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN
);
insert into EGO_ITEM_GTN_ATTRS_TL (
REQUEST_ID,
EXTENSION_ID,
INVENTORY_ITEM_ID,
ORGANIZATION_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
ITEM_CATALOG_GROUP_ID,
REVISION_ID,
INVOICE_NAME,
DESCRIPTIVE_SIZE,
FUNCTIONAL_NAME,
TRADE_ITEM_FORM_DESCRIPTION,
WARRANTY_DESCRIPTION,
TRADE_ITEM_FINISH_DESCRIPTION,
DESCRIPTION_SHORT,
LANGUAGE,
SOURCE_LANG
) select
X_REQUEST_ID,
X_EXTENSION_ID,
X_INVENTORY_ITEM_ID,
X_ORGANIZATION_ID,
X_CREATED_BY,
X_CREATION_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN,
X_ITEM_CATALOG_GROUP_ID,
X_REVISION_ID,
X_INVOICE_NAME,
X_DESCRIPTIVE_SIZE,
X_FUNCTIONAL_NAME,
X_TRADE_ITEM_FORM_DESCRIPTION,
X_WARRANTY_DESCRIPTION,
X_TRADE_ITEM_FINISH_DESCRIPTIO,
X_DESCRIPTION_SHORT,
L.LANGUAGE_CODE,
userenv('LANG')
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from EGO_ITEM_GTN_ATTRS_TL T
where T.EXTENSION_ID = X_EXTENSION_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
end INSERT_ROW;
X_REGISTRATION_UPDATE_DATE in DATE,
X_TP_NEUTRAL_UPDATE_DATE in DATE,
X_IS_BARCODE_SYMBOLOGY_DERIVAB in VARCHAR2,
X_INVOICE_NAME in VARCHAR2,
X_DESCRIPTIVE_SIZE in VARCHAR2,
X_FUNCTIONAL_NAME in VARCHAR2,
X_TRADE_ITEM_FORM_DESCRIPTION in VARCHAR2,
X_WARRANTY_DESCRIPTION in VARCHAR2,
X_TRADE_ITEM_FINISH_DESCRIPTIO in VARCHAR2,
X_DESCRIPTION_SHORT in VARCHAR2
) is
cursor c is select
REQUEST_ID,
DELIVERY_TO_MRKT_TEMP_MIN,
UOM_DELIVERY_TO_MRKT_TEMP_MIN,
SUB_BRAND,
UOM_DEL_TO_DIST_CNTR_TEMP_MIN,
DELIVERY_TO_MRKT_TEMP_MAX,
UOM_DELIVERY_TO_MRKT_TEMP_MAX,
INVENTORY_ITEM_ID,
ORGANIZATION_ID,
ITEM_CATALOG_GROUP_ID,
REVISION_ID,
IS_TRADE_ITEM_A_CONSUMER_UNIT,
IS_TRADE_ITEM_INFO_PRIVATE,
GROSS_WEIGHT,
UOM_GROSS_WEIGHT,
EFFECTIVE_DATE,
CANCELED_DATE,
DISCONTINUED_DATE,
END_AVAILABILITY_DATE_TIME,
START_AVAILABILITY_DATE_TIME,
BRAND_NAME,
IS_TRADE_ITEM_A_BASE_UNIT,
IS_TRADE_ITEM_A_VARIABLE_UNIT,
IS_PACK_MARKED_WITH_EXP_DATE,
IS_PACK_MARKED_WITH_GREEN_DOT,
IS_PACK_MARKED_WITH_INGRED,
IS_PACKAGE_MARKED_AS_REC,
IS_PACKAGE_MARKED_RET,
STACKING_FACTOR,
STACKING_WEIGHT_MAXIMUM,
UOM_STACKING_WEIGHT_MAXIMUM,
ORDERING_LEAD_TIME,
UOM_ORDERING_LEAD_TIME,
ORDER_QUANTITY_MAX,
ORDER_QUANTITY_MIN,
ORDER_QUANTITY_MULTIPLE,
ORDER_SIZING_FACTOR,
EFFECTIVE_START_DATE,
CATALOG_PRICE,
EFFECTIVE_END_DATE,
SUGGESTED_RETAIL_PRICE,
MATERIAL_SAFETY_DATA_SHEET_NO,
HAS_BATCH_NUMBER,
IS_NON_SOLD_TRADE_RET_FLAG,
IS_TRADE_ITEM_MAR_REC_FLAG,
DIAMETER,
UOM_DIAMETER,
DRAINED_WEIGHT,
UOM_DRAINED_WEIGHT,
GENERIC_INGREDIENT,
GENERIC_INGREDIENT_STRGTH,
UOM_GENERIC_INGREDIENT_STRGTH,
INGREDIENT_STRENGTH,
IS_NET_CONTENT_DEC_FLAG,
NET_CONTENT,
UOM_NET_CONTENT,
PEG_HORIZONTAL,
UOM_PEG_HORIZONTAL,
PEG_VERTICAL,
UOM_PEG_VERTICAL,
CONSUMER_AVAIL_DATE_TIME,
DEL_TO_DIST_CNTR_TEMP_MAX,
UOM_DEL_TO_DIST_CNTR_TEMP_MAX,
DEL_TO_DIST_CNTR_TEMP_MIN,
TRADE_ITEM_DESCRIPTOR,
EANUCC_CODE,
EANUCC_TYPE,
RETAIL_PRICE_ON_TRADE_ITEM,
QUANTITY_OF_COMP_LAY_ITEM,
QUANITY_OF_ITEM_IN_LAYER,
QUANTITY_OF_ITEM_INNER_PACK,
TARGET_MARKET_DESC,
QUANTITY_OF_INNER_PACK,
BRAND_OWNER_GLN,
BRAND_OWNER_NAME,
STORAGE_HANDLING_TEMP_MAX,
UOM_STORAGE_HANDLING_TEMP_MAX,
STORAGE_HANDLING_TEMP_MIN,
UOM_STORAGE_HANDLING_TEMP_MIN,
TRADE_ITEM_COUPON,
DEGREE_OF_ORIGINAL_WORT,
FAT_PERCENT_IN_DRY_MATTER,
PERCENT_OF_ALCOHOL_BY_VOL,
ISBN_NUMBER,
ISSN_NUMBER,
IS_INGREDIENT_IRRADIATED,
IS_RAW_MATERIAL_IRRADIATED,
IS_TRADE_ITEM_GENETICALLY_MOD,
IS_TRADE_ITEM_IRRADIATED,
PUBLICATION_STATUS,
TOP_GTIN,
SECURITY_TAG_LOCATION,
URL_FOR_WARRANTY,
NESTING_INCREMENT,
UOM_NESTING_INCREMENT,
IS_TRADE_ITEM_RECALLED,
MODEL_NUMBER,
PIECES_PER_TRADE_ITEM,
UOM_PIECES_PER_TRADE_ITEM,
DEPT_OF_TRNSPRT_DANG_GOODS_NUM,
RETURN_GOODS_POLICY,
IS_OUT_OF_BOX_PROVIDED,
REGISTRATION_UPDATE_DATE,
TP_NEUTRAL_UPDATE_DATE,
IS_BARCODE_SYMBOLOGY_DERIVABLE
from EGO_ITEM_GTN_ATTRS_B
where EXTENSION_ID = X_EXTENSION_ID
for update of EXTENSION_ID nowait;
cursor c1 is select
INVOICE_NAME,
DESCRIPTIVE_SIZE,
FUNCTIONAL_NAME,
TRADE_ITEM_FORM_DESCRIPTION,
WARRANTY_DESCRIPTION,
TRADE_ITEM_FINISH_DESCRIPTION,
DESCRIPTION_SHORT,
decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
from EGO_ITEM_GTN_ATTRS_TL
where EXTENSION_ID = X_EXTENSION_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
for update of EXTENSION_ID nowait;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
AND ((recinfo.REGISTRATION_UPDATE_DATE = X_REGISTRATION_UPDATE_DATE)
OR ((recinfo.REGISTRATION_UPDATE_DATE is null) AND (X_REGISTRATION_UPDATE_DATE is null)))
AND ((recinfo.TP_NEUTRAL_UPDATE_DATE = X_TP_NEUTRAL_UPDATE_DATE)
OR ((recinfo.TP_NEUTRAL_UPDATE_DATE is null) AND (X_TP_NEUTRAL_UPDATE_DATE is null)))
AND ((recinfo.IS_BARCODE_SYMBOLOGY_DERIVABLE = X_IS_BARCODE_SYMBOLOGY_DERIVAB)
OR ((recinfo.IS_BARCODE_SYMBOLOGY_DERIVABLE is null) AND (X_IS_BARCODE_SYMBOLOGY_DERIVAB is null)))
) then
null;
procedure UPDATE_ROW (
X_EXTENSION_ID in NUMBER,
X_REQUEST_ID in NUMBER,
X_DELIVERY_TO_MRKT_TEMP_MIN in NUMBER,
X_UOM_DELIVERY_TO_MRKT_TEMP_MI in VARCHAR2,
X_SUB_BRAND in VARCHAR2,
X_UOM_DEL_TO_DIST_CNTR_TEMP_MI in VARCHAR2,
X_DELIVERY_TO_MRKT_TEMP_MAX in NUMBER,
X_UOM_DELIVERY_TO_MRKT_TEMP_MA in VARCHAR2,
X_INVENTORY_ITEM_ID in NUMBER,
X_ORGANIZATION_ID in NUMBER,
X_ITEM_CATALOG_GROUP_ID in NUMBER,
X_REVISION_ID in NUMBER,
X_IS_TRADE_ITEM_A_CONSUMER_UNI in VARCHAR2,
X_IS_TRADE_ITEM_INFO_PRIVATE in VARCHAR2,
X_GROSS_WEIGHT in NUMBER,
X_UOM_GROSS_WEIGHT in VARCHAR2,
X_EFFECTIVE_DATE in DATE,
X_CANCELED_DATE in DATE,
X_DISCONTINUED_DATE in DATE,
X_END_AVAILABILITY_DATE_TIME in DATE,
X_START_AVAILABILITY_DATE_TIME in DATE,
X_BRAND_NAME in VARCHAR2,
X_IS_TRADE_ITEM_A_BASE_UNIT in VARCHAR2,
X_IS_TRADE_ITEM_A_VARIABLE_UNI in VARCHAR2,
X_IS_PACK_MARKED_WITH_EXP_DATE in VARCHAR2,
X_IS_PACK_MARKED_WITH_GREEN_DO in VARCHAR2,
X_IS_PACK_MARKED_WITH_INGRED in VARCHAR2,
X_IS_PACKAGE_MARKED_AS_REC in VARCHAR2,
X_IS_PACKAGE_MARKED_RET in VARCHAR2,
X_STACKING_FACTOR in NUMBER,
X_STACKING_WEIGHT_MAXIMUM in NUMBER,
X_UOM_STACKING_WEIGHT_MAXIMUM in VARCHAR2,
X_ORDERING_LEAD_TIME in NUMBER,
X_UOM_ORDERING_LEAD_TIME in VARCHAR2,
X_ORDER_QUANTITY_MAX in NUMBER,
X_ORDER_QUANTITY_MIN in NUMBER,
X_ORDER_QUANTITY_MULTIPLE in NUMBER,
X_ORDER_SIZING_FACTOR in NUMBER,
X_EFFECTIVE_START_DATE in DATE,
X_CATALOG_PRICE in NUMBER,
X_EFFECTIVE_END_DATE in DATE,
X_SUGGESTED_RETAIL_PRICE in NUMBER,
X_MATERIAL_SAFETY_DATA_SHEET_N in VARCHAR2,
X_HAS_BATCH_NUMBER in VARCHAR2,
X_IS_NON_SOLD_TRADE_RET_FLAG in VARCHAR2,
X_IS_TRADE_ITEM_MAR_REC_FLAG in VARCHAR2,
X_DIAMETER in NUMBER,
X_UOM_DIAMETER in VARCHAR2,
X_DRAINED_WEIGHT in NUMBER,
X_UOM_DRAINED_WEIGHT in VARCHAR2,
X_GENERIC_INGREDIENT in VARCHAR2,
X_GENERIC_INGREDIENT_STRGTH in NUMBER,
X_UOM_GENERIC_INGREDIENT_STRGT in VARCHAR2,
X_INGREDIENT_STRENGTH in VARCHAR2,
X_IS_NET_CONTENT_DEC_FLAG in VARCHAR2,
X_NET_CONTENT in NUMBER,
X_UOM_NET_CONTENT in VARCHAR2,
X_PEG_HORIZONTAL in NUMBER,
X_UOM_PEG_HORIZONTAL in VARCHAR2,
X_PEG_VERTICAL in NUMBER,
X_UOM_PEG_VERTICAL in VARCHAR2,
X_CONSUMER_AVAIL_DATE_TIME in DATE,
X_DEL_TO_DIST_CNTR_TEMP_MAX in NUMBER,
X_UOM_DEL_TO_DIST_CNTR_TEMP_MA in VARCHAR2,
X_DEL_TO_DIST_CNTR_TEMP_MIN in NUMBER,
X_TRADE_ITEM_DESCRIPTOR in VARCHAR2,
X_EANUCC_CODE in VARCHAR2,
X_EANUCC_TYPE in VARCHAR2,
X_RETAIL_PRICE_ON_TRADE_ITEM in NUMBER,
X_QUANTITY_OF_COMP_LAY_ITEM in NUMBER,
X_QUANITY_OF_ITEM_IN_LAYER in NUMBER,
X_QUANTITY_OF_ITEM_INNER_PACK in NUMBER,
X_TARGET_MARKET_DESC in VARCHAR2,
X_QUANTITY_OF_INNER_PACK in NUMBER,
X_BRAND_OWNER_GLN in VARCHAR2,
X_BRAND_OWNER_NAME in VARCHAR2,
X_STORAGE_HANDLING_TEMP_MAX in NUMBER,
X_UOM_STORAGE_HANDLING_TEMP_MA in VARCHAR2,
X_STORAGE_HANDLING_TEMP_MIN in NUMBER,
X_UOM_STORAGE_HANDLING_TEMP_MI in VARCHAR2,
X_TRADE_ITEM_COUPON in NUMBER,
X_DEGREE_OF_ORIGINAL_WORT in VARCHAR2,
X_FAT_PERCENT_IN_DRY_MATTER in NUMBER,
X_PERCENT_OF_ALCOHOL_BY_VOL in NUMBER,
X_ISBN_NUMBER in VARCHAR2,
X_ISSN_NUMBER in VARCHAR2,
X_IS_INGREDIENT_IRRADIATED in VARCHAR2,
X_IS_RAW_MATERIAL_IRRADIATED in VARCHAR2,
X_IS_TRADE_ITEM_GENETICALLY_MO in VARCHAR2,
X_IS_TRADE_ITEM_IRRADIATED in VARCHAR2,
X_PUBLICATION_STATUS in NUMBER,
X_TOP_GTIN in VARCHAR2,
X_SECURITY_TAG_LOCATION in VARCHAR2,
X_URL_FOR_WARRANTY in VARCHAR2,
X_NESTING_INCREMENT in NUMBER,
X_UOM_NESTING_INCREMENT in VARCHAR2,
X_IS_TRADE_ITEM_RECALLED in VARCHAR2,
X_MODEL_NUMBER in VARCHAR2,
X_PIECES_PER_TRADE_ITEM in NUMBER,
X_UOM_PIECES_PER_TRADE_ITEM in VARCHAR2,
X_DEPT_OF_TRNSPRT_DANG_GOODS_N in VARCHAR2,
X_RETURN_GOODS_POLICY in VARCHAR2,
X_IS_OUT_OF_BOX_PROVIDED in VARCHAR2,
X_REGISTRATION_UPDATE_DATE in DATE,
X_TP_NEUTRAL_UPDATE_DATE in DATE,
X_IS_BARCODE_SYMBOLOGY_DERIVAB in VARCHAR2,
X_INVOICE_NAME in VARCHAR2,
X_DESCRIPTIVE_SIZE in VARCHAR2,
X_FUNCTIONAL_NAME in VARCHAR2,
X_TRADE_ITEM_FORM_DESCRIPTION in VARCHAR2,
X_WARRANTY_DESCRIPTION in VARCHAR2,
X_TRADE_ITEM_FINISH_DESCRIPTIO in VARCHAR2,
X_DESCRIPTION_SHORT in VARCHAR2,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
update EGO_ITEM_GTN_ATTRS_B set
REQUEST_ID = X_REQUEST_ID,
DELIVERY_TO_MRKT_TEMP_MIN = X_DELIVERY_TO_MRKT_TEMP_MIN,
UOM_DELIVERY_TO_MRKT_TEMP_MIN = X_UOM_DELIVERY_TO_MRKT_TEMP_MI,
SUB_BRAND = X_SUB_BRAND,
UOM_DEL_TO_DIST_CNTR_TEMP_MIN = X_UOM_DEL_TO_DIST_CNTR_TEMP_MI,
DELIVERY_TO_MRKT_TEMP_MAX = X_DELIVERY_TO_MRKT_TEMP_MAX,
UOM_DELIVERY_TO_MRKT_TEMP_MAX = X_UOM_DELIVERY_TO_MRKT_TEMP_MA,
INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
ORGANIZATION_ID = X_ORGANIZATION_ID,
ITEM_CATALOG_GROUP_ID = X_ITEM_CATALOG_GROUP_ID,
REVISION_ID = X_REVISION_ID,
IS_TRADE_ITEM_A_CONSUMER_UNIT = X_IS_TRADE_ITEM_A_CONSUMER_UNI,
IS_TRADE_ITEM_INFO_PRIVATE = X_IS_TRADE_ITEM_INFO_PRIVATE,
GROSS_WEIGHT = X_GROSS_WEIGHT,
UOM_GROSS_WEIGHT = X_UOM_GROSS_WEIGHT,
EFFECTIVE_DATE = X_EFFECTIVE_DATE,
CANCELED_DATE = X_CANCELED_DATE,
DISCONTINUED_DATE = X_DISCONTINUED_DATE,
END_AVAILABILITY_DATE_TIME = X_END_AVAILABILITY_DATE_TIME,
START_AVAILABILITY_DATE_TIME = X_START_AVAILABILITY_DATE_TIME,
BRAND_NAME = X_BRAND_NAME,
IS_TRADE_ITEM_A_BASE_UNIT = X_IS_TRADE_ITEM_A_BASE_UNIT,
IS_TRADE_ITEM_A_VARIABLE_UNIT = X_IS_TRADE_ITEM_A_VARIABLE_UNI,
IS_PACK_MARKED_WITH_EXP_DATE = X_IS_PACK_MARKED_WITH_EXP_DATE,
IS_PACK_MARKED_WITH_GREEN_DOT = X_IS_PACK_MARKED_WITH_GREEN_DO,
IS_PACK_MARKED_WITH_INGRED = X_IS_PACK_MARKED_WITH_INGRED,
IS_PACKAGE_MARKED_AS_REC = X_IS_PACKAGE_MARKED_AS_REC,
IS_PACKAGE_MARKED_RET = X_IS_PACKAGE_MARKED_RET,
STACKING_FACTOR = X_STACKING_FACTOR,
STACKING_WEIGHT_MAXIMUM = X_STACKING_WEIGHT_MAXIMUM,
UOM_STACKING_WEIGHT_MAXIMUM = X_UOM_STACKING_WEIGHT_MAXIMUM,
ORDERING_LEAD_TIME = X_ORDERING_LEAD_TIME,
UOM_ORDERING_LEAD_TIME = X_UOM_ORDERING_LEAD_TIME,
ORDER_QUANTITY_MAX = X_ORDER_QUANTITY_MAX,
ORDER_QUANTITY_MIN = X_ORDER_QUANTITY_MIN,
ORDER_QUANTITY_MULTIPLE = X_ORDER_QUANTITY_MULTIPLE,
ORDER_SIZING_FACTOR = X_ORDER_SIZING_FACTOR,
EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE,
CATALOG_PRICE = X_CATALOG_PRICE,
EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE,
SUGGESTED_RETAIL_PRICE = X_SUGGESTED_RETAIL_PRICE,
MATERIAL_SAFETY_DATA_SHEET_NO = X_MATERIAL_SAFETY_DATA_SHEET_N,
HAS_BATCH_NUMBER = X_HAS_BATCH_NUMBER,
IS_NON_SOLD_TRADE_RET_FLAG = X_IS_NON_SOLD_TRADE_RET_FLAG,
IS_TRADE_ITEM_MAR_REC_FLAG = X_IS_TRADE_ITEM_MAR_REC_FLAG,
DIAMETER = X_DIAMETER,
UOM_DIAMETER = X_UOM_DIAMETER,
DRAINED_WEIGHT = X_DRAINED_WEIGHT,
UOM_DRAINED_WEIGHT = X_UOM_DRAINED_WEIGHT,
GENERIC_INGREDIENT = X_GENERIC_INGREDIENT,
GENERIC_INGREDIENT_STRGTH = X_GENERIC_INGREDIENT_STRGTH,
UOM_GENERIC_INGREDIENT_STRGTH = X_UOM_GENERIC_INGREDIENT_STRGT,
INGREDIENT_STRENGTH = X_INGREDIENT_STRENGTH,
IS_NET_CONTENT_DEC_FLAG = X_IS_NET_CONTENT_DEC_FLAG,
NET_CONTENT = X_NET_CONTENT,
UOM_NET_CONTENT = X_UOM_NET_CONTENT,
PEG_HORIZONTAL = X_PEG_HORIZONTAL,
UOM_PEG_HORIZONTAL = X_UOM_PEG_HORIZONTAL,
PEG_VERTICAL = X_PEG_VERTICAL,
UOM_PEG_VERTICAL = X_UOM_PEG_VERTICAL,
CONSUMER_AVAIL_DATE_TIME = X_CONSUMER_AVAIL_DATE_TIME,
DEL_TO_DIST_CNTR_TEMP_MAX = X_DEL_TO_DIST_CNTR_TEMP_MAX,
UOM_DEL_TO_DIST_CNTR_TEMP_MAX = X_UOM_DEL_TO_DIST_CNTR_TEMP_MA,
DEL_TO_DIST_CNTR_TEMP_MIN = X_DEL_TO_DIST_CNTR_TEMP_MIN,
TRADE_ITEM_DESCRIPTOR = X_TRADE_ITEM_DESCRIPTOR,
EANUCC_CODE = X_EANUCC_CODE,
EANUCC_TYPE = X_EANUCC_TYPE,
RETAIL_PRICE_ON_TRADE_ITEM = X_RETAIL_PRICE_ON_TRADE_ITEM,
QUANTITY_OF_COMP_LAY_ITEM = X_QUANTITY_OF_COMP_LAY_ITEM,
QUANITY_OF_ITEM_IN_LAYER = X_QUANITY_OF_ITEM_IN_LAYER,
QUANTITY_OF_ITEM_INNER_PACK = X_QUANTITY_OF_ITEM_INNER_PACK,
TARGET_MARKET_DESC = X_TARGET_MARKET_DESC,
QUANTITY_OF_INNER_PACK = X_QUANTITY_OF_INNER_PACK,
BRAND_OWNER_GLN = X_BRAND_OWNER_GLN,
BRAND_OWNER_NAME = X_BRAND_OWNER_NAME,
STORAGE_HANDLING_TEMP_MAX = X_STORAGE_HANDLING_TEMP_MAX,
UOM_STORAGE_HANDLING_TEMP_MAX = X_UOM_STORAGE_HANDLING_TEMP_MA,
STORAGE_HANDLING_TEMP_MIN = X_STORAGE_HANDLING_TEMP_MIN,
UOM_STORAGE_HANDLING_TEMP_MIN = X_UOM_STORAGE_HANDLING_TEMP_MI,
TRADE_ITEM_COUPON = X_TRADE_ITEM_COUPON,
DEGREE_OF_ORIGINAL_WORT = X_DEGREE_OF_ORIGINAL_WORT,
FAT_PERCENT_IN_DRY_MATTER = X_FAT_PERCENT_IN_DRY_MATTER,
PERCENT_OF_ALCOHOL_BY_VOL = X_PERCENT_OF_ALCOHOL_BY_VOL,
ISBN_NUMBER = X_ISBN_NUMBER,
ISSN_NUMBER = X_ISSN_NUMBER,
IS_INGREDIENT_IRRADIATED = X_IS_INGREDIENT_IRRADIATED,
IS_RAW_MATERIAL_IRRADIATED = X_IS_RAW_MATERIAL_IRRADIATED,
IS_TRADE_ITEM_GENETICALLY_MOD = X_IS_TRADE_ITEM_GENETICALLY_MO,
IS_TRADE_ITEM_IRRADIATED = X_IS_TRADE_ITEM_IRRADIATED,
PUBLICATION_STATUS = X_PUBLICATION_STATUS,
TOP_GTIN = X_TOP_GTIN,
SECURITY_TAG_LOCATION = X_SECURITY_TAG_LOCATION,
URL_FOR_WARRANTY = X_URL_FOR_WARRANTY,
NESTING_INCREMENT = X_NESTING_INCREMENT,
UOM_NESTING_INCREMENT = X_UOM_NESTING_INCREMENT,
IS_TRADE_ITEM_RECALLED = X_IS_TRADE_ITEM_RECALLED,
MODEL_NUMBER = X_MODEL_NUMBER,
PIECES_PER_TRADE_ITEM = X_PIECES_PER_TRADE_ITEM,
UOM_PIECES_PER_TRADE_ITEM = X_UOM_PIECES_PER_TRADE_ITEM,
DEPT_OF_TRNSPRT_DANG_GOODS_NUM = X_DEPT_OF_TRNSPRT_DANG_GOODS_N,
RETURN_GOODS_POLICY = X_RETURN_GOODS_POLICY,
IS_OUT_OF_BOX_PROVIDED = X_IS_OUT_OF_BOX_PROVIDED,
REGISTRATION_UPDATE_DATE = X_REGISTRATION_UPDATE_DATE,
TP_NEUTRAL_UPDATE_DATE = X_TP_NEUTRAL_UPDATE_DATE,
IS_BARCODE_SYMBOLOGY_DERIVABLE = X_IS_BARCODE_SYMBOLOGY_DERIVAB,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
where EXTENSION_ID = X_EXTENSION_ID;
update EGO_ITEM_GTN_ATTRS_TL set
INVOICE_NAME = X_INVOICE_NAME,
DESCRIPTIVE_SIZE = X_DESCRIPTIVE_SIZE,
FUNCTIONAL_NAME = X_FUNCTIONAL_NAME,
TRADE_ITEM_FORM_DESCRIPTION = X_TRADE_ITEM_FORM_DESCRIPTION,
WARRANTY_DESCRIPTION = X_WARRANTY_DESCRIPTION,
TRADE_ITEM_FINISH_DESCRIPTION = X_TRADE_ITEM_FINISH_DESCRIPTIO,
DESCRIPTION_SHORT = X_DESCRIPTION_SHORT,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
SOURCE_LANG = userenv('LANG')
where EXTENSION_ID = X_EXTENSION_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
end UPDATE_ROW;
procedure DELETE_ROW (
X_EXTENSION_ID in NUMBER
) is
begin
delete from EGO_ITEM_GTN_ATTRS_TL
where EXTENSION_ID = X_EXTENSION_ID;
delete from EGO_ITEM_GTN_ATTRS_B
where EXTENSION_ID = X_EXTENSION_ID;
end DELETE_ROW;
delete from EGO_ITEM_GTN_ATTRS_TL T
where not exists
(select NULL
from EGO_ITEM_GTN_ATTRS_B B
where B.EXTENSION_ID = T.EXTENSION_ID
);
update EGO_ITEM_GTN_ATTRS_TL T set (
INVOICE_NAME,
DESCRIPTIVE_SIZE,
FUNCTIONAL_NAME,
TRADE_ITEM_FORM_DESCRIPTION,
WARRANTY_DESCRIPTION,
TRADE_ITEM_FINISH_DESCRIPTION,
DESCRIPTION_SHORT
) = (select
B.INVOICE_NAME,
B.DESCRIPTIVE_SIZE,
B.FUNCTIONAL_NAME,
B.TRADE_ITEM_FORM_DESCRIPTION,
B.WARRANTY_DESCRIPTION,
B.TRADE_ITEM_FINISH_DESCRIPTION,
B.DESCRIPTION_SHORT
from EGO_ITEM_GTN_ATTRS_TL B
where B.EXTENSION_ID = T.EXTENSION_ID
and B.LANGUAGE = T.SOURCE_LANG)
where (
T.EXTENSION_ID,
T.LANGUAGE
) in (select
SUBT.EXTENSION_ID,
SUBT.LANGUAGE
from EGO_ITEM_GTN_ATTRS_TL SUBB, EGO_ITEM_GTN_ATTRS_TL SUBT
where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
and SUBB.LANGUAGE = SUBT.SOURCE_LANG
and (SUBB.INVOICE_NAME <> SUBT.INVOICE_NAME
or (SUBB.INVOICE_NAME is null and SUBT.INVOICE_NAME is not null)
or (SUBB.INVOICE_NAME is not null and SUBT.INVOICE_NAME is null)
or SUBB.DESCRIPTIVE_SIZE <> SUBT.DESCRIPTIVE_SIZE
or (SUBB.DESCRIPTIVE_SIZE is null and SUBT.DESCRIPTIVE_SIZE is not null)
or (SUBB.DESCRIPTIVE_SIZE is not null and SUBT.DESCRIPTIVE_SIZE is null)
or SUBB.FUNCTIONAL_NAME <> SUBT.FUNCTIONAL_NAME
or (SUBB.FUNCTIONAL_NAME is null and SUBT.FUNCTIONAL_NAME is not null)
or (SUBB.FUNCTIONAL_NAME is not null and SUBT.FUNCTIONAL_NAME is null)
or SUBB.TRADE_ITEM_FORM_DESCRIPTION <> SUBT.TRADE_ITEM_FORM_DESCRIPTION
or (SUBB.TRADE_ITEM_FORM_DESCRIPTION is null and SUBT.TRADE_ITEM_FORM_DESCRIPTION is not null)
or (SUBB.TRADE_ITEM_FORM_DESCRIPTION is not null and SUBT.TRADE_ITEM_FORM_DESCRIPTION is null)
or SUBB.WARRANTY_DESCRIPTION <> SUBT.WARRANTY_DESCRIPTION
or (SUBB.WARRANTY_DESCRIPTION is null and SUBT.WARRANTY_DESCRIPTION is not null)
or (SUBB.WARRANTY_DESCRIPTION is not null and SUBT.WARRANTY_DESCRIPTION is null)
or SUBB.TRADE_ITEM_FINISH_DESCRIPTION <> SUBT.TRADE_ITEM_FINISH_DESCRIPTION
or (SUBB.TRADE_ITEM_FINISH_DESCRIPTION is null and SUBT.TRADE_ITEM_FINISH_DESCRIPTION is not null)
or (SUBB.TRADE_ITEM_FINISH_DESCRIPTION is not null and SUBT.TRADE_ITEM_FINISH_DESCRIPTION is null)
or SUBB.DESCRIPTION_SHORT <> SUBT.DESCRIPTION_SHORT
or (SUBB.DESCRIPTION_SHORT is null and SUBT.DESCRIPTION_SHORT is not null)
or (SUBB.DESCRIPTION_SHORT is not null and SUBT.DESCRIPTION_SHORT is null)
));
insert into EGO_ITEM_GTN_ATTRS_TL (
REQUEST_ID,
EXTENSION_ID,
INVENTORY_ITEM_ID,
ORGANIZATION_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
ITEM_CATALOG_GROUP_ID,
REVISION_ID,
INVOICE_NAME,
DESCRIPTIVE_SIZE,
FUNCTIONAL_NAME,
TRADE_ITEM_FORM_DESCRIPTION,
WARRANTY_DESCRIPTION,
TRADE_ITEM_FINISH_DESCRIPTION,
DESCRIPTION_SHORT,
LANGUAGE,
SOURCE_LANG
) select /*+ ORDERED */
B.REQUEST_ID,
B.EXTENSION_ID,
B.INVENTORY_ITEM_ID,
B.ORGANIZATION_ID,
B.CREATED_BY,
B.CREATION_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_DATE,
B.LAST_UPDATE_LOGIN,
B.ITEM_CATALOG_GROUP_ID,
B.REVISION_ID,
B.INVOICE_NAME,
B.DESCRIPTIVE_SIZE,
B.FUNCTIONAL_NAME,
B.TRADE_ITEM_FORM_DESCRIPTION,
B.WARRANTY_DESCRIPTION,
B.TRADE_ITEM_FINISH_DESCRIPTION,
B.DESCRIPTION_SHORT,
L.LANGUAGE_CODE,
B.SOURCE_LANG
from EGO_ITEM_GTN_ATTRS_TL B, FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and B.LANGUAGE = userenv('LANG')
and not exists
(select NULL
from EGO_ITEM_GTN_ATTRS_TL T
where T.EXTENSION_ID = B.EXTENSION_ID
and T.LANGUAGE = L.LANGUAGE_CODE);