1 package IEU_UWQM_AUDIT_LOG_PKG AUTHID CURRENT_USER as
2 /* $Header: IEUVUALS.pls 120.0 2005/06/02 16:00:40 appldev noship $ */
3 procedure INSERT_ROW (
4 P_ACTION_KEY IN VARCHAR2,
5 P_EVENT_KEY IN VARCHAR2,
6 P_MODULE IN VARCHAR2,
7 P_WS_CODE IN VARCHAR2,
8 P_APPLICATION_ID IN VARCHAR2,
9 P_WORKITEM_PK_ID IN VARCHAR2,
10 P_WORKITEM_OBJ_CODE IN VARCHAR2,
11 P_WORK_ITEM_STATUS_PREV IN VARCHAR2,
12 P_WORK_ITEM_STATUS_CURR IN VARCHAR2,
13 P_OWNER_ID_PREV IN NUMBER,
14 P_OWNER_ID_CURR IN NUMBER,
15 P_OWNER_TYPE_PREV IN VARCHAR2,
16 P_OWNER_TYPE_CURR IN VARCHAR2,
17 P_ASSIGNEE_ID_PREV IN NUMBER,
18 P_ASSIGNEE_ID_CURR IN NUMBER,
19 P_ASSIGNEE_TYPE_PREV IN VARCHAR2,
20 P_ASSIGNEE_TYPE_CURR IN VARCHAR2,
21 P_SOURCE_OBJECT_ID_PREV IN NUMBER,
22 P_SOURCE_OBJECT_ID_CURR IN NUMBER,
23 P_SOURCE_OBJECT_TYPE_CODE_PREV IN VARCHAR2,
24 P_SOURCE_OBJECT_TYPE_CODE_CURR IN VARCHAR2,
25 P_PARENT_WORKITEM_STATUS_PREV IN VARCHAR2,
26 P_PARENT_WORKITEM_STATUS_CURR IN VARCHAR2,
27 P_PARENT_DIST_STATUS_PREV IN VARCHAR2,
28 P_PARENT_DIST_STATUS_CURR IN VARCHAR2,
29 P_WORKITEM_DIST_STATUS_PREV IN VARCHAR2,
30 P_WORKITEM_DIST_STATUS_CURR IN VARCHAR2,
31 P_PRIORITY_PREV IN VARCHAR2,
32 P_PRIORITY_CURR IN VARCHAR2,
33 P_DUE_DATE_PREV IN DATE,
34 P_DUE_DATE_CURR IN DATE,
35 P_RESCHEDULE_TIME_PREV IN DATE,
36 P_RESCHEDULE_TIME_CURR IN DATE,
37 P_IEU_COMMENT_CODE1 IN VARCHAR2,
38 P_IEU_COMMENT_CODE2 IN VARCHAR2,
39 P_IEU_COMMENT_CODE3 IN VARCHAR2,
40 P_IEU_COMMENT_CODE4 IN VARCHAR2,
41 P_IEU_COMMENT_CODE5 IN VARCHAR2,
42 P_WORKITEM_COMMENT_CODE1 IN VARCHAR2,
43 P_WORKITEM_COMMENT_CODE2 IN VARCHAR2,
44 P_WORKITEM_COMMENT_CODE3 IN VARCHAR2,
45 P_WORKITEM_COMMENT_CODE4 IN VARCHAR2,
46 P_WORKITEM_COMMENT_CODE5 IN VARCHAR2,
47 P_STATUS IN VARCHAR2,
48 P_ERROR_CODE IN VARCHAR2,
49 X_AUDIT_LOG_ID OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2
52 );
53
54 procedure UPDATE_ROW (
55 P_AUDIT_LOG_ID IN NUMBER,
56 P_ACTION_KEY IN VARCHAR2,
57 P_EVENT_KEY IN VARCHAR2,
58 P_MODULE IN VARCHAR2,
59 P_WS_CODE IN VARCHAR2,
60 P_APPLICATION_ID IN VARCHAR2,
61 P_WORKITEM_PK_ID IN VARCHAR2,
62 P_WORKITEM_OBJ_CODE IN VARCHAR2,
63 P_WORK_ITEM_STATUS_PREV IN VARCHAR2,
64 P_WORK_ITEM_STATUS_CURR IN VARCHAR2,
65 P_OWNER_ID_PREV IN NUMBER,
66 P_OWNER_ID_CURR IN NUMBER,
67 P_OWNER_TYPE_PREV IN VARCHAR2,
68 P_OWNER_TYPE_CURR IN VARCHAR2,
69 P_ASSIGNEE_ID_PREV IN NUMBER,
70 P_ASSIGNEE_ID_CURR IN NUMBER,
71 P_ASSIGNEE_TYPE_PREV IN VARCHAR2,
72 P_ASSIGNEE_TYPE_CURR IN VARCHAR2,
73 P_SOURCE_OBJECT_ID_PREV IN NUMBER,
74 P_SOURCE_OBJECT_ID_CURR IN NUMBER,
75 P_SOURCE_OBJECT_TYPE_CODE_PREV IN VARCHAR2,
76 P_SOURCE_OBJECT_TYPE_CODE_CURR IN VARCHAR2,
77 P_PARENT_WORKITEM_STATUS_PREV IN VARCHAR2,
78 P_PARENT_WORKITEM_STATUS_CURR IN VARCHAR2,
79 P_PARENT_DIST_STATUS_PREV IN VARCHAR2,
80 P_PARENT_DIST_STATUS_CURR IN VARCHAR2,
81 P_WORKITEM_DIST_STATUS_PREV IN VARCHAR2,
82 P_WORKITEM_DIST_STATUS_CURR IN VARCHAR2,
83 P_PRIORITY_PREV IN VARCHAR2,
84 P_PRIORITY_CURR IN VARCHAR2,
85 P_DUE_DATE_PREV IN DATE,
86 P_DUE_DATE_CURR IN DATE,
87 P_RESCHEDULE_TIME_PREV IN DATE,
88 P_RESCHEDULE_TIME_CURR IN DATE,
89 P_IEU_COMMENT_CODE1 IN VARCHAR2,
90 P_IEU_COMMENT_CODE2 IN VARCHAR2,
91 P_IEU_COMMENT_CODE3 IN VARCHAR2,
92 P_IEU_COMMENT_CODE4 IN VARCHAR2,
93 P_IEU_COMMENT_CODE5 IN VARCHAR2,
94 P_WORKITEM_COMMENT_CODE1 IN VARCHAR2,
95 P_WORKITEM_COMMENT_CODE2 IN VARCHAR2,
96 P_WORKITEM_COMMENT_CODE3 IN VARCHAR2,
97 P_WORKITEM_COMMENT_CODE4 IN VARCHAR2,
98 P_WORKITEM_COMMENT_CODE5 IN VARCHAR2,
99 P_STATUS IN VARCHAR2,
100 P_ERROR_CODE IN VARCHAR2
101 );
102
103 PROCEDURE LOAD_ROW (
104 P_AUDIT_LOG_ID IN NUMBER,
105 P_ACTION_KEY IN VARCHAR2,
106 P_EVENT_KEY IN VARCHAR2,
107 P_MODULE IN VARCHAR2,
108 P_WS_CODE IN VARCHAR2,
109 P_APPLICATION_ID IN VARCHAR2,
110 P_WORKITEM_PK_ID IN VARCHAR2,
111 P_WORKITEM_OBJ_CODE IN VARCHAR2,
112 P_WORK_ITEM_STATUS_PREV IN VARCHAR2,
113 P_WORK_ITEM_STATUS_CURR IN VARCHAR2,
114 P_OWNER_ID_PREV IN NUMBER,
115 P_OWNER_ID_CURR IN NUMBER,
116 P_OWNER_TYPE_PREV IN VARCHAR2,
117 P_OWNER_TYPE_CURR IN VARCHAR2,
118 P_ASSIGNEE_ID_PREV IN NUMBER,
119 P_ASSIGNEE_ID_CURR IN NUMBER,
120 P_ASSIGNEE_TYPE_PREV IN VARCHAR2,
121 P_ASSIGNEE_TYPE_CURR IN VARCHAR2,
122 P_SOURCE_OBJECT_ID_PREV IN NUMBER,
123 P_SOURCE_OBJECT_ID_CURR IN NUMBER,
124 P_SOURCE_OBJECT_TYPE_CODE_PREV IN VARCHAR2,
125 P_SOURCE_OBJECT_TYPE_CODE_CURR IN VARCHAR2,
126 P_PARENT_WORKITEM_STATUS_PREV IN VARCHAR2,
127 P_PARENT_WORKITEM_STATUS_CURR IN VARCHAR2,
128 P_PARENT_DIST_STATUS_PREV IN VARCHAR2,
129 P_PARENT_DIST_STATUS_CURR IN VARCHAR2,
130 P_WORKITEM_DIST_STATUS_PREV IN VARCHAR2,
131 P_WORKITEM_DIST_STATUS_CURR IN VARCHAR2,
132 P_PRIORITY_PREV IN VARCHAR2,
133 P_PRIORITY_CURR IN VARCHAR2,
134 P_DUE_DATE_PREV IN DATE,
135 P_DUE_DATE_CURR IN DATE,
136 P_RESCHEDULE_TIME_PREV IN DATE,
137 P_RESCHEDULE_TIME_CURR IN DATE,
138 P_IEU_COMMENT_CODE1 IN VARCHAR2,
139 P_IEU_COMMENT_CODE2 IN VARCHAR2,
140 P_IEU_COMMENT_CODE3 IN VARCHAR2,
141 P_IEU_COMMENT_CODE4 IN VARCHAR2,
142 P_IEU_COMMENT_CODE5 IN VARCHAR2,
143 P_WORKITEM_COMMENT_CODE1 IN VARCHAR2,
144 P_WORKITEM_COMMENT_CODE2 IN VARCHAR2,
145 P_WORKITEM_COMMENT_CODE3 IN VARCHAR2,
146 P_WORKITEM_COMMENT_CODE4 IN VARCHAR2,
147 P_WORKITEM_COMMENT_CODE5 IN VARCHAR2,
148 P_STATUS IN VARCHAR2,
149 P_ERROR_CODE IN VARCHAR2,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 x_return_status OUT NOCOPY VARCHAR2
152 );
153
154 procedure DELETE_ROW (
155 P_WS_CODE IN VARCHAR2
156 );
157
158 end IEU_UWQM_AUDIT_LOG_PKG;