1 PACKAGE JTF_TASK_ASSIGNMENT_AUDIT_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtftkaus.pls 120.0.12010000.1 2009/04/13 08:27:50 anangupt noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_TASK_ASSIGNMENT_AUDIT_PKG';
5
6 /*#
7 * Procedure to accept call for creation of audit record for change in
8 * task assignment. This procedure validates if the update is actual
9 * update or a dummy update by comparing values passed with the values
10 * stored for the given assignment.This procedure inturn calls
11 * INSERT_ROW() procedure to create row in database.
12 *
13 * @param p_api_version Standard API version number. See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
14 * @param p_init_msg_list Standard API flag allows API callers to request that the API does the initialization of the message list on their
15 * behalf. By default, the message list will not be initialized. See "Standard IN Parameters", Oracle Common Application Calendar API Reference
16 * Guide.
17 * @param p_commit Standard API flag is used by API callers to ask the API to commit on their behalf after performing its function. By default,
18 * the commit will not be performed.See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
19 * @param p_object_version_number Object version number of the current record.
20 * @param p_task_id task ID
21 * @param P_TASK_ASSIGNMENT_ID Assignment id
22 * @param p_new_resource_type_code new resource type code
23 * @param p_new_resource_id new resource id
24 * @param p_new_assignment_status new assignment status
25 * @param p_new_actual_effort new actual effort
26 * @param p_new_actual_effort_uom new actual effort UOM
27 * @param p_new_res_territory_id new resoruce territory id
28 * @param p_new_assignee_role new assignee role
29 * @param p_new_schedule_flag new schedule flag
30 * @param p_new_alarm_type new alarm type
31 * @param p_new_alarm_contact new alarm contact
32 * @param p_new_update_status_flag new update status flag
33 * @param p_new_show_on_cal_flag new show on calendar flag
34 * @param p_new_category_id new category id
35 * @param p_new_free_busy_type new free busy type
36 * @param p_new_booking_start_date new booking start date
37 * @param p_new_booking_end_date new booking end date
38 * @param p_new_actual_travel_distance new actual travel distance
39 * @param p_new_actual_travel_duration new actual travel duration
40 * @param p_new_actual_travel_dur_uom new actual travel duration UOM
41 * @param p_new_sched_travel_distance new schedule travel distance
42 * @param p_new_sched_travel_duration new schedule travel duration
43 * @param p_new_sched_travel_dur_uom new schedule travel duration UOM
44 * @param p_new_actual_start_date new actual start date
45 * @param p_new_actual_end_date new actual end date
46 * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
47 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code> - If the API processed the data successfully.
48 * <LI><Code>FND_API.G_RET_STS_ERROR</Code> - If there was an expected error in API processing.
49 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code> If there was an unexpected error in API processing.
50 * @param x_msg_count Number of messages returned in the API message list.
51 * @param x_msg_data Returned message data in an encoded format if <code>x_msg_count</code> returns non-zero value.
52 */
53 PROCEDURE CREATE_TASK_ASSIGNMENT_AUDIT (
54 P_API_VERSION IN NUMBER,
55 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57 P_OBJECT_VERSION_NUMBER IN NUMBER,
58 P_TASK_ID IN NUMBER,
59 P_TASK_ASSIGNMENT_ID IN NUMBER,
60 P_NEW_RESOURCE_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
61 P_NEW_RESOURCE_ID IN NUMBER DEFAULT NULL,
62 P_NEW_ASSIGNMENT_STATUS IN NUMBER DEFAULT NULL,
63 P_NEW_ACTUAL_EFFORT IN NUMBER DEFAULT NULL,
64 P_NEW_ACTUAL_EFFORT_UOM IN VARCHAR2 DEFAULT NULL,
65 P_NEW_RES_TERRITORY_ID IN NUMBER DEFAULT NULL,
66 P_NEW_ASSIGNEE_ROLE IN VARCHAR2 DEFAULT NULL,
67 P_NEW_SCHEDULE_FLAG IN VARCHAR2 DEFAULT NULL,
68 P_NEW_ALARM_TYPE IN VARCHAR2 DEFAULT NULL,
69 P_NEW_ALARM_CONTACT IN VARCHAR2 DEFAULT NULL,
70 P_NEW_UPDATE_STATUS_FLAG IN VARCHAR2 DEFAULT NULL,
71 P_NEW_SHOW_ON_CAL_FLAG IN VARCHAR2 DEFAULT NULL,
72 P_NEW_CATEGORY_ID IN NUMBER DEFAULT NULL,
73 P_NEW_FREE_BUSY_TYPE IN VARCHAR2 DEFAULT NULL,
74 P_NEW_BOOKING_START_DATE IN DATE DEFAULT NULL,
75 P_NEW_BOOKING_END_DATE IN DATE DEFAULT NULL,
76 P_NEW_ACTUAL_TRAVEL_DISTANCE IN NUMBER DEFAULT NULL,
77 P_NEW_ACTUAL_TRAVEL_DURATION IN NUMBER DEFAULT NULL,
78 P_NEW_ACTUAL_TRAVEL_DUR_UOM IN VARCHAR2 DEFAULT NULL,
79 P_NEW_SCHED_TRAVEL_DISTANCE IN NUMBER DEFAULT NULL,
80 P_NEW_SCHED_TRAVEL_DURATION IN NUMBER DEFAULT NULL,
81 P_NEW_SCHED_TRAVEL_DUR_UOM IN VARCHAR2 DEFAULT NULL,
82 P_NEW_ACTUAL_START_DATE IN DATE DEFAULT NULL,
83 P_NEW_ACTUAL_END_DATE IN DATE DEFAULT NULL,
84 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
85 X_MSG_COUNT OUT NOCOPY NUMBER,
86 X_MSG_DATA OUT NOCOPY VARCHAR2
87 );
88
89 /*#
90 * This procedure accepts new and old values for a task assigment.
91 * and creates a new row in JTF_TASK_ASSIGNMENTS_AUDIT_B table
92 *
93 * @param p_object_version_number Object version number of the current record.
94 * @param p_task_id task ID
95 * @param P_TASK_ASSIGNMENT_ID Assignment id
96 * @param p_new_resource_type_code new resource type code
97 * @param p_new_resource_id new resource id
98 * @param p_new_assignment_status new assignment status
99 * @param p_new_actual_effort new actual effort
100 * @param p_new_actual_effort_uom new actual effort UOM
101 * @param p_new_res_territory_id new resoruce territory id
102 * @param p_new_assignee_role new assignee role
103 * @param p_schedule_flag_changed schedule flag changed or not.Possible values are 'Y' or 'N'
104 * @param p_new_alarm_type new alarm type
105 * @param p_new_alarm_contact new alarm contact
106 * @param p_update_status_flag_changed update status flag changed or not.Possible values are 'Y' or 'N'
107 * @param p_show_on_cal_flag_changed Show on calendar flag changed or not.Possible values are 'Y' or 'N'
108 * @param p_new_category_id new category id
109 * @param p_free_busy_type_changed free busy type flag changed or not.Possible values are 'Y' or 'N'
110 * @param p_new_booking_start_date new booking start date
111 * @param p_new_booking_end_date new booking end date
112 * @param p_new_actual_travel_distance new actual travel distance
113 * @param p_new_actual_travel_duration new actual travel duration
114 * @param p_new_actual_travel_dur_uom new actual travel duration UOM
115 * @param p_new_sched_travel_distance new schedule travel distance
116 * @param p_new_sched_travel_duration new schedule travel duration
117 * @param p_new_sched_travel_dur_uom new schedule travel duration UOM
118 * @param p_new_actual_start_date new actual start date
119 * @param p_new_actual_end_date new actual end date
120 * @param p_old_resource_type_code old resource type code
121 * @param p_old_resource_id old resource id
122 * @param p_old_assignment_status old assignment status
123 * @param p_old_actual_effort old actual effort
124 * @param p_old_actual_effort_uom old actual effort UOM
125 * @param p_old_res_territory_id old resoruce territory id
126 * @param p_old_assignee_role old assignee role
127 * @param p_old_alarm_type old alarm type
128 * @param p_old_alarm_contact old alarm contact
129 * @param p_old_category_id old category id
130 * @param p_old_booking_start_date old booking start date
131 * @param p_old_booking_end_date old booking end date
132 * @param p_old_actual_travel_distance old actual travel distance
133 * @param p_old_actual_travel_duration old actual travel duration
134 * @param p_old_actual_travel_dur_uom old actual travel duration UOM
135 * @param p_old_sched_travel_distance old schedule travel distance
136 * @param p_old_sched_travel_duration old schedule travel duration
137 * @param p_old_sched_travel_dur_uom old schedule travel duration UOM
138 * @param p_old_actual_start_date old actual start date
139 * @param p_old_actual_end_date old actual end date
140 * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
141 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code> - If the API processed the data successfully.
142 * <LI><Code>FND_API.G_RET_STS_ERROR</Code> - If there was an expected error in API processing.
143 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code> If there was an unexpected error in API processing.
144 * @param x_msg_count Number of messages returned in the API message list.
145 * @param x_msg_data Returned message data in an encoded format if <code>x_msg_count</code> returns non-zero value.
146 */
147
148 PROCEDURE INSERT_ROW (
149 X_ASSIGNMENT_AUDIT_ID IN NUMBER,
150 X_ASSIGNMENT_ID IN NUMBER,
151 X_TASK_ID IN NUMBER,
152 X_CREATION_DATE in DATE,
153 X_CREATED_BY in NUMBER,
154 X_LAST_UPDATE_DATE in DATE,
155 X_LAST_UPDATED_BY in NUMBER,
156 X_LAST_UPDATE_LOGIN in NUMBER,
157 X_OLD_RESOURCE_TYPE_CODE IN VARCHAR2,
158 X_NEW_RESOURCE_TYPE_CODE IN VARCHAR2,
159 X_OLD_RESOURCE_ID IN NUMBER,
160 X_NEW_RESOURCE_ID IN NUMBER,
161 X_OLD_ASSIGNMENT_STATUS_ID IN NUMBER,
162 X_NEW_ASSIGNMENT_STATUS_ID IN NUMBER,
163 X_OLD_ACTUAL_EFFORT IN NUMBER,
164 X_NEW_ACTUAL_EFFORT IN NUMBER,
165 X_OLD_ACTUAL_EFFORT_UOM IN VARCHAR2,
166 X_NEW_ACTUAL_EFFORT_UOM IN VARCHAR2,
167 X_OLD_RES_TERRITORY_ID IN NUMBER,
168 X_NEW_RES_TERRITORY_ID IN NUMBER,
169 X_OLD_ASSIGNEE_ROLE IN VARCHAR2,
170 X_NEW_ASSIGNEE_ROLE IN VARCHAR2,
171 X_OLD_ALARM_TYPE IN VARCHAR2,
172 X_NEW_ALARM_TYPE IN VARCHAR2,
173 X_OLD_ALARM_CONTACT IN VARCHAR2,
174 X_NEW_ALARM_CONTACT IN VARCHAR2,
175 X_OLD_CATEGORY_ID IN NUMBER,
176 X_NEW_CATEGORY_ID IN NUMBER,
177 X_OLD_BOOKING_START_DATE IN DATE,
178 X_NEW_BOOKING_START_DATE IN DATE,
179 X_OLD_BOOKING_END_DATE IN DATE,
180 X_NEW_BOOKING_END_DATE IN DATE,
184 X_NEW_ACTUAL_TRAVEL_DURATION IN NUMBER,
181 X_OLD_ACTUAL_TRAVEL_DISTANCE IN NUMBER,
182 X_NEW_ACTUAL_TRAVEL_DISTANCE IN NUMBER,
183 X_OLD_ACTUAL_TRAVEL_DURATION IN NUMBER,
185 X_OLD_ACTUAL_TRAVEL_DUR_UOM IN VARCHAR2,
186 X_NEW_ACTUAL_TRAVEL_DUR_UOM IN VARCHAR2,
187 X_OLD_SCHED_TRAVEL_DISTANCE IN NUMBER,
188 X_NEW_SCHED_TRAVEL_DISTANCE IN NUMBER,
189 X_OLD_SCHED_TRAVEL_DURATION IN NUMBER,
190 X_NEW_SCHED_TRAVEL_DURATION IN NUMBER,
191 X_OLD_SCHED_TRAVEL_DUR_UOM IN VARCHAR2,
192 X_NEW_SCHED_TRAVEL_DUR_UOM IN VARCHAR2,
193 X_OLD_ACTUAL_START_DATE IN DATE,
194 X_NEW_ACTUAL_START_DATE IN DATE,
195 X_OLD_ACTUAL_END_DATE IN DATE,
196 X_NEW_ACTUAL_END_DATE IN DATE,
197 X_FREE_BUSY_TYPE_CHANGED IN VARCHAR2,
198 X_UPDATE_STATUS_FLAG_CHANGED IN VARCHAR2,
199 X_SHOW_ON_CALENDAR_CHANGED IN VARCHAR2,
200 X_SCHEDULED_FLAG_CHANGED IN VARCHAR2
201 );
202
203 /*#
204 * This procedure acceptsassignmetn id for a deleted task assignment
205 * and removes all assignment audit records from JTF_TASK_ASSIGNMENTS_AUDIT_B
206 * table corresponds to the given TASK_ASSIGNMENT_ID
207 *
208 * @param X_ASSIGNMENT_ID task Assignment ID of task assignment which is deleted.
209 */
210
211 PROCEDURE DELETE_ROW(X_ASSIGNMENT_ID NUMBER);
212
213 END jtf_task_assignment_audit_pkg;