6: g_pkg_name CONSTANT VARCHAR2(30) := 'IEU_SH_PVT';
7:
8: PROCEDURE UWQ_BEGIN_SESSION
9: ( P_API_VERSION IN NUMBER,
10: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
11: P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
12: P_RESOURCE_ID IN NUMBER,
13: P_USER_ID IN NUMBER,
14: P_LOGIN_ID IN NUMBER DEFAULT NULL,
7:
8: PROCEDURE UWQ_BEGIN_SESSION
9: ( P_API_VERSION IN NUMBER,
10: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
11: P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
12: P_RESOURCE_ID IN NUMBER,
13: P_USER_ID IN NUMBER,
14: P_LOGIN_ID IN NUMBER DEFAULT NULL,
15: P_EXTENSION IN VARCHAR2 DEFAULT NULL,
21:
22: /* Used to UPDATE IEU_SH_SESSIONS TABLE when END session */
23: PROCEDURE UWQ_END_SESSION
24: ( P_API_VERSION IN NUMBER,
25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
26: P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
27: P_SESSION_ID IN NUMBER,
28: P_END_REASON_CODE IN VARCHAR2 DEFAULT NULL,
29: X_MSG_COUNT OUT NOCOPY NUMBER,
22: /* Used to UPDATE IEU_SH_SESSIONS TABLE when END session */
23: PROCEDURE UWQ_END_SESSION
24: ( P_API_VERSION IN NUMBER,
25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
26: P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
27: P_SESSION_ID IN NUMBER,
28: P_END_REASON_CODE IN VARCHAR2 DEFAULT NULL,
29: X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2,
32:
33: /* Used to INSERT INTO IEU_SH_ACTIVITIES TABLE when BEGIN ACTIVITY */
34: PROCEDURE UWQ_BEGIN_ACTIVITY
35: ( P_API_VERSION IN NUMBER,
36: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
37: P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
38: P_SESSION_ID IN NUMBER,
39: P_ACTIVITY_TYPE_CODE IN VARCHAR2,
40: P_LAST_ACTIVITY_ID IN NUMBER DEFAULT NULL,
33: /* Used to INSERT INTO IEU_SH_ACTIVITIES TABLE when BEGIN ACTIVITY */
34: PROCEDURE UWQ_BEGIN_ACTIVITY
35: ( P_API_VERSION IN NUMBER,
36: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
37: P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
38: P_SESSION_ID IN NUMBER,
39: P_ACTIVITY_TYPE_CODE IN VARCHAR2,
40: P_LAST_ACTIVITY_ID IN NUMBER DEFAULT NULL,
41: P_BEGIN_TIME_FLAG IN NUMBER DEFAULT NULL,
60: /* Used to UPDATE IEU_SH_ACTIVITIES TABLE for an intermediate
61: state change. */
62: PROCEDURE UWQ_UPDATE_ACTIVITY
63: ( P_API_VERSION IN NUMBER,
64: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
65: P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
66: P_ACTIVITY_ID IN NUMBER,
67: P_INTERMEDIATE_STATE_CODE IN VARCHAR2 DEFAULT NULL,
68: P_MEDIA_TYPE_ID IN NUMBER DEFAULT NULL,
61: state change. */
62: PROCEDURE UWQ_UPDATE_ACTIVITY
63: ( P_API_VERSION IN NUMBER,
64: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
65: P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
66: P_ACTIVITY_ID IN NUMBER,
67: P_INTERMEDIATE_STATE_CODE IN VARCHAR2 DEFAULT NULL,
68: P_MEDIA_TYPE_ID IN NUMBER DEFAULT NULL,
69: P_MEDIA_ID IN NUMBER DEFAULT NULL,
74:
75: /* Used to UPDATE IEU_SH_ACTIVITIES TABLE when END ACTIVITY */
76: PROCEDURE UWQ_END_ACTIVITY
77: ( P_API_VERSION IN NUMBER,
78: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
79: P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
80: P_ACTIVITY_ID IN NUMBER,
81: P_LAST_ACTIVITY_ID IN NUMBER DEFAULT NULL,
82: P_MEDIA_TYPE_ID IN NUMBER DEFAULT NULL,
75: /* Used to UPDATE IEU_SH_ACTIVITIES TABLE when END ACTIVITY */
76: PROCEDURE UWQ_END_ACTIVITY
77: ( P_API_VERSION IN NUMBER,
78: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
79: P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
80: P_ACTIVITY_ID IN NUMBER,
81: P_LAST_ACTIVITY_ID IN NUMBER DEFAULT NULL,
82: P_MEDIA_TYPE_ID IN NUMBER DEFAULT NULL,
83: P_MEDIA_ID IN NUMBER DEFAULT NULL,
88:
89: /*Used to transition Break Reasons */
90: PROCEDURE UWQ_BREAK_TRANSITION
91: ( P_API_VERSION IN NUMBER,
92: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
93: P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
94: P_SESSION_ID IN NUMBER,
95: P_ACTIVITY_ID IN NUMBER,
96: -- P_ACTIVITY_TYPE_ID IN NUMBER,
89: /*Used to transition Break Reasons */
90: PROCEDURE UWQ_BREAK_TRANSITION
91: ( P_API_VERSION IN NUMBER,
92: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
93: P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
94: P_SESSION_ID IN NUMBER,
95: P_ACTIVITY_ID IN NUMBER,
96: -- P_ACTIVITY_TYPE_ID IN NUMBER,
97: P_ACTIVITY_TYPE_CODE IN VARCHAR2,