[Home] [Help]
1321: ** Added by Devendra - for updation of REGISTRATION_UPDATE_DATE and TP_NEUTRAL_UPDATE_DATE
1322: */
1323: PROCEDURE PROCESS_ATTRIBUTE_UPDATES (p_inventory_item_id NUMBER,
1324: p_organization_id NUMBER,
1325: p_attribute_names EGO_VARCHAR_TBL_TYPE,
1326: p_commit VARCHAR2 := FND_API.G_FALSE,
1327: x_return_status OUT NOCOPY VARCHAR2,
1328: x_msg_count OUT NOCOPY NUMBER,
1329: x_msg_data OUT NOCOPY VARCHAR2) AS
1381: l_min_trade_item_life_arr EGO_ITEM_CUST_ATTRS_B.MIN_TRADE_ITEM_LIFE_ARR%TYPE;
1382: l_order_quantity_min EGO_ITEM_CUST_ATTRS_B.ORDER_QUANTITY_MIN%TYPE;
1383: l_order_quantity_max EGO_ITEM_CUST_ATTRS_B.ORDER_QUANTITY_MAX%TYPE;
1384:
1385: l_reg_attr_list EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(Net_Content, Uom_Net_Content, Trade_Item_Descriptor, Brand_Name,
1386: Is_Trade_Item_A_Consumer_Unit, Customer_Order_Enabled_Flag,
1387: Unit_Weight, Unit_Height, Unit_Length, Unit_Width, Unit_Volume,
1388: Dimension_Uom_Code, Size_Code_Value, Size_Code_List_Agency,
1389: Effective_Date, Eanucc_Code, EANUCC_Type, Retail_Brand_Owner_Gln,
1391: Description_Short, Weight_Uom_Code, Gross_Weight, Uom_Gross_Weight,
1392: Volume_Uom_Code, Delivery_Method_Indicator, Canceled_Date, Discontinued_Date
1393: );
1394:
1395: l_core_tp_attr_list EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE
1396: ('Shelf_Life_Days', 'Start_Availability_Date_Time', 'End_Availability_Date_Time',
1397: 'Order_Quantity_Min', 'Order_Quantity_Max', 'Shippable_Item_Flag',
1398: 'Invoiceable_Item_Flag');
1399: CURSOR c_customers(c_gtin IN VARCHAR2) IS
1575: * is TP-Dependant or not.
1576: */
1577: PROCEDURE PROCESS_EXTN_ATTRIBUTE_UPDATES (p_inventory_item_id NUMBER,
1578: p_organization_id NUMBER,
1579: p_attribute_names EGO_VARCHAR_TBL_TYPE,
1580: p_attr_group_name VARCHAR2,
1581: p_commit VARCHAR2 := FND_API.G_FALSE,
1582: x_return_status OUT NOCOPY VARCHAR2,
1583: x_msg_count OUT NOCOPY NUMBER,
1792: l_volume_uom_code MTL_SYSTEM_ITEMS.VOLUME_UOM_CODE%TYPE := NULL; -- Bug: 3921782
1793: l_shelf_life_days MTL_SYSTEM_ITEMS.SHELF_LIFE_DAYS%TYPE := NULL; -- Bug: 5254856
1794: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
1795:
1796: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
1797:
1798: k BINARY_INTEGER := 0;
1799: l_return_status VARCHAR2(1);
1800: l_msg_text VARCHAR2(2000);
1816: FOR i IN c_upated_items LOOP
1817: write_debug_log('Item ID , Org ID = '||i.inventory_item_id||','||i.organization_id);
1818: l_error := FALSE;
1819: l_msib_upd_reqd := FALSE;
1820: l_attribute_names := EGO_VARCHAR_TBL_TYPE(null);
1821: k := 0;
1822: l_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();
1823: -- find whether updated item is an UCCnet enabled item or not
1824: BEGIN
2438:
2439: l_unit_weight MTL_SYSTEM_ITEMS.UNIT_WEIGHT%TYPE := NULL;
2440: l_weight_uom_code MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE%TYPE := NULL;
2441:
2442: l_msi_attr_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
2443: l_msi_attr_given BOOLEAN := FALSE;
2444: l_msi_index NUMBER;
2445:
2446: CURSOR c_user_attr_metadata IS
2462: l_pk_columns EGO_COL_NAME_VALUE_PAIR_ARRAY;
2463: l_class_code EGO_COL_NAME_VALUE_PAIR_ARRAY;
2464: l_item_catalog_group_id NUMBER;
2465: l_error_code NUMBER;
2466: l_attribute_names EGO_VARCHAR_TBL_TYPE;
2467: l_attr_new_values EGO_USER_ATTR_DATA_TABLE;
2468:
2469: --Cursor for creating the classification code
2470: CURSOR get_classification_code IS
2595:
2596: IF x_return_status = 'S' THEN
2597:
2598: -- build attr list and call process_attr_updates
2599: l_attribute_names := EGO_VARCHAR_TBL_TYPE(p_attr_name);
2600:
2601: write_debug_log(l_api_name||': calling Process_Attribute_Updates');
2602:
2603: Process_Attribute_Updates