Error in PL SQL for API assign Item
Dear All,
Please Help. I am newbie in PL/SQL and want to create procedure to assign Item in oracle , and when I want to create Procedure the error appear. Please help to check when did I do wrong.
Thanks in Advance.
Create or replace procedure XXCUST.Item_Asignment
IS
CURSOR asign_item
IS
SELECT inventory_item_id,segment1, organization_id, assign
FROM xxcust.xxcust_item_assignment
WHERE assign = 'N'
order by segment1;
p_from_organization_id Number(3) := 101; -- Source organization id
p_organization_id number(3):=146; -- To be assigned
l_api_version NUMBER:= 1.0;
l_init_msg_list VARCHAR2(2) := FND_API.G_TRUE;