DBA Data[Home] [Help]

APPS.JTF_TASK_WF_EVENTS_PVT dependencies on WF_EVENT

Line 1: PACKAGE BODY jtf_task_wf_events_pvt AS

1: PACKAGE BODY jtf_task_wf_events_pvt AS
2: /* $Header: jtftkbeb.pls 115.8 2004/02/27 10:53:09 sachoudh noship $ */
3: PROCEDURE publish_create_task (
4: P_TASK_REC IN jtf_tasks_pvt.Task_Rec_type,
5: x_return_status OUT NOCOPY VARCHAR2

Line 24: wf_event.raise3(

20: Compare_and_set_attr_to_list('ENABLE_WORKFLOW', NULL, l_task_record.enable_workflow, 'C', l_list,'N');
21: Compare_and_set_attr_to_list('ABORT_WORKFLOW', NULL, l_task_record.abort_workflow, 'C',l_list, 'N');
22:
23: -- Raise the create task event
24: wf_event.raise3(
25: p_event_name => l_event_name,
26: p_event_key => l_key,
27: p_parameter_list => l_list,
28: p_send_date => sysdate

Line 32: wf_event.getvalueforparameter (

28: p_send_date => sysdate
29: );
30:
31: x_return_status :=
32: wf_event.getvalueforparameter (
33: 'X_RETURN_STATUS',
34: l_list
35: );
36:

Line 68: wf_event.raise3(

64: Compare_and_set_attr_to_list('ABORT_WORKFLOW', NULL, l_task_record_new.abort_workflow, 'U',l_list, 'N');
65:
66:
67: -- Raise the update task Event
68: wf_event.raise3(
69: p_event_name => l_event_name,
70: p_event_key => l_key,
71: p_parameter_list => l_list,
72: p_send_date => sysdate

Line 76: wf_event.getvalueforparameter (

72: p_send_date => sysdate
73: );
74:
75: x_return_status :=
76: wf_event.getvalueforparameter (
77: 'X_RETURN_STATUS',
78: l_list
79: );
80: l_list.DELETE;

Line 104: wf_event.raise3(

100: Compare_and_set_attr_to_list('ENABLE_WORKFLOW',p_task_rec.enable_workflow, NULL, 'D', l_list,'N');
101: Compare_and_set_attr_to_list('ABORT_WORKFLOW',p_task_rec.abort_workflow, NULL, 'D',l_list, 'N');
102:
103: -- Raise delete task Event
104: wf_event.raise3(
105: p_event_name => l_event_name,
106: p_event_key => l_key,
107: p_parameter_list => l_list,
108: p_send_date => sysdate

Line 112: wf_event.getvalueforparameter (

108: p_send_date => sysdate
109: );
110:
111: x_return_status :=
112: wf_event.getvalueforparameter (
113: 'X_RETURN_STATUS',
114: l_list
115: );
116: l_list.DELETE;

Line 147: wf_event.raise3(

143: Compare_and_set_attr_to_list('CATEGORY_ID',NULL ,P_ASSIGNMENT_REC.category_id ,'C',l_list);
144: Compare_and_set_attr_to_list('ENABLE_WORKFLOW', NULL, P_ASSIGNMENT_REC.enable_workflow, 'C', l_list,'N');
145: Compare_and_set_attr_to_list('ABORT_WORKFLOW', NULL, P_ASSIGNMENT_REC.abort_workflow, 'C',l_list, 'N');
146:
147: wf_event.raise3(
148: p_event_name => l_event_name,
149: p_event_key => l_key,
150: p_parameter_list => l_list,
151: p_send_date => sysdate

Line 155: wf_event.getvalueforparameter (

151: p_send_date => sysdate
152: );
153:
154: x_return_status :=
155: wf_event.getvalueforparameter (
156: 'X_RETURN_STATUS',
157: l_list
158: );
159:

Line 190: wf_event.raise3(

186: Compare_and_set_attr_to_list('CATEGORY_ID',P_ASSIGNMENT_REC_OLD.category_id, P_ASSIGNMENT_REC_NEW.category_id ,'U',l_list,'Y');
187: Compare_and_set_attr_to_list('ENABLE_WORKFLOW', NULL, P_ASSIGNMENT_REC_OLD.enable_workflow, 'U', l_list,'N');
188: Compare_and_set_attr_to_list('ABORT_WORKFLOW', NULL, P_ASSIGNMENT_REC_OLD.abort_workflow, 'U',l_list, 'N');
189:
190: wf_event.raise3(
191: p_event_name => l_event_name,
192: p_event_key => l_key,
193: p_parameter_list => l_list,
194: p_send_date => sysdate

Line 198: wf_event.getvalueforparameter (

194: p_send_date => sysdate
195: );
196:
197: x_return_status :=
198: wf_event.getvalueforparameter (
199: 'X_RETURN_STATUS',
200: l_list
201: );
202: l_list.DELETE;

Line 225: wf_event.raise3(

221: Compare_and_set_attr_to_list('ASSIGNMENT_STATUS_ID',P_ASSIGNMENT_REC.assignment_status_id, NULL, 'D',l_list,'N');
222: Compare_and_set_attr_to_list('ENABLE_WORKFLOW', P_ASSIGNMENT_REC.enable_workflow, NULL, 'D', l_list,'N');
223: Compare_and_set_attr_to_list('ABORT_WORKFLOW', P_ASSIGNMENT_REC.abort_workflow, NULL, 'D',l_list, 'N');
224:
225: wf_event.raise3(
226: p_event_name => l_event_name,
227: p_event_key => l_key,
228: p_parameter_list => l_list,
229: p_send_date => sysdate

Line 233: wf_event.getvalueforparameter (

229: p_send_date => sysdate
230: );
231:
232: x_return_status :=
233: wf_event.getvalueforparameter (
234: 'X_RETURN_STATUS',
235: l_list
236: );
237: l_list.DELETE;

Line 246: SELECT p_event_name ||'-'|| jtf_task_wf_events_s.nextval INTO l_key FROM DUAL;

242: RETURN VARCHAR2
243: IS
244: l_key varchar2(240);
245: BEGIN
246: SELECT p_event_name ||'-'|| jtf_task_wf_events_s.nextval INTO l_key FROM DUAL;
247: RETURN l_key;
248: END get_item_key;
249:
250: PROCEDURE compare_and_set_attr_to_list (

Line 264: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);

260: IF (P_ACTION = 'C')
261: THEN
262: IF (P_NEW_VALUE IS NOT NULL)
263: THEN
264: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
265: END IF;
266: ELSIF (P_ACTION = 'U')
267: THEN
268: IF (PUBLISH_IF_CHANGE = 'N')

Line 270: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);

266: ELSIF (P_ACTION = 'U')
267: THEN
268: IF (PUBLISH_IF_CHANGE = 'N')
269: THEN
270: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
271: ELSE IF (PUBLISH_IF_CHANGE = 'Y') AND ((P_NEW_VALUE IS NULL) OR (P_OLD_VALUE IS NULL) OR (P_NEW_VALUE <> P_OLD_VALUE)
272: OR (P_ATTRIBUTE_NAME = 'RESOURCE_TYPE_CODE'))
273: THEN
274: wf_event.addparametertolist ('NEW_'||P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);

Line 274: wf_event.addparametertolist ('NEW_'||P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);

270: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
271: ELSE IF (PUBLISH_IF_CHANGE = 'Y') AND ((P_NEW_VALUE IS NULL) OR (P_OLD_VALUE IS NULL) OR (P_NEW_VALUE <> P_OLD_VALUE)
272: OR (P_ATTRIBUTE_NAME = 'RESOURCE_TYPE_CODE'))
273: THEN
274: wf_event.addparametertolist ('NEW_'||P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
275: wf_event.addparametertolist ('OLD_'||P_ATTRIBUTE_NAME, P_OLD_VALUE, P_LIST);
276: ELSE IF (PUBLISH_IF_CHANGE = 'Y') AND (P_NEW_VALUE IS NOT NULL) AND (P_OLD_VALUE IS NOT NULL)
277: AND (P_NEW_VALUE = P_OLD_VALUE)
278: THEN

Line 275: wf_event.addparametertolist ('OLD_'||P_ATTRIBUTE_NAME, P_OLD_VALUE, P_LIST);

271: ELSE IF (PUBLISH_IF_CHANGE = 'Y') AND ((P_NEW_VALUE IS NULL) OR (P_OLD_VALUE IS NULL) OR (P_NEW_VALUE <> P_OLD_VALUE)
272: OR (P_ATTRIBUTE_NAME = 'RESOURCE_TYPE_CODE'))
273: THEN
274: wf_event.addparametertolist ('NEW_'||P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
275: wf_event.addparametertolist ('OLD_'||P_ATTRIBUTE_NAME, P_OLD_VALUE, P_LIST);
276: ELSE IF (PUBLISH_IF_CHANGE = 'Y') AND (P_NEW_VALUE IS NOT NULL) AND (P_OLD_VALUE IS NOT NULL)
277: AND (P_NEW_VALUE = P_OLD_VALUE)
278: THEN
279: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);

Line 279: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);

275: wf_event.addparametertolist ('OLD_'||P_ATTRIBUTE_NAME, P_OLD_VALUE, P_LIST);
276: ELSE IF (PUBLISH_IF_CHANGE = 'Y') AND (P_NEW_VALUE IS NOT NULL) AND (P_OLD_VALUE IS NOT NULL)
277: AND (P_NEW_VALUE = P_OLD_VALUE)
278: THEN
279: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
280: END IF;
281: END IF;
282: END IF;
283: ELSIF (P_ACTION = 'D')

Line 287: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_OLD_VALUE, P_LIST);

283: ELSIF (P_ACTION = 'D')
284: THEN
285: IF (P_OLD_VALUE IS NOT NULL)
286: THEN
287: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_OLD_VALUE, P_LIST);
288: END IF;
289: END IF;
290: END;
291: PROCEDURE compare_and_set_attr_to_list (