[Home] [Help]
PACKAGE BODY: APPS.IEU_SH_PUB
Source
1 PACKAGE BODY IEU_SH_PUB AS
2 /* $Header: IEUPSHB.pls 120.0 2005/06/02 15:49:02 appldev noship $ */
3 PROCEDURE UWQ_BEGIN_SESSION
4 ( P_API_VERSION IN NUMBER,
5 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
6 P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
7 P_RESOURCE_ID IN NUMBER,
8 P_USER_ID IN NUMBER,
9 P_LOGIN_ID IN NUMBER,
10 P_EXTENSION IN VARCHAR2 DEFAULT NULL,
11 P_APPLICATION_ID IN NUMBER,
12 X_SESSION_ID OUT NOCOPY NUMBER,
13 X_MSG_COUNT OUT NOCOPY NUMBER,
14 X_MSG_DATA OUT NOCOPY VARCHAR2,
15 X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
16
17 --
18 BEGIN
19
20 IEU_SH_PVT.UWQ_BEGIN_SESSION
21 ( P_API_VERSION,
22 P_INIT_MSG_LIST,
23 P_COMMIT,
24 P_RESOURCE_ID,
25 P_USER_ID,
26 P_LOGIN_ID,
27 P_EXTENSION,
28 P_APPLICATION_ID,
29 X_SESSION_ID,
30 X_MSG_COUNT,
31 X_MSG_DATA,
32 X_RETURN_STATUS);
33
34
35 END UWQ_BEGIN_SESSION;
36
37 PROCEDURE UWQ_END_SESSION
38 ( P_API_VERSION IN NUMBER,
39 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
40 P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
41 P_SESSION_ID IN NUMBER,
42 P_END_REASON_CODE IN VARCHAR2 DEFAULT NULL,
43 X_MSG_COUNT OUT NOCOPY NUMBER,
44 X_MSG_DATA OUT NOCOPY VARCHAR2,
45 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ) IS
46
47 BEGIN
48
49 IEU_SH_PVT.UWQ_END_SESSION
50 ( P_API_VERSION,
51 P_INIT_MSG_LIST,
52 P_COMMIT,
53 P_SESSION_ID,
54 P_END_REASON_CODE,
55 X_MSG_COUNT,
56 X_MSG_DATA,
57 X_RETURN_STATUS);
58
59 END UWQ_END_SESSION;
60
61 PROCEDURE UWQ_BEGIN_ACTIVITY
62 ( P_API_VERSION IN NUMBER,
63 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
64 P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
65 P_SESSION_ID IN NUMBER,
66 -- P_ACTIVITY_TYPE_ID IN NUMBER,
67 P_ACTIVITY_TYPE_CODE IN VARCHAR2,
68 P_MEDIA_TYPE_ID IN NUMBER DEFAULT NULL,
69 P_MEDIA_ID IN NUMBER DEFAULT NULL,
70 P_USER_ID IN NUMBER,
71 P_LOGIN_ID IN NUMBER,
72 P_REASON_CODE IN VARCHAR2 DEFAULT NULL,
73 P_REQUEST_METHOD IN VARCHAR2 DEFAULT NULL,
74 P_REQUESTED_MEDIA_TYPE_ID IN NUMBER DEFAULT NULL,
75 P_WORK_ITEM_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
76 P_WORK_ITEM_PK_ID IN NUMBER DEFAULT NULL,
77 P_END_ACTIVITY_FLAG IN VARCHAR2 DEFAULT NULL,
78 X_ACTIVITY_ID OUT NOCOPY NUMBER,
79 X_MSG_COUNT OUT NOCOPY NUMBER,
80 X_MSG_DATA OUT NOCOPY VARCHAR2,
81 X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
82
83 BEGIN
84
85
86 IEU_SH_PVT.UWQ_BEGIN_ACTIVITY
87 ( P_API_VERSION => P_API_VERSION,
88 P_INIT_MSG_LIST => P_INIT_MSG_LIST ,
89 P_COMMIT => P_COMMIT ,
90 P_SESSION_ID => P_SESSION_ID ,
91 -- P_ACTIVITY_TYPE_ID => ,
92 P_ACTIVITY_TYPE_CODE => P_ACTIVITY_TYPE_CODE ,
93 P_MEDIA_TYPE_ID => P_MEDIA_TYPE_ID ,
94 P_MEDIA_ID => P_MEDIA_ID ,
95 P_USER_ID => P_USER_ID ,
96 P_LOGIN_ID => P_LOGIN_ID ,
97 P_REASON_CODE => P_REASON_CODE ,
98 P_REQUEST_METHOD => P_REQUEST_METHOD ,
99 P_REQUESTED_MEDIA_TYPE_ID => P_REQUESTED_MEDIA_TYPE_ID ,
100 P_WORK_ITEM_TYPE_CODE => P_WORK_ITEM_TYPE_CODE ,
101 P_WORK_ITEM_PK_ID => P_WORK_ITEM_PK_ID ,
102 P_END_ACTIVITY_FLAG => P_END_ACTIVITY_FLAG ,
103 X_ACTIVITY_ID => X_ACTIVITY_ID ,
104 X_MSG_COUNT => X_MSG_COUNT ,
105 X_MSG_DATA => X_MSG_DATA ,
106 X_RETURN_STATUS => X_RETURN_STATUS );
107
108
109 END UWQ_BEGIN_ACTIVITY;
110
111
112 PROCEDURE UWQ_UPDATE_ACTIVITY
113 ( P_API_VERSION IN NUMBER,
114 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
115 P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
116 P_ACTIVITY_ID IN NUMBER,
117 P_INTERMEDIATE_STATE_CODE IN VARCHAR2 DEFAULT NULL,
118 P_MEDIA_TYPE_ID IN NUMBER DEFAULT NULL,
119 P_MEDIA_ID IN NUMBER DEFAULT NULL,
120 P_REASON_CODE IN VARCHAR2 DEFAULT NULL,
121 X_MSG_COUNT OUT NOCOPY NUMBER,
122 X_MSG_DATA OUT NOCOPY VARCHAR2,
123 X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
124
125 BEGIN
126
127
128 IEU_SH_PVT.UWQ_UPDATE_ACTIVITY
129 ( P_API_VERSION,
130 P_INIT_MSG_LIST,
131 P_COMMIT,
132 P_ACTIVITY_ID,
133 P_INTERMEDIATE_STATE_CODE,
134 P_MEDIA_TYPE_ID,
135 P_MEDIA_ID,
136 P_REASON_CODE,
137 X_MSG_COUNT,
138 X_MSG_DATA,
139 X_RETURN_STATUS);
140
141
142 END UWQ_UPDATE_ACTIVITY;
143
144
145 PROCEDURE UWQ_END_ACTIVITY
146 ( P_API_VERSION IN NUMBER,
147 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
148 P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
149 P_ACTIVITY_ID IN NUMBER,
150 P_MEDIA_TYPE_ID IN NUMBER DEFAULT NULL,
151 P_MEDIA_ID IN NUMBER DEFAULT NULL,
152 P_COMPLETION_CODE IN VARCHAR2 DEFAULT NULL,
153 X_MSG_COUNT OUT NOCOPY NUMBER,
154 X_MSG_DATA OUT NOCOPY VARCHAR2,
155 X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
156
157 BEGIN
158
159
160 IEU_SH_PVT.UWQ_END_ACTIVITY
161 ( P_API_VERSION => P_API_VERSION,
162 P_INIT_MSG_LIST => P_INIT_MSG_LIST,
163 P_COMMIT => P_COMMIT,
164 P_ACTIVITY_ID => P_ACTIVITY_ID,
165 P_MEDIA_TYPE_ID => P_MEDIA_TYPE_ID,
166 P_MEDIA_ID => P_MEDIA_ID,
167 P_COMPLETION_CODE => P_COMPLETION_CODE,
168 X_MSG_COUNT => X_MSG_COUNT,
169 X_MSG_DATA => X_MSG_DATA,
170 X_RETURN_STATUS => X_RETURN_STATUS);
171
172
173 END UWQ_END_ACTIVITY;
174
175 END IEU_SH_PUB;