3604: AND eiuai.ORGANIZATION_ID = c_organization_id;
3605:
3606: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
3607: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;
3608: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3609: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3610: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3611: l_return_status VARCHAR2(10);
3612: l_msg_count NUMBER;
3605:
3606: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
3607: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;
3608: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3609: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3610: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3611: l_return_status VARCHAR2(10);
3612: l_msg_count NUMBER;
3613: l_msg_data VARCHAR2(4000);
3606: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
3607: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;
3608: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3609: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3610: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3611: l_return_status VARCHAR2(10);
3612: l_msg_count NUMBER;
3613: l_msg_data VARCHAR2(4000);
3614: BEGIN
3667: END IF; -- end IF l_attribute_names.COUN
3668:
3669: IF l_attr_diffs.COUNT > 0 THEN
3670: Debug_Msg('Calling EGO_GTIN_PVT.Item_Propagate_Attributes');
3671: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3672: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(i.INVENTORY_ITEM_ID))
3673: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(i.ORGANIZATION_ID))
3674: );
3675:
3672: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(i.INVENTORY_ITEM_ID))
3673: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(i.ORGANIZATION_ID))
3674: );
3675:
3676: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3677: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(i.ITEM_CATALOG_GROUP_ID)));
3678:
3679: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', NULL));
3680:
3675:
3676: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3677: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(i.ITEM_CATALOG_GROUP_ID)));
3678:
3679: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', NULL));
3680:
3681: l_msg_data := NULL;
3682: EGO_GTIN_PVT.Item_Propagate_Attributes
3683: ( p_pk_column_name_value_pairs => l_pk_column_name_value_pairs
3750:
3751: /*
3752: */
3753: PROCEDURE Process_Multi_Row_AG(p_attr_group_name VARCHAR2,
3754: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3755: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3756: p_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3757: p_extension_id NUMBER,
3758: p_transaction_type VARCHAR2,
3751: /*
3752: */
3753: PROCEDURE Process_Multi_Row_AG(p_attr_group_name VARCHAR2,
3754: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3755: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3756: p_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3757: p_extension_id NUMBER,
3758: p_transaction_type VARCHAR2,
3759: p_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE,
3752: */
3753: PROCEDURE Process_Multi_Row_AG(p_attr_group_name VARCHAR2,
3754: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3755: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3756: p_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3757: p_extension_id NUMBER,
3758: p_transaction_type VARCHAR2,
3759: p_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE,
3760: x_return_status OUT NOCOPY VARCHAR2,
3889: l_new_row BOOLEAN;
3890: l_row_identifier NUMBER;
3891: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
3892: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
3893: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3894: l_cc_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3895: l_dl_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3896: l_category_id NUMBER;
3897:
3890: l_row_identifier NUMBER;
3891: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
3892: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
3893: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3894: l_cc_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3895: l_dl_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3896: l_category_id NUMBER;
3897:
3898: TYPE t_col_list_type IS TABLE OF NUMBER INDEX BY VARCHAR2(100);
3891: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
3892: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
3893: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3894: l_cc_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3895: l_dl_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3896: l_category_id NUMBER;
3897:
3898: TYPE t_col_list_type IS TABLE OF NUMBER INDEX BY VARCHAR2(100);
3899: l_multi_row_cols t_col_list_type;
4033: FROM MTL_SYSTEM_ITEMS_B
4034: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
4035: AND ORGANIZATION_ID = p_organization_id;
4036:
4037: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY( EGO_COL_NAME_VALUE_PAIR_OBJ( 'INVENTORY_ITEM_ID' , TO_CHAR(p_inventory_item_id))
4038: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'ORGANIZATION_ID' , TO_CHAR(p_organization_id) ) );
4039:
4040: -- Bug: 5523366
4041: EGO_ITEM_PVT.Get_Related_Class_Codes(
4041: EGO_ITEM_PVT.Get_Related_Class_Codes(
4042: p_classification_code => l_category_id
4043: , x_related_class_codes_list => l_related_class_codes_list );
4044:
4045: l_cc_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
4046: EGO_COL_NAME_VALUE_PAIR_OBJ( 'ITEM_CATALOG_GROUP_ID' , TO_CHAR(l_category_id) )
4047: , EGO_COL_NAME_VALUE_PAIR_OBJ( 'RELATED_CLASS_CODE_LIST_1' , l_related_class_codes_list ));
4048:
4049: l_dl_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , NULL));
4045: l_cc_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
4046: EGO_COL_NAME_VALUE_PAIR_OBJ( 'ITEM_CATALOG_GROUP_ID' , TO_CHAR(l_category_id) )
4047: , EGO_COL_NAME_VALUE_PAIR_OBJ( 'RELATED_CLASS_CODE_LIST_1' , l_related_class_codes_list ));
4048:
4049: l_dl_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , NULL));
4050:
4051: Debug_Msg('Checking the Trade Item Descriptor');
4052: BEGIN
4053: SELECT TRADE_ITEM_DESCRIPTOR INTO l_trade_item_desc