1 PACKAGE CS_WF_EVENT_PKG AUTHID CURRENT_USER AS
2 /* $Header: cswfevts.pls 120.1 2011/02/17 09:55:49 bkanimoz ship $ */
3
4 /******
5 TYPE link_rec IS RECORD (
6 INCIDENT_NUMBER VARCHAR2(64),
7 SUBJECT_ID NUMBER,
8 --LINK_TYPE VARCHAR2(90)
9 LINK_TYPE_ID NUMBER
10 );
11 ***/
12 G_CONTACTS_TABLE CS_SERVICEREQUEST_PVT.contacts_table;
13
14 FUNCTION CS_Custom_Rule_Func(p_subscription_guid in raw,
15 p_event in out nocopy WF_EVENT_T) RETURN varchar2;
16 --added by bkanimoz for 12.2 Auto Task projecy - Workflow enhancements for the
17 --Requirement - Launching a Workflow when SR status transition happens
18 FUNCTION CS_Custom_Rule_Func1(p_subscription_guid in raw,
19 p_event in out nocopy WF_EVENT_T) RETURN varchar2;
20
21
22 PROCEDURE Raise_ServiceRequest_Event(
23 p_api_version IN NUMBER,
24 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
25 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
26 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
27 p_Event_Code IN VARCHAR2,
28 p_Incident_Number IN VARCHAR2,
29 p_USER_ID IN NUMBER DEFAULT FND_GLOBAL.USER_ID, /** p_last_updated_by from Update_ServiceREquest() **/
30 p_RESP_ID IN NUMBER, /** p_resp_id from Update_ServiceREquest() **/
31 p_RESP_APPL_ID IN NUMBER, /** p_resp_appl_id from Update_ServiceREquest() **/
32 p_Old_SR_Rec IN CS_ServiceRequest_PVT.service_request_rec_type := NULL,
33 p_New_SR_Rec IN CS_ServiceRequest_PVT.service_request_rec_type := NULL,
34 p_Contacts_Table IN CS_ServiceRequest_PVT.contacts_table := G_CONTACTS_TABLE,
35 p_Link_Rec IN CS_INCIDENTLINKS_PVT.CS_INCIDENT_LINK_REC_TYPE := NULL,
36 p_wf_process_id IN NUMBER DEFAULT NULL,
37 p_owner_id IN NUMBER DEFAULT NULL, /** passed by CIC **/
38 p_wf_manual_launch IN VARCHAR2 DEFAULT 'N',
39 x_wf_process_id OUT NOCOPY NUMBER,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2);
43
44
45 END CS_WF_EVENT_PKG;