197: l_subject := FND_MESSAGE.GET;
198:
199: END IF;
200:
201: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
202: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
203: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_1', l_entity_name);
204: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', l_counter_entity_name);
205: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
198:
199: END IF;
200:
201: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
202: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
203: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_1', l_entity_name);
204: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', l_counter_entity_name);
205: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
206: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
199: END IF;
200:
201: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
202: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
203: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_1', l_entity_name);
204: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', l_counter_entity_name);
205: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
206: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
207: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
200:
201: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
202: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
203: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_1', l_entity_name);
204: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', l_counter_entity_name);
205: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
206: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
207: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
208: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', l_run_name);
201: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
202: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
203: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_1', l_entity_name);
204: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', l_counter_entity_name);
205: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
206: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
207: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
208: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', l_run_name);
209: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
202: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
203: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_1', l_entity_name);
204: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', l_counter_entity_name);
205: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
206: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
207: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
208: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', l_run_name);
209: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
210: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
203: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_1', l_entity_name);
204: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', l_counter_entity_name);
205: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
206: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
207: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
208: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', l_run_name);
209: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
210: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
211: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
204: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', l_counter_entity_name);
205: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
206: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
207: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
208: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', l_run_name);
209: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
210: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
211: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
212: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', l_entry_id);
205: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
206: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
207: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
208: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', l_run_name);
209: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
210: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
211: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
212: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', l_entry_id);
213: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
206: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
207: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
208: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', l_run_name);
209: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
210: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
211: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
212: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', l_entry_id);
213: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
214: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'N');
207: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
208: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', l_run_name);
209: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
210: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
211: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
212: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', l_entry_id);
213: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
214: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'N');
215: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
208: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', l_run_name);
209: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
210: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
211: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
212: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', l_entry_id);
213: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
214: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'N');
215: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
216: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
209: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
210: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
211: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
212: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', l_entry_id);
213: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
214: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'N');
215: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
216: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
217: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
210: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
211: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
212: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', l_entry_id);
213: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
214: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'N');
215: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
216: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
217: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
218:
211: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
212: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', l_entry_id);
213: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
214: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'N');
215: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
216: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
217: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
218:
219: COMMIT;
212: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', l_entry_id);
213: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
214: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'N');
215: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
216: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
217: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
218:
219: COMMIT;
220:
213: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
214: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'N');
215: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
216: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
217: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
218:
219: COMMIT;
220:
221: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' EXIT ');
332: l_attachment := 'FND:entity=GCS_DATA_SUB_DTLS'||'&'||'pk1name=LOAD_ID'||'&'||'pk1value='||p_load_id;
333: */
334: END IF;
335:
336: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
337: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
338: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
339: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
340: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
333: */
334: END IF;
335:
336: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
337: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
338: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
339: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
340: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
341: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
334: END IF;
335:
336: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
337: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
338: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
339: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
340: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
341: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
342: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
335:
336: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
337: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
338: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
339: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
340: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
341: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
342: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
343: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
336: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
337: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
338: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
339: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
340: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
341: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
342: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
343: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
344: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
337: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
338: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
339: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
340: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
341: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
342: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
343: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
344: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
345: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', p_entry_id);
338: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
339: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
340: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
341: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
342: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
343: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
344: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
345: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', p_entry_id);
346: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
339: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
340: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
341: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
342: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
343: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
344: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
345: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', p_entry_id);
346: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
347: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'Y');
340: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
341: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
342: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
343: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
344: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
345: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', p_entry_id);
346: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
347: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'Y');
348: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
341: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
342: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
343: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
344: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
345: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', p_entry_id);
346: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
347: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'Y');
348: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
349: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
342: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', l_wf_region);
343: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
344: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
345: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', p_entry_id);
346: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
347: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'Y');
348: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
349: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
350: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
343: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
344: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
345: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', p_entry_id);
346: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
347: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'Y');
348: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
349: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
350: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
351:
344: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
345: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', p_entry_id);
346: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
347: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'Y');
348: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
349: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
350: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
351:
352: COMMIT;
345: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', p_entry_id);
346: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
347: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'Y');
348: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
349: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
350: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
351:
352: COMMIT;
353:
346: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', l_attachment);
347: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'Y');
348: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
349: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
350: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
351:
352: COMMIT;
353:
354: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
440: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
441: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
442: l_subject := FND_MESSAGE.GET;
443:
444: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
445: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_1', null);
446: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', null);
447: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
448: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
441: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
442: l_subject := FND_MESSAGE.GET;
443:
444: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
445: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_1', null);
446: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', null);
447: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
448: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
449: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
442: l_subject := FND_MESSAGE.GET;
443:
444: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
445: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_1', null);
446: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', null);
447: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
448: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
449: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
450: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
443:
444: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
445: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_1', null);
446: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', null);
447: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
448: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
449: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
450: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
451: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
444: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
445: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_1', null);
446: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', null);
447: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
448: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
449: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
450: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
451: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
452: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', NULL);
445: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_1', null);
446: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', null);
447: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
448: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
449: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
450: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
451: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
452: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', NULL);
453: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
446: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', null);
447: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
448: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
449: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
450: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
451: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
452: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', NULL);
453: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
454: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
447: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SENDER', fnd_global.user_name);
448: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
449: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
450: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
451: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
452: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', NULL);
453: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
454: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
455: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', NULL);
448: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RECIPIENT', l_recipient);
449: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
450: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
451: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
452: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', NULL);
453: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
454: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
455: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', NULL);
456: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', NULL);
449: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'HIERARCHY', l_hierarchy_name);
450: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
451: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
452: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', NULL);
453: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
454: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
455: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', NULL);
456: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', NULL);
457: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
450: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY', l_cons_entity_name);
451: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
452: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', NULL);
453: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
454: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
455: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', NULL);
456: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', NULL);
457: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
458: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
451: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'RUNNAME', p_run_name);
452: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', NULL);
453: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
454: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
455: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', NULL);
456: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', NULL);
457: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
458: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
459: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'N');
452: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'WFREGION', NULL);
453: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
454: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
455: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', NULL);
456: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', NULL);
457: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
458: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
459: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'N');
460: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
453: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'BALTYPE', l_balance_type);
454: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
455: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', NULL);
456: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', NULL);
457: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
458: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
459: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'N');
460: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
461:
454: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'DATE', l_date);
455: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', NULL);
456: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', NULL);
457: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
458: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
459: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'N');
460: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
461:
462: COMMIT;
455: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTRYID', NULL);
456: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', NULL);
457: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
458: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
459: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'N');
460: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
461:
462: COMMIT;
463:
456: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, '#ATTACHMENTS', NULL);
457: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'SUBJECT', l_subject);
458: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'MESSAGE CONTENT', l_subject);
459: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'IMPACTED FLAG', 'N');
460: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
461:
462: COMMIT;
463:
464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
492: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
493: );
494: END IF;
495:
496: l_attachment := WF_ENGINE.GetItemAttrText(p_itemtype, p_itemkey, '#ATTACHMENTS', FALSE);
497:
498: IF (l_attachment IS NULL) THEN
499: p_result := 'COMPLETE:F';
500: ELSE
532: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
533: );
534: END IF;
535:
536: l_impacted_flag := WF_ENGINE.GetItemAttrText(p_itemtype, p_itemkey, 'IMPACTED FLAG', FALSE);
537:
538: IF (l_impacted_flag = 'Y') THEN
539: p_result := 'COMPLETE:T';
540: ELSE
581: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
582: );
583: END IF;
584:
585: l_run_dtl_id := WF_ENGINE.GetItemAttrText(p_itemtype, p_itemkey, 'RUN DETAIL ID', FALSE);
586: /*
587: IF (l_run_dtl_id IS NOT NULL) THEN
588: OPEN c_ntf_id(p_itemtype, p_itemkey);
589: FETCH c_ntf_id INTO l_ntf_id;