Monday, June 18, 2007

Calling cs_servicerequest_pvt API for create service request

Calling cs_servicerequest_pvt API for create service request in Oracle 11i.

cs_servicerequest_pvt.Create_ServiceRequest(
        P_API_VERSION           => 3.0,
        P_INIT_MSG_LIST         => FND_API.G_TRUE,
        P_COMMIT                => FND_API.G_FALSE,
        P_VALIDATION_LEVEL      => fnd_api.g_valid_level_full ,
        X_RETURN_STATUS         => out_status,
        X_MSG_COUNT             => x_msg_count,
        X_MSG_DATA              => out_message,
        P_RESP_APPL_ID          => NULL,
        P_ORG_ID                => NULL,
        P_REQUEST_NUMBER       =>  in_request_number,
        P_SERVICE_REQUEST_REC   => m_sr_rec,
        P_NOTES                 => m_notes_tbl,
        P_CONTACTS              => m_contacts_tbl,
        P_USER_ID               => m_user_id,
        P_RESP_ID               => in_respId ,
        X_REQUEST_ID            => x_sr_id,
        P_AUTO_ASSIGN           => in_autoassign,
        X_REQUEST_NUMBER        => out_sr_number,
        X_INTERACTION_ID        => x_inter_id,
        X_WORKFLOW_PROCESS_ID   => x_workflow_id,
        X_INDIVIDUAL_OWNER      =>P_INDIVIDUAL_OWNER,
        X_GROUP_OWNER           =>P_GROUP_OWNER,
        X_INDIVIDUAL_TYPE       =>P_INDIVIDUAL_TYPE );

8 comments:

Riki said...

Hey can I get full code instead of the calling statement at oracleebz@gmail.com

Anonymous said...

A more extensive example is available here

http://oracleappsnotes.wordpress.com/2011/04/22/sample-code-for-service-request-and-task-apis/

Anonymous said...

ӏ like the valuable information you pгovide in
your artіcles. I'll bookmark your blog and check again here regularly. I'm quіte
cеrtain I will lеarn many new stuff right herе!
Best of luck for the neхt!

Here is my wеbpаge quick loans
Also see my web page > quick loans

Anonymous said...

Hello there. I was contemplating adding a website link back to your site since both of our sites
are primarily based around the same niche. Would you prefer I link to you using your
website address: http://www.blogger.com/comment.
g?blogID=4365662739166968864&postID=2963511126878866424 or web site title:
Blogger: Oracle CRM Blog. Please let me know at your earliest convenience.
Many thanks

Also visit my web blog :: parkour games

Anonymous said...

Wоah! Ι'm really loving the template/theme of this site. It's simple, yet effective.

A lоt of times it's very hard to get that "perfect balance" between superb usability and appearance. I must say you have done a awesome job with this. In addition, the blog loads very fast for me on Chrome. Exceptional Blog!

my site Payday Loans

Anonymous said...

We aгe a grοup of volunteers and opening a nеw scheme in
ouг communitу. Youг site provideԁ us ωith valuable іnfo to work on.

You've done a formidable job and our whole community will be thankful to you.

My web blog - payday loans

Unknown said...

It was very interesting for me to succeed and win

گوشی iphone X و ورود آن به هند و پایان انتظار
گوشی هوشمند iPhone X و انتشار آن
برنامه‌های دوستیابی و بررسی خطرات آن

sapna vyas said...

interesting post nice sharing
simple mehndi designs