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 );

3 comments:

Riki said...

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

Anonymous said...

topic07, [url=http://www.chop.edu/forum/user/profile/8207.page]klonopin no prescription[/url], :-) rss, http://www.chop.edu/forum/user/profile/8207.page buy klonopin ;-(, [url=http://www.chop.edu/forum/user/profile/8208.page]purchase xanax 2mg[/url], :-) vek, http://www.chop.edu/forum/user/profile/8208.page purchase xanax 2mg :-), [url=http://forum.cprs.ca/default.aspx?g=posts&m=6]order adipex online[/url], :-( jid, http://forum.cprs.ca/default.aspx?g=posts&m=6 order adipex ;-(, [url=http://forum.cprs.ca/default.aspx?g=posts&m=7]cheap alprazolam[/url], :-( and, http://forum.cprs.ca/default.aspx?g=posts&m=7 cheap alprazolam *sorry*, [url=http://forum.cprs.ca/default.aspx?g=posts&m=8]buy ambien without prescription[/url], :-( hnj, http://forum.cprs.ca/default.aspx?g=posts&m=8 order ambien no prescription :-)

Anonymous said...

A more extensive example is available here

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