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:

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

    ReplyDelete
  2. A more extensive example is available here

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

    ReplyDelete
  3. ӏ 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

    ReplyDelete
  4. 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

    ReplyDelete
  5. 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

    ReplyDelete
  6. 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

    ReplyDelete