Oracle EBS 创建物资分类

declare
  l_Item_Tbl_Typ  EGO_Item_PUB.Item_Tbl_Type;
  x_Item_Table    EGO_Item_PUB.Item_Tbl_Type;
  x_Return_Status VARCHAR2(240);
  x_Msg_Count     NUMBER;
  X_MSG           VARCHAR2(240);
begin
  l_Item_Tbl_Typ(1).Transaction_Type := 'CREATE';
  l_Item_Tbl_Typ(1).Item_Number := 'LS00000001';
  l_Item_Tbl_Typ(1).Segment1 := 'LS00000001';
  l_Item_Tbl_Typ(1).Item_Catalog_Group_Id := 10002;
  l_Item_Tbl_Typ(1).Description := '函数生成';
  l_Item_Tbl_Typ(1).Primary_Uom_Code := '件';
  l_Item_Tbl_Typ(1).Organization_Id := 82;
  l_Item_Tbl_Typ(1).Organization_Code := 'WL';
  l_Item_Tbl_Typ(1).Language_Code := 'ZHS';
  l_Item_Tbl_Typ(1).INVENTORY_ITEM_STATUS_CODE := 'Active';

  Dbms_Output.Put_Line('Ego_Item_Pub.Process_Items API call start ' ||
                       To_Char(SYSDATE, 'DD-MON-RRRR HH24:MI:SS'));
  Ego_Item_Pub.Process_Items(p_Api_Version   => 1.0,
                             p_Init_Msg_List => Fnd_Api.g_True,
                             p_Commit        => Fnd_Api.g_True,
                             p_Item_Tbl      => l_Item_Tbl_Typ,
                             x_Item_Tbl      => x_Item_Table,
                             x_Return_Status => x_Return_Status,
                             x_Msg_Count     => x_Msg_Count);
  Dbms_Output.Put_Line('Ego_Item_Pub.Process_Items API call end ' ||
                       To_Char(SYSDATE, 'DD-MON-RRRR HH24:MI:SS'));
  Dbms_Output.Put_Line('Return status ' || x_Return_Status);
  DBMS_OUTPUT.put_line('x_Msg_Count ' || x_Msg_Count);
  X_MSG := fnd_msg_pub.get(p_msg_index => 0, p_encoded => 'F');
  dbms_output.put_line('MSG : ' || X_MSG);
end;
declare
  x_return_status varchar2(240);
  x_errorcode     number;
  x_msg_count     number;
  x_msg_data      varchar2(240);
begin
  INV_ITEM_CATEGORY_PUB.Create_Category_Assignment(p_api_version       => 1.0,
                                                   p_init_msg_list     => FND_API.G_FALSE,
                                                   p_commit            => FND_API.G_FALSE,
                                                   x_return_status     => x_return_status,
                                                   x_errorcode         => x_errorcode,
                                                   x_msg_count         => x_msg_count,
                                                   x_msg_data          => x_msg_data,
                                                   p_category_id       => 6783,
                                                   p_category_set_id   => 1,
                                                   p_inventory_item_id => 3414258,
                                                   p_organization_id   => 82);
  dbms_output.put_line(' x_return_status ' || x_return_status);
  dbms_output.put_line(' x_msg_data ' || x_msg_data);
end;
DECLARE 
  l_api_version                 NUMBER := 1;
  l_object_name                 VARCHAR2(20) := 'EGO_ITEM_REVISION'; --EGO_ITEM_REVISION  -- ITEM_REVISION_LEVEL
  l_attributes_row_table        EGO_USER_ATTR_ROW_TABLE := EGO_USER_ATTR_ROW_TABLE();
  l_attributes_data_table       EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
  l_pk_column_name_value_pairs  EGO_COL_NAME_VALUE_PAIR_ARRAY := EGO_COL_NAME_VALUE_PAIR_ARRAY();
  l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := EGO_COL_NAME_VALUE_PAIR_ARRAY();
  l_user_privileges_on_object   EGO_VARCHAR_TBL_TYPE := NULL;
  l_entity_id                   NUMBER := NULL;
  l_entity_index                NUMBER := NULL;
  l_entity_code                 VARCHAR2(1) := NULL;
  l_debug_level                 NUMBER := 3;
  l_init_error_handler          VARCHAR2(1) := FND_API.G_TRUE;
  l_write_to_concurrent_log     VARCHAR2(1) := FND_API.G_TRUE;
  l_init_fnd_msg_list           VARCHAR2(1) := FND_API.G_TRUE;
  l_log_errors                  VARCHAR2(1) := FND_API.G_TRUE;
  l_add_errors_to_fnd_stack     VARCHAR2(1) := FND_API.G_FALSE;
  l_commit                      VARCHAR2(1) := FND_API.G_FALSE; -- Do NOT set to TRUE, Verify the data and then COMMIT !
  x_failed_row_id_list          VARCHAR2(255);
  x_return_status               VARCHAR2(10);
  x_errorcode