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_ESC_WF_EVENTS_PVT dependencies on WF_EVENT

Line 1: PACKAGE BODY jtf_esc_wf_events_pvt AS

1: PACKAGE BODY jtf_esc_wf_events_pvt AS
2: /* $Header: jtfecbeb.pls 115.7 2004/02/13 10:58:16 nselvam noship $ */
3: --Created for Esc BES enh 2660883
4: PROCEDURE publish_create_esc (
5: P_ESC_REC IN jtf_ec_pvt.Esc_Rec_type

Line 21: wf_event.raise(

17: l_key := get_item_key(l_event_name);
18: Compare_and_set_attr_to_list('TASK_ID', NULL, l_esc_record.escalation_id,'C', l_list,'N');
19:
20: -- Raise the create esc event
21: wf_event.raise(
22: p_event_name => l_event_name
23: ,p_event_key => l_key
24: ,p_parameters => l_list
25: );

Line 50: wf_event.raise(

46: l_key := get_item_key(l_event_name);
47: Compare_and_set_attr_to_list('TASK_ID',NULL,l_esc_record.escalation_id, 'U', l_list,'N');
48: Compare_and_set_attr_to_list('TASK_AUDIT_ID',NULL,l_esc_record.task_audit_id, 'U', l_list);
49: -- Raise the update esc Event
50: wf_event.raise(
51: p_event_name => l_event_name
52: ,p_event_key => l_key
53: ,p_parameters => l_list
54: );

Line 77: wf_event.raise(

73: --Get the item key
74: l_key := get_item_key(l_event_name);
75: Compare_and_set_attr_to_list('TASK_ID', l_esc_record.escalation_id, NULL, 'D',l_list,'N');
76: -- Raise delete esc Event
77: wf_event.raise(
78: p_event_name => l_event_name
79: ,p_event_key => l_key
80: ,p_parameters => l_list
81: );

Line 110: wf_event.raise (

106: -- Added for Bug # 3385990
107: Compare_and_set_attr_to_list('TASK_ID',NULL ,l_esc_ref_record.task_id,'C',l_list,'N');
108:
109:
110: wf_event.raise (
111: p_event_name => l_event_name,
112: p_event_key => l_key,
113: p_parameters => l_list
114: );

Line 138: wf_event.raise (

134: Compare_and_set_attr_to_list('OBJECT_ID',P_ESC_REF_REC_OLD.object_id,P_ESC_REF_REC_NEW.object_id,'U',l_list);
135: -- Added for Bug # 3385990
136: Compare_and_set_attr_to_list('TASK_ID',P_ESC_REF_REC_OLD.task_id ,P_ESC_REF_REC_NEW.task_id,'U',l_list, 'N');
137:
138: wf_event.raise (
139: p_event_name => l_event_name,
140: p_event_key => l_key,
141: p_parameters => l_list
142: );

Line 167: wf_event.raise(

163: Compare_and_set_attr_to_list('TASK_ID', P_ESC_REF_REC.task_id, NULL, 'D',l_list,'N');
164:
165: -- End Changes
166:
167: wf_event.raise(
168: p_event_name => l_event_name
169: ,p_event_key => l_key
170: ,p_parameters => l_list
171: );

Line 183: SELECT p_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;

179: RETURN VARCHAR2
180: IS
181: l_key varchar2(240);
182: BEGIN
183: SELECT p_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;
184: RETURN l_key;
185: END get_item_key;
186:
187: PROCEDURE compare_and_set_attr_to_list (

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

199: IF (P_ACTION = 'C')
200: THEN
201: IF (P_NEW_VALUE IS NOT NULL)
202: THEN
203: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
204: END IF;
205: ELSIF (P_ACTION = 'U')
206: THEN
207: IF (PUBLISH_IF_CHANGE = 'N')

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

205: ELSIF (P_ACTION = 'U')
206: THEN
207: IF (PUBLISH_IF_CHANGE = 'N')
208: THEN
209: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
210: 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))
211: THEN
212: wf_event.addparametertolist ('NEW_'||P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
213: wf_event.addparametertolist ('OLD_'||P_ATTRIBUTE_NAME, P_OLD_VALUE, P_LIST);

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

208: THEN
209: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
210: 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))
211: THEN
212: wf_event.addparametertolist ('NEW_'||P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
213: wf_event.addparametertolist ('OLD_'||P_ATTRIBUTE_NAME, P_OLD_VALUE, P_LIST);
214: ELSE IF (PUBLISH_IF_CHANGE = 'Y') AND (P_NEW_VALUE IS NOT NULL) AND (P_OLD_VALUE IS NOT NULL)
215: AND (P_NEW_VALUE = P_OLD_VALUE)
216: THEN

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

209: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
210: 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))
211: THEN
212: wf_event.addparametertolist ('NEW_'||P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
213: wf_event.addparametertolist ('OLD_'||P_ATTRIBUTE_NAME, P_OLD_VALUE, P_LIST);
214: ELSE IF (PUBLISH_IF_CHANGE = 'Y') AND (P_NEW_VALUE IS NOT NULL) AND (P_OLD_VALUE IS NOT NULL)
215: AND (P_NEW_VALUE = P_OLD_VALUE)
216: THEN
217: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);

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

213: wf_event.addparametertolist ('OLD_'||P_ATTRIBUTE_NAME, P_OLD_VALUE, P_LIST);
214: ELSE IF (PUBLISH_IF_CHANGE = 'Y') AND (P_NEW_VALUE IS NOT NULL) AND (P_OLD_VALUE IS NOT NULL)
215: AND (P_NEW_VALUE = P_OLD_VALUE)
216: THEN
217: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
218: END IF;
219: END IF;
220: END IF;
221: ELSIF (P_ACTION = 'D')

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

221: ELSIF (P_ACTION = 'D')
222: THEN
223: IF (P_OLD_VALUE IS NOT NULL)
224: THEN
225: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_OLD_VALUE, P_LIST);
226: END IF;
227: END IF;
228: -- End Add
229:

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

230: /* IF (P_ACTION = 'C')
231: THEN
232: IF (P_NEW_VALUE IS NOT NULL)
233: THEN
234: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
235: END IF;
236: ELSIF (P_ACTION = 'U')
237: THEN
238: IF (PUBLISH_IF_CHANGE = 'N')

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

236: ELSIF (P_ACTION = 'U')
237: THEN
238: IF (PUBLISH_IF_CHANGE = 'N')
239: THEN
240: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
241: ELSE IF (P_NEW_VALUE <> P_OLD_VALUE) AND (PUBLISH_IF_CHANGE = 'Y')
242: THEN
243: wf_event.addparametertolist ('NEW_'||P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
244: wf_event.addparametertolist ('OLD_'||P_ATTRIBUTE_NAME, P_OLD_VALUE, P_LIST);

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

239: THEN
240: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
241: ELSE IF (P_NEW_VALUE <> P_OLD_VALUE) AND (PUBLISH_IF_CHANGE = 'Y')
242: THEN
243: wf_event.addparametertolist ('NEW_'||P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
244: wf_event.addparametertolist ('OLD_'||P_ATTRIBUTE_NAME, P_OLD_VALUE, P_LIST);
245: END IF;
246: END IF;
247: ELSIF (P_ACTION = 'D')

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

240: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
241: ELSE IF (P_NEW_VALUE <> P_OLD_VALUE) AND (PUBLISH_IF_CHANGE = 'Y')
242: THEN
243: wf_event.addparametertolist ('NEW_'||P_ATTRIBUTE_NAME, P_NEW_VALUE, P_LIST);
244: wf_event.addparametertolist ('OLD_'||P_ATTRIBUTE_NAME, P_OLD_VALUE, P_LIST);
245: END IF;
246: END IF;
247: ELSIF (P_ACTION = 'D')
248: THEN

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

247: ELSIF (P_ACTION = 'D')
248: THEN
249: IF (P_OLD_VALUE IS NOT NULL)
250: THEN
251: wf_event.addparametertolist (P_ATTRIBUTE_NAME, P_OLD_VALUE, P_LIST);
252: END IF;
253: END IF; */
254:
255: END;