[Home] [Help]
PACKAGE: APPS.CS_SR_WORKITEM_PVT
Source
1 PACKAGE CS_SR_WORKITEM_PVT AS
2 /* $Header: csvsrwis.pls 120.1 2006/01/10 12:51:59 spusegao noship $ */
3
4
5 /******************************************************
6 Create_Workitem() -
7 ******************************************************/
8
9 PROCEDURE Create_Workitem(
10 p_api_version IN NUMBER,
11 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
12 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
13 p_incident_id IN NUMBER,
14 p_incident_number IN VARCHAR2,
15 p_sr_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
16 p_user_id IN NUMBER, -- Required
17 p_resp_appl_id IN NUMBER, -- Required
18 p_login_id IN NUMBER DEFAULT NULL,
19 x_work_item_id OUT NOCOPY NUMBER,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2);
23
24
25 /******************************************************
26 Update_Workitem() -
27 ******************************************************/
28
29 PROCEDURE Update_Workitem(
30 p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
32 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
33 p_incident_id IN NUMBER,
34 p_old_sr_rec IN CS_ServiceRequest_PVT.sr_oldvalues_rec_type,
35 p_new_sr_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
36 p_user_id IN NUMBER, -- Required
37 p_resp_appl_id IN NUMBER, -- Required
38 p_login_id IN NUMBER DEFAULT NULL,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2);
42
43
44 /******************************************************
45 FUNCTION Is_Value_Changed()
46 ******************************************************/
47
48 FUNCTION Is_Value_Changed(
49 p_old_val IN VARCHAR2,
50 p_new_val IN VARCHAR2) RETURN BOOLEAN;
51
52 /******************************************************
53 FUNCTION Is_Value_Changed()
54 ******************************************************/
55
56 FUNCTION Is_Value_Changed(
57 p_old_val IN NUMBER,
58 p_new_val IN NUMBER) RETURN BOOLEAN;
59
60 /******************************************************
61 FUNCTION Is_Value_Changed()
62 ******************************************************/
63
64 FUNCTION Is_Value_Changed(
65 p_old_val IN DATE,
66 p_new_val IN DATE) RETURN BOOLEAN;
67
68 /******************************************************
69 Procedure Apply_Priority_Rule
70 ******************************************************/
71
72 PROCEDURE Apply_Priority_Rule
73 (P_New_Inc_Responded_By_Date IN DATE,
74 P_New_Obligation_Date IN DATE,
75 P_New_Exp_Resolution_Date IN DATE,
76 P_New_Severity_Id IN NUMBER,
77 P_Old_Inc_Responded_By_Date IN DATE,
78 P_Old_Obligation_Date IN DATE,
79 P_Old_Exp_Resolution_Date IN DATE,
80 P_Old_Severity_Id IN NUMBER,
81 P_Operation_mode IN VARCHAR2,
82 X_Change_WI_Flag OUT NOCOPY VARCHAR2,
83 X_Due_Date OUT NOCOPY DATE,
84 X_Priority_Code OUT NOCOPY VARCHAR2,
85 X_Return_Status OUT NOCOPY VARCHAR2,
86 X_Msg_Count OUT NOCOPY NUMBER,
87 X_Msg_Data OUT NOCOPY VARCHAR2);
88
89 END CS_SR_WORKITEM_PVT;