Custom Web Service for multiple records

Summary

Custom Web Service for multiple records

Content

Hi Experts,

I am able to develop and deploy a web service which when we pass inventory item id give me one record details of that inventory item id in EBS R12.1.3.

Now My requirement is when i pass LAST_UPDATE_DATE it should give me all the items later than that last update date. I will use this web service in OIC to get EBS Items and POST in Engagement Cloud adapter.

Regards,

Zahid Rahim

 

 

Version

EBS R12.1.3

Code Snippet

FUNCTION getItemDetails(pLastUpdateDate DATE)
RETURN     invTabTyp
IS
    CURSOR c IS
        SELECT description
        from mtl_system_items msi   
        WHERE trunc(last_update_date) > pLastUpdateDate; 
        
        vInvTable invTabTyp;
        
        vIndex NUMBER := 1;
    

    BEGIN