PL/SQL (MOSC)

MOSC Banner

Error in PL SQL for API assign Item

edited Apr 3, 2014 12:00PM in PL/SQL (MOSC) 1 commentAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center