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,
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,
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,
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,
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,
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,
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,
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,
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,
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,