1 PACKAGE IEU_SH_PVT AUTHID CURRENT_USER AS
2 /* $Header: IEUSHVS.pls 115.11 2003/07/28 22:28:58 parghosh ship $ */
3
4 /* Used to insert INTO IEU_SH_SESSIONS TABLE when begin session */
5
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,
15 P_EXTENSION IN VARCHAR2 DEFAULT NULL,
16 P_APPLICATION_ID IN NUMBER,
17 X_SESSION_ID OUT NOCOPY NUMBER,
18 X_MSG_COUNT OUT NOCOPY NUMBER,
19 X_MSG_DATA OUT NOCOPY VARCHAR2,
20 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
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,
30 X_MSG_DATA OUT NOCOPY VARCHAR2,
31 X_RETURN_STATUS 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,
41 P_BEGIN_TIME_FLAG IN NUMBER DEFAULT NULL,
42 P_MEDIA_TYPE_ID IN NUMBER DEFAULT NULL,
43 P_MEDIA_ID IN NUMBER DEFAULT NULL,
44 P_USER_ID IN NUMBER,
45 P_LOGIN_ID IN NUMBER DEFAULT NULL,
46 P_REASON_CODE IN VARCHAR2 DEFAULT NULL,
47 P_REQUEST_METHOD IN VARCHAR2 DEFAULT NULL,
48 P_REQUESTED_MEDIA_TYPE_ID IN NUMBER DEFAULT NULL,
49 P_WORK_ITEM_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
50 P_WORK_ITEM_PK_ID IN NUMBER DEFAULT NULL,
51 P_END_ACTIVITY_FLAG IN VARCHAR2 DEFAULT NULL,
52 P_PARENT_CYCLE_ID IN NUMBER DEFAULT NULL,
53 P_CATEGORY_TYPE IN VARCHAR2 DEFAULT NULL,
54 P_CATEGORY_VALUE IN VARCHAR2 DEFAULT NULL,
55 X_ACTIVITY_ID OUT NOCOPY NUMBER,
56 X_MSG_COUNT OUT NOCOPY NUMBER,
57 X_MSG_DATA OUT NOCOPY VARCHAR2,
58 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
59
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,
69 P_MEDIA_ID IN NUMBER DEFAULT NULL,
70 P_REASON_CODE IN VARCHAR2 DEFAULT NULL,
71 X_MSG_COUNT OUT NOCOPY NUMBER,
72 X_MSG_DATA OUT NOCOPY VARCHAR2,
73 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
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,
83 P_MEDIA_ID IN NUMBER DEFAULT NULL,
84 P_COMPLETION_CODE IN VARCHAR2 DEFAULT NULL,
85 X_MSG_COUNT OUT NOCOPY NUMBER,
86 X_MSG_DATA OUT NOCOPY VARCHAR2,
87 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
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,
97 P_ACTIVITY_TYPE_CODE IN VARCHAR2,
98 P_LAST_ACTIVITY_ID IN NUMBER DEFAULT NULL,
99 P_BEGIN_TIME_FLAG IN NUMBER DEFAULT NULL,
100 P_MEDIA_TYPE_ID IN NUMBER DEFAULT NULL,
101 P_MEDIA_ID IN NUMBER DEFAULT NULL,
102 P_USER_ID IN NUMBER,
103 P_LOGIN_ID IN NUMBER DEFAULT NULL,
104 -- P_PRV_REASON_CODE IN VARCHAR2 DEFAULT NULL
105 P_COMPLETION_CODE IN VARCHAR2 DEFAULT NULL,
106 P_REASON_CODE IN VARCHAR2 DEFAULT NULL,
107 P_REQUEST_METHOD IN VARCHAR2 DEFAULT NULL,
108 P_REQUESTED_MEDIA_TYPE_ID IN NUMBER DEFAULT NULL,
109 P_WORK_ITEM_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
110 P_WORK_ITEM_PK_ID IN NUMBER DEFAULT NULL,
111 P_END_ACTIVITY_FLAG IN VARCHAR2 DEFAULT NULL,
112 P_PARENT_CYCLE_ID IN NUMBER DEFAULT NULL,
113 P_CATEGORY_TYPE IN VARCHAR2 DEFAULT NULL,
114 P_CATEGORY_VALUE IN VARCHAR2 DEFAULT NULL,
115 X_ACTIVITY_ID OUT NOCOPY NUMBER,
116 X_MSG_COUNT OUT NOCOPY NUMBER,
117 X_MSG_DATA OUT NOCOPY VARCHAR2,
118 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
119
120 END IEU_SH_PVT;