Oracle Item creation API & Child Org Assignment
Declare -- 1. Use the standard Oracle API collection types l_item_tbl EGO_ITEM_PUB.Item_Tbl_Type; x_item_tbl EGO_ITEM_PUB.Item_Tbl_Type; l_error_tbl Error_Handler.Error_Tbl_Type; --l_item_rec EGO_ITEM_PUB.Item_Rec_Type; -- Standard API tracking variables x_return_status VARCHAR2(1); x_msg_count NUMBER; TYPE l_input_stg is TABLE OF XXKT_ALT_ITEMINFO_STG%rowtype; l_input_stg_row l_input_stg:=l_input_stg(); l_error_msg VARCHAR2(4000); l_idx NUMBER := 0; -- Counter for loop init...