eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASK_WF_SUBSCRIBE_PVT dependencies on WF_EVENT

Line 3: FUNCTION create_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

1: PACKAGE BODY jtf_task_wf_subscribe_pvt AS
2: /* $Header: jtftkwkb.pls 120.1.12000000.2 2007/10/04 14:16:11 venjayar ship $ */
3: FUNCTION create_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
4: RETURN VARCHAR2 IS
5: l_task_id jtf_tasks_b.task_id%TYPE;
6: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
7: l_enable_workflow VARCHAR2(1);

Line 13: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);

9: x_return_status VARCHAR2(200);
10: x_msg_count NUMBER;
11: x_msg_data VARCHAR2(1000);
12: BEGIN
13: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
14: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
15: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
16: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);
17:

Line 14: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);

10: x_msg_count NUMBER;
11: x_msg_data VARCHAR2(1000);
12: BEGIN
13: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
14: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
15: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
16: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);
17:
18: IF (l_source_object_type_code <> 'APPOINTMENT') THEN

Line 15: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);

11: x_msg_data VARCHAR2(1000);
12: BEGIN
13: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
14: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
15: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
16: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);
17:
18: IF (l_source_object_type_code <> 'APPOINTMENT') THEN
19: IF (l_enable_workflow = 'Y') THEN

Line 16: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);

12: BEGIN
13: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
14: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
15: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
16: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);
17:
18: IF (l_source_object_type_code <> 'APPOINTMENT') THEN
19: IF (l_enable_workflow = 'Y') THEN
20: IF (jtf_task_wf_util.do_notification(l_task_id)) THEN

Line 35: wf_event.seterrorinfo(p_event, 'WARNING');

31: END IF;
32:
33: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
34: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'create_task_notif_subs', p_event.event_name, p_subscription_guid);
35: wf_event.seterrorinfo(p_event, 'WARNING');
36: RETURN 'WARNING';
37: END IF;
38:
39: RETURN 'SUCCESS';

Line 43: wf_event.seterrorinfo(p_event, 'WARNING');

39: RETURN 'SUCCESS';
40: EXCEPTION
41: WHEN OTHERS THEN
42: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'create_task_notif_subs', p_event.event_name, p_subscription_guid);
43: wf_event.seterrorinfo(p_event, 'WARNING');
44: RETURN 'WARNING';
45: END create_task_notif_subs;
46:
47: FUNCTION update_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

Line 47: FUNCTION update_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

43: wf_event.seterrorinfo(p_event, 'WARNING');
44: RETURN 'WARNING';
45: END create_task_notif_subs;
46:
47: FUNCTION update_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
48: RETURN VARCHAR2 IS
49: l_task_id jtf_tasks_b.task_id%TYPE;
50: l_task_audit_id jtf_task_audits_b.task_audit_id%TYPE;
51: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

Line 88: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);

84: WHERE task_audit_id = b_task_audit_id;
85:
86: rec_task c_task_detail%ROWTYPE;
87: BEGIN
88: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
89: l_task_audit_id := wf_event.getvalueforparameter('TASK_AUDIT_ID', p_event.parameter_list);
90: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
91: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
92: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);

Line 89: l_task_audit_id := wf_event.getvalueforparameter('TASK_AUDIT_ID', p_event.parameter_list);

85:
86: rec_task c_task_detail%ROWTYPE;
87: BEGIN
88: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
89: l_task_audit_id := wf_event.getvalueforparameter('TASK_AUDIT_ID', p_event.parameter_list);
90: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
91: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
92: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);
93:

Line 90: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);

86: rec_task c_task_detail%ROWTYPE;
87: BEGIN
88: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
89: l_task_audit_id := wf_event.getvalueforparameter('TASK_AUDIT_ID', p_event.parameter_list);
90: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
91: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
92: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);
93:
94: OPEN c_task_detail(l_task_audit_id);

Line 91: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);

87: BEGIN
88: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
89: l_task_audit_id := wf_event.getvalueforparameter('TASK_AUDIT_ID', p_event.parameter_list);
90: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
91: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
92: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);
93:
94: OPEN c_task_detail(l_task_audit_id);
95:

Line 92: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);

88: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
89: l_task_audit_id := wf_event.getvalueforparameter('TASK_AUDIT_ID', p_event.parameter_list);
90: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
91: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
92: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);
93:
94: OPEN c_task_detail(l_task_audit_id);
95:
96: FETCH c_task_detail

Line 142: wf_event.seterrorinfo(p_event, 'WARNING');

138: END IF;
139:
140: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
141: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'update_task_notif_subs', p_event.event_name, p_subscription_guid);
142: wf_event.seterrorinfo(p_event, 'WARNING');
143: RETURN 'WARNING';
144: END IF;
145:
146: RETURN 'SUCCESS';

Line 150: wf_event.seterrorinfo(p_event, 'WARNING');

146: RETURN 'SUCCESS';
147: EXCEPTION
148: WHEN OTHERS THEN
149: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'update_task_notif_subs', p_event.event_name, p_subscription_guid);
150: wf_event.seterrorinfo(p_event, 'WARNING');
151: RETURN 'WARNING';
152: END update_task_notif_subs;
153:
154: FUNCTION delete_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

Line 154: FUNCTION delete_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

150: wf_event.seterrorinfo(p_event, 'WARNING');
151: RETURN 'WARNING';
152: END update_task_notif_subs;
153:
154: FUNCTION delete_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
155: RETURN VARCHAR2 IS
156: l_task_id jtf_tasks_b.task_id%TYPE;
157: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
158: l_enable_workflow VARCHAR2(1);

Line 164: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);

160: x_return_status VARCHAR2(200);
161: x_msg_count NUMBER;
162: x_msg_data VARCHAR2(1000);
163: BEGIN
164: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
165: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
166: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
167: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);
168:

Line 165: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);

161: x_msg_count NUMBER;
162: x_msg_data VARCHAR2(1000);
163: BEGIN
164: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
165: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
166: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
167: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);
168:
169: IF (l_source_object_type_code <> 'APPOINTMENT') THEN

Line 166: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);

162: x_msg_data VARCHAR2(1000);
163: BEGIN
164: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
165: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
166: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
167: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);
168:
169: IF (l_source_object_type_code <> 'APPOINTMENT') THEN
170: IF (l_enable_workflow = 'Y') THEN

Line 167: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);

163: BEGIN
164: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
165: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
166: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
167: l_source_object_type_code := wf_event.getvalueforparameter('SOURCE_OBJECT_TYPE_CODE', p_event.parameter_list);
168:
169: IF (l_source_object_type_code <> 'APPOINTMENT') THEN
170: IF (l_enable_workflow = 'Y') THEN
171: IF (jtf_task_wf_util.do_notification(l_task_id)) THEN

Line 186: wf_event.seterrorinfo(p_event, 'WARNING');

182: END IF;
183:
184: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
185: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'delete_task_notif_subs', p_event.event_name, p_subscription_guid);
186: wf_event.seterrorinfo(p_event, 'WARNING');
187: RETURN 'WARNING';
188: END IF;
189:
190: RETURN 'SUCCESS';

Line 194: wf_event.seterrorinfo(p_event, 'WARNING');

190: RETURN 'SUCCESS';
191: EXCEPTION
192: WHEN OTHERS THEN
193: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'delete_task_notif_subs', p_event.event_name, p_subscription_guid);
194: wf_event.seterrorinfo(p_event, 'WARNING');
195: RETURN 'WARNING';
196: END delete_task_notif_subs;
197:
198: FUNCTION create_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

Line 198: FUNCTION create_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

194: wf_event.seterrorinfo(p_event, 'WARNING');
195: RETURN 'WARNING';
196: END delete_task_notif_subs;
197:
198: FUNCTION create_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
199: RETURN VARCHAR2 IS
200: l_enable_workflow VARCHAR2(1);
201: l_abort_workflow VARCHAR2(1);
202: x_return_status VARCHAR2(200);

Line 210: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);

206: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
207: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
208: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
209: BEGIN
210: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
211: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
212: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);
213: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
214: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);

Line 211: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);

207: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
208: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
209: BEGIN
210: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
211: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
212: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);
213: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
214: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
215: l_assignee_role := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);

Line 212: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);

208: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
209: BEGIN
210: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
211: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
212: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);
213: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
214: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
215: l_assignee_role := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);
216:

Line 213: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);

209: BEGIN
210: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
211: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
212: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);
213: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
214: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
215: l_assignee_role := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);
216:
217: IF (l_assignee_role <> 'OWNER') AND(l_enable_workflow = 'Y') THEN

Line 214: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);

210: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
211: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
212: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);
213: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
214: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
215: l_assignee_role := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);
216:
217: IF (l_assignee_role <> 'OWNER') AND(l_enable_workflow = 'Y') THEN
218: IF (jtf_task_wf_util.do_notification(l_task_id)) THEN

Line 215: l_assignee_role := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);

211: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
212: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);
213: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
214: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
215: l_assignee_role := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);
216:
217: IF (l_assignee_role <> 'OWNER') AND(l_enable_workflow = 'Y') THEN
218: IF (jtf_task_wf_util.do_notification(l_task_id)) THEN
219: jtf_task_wf_util.create_notification(

Line 234: wf_event.seterrorinfo(p_event, 'WARNING');

230: END IF;
231:
232: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
233: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'create_assg_notif_subs', p_event.event_name, p_subscription_guid);
234: wf_event.seterrorinfo(p_event, 'WARNING');
235: RETURN 'WARNING';
236: END IF;
237:
238: RETURN 'SUCCESS';

Line 242: wf_event.seterrorinfo(p_event, 'WARNING');

238: RETURN 'SUCCESS';
239: EXCEPTION
240: WHEN OTHERS THEN
241: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'create_assg_notif_subs', p_event.event_name, p_subscription_guid);
242: wf_event.seterrorinfo(p_event, 'WARNING');
243: RETURN 'WARNING';
244: END create_assg_notif_subs;
245:
246: FUNCTION update_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

Line 246: FUNCTION update_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

242: wf_event.seterrorinfo(p_event, 'WARNING');
243: RETURN 'WARNING';
244: END create_assg_notif_subs;
245:
246: FUNCTION update_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
247: RETURN VARCHAR2 IS
248: l_enable_workflow VARCHAR2(1);
249: l_abort_workflow VARCHAR2(1);
250: l_assignee_role_db jtf_task_all_assignments.assignee_role%TYPE;

Line 261: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);

257: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
258: l_orig_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
259: l_orig_resource_id jtf_task_all_assignments.resource_id%TYPE;
260: BEGIN
261: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
262: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
263: l_resource_type_code := wf_event.getvalueforparameter('NEW_RESOURCE_TYPE_CODE', p_event.parameter_list);
264: l_resource_id := wf_event.getvalueforparameter('NEW_RESOURCE_ID', p_event.parameter_list);
265: l_orig_resource_type_code := wf_event.getvalueforparameter('OLD_RESOURCE_TYPE_CODE', p_event.parameter_list);

Line 262: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);

258: l_orig_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
259: l_orig_resource_id jtf_task_all_assignments.resource_id%TYPE;
260: BEGIN
261: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
262: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
263: l_resource_type_code := wf_event.getvalueforparameter('NEW_RESOURCE_TYPE_CODE', p_event.parameter_list);
264: l_resource_id := wf_event.getvalueforparameter('NEW_RESOURCE_ID', p_event.parameter_list);
265: l_orig_resource_type_code := wf_event.getvalueforparameter('OLD_RESOURCE_TYPE_CODE', p_event.parameter_list);
266: l_orig_resource_id := wf_event.getvalueforparameter('OLD_RESOURCE_ID', p_event.parameter_list);

Line 263: l_resource_type_code := wf_event.getvalueforparameter('NEW_RESOURCE_TYPE_CODE', p_event.parameter_list);

259: l_orig_resource_id jtf_task_all_assignments.resource_id%TYPE;
260: BEGIN
261: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
262: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
263: l_resource_type_code := wf_event.getvalueforparameter('NEW_RESOURCE_TYPE_CODE', p_event.parameter_list);
264: l_resource_id := wf_event.getvalueforparameter('NEW_RESOURCE_ID', p_event.parameter_list);
265: l_orig_resource_type_code := wf_event.getvalueforparameter('OLD_RESOURCE_TYPE_CODE', p_event.parameter_list);
266: l_orig_resource_id := wf_event.getvalueforparameter('OLD_RESOURCE_ID', p_event.parameter_list);
267: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);

Line 264: l_resource_id := wf_event.getvalueforparameter('NEW_RESOURCE_ID', p_event.parameter_list);

260: BEGIN
261: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
262: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
263: l_resource_type_code := wf_event.getvalueforparameter('NEW_RESOURCE_TYPE_CODE', p_event.parameter_list);
264: l_resource_id := wf_event.getvalueforparameter('NEW_RESOURCE_ID', p_event.parameter_list);
265: l_orig_resource_type_code := wf_event.getvalueforparameter('OLD_RESOURCE_TYPE_CODE', p_event.parameter_list);
266: l_orig_resource_id := wf_event.getvalueforparameter('OLD_RESOURCE_ID', p_event.parameter_list);
267: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
268: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);

Line 265: l_orig_resource_type_code := wf_event.getvalueforparameter('OLD_RESOURCE_TYPE_CODE', p_event.parameter_list);

261: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
262: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
263: l_resource_type_code := wf_event.getvalueforparameter('NEW_RESOURCE_TYPE_CODE', p_event.parameter_list);
264: l_resource_id := wf_event.getvalueforparameter('NEW_RESOURCE_ID', p_event.parameter_list);
265: l_orig_resource_type_code := wf_event.getvalueforparameter('OLD_RESOURCE_TYPE_CODE', p_event.parameter_list);
266: l_orig_resource_id := wf_event.getvalueforparameter('OLD_RESOURCE_ID', p_event.parameter_list);
267: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
268: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
269: l_assignee_role_db := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);

Line 266: l_orig_resource_id := wf_event.getvalueforparameter('OLD_RESOURCE_ID', p_event.parameter_list);

262: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
263: l_resource_type_code := wf_event.getvalueforparameter('NEW_RESOURCE_TYPE_CODE', p_event.parameter_list);
264: l_resource_id := wf_event.getvalueforparameter('NEW_RESOURCE_ID', p_event.parameter_list);
265: l_orig_resource_type_code := wf_event.getvalueforparameter('OLD_RESOURCE_TYPE_CODE', p_event.parameter_list);
266: l_orig_resource_id := wf_event.getvalueforparameter('OLD_RESOURCE_ID', p_event.parameter_list);
267: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
268: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
269: l_assignee_role_db := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);
270:

Line 267: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);

263: l_resource_type_code := wf_event.getvalueforparameter('NEW_RESOURCE_TYPE_CODE', p_event.parameter_list);
264: l_resource_id := wf_event.getvalueforparameter('NEW_RESOURCE_ID', p_event.parameter_list);
265: l_orig_resource_type_code := wf_event.getvalueforparameter('OLD_RESOURCE_TYPE_CODE', p_event.parameter_list);
266: l_orig_resource_id := wf_event.getvalueforparameter('OLD_RESOURCE_ID', p_event.parameter_list);
267: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
268: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
269: l_assignee_role_db := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);
270:
271: IF (l_assignee_role_db IS NULL) THEN

Line 268: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);

264: l_resource_id := wf_event.getvalueforparameter('NEW_RESOURCE_ID', p_event.parameter_list);
265: l_orig_resource_type_code := wf_event.getvalueforparameter('OLD_RESOURCE_TYPE_CODE', p_event.parameter_list);
266: l_orig_resource_id := wf_event.getvalueforparameter('OLD_RESOURCE_ID', p_event.parameter_list);
267: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
268: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
269: l_assignee_role_db := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);
270:
271: IF (l_assignee_role_db IS NULL) THEN
272: l_assignee_role_db := wf_event.getvalueforparameter('NEW_ASSIGNEE_ROLE', p_event.parameter_list);

Line 269: l_assignee_role_db := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);

265: l_orig_resource_type_code := wf_event.getvalueforparameter('OLD_RESOURCE_TYPE_CODE', p_event.parameter_list);
266: l_orig_resource_id := wf_event.getvalueforparameter('OLD_RESOURCE_ID', p_event.parameter_list);
267: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
268: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
269: l_assignee_role_db := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);
270:
271: IF (l_assignee_role_db IS NULL) THEN
272: l_assignee_role_db := wf_event.getvalueforparameter('NEW_ASSIGNEE_ROLE', p_event.parameter_list);
273: END IF;

Line 272: l_assignee_role_db := wf_event.getvalueforparameter('NEW_ASSIGNEE_ROLE', p_event.parameter_list);

268: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
269: l_assignee_role_db := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);
270:
271: IF (l_assignee_role_db IS NULL) THEN
272: l_assignee_role_db := wf_event.getvalueforparameter('NEW_ASSIGNEE_ROLE', p_event.parameter_list);
273: END IF;
274:
275: IF (l_assignee_role_db IS NOT NULL) THEN
276: IF (l_enable_workflow = 'Y') THEN

Line 312: wf_event.seterrorinfo(p_event, 'WARNING');

308: END IF;
309:
310: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
311: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'update_assg_notif_subs', p_event.event_name, p_subscription_guid);
312: wf_event.seterrorinfo(p_event, 'WARNING');
313: RETURN 'WARNING';
314: END IF;
315:
316: RETURN 'SUCCESS';

Line 320: wf_event.seterrorinfo(p_event, 'WARNING');

316: RETURN 'SUCCESS';
317: EXCEPTION
318: WHEN OTHERS THEN
319: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'update_assg_notif_subs', p_event.event_name, p_subscription_guid);
320: wf_event.seterrorinfo(p_event, 'WARNING');
321: RETURN 'WARNING';
322: END update_assg_notif_subs;
323:
324: FUNCTION delete_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

Line 324: FUNCTION delete_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

320: wf_event.seterrorinfo(p_event, 'WARNING');
321: RETURN 'WARNING';
322: END update_assg_notif_subs;
323:
324: FUNCTION delete_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
325: RETURN VARCHAR2 IS
326: l_enable_workflow VARCHAR2(1);
327: l_abort_workflow VARCHAR2(1);
328: x_return_status VARCHAR2(200);

Line 337: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);

333: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
334: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
335: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
336: BEGIN
337: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
338: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
339: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
340: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);
341: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);

Line 338: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);

334: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
335: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
336: BEGIN
337: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
338: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
339: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
340: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);
341: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
342: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);

Line 339: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);

335: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
336: BEGIN
337: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
338: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
339: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
340: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);
341: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
342: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
343: l_assignee_role := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);

Line 340: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);

336: BEGIN
337: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
338: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
339: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
340: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);
341: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
342: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
343: l_assignee_role := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);
344:

Line 341: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);

337: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
338: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
339: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
340: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);
341: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
342: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
343: l_assignee_role := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);
344:
345: IF (l_assignee_role <> 'OWNER') AND(l_enable_workflow = 'Y') THEN

Line 342: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);

338: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
339: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
340: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);
341: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
342: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
343: l_assignee_role := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);
344:
345: IF (l_assignee_role <> 'OWNER') AND(l_enable_workflow = 'Y') THEN
346: IF (jtf_task_wf_util.do_notification(l_task_id)) THEN

Line 343: l_assignee_role := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);

339: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
340: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);
341: l_enable_workflow := wf_event.getvalueforparameter('ENABLE_WORKFLOW', p_event.parameter_list);
342: l_abort_workflow := wf_event.getvalueforparameter('ABORT_WORKFLOW', p_event.parameter_list);
343: l_assignee_role := wf_event.getvalueforparameter('ASSIGNEE_ROLE', p_event.parameter_list);
344:
345: IF (l_assignee_role <> 'OWNER') AND(l_enable_workflow = 'Y') THEN
346: IF (jtf_task_wf_util.do_notification(l_task_id)) THEN
347: jtf_task_wf_util.create_notification(

Line 362: wf_event.seterrorinfo(p_event, 'WARNING');

358: END IF;
359:
360: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
361: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'delete_assg_notif_subs', p_event.event_name, p_subscription_guid);
362: wf_event.seterrorinfo(p_event, 'WARNING');
363: RETURN 'WARNING';
364: END IF;
365:
366: RETURN 'SUCCESS';

Line 370: wf_event.seterrorinfo(p_event, 'WARNING');

366: RETURN 'SUCCESS';
367: EXCEPTION
368: WHEN OTHERS THEN
369: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'delete_assg_notif_subs', p_event.event_name, p_subscription_guid);
370: wf_event.seterrorinfo(p_event, 'WARNING');
371: RETURN 'WARNING';
372: END delete_assg_notif_subs;
373:
374: FUNCTION compare_old_new_param(p_new_param IN VARCHAR2, p_old_param IN VARCHAR2)