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.HR_DELTA_SYNC_MESSAGES dependencies on WF_EVENT

Line 204: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

200: values(p_cntry_code,p_cntry_desc,p_row_id,p_cntry_code,p_obs_flag,p_last_update_date,'QUEUED',p_effective_date,
201: p_cntry_code||'-'||to_char(p_unique_key));
202: commit;
203:
204: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
205: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'CNTRY',l_params);
206: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
207: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_cntry_code||'-'||to_char(p_unique_key), l_params);
208: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 205: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'CNTRY',l_params);

201: p_cntry_code||'-'||to_char(p_unique_key));
202: commit;
203:
204: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
205: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'CNTRY',l_params);
206: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
207: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_cntry_code||'-'||to_char(p_unique_key), l_params);
208: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
209: p_event_key => p_cntry_code||'-'||to_char(p_unique_key),

Line 206: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

202: commit;
203:
204: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
205: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'CNTRY',l_params);
206: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
207: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_cntry_code||'-'||to_char(p_unique_key), l_params);
208: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
209: p_event_key => p_cntry_code||'-'||to_char(p_unique_key),
210: p_parameters => l_params);

Line 207: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_cntry_code||'-'||to_char(p_unique_key), l_params);

203:
204: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
205: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'CNTRY',l_params);
206: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
207: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_cntry_code||'-'||to_char(p_unique_key), l_params);
208: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
209: p_event_key => p_cntry_code||'-'||to_char(p_unique_key),
210: p_parameters => l_params);
211:

Line 208: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

204: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
205: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'CNTRY',l_params);
206: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
207: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_cntry_code||'-'||to_char(p_unique_key), l_params);
208: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
209: p_event_key => p_cntry_code||'-'||to_char(p_unique_key),
210: p_parameters => l_params);
211:
212: open csr_gen_msg(p_cntry_code||'-'||to_char(p_unique_key));

Line 243: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

239: COUNTRY_2CHAR,OBSOLETE_FLAG,LAST_UPDATE_DATE,STATUS,EFFECTIVE_STATUS_DATE,EVENT_KEY)
240: values(p_cntry_code,p_cntry_desc,p_row_id,p_cntry_code,p_obs_flag,p_last_update_date,'QUEUED',p_effective_date,
241: p_cntry_code||'-'||to_char(p_unique_key));
242: commit;
243: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
244: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'CNTRY',l_params);
245: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
246: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_cntry_code||'-'||to_char(p_unique_key), l_params);
247: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 244: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'CNTRY',l_params);

240: values(p_cntry_code,p_cntry_desc,p_row_id,p_cntry_code,p_obs_flag,p_last_update_date,'QUEUED',p_effective_date,
241: p_cntry_code||'-'||to_char(p_unique_key));
242: commit;
243: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
244: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'CNTRY',l_params);
245: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
246: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_cntry_code||'-'||to_char(p_unique_key), l_params);
247: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
248: p_event_key => p_cntry_code||'-'||to_char(p_unique_key),

Line 245: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

241: p_cntry_code||'-'||to_char(p_unique_key));
242: commit;
243: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
244: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'CNTRY',l_params);
245: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
246: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_cntry_code||'-'||to_char(p_unique_key), l_params);
247: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
248: p_event_key => p_cntry_code||'-'||to_char(p_unique_key),
249: p_parameters => l_params);

Line 246: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_cntry_code||'-'||to_char(p_unique_key), l_params);

242: commit;
243: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
244: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'CNTRY',l_params);
245: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
246: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_cntry_code||'-'||to_char(p_unique_key), l_params);
247: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
248: p_event_key => p_cntry_code||'-'||to_char(p_unique_key),
249: p_parameters => l_params);
250:

Line 247: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

243: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
244: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'CNTRY',l_params);
245: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
246: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_cntry_code||'-'||to_char(p_unique_key), l_params);
247: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
248: p_event_key => p_cntry_code||'-'||to_char(p_unique_key),
249: p_parameters => l_params);
250:
251: open csr_gen_msg(p_cntry_code||'-'||to_char(p_unique_key));

Line 410: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

406: LAST_UPDATE_DATE,EVENT_KEY )
407: values(p_cntry_code,p_state_code,p_state_desc,p_enable_flag,'QUEUED',p_effective_date,p_last_update_date,p_state_code||'-'||to_char(p_unique_key));
408: commit;
409:
410: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
411: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'STATE',l_params);
412: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
413: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_state_code||'-'||to_char(p_unique_key), l_params);
414: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 411: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'STATE',l_params);

407: values(p_cntry_code,p_state_code,p_state_desc,p_enable_flag,'QUEUED',p_effective_date,p_last_update_date,p_state_code||'-'||to_char(p_unique_key));
408: commit;
409:
410: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
411: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'STATE',l_params);
412: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
413: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_state_code||'-'||to_char(p_unique_key), l_params);
414: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
415: p_event_key => p_state_code||'-'||to_char(p_unique_key),

Line 412: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

408: commit;
409:
410: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
411: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'STATE',l_params);
412: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
413: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_state_code||'-'||to_char(p_unique_key), l_params);
414: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
415: p_event_key => p_state_code||'-'||to_char(p_unique_key),
416: p_parameters => l_params);

Line 413: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_state_code||'-'||to_char(p_unique_key), l_params);

409:
410: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
411: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'STATE',l_params);
412: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
413: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_state_code||'-'||to_char(p_unique_key), l_params);
414: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
415: p_event_key => p_state_code||'-'||to_char(p_unique_key),
416: p_parameters => l_params);
417: end if;

Line 414: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

410: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
411: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'STATE',l_params);
412: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
413: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_state_code||'-'||to_char(p_unique_key), l_params);
414: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
415: p_event_key => p_state_code||'-'||to_char(p_unique_key),
416: p_parameters => l_params);
417: end if;
418: close fet_state_qsync;

Line 448: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

444: STATE_DESCRIPTION,ENABLE_FLAG,STATUS,EFFECTIVE_STATUS_DATE,
445: LAST_UPDATE_DATE,EVENT_KEY ) values(p_cntry_code,p_state_code,p_state_desc,p_enable_flag,'QUEUED',p_effective_date,p_last_update_date,p_state_code||'-'||to_char(p_unique_key));
446: commit;
447:
448: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
449: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'STATE',l_params);
450: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
451: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_state_code||'-'||to_char(p_unique_key), l_params);
452: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 449: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'STATE',l_params);

445: LAST_UPDATE_DATE,EVENT_KEY ) values(p_cntry_code,p_state_code,p_state_desc,p_enable_flag,'QUEUED',p_effective_date,p_last_update_date,p_state_code||'-'||to_char(p_unique_key));
446: commit;
447:
448: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
449: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'STATE',l_params);
450: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
451: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_state_code||'-'||to_char(p_unique_key), l_params);
452: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
453: p_event_key => p_state_code||'-'||to_char(p_unique_key),

Line 450: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

446: commit;
447:
448: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
449: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'STATE',l_params);
450: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
451: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_state_code||'-'||to_char(p_unique_key), l_params);
452: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
453: p_event_key => p_state_code||'-'||to_char(p_unique_key),
454: p_parameters => l_params);

Line 451: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_state_code||'-'||to_char(p_unique_key), l_params);

447:
448: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
449: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'STATE',l_params);
450: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
451: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_state_code||'-'||to_char(p_unique_key), l_params);
452: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
453: p_event_key => p_state_code||'-'||to_char(p_unique_key),
454: p_parameters => l_params);
455:

Line 452: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

448: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
449: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'STATE',l_params);
450: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
451: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_state_code||'-'||to_char(p_unique_key), l_params);
452: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
453: p_event_key => p_state_code||'-'||to_char(p_unique_key),
454: p_parameters => l_params);
455:
456: open csr_gen_msg(p_state_code||'-'||to_char(p_unique_key));

Line 748: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

744: p_tel_no_3,p_loc_info_13, p_loc_info_14,p_loc_info_15,p_loc_info_16,p_loc_info_17,p_loc_info_18,
745: p_loc_info_19,p_loc_info_20,'QUEUED',p_effective_date,p_last_update_date,p_loc_id||'-'||to_char(p_unique_key));
746: commit;
747:
748: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
749: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'LOCN',l_params);
750: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
751: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_loc_id||'-'||to_char(p_unique_key), l_params);
752: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 749: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'LOCN',l_params);

745: p_loc_info_19,p_loc_info_20,'QUEUED',p_effective_date,p_last_update_date,p_loc_id||'-'||to_char(p_unique_key));
746: commit;
747:
748: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
749: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'LOCN',l_params);
750: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
751: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_loc_id||'-'||to_char(p_unique_key), l_params);
752: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
753: p_event_key => p_loc_id||'-'||to_char(p_unique_key),

Line 750: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

746: commit;
747:
748: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
749: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'LOCN',l_params);
750: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
751: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_loc_id||'-'||to_char(p_unique_key), l_params);
752: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
753: p_event_key => p_loc_id||'-'||to_char(p_unique_key),
754: p_parameters => l_params);

Line 751: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_loc_id||'-'||to_char(p_unique_key), l_params);

747:
748: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
749: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'LOCN',l_params);
750: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
751: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_loc_id||'-'||to_char(p_unique_key), l_params);
752: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
753: p_event_key => p_loc_id||'-'||to_char(p_unique_key),
754: p_parameters => l_params);
755:

Line 752: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

748: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
749: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'LOCN',l_params);
750: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
751: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_loc_id||'-'||to_char(p_unique_key), l_params);
752: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
753: p_event_key => p_loc_id||'-'||to_char(p_unique_key),
754: p_parameters => l_params);
755:
756:

Line 825: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

821: p_tel_no_3,p_loc_info_13, p_loc_info_14,p_loc_info_15,p_loc_info_16,p_loc_info_17,p_loc_info_18,
822: p_loc_info_19,p_loc_info_20,'QUEUED',p_effective_date,p_last_update_date,p_loc_id||'-'||to_char(p_unique_key));
823: commit;
824:
825: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
826: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'LOCN',l_params);
827: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
828: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_loc_id||'-'||to_char(p_unique_key), l_params);
829: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 826: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'LOCN',l_params);

822: p_loc_info_19,p_loc_info_20,'QUEUED',p_effective_date,p_last_update_date,p_loc_id||'-'||to_char(p_unique_key));
823: commit;
824:
825: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
826: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'LOCN',l_params);
827: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
828: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_loc_id||'-'||to_char(p_unique_key), l_params);
829: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
830: p_event_key => p_loc_id||'-'||to_char(p_unique_key),

Line 827: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

823: commit;
824:
825: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
826: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'LOCN',l_params);
827: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
828: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_loc_id||'-'||to_char(p_unique_key), l_params);
829: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
830: p_event_key => p_loc_id||'-'||to_char(p_unique_key),
831: p_parameters => l_params);

Line 828: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_loc_id||'-'||to_char(p_unique_key), l_params);

824:
825: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
826: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'LOCN',l_params);
827: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
828: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_loc_id||'-'||to_char(p_unique_key), l_params);
829: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
830: p_event_key => p_loc_id||'-'||to_char(p_unique_key),
831: p_parameters => l_params);
832:

Line 829: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

825: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
826: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'LOCN',l_params);
827: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
828: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', p_loc_id||'-'||to_char(p_unique_key), l_params);
829: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
830: p_event_key => p_loc_id||'-'||to_char(p_unique_key),
831: p_parameters => l_params);
832:
833: open csr_gen_msg(p_loc_id||'-'||to_char(p_unique_key));

Line 1244: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

1240:
1241: commit;
1242:
1243:
1244: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1245: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PERSON',l_params);
1246: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1247: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key), l_params);
1248: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 1245: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PERSON',l_params);

1241: commit;
1242:
1243:
1244: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1245: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PERSON',l_params);
1246: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1247: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key), l_params);
1248: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1249: p_event_key => L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key),

Line 1246: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

1242:
1243:
1244: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1245: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PERSON',l_params);
1246: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1247: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key), l_params);
1248: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1249: p_event_key => L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key),
1250: p_parameters => l_params);

Line 1247: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key), l_params);

1243:
1244: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1245: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PERSON',l_params);
1246: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1247: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key), l_params);
1248: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1249: p_event_key => L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key),
1250: p_parameters => l_params);
1251:

Line 1248: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

1244: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1245: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PERSON',l_params);
1246: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1247: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key), l_params);
1248: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1249: p_event_key => L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key),
1250: p_parameters => l_params);
1251:
1252: open csr_gen_msg(L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key));

Line 1315: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

1311: p_last_update_date,L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key));
1312:
1313: commit;
1314:
1315: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1316: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PERSON',l_params);
1317: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1318: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key), l_params);
1319: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 1316: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PERSON',l_params);

1312:
1313: commit;
1314:
1315: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1316: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PERSON',l_params);
1317: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1318: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key), l_params);
1319: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1320: p_event_key => L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key),

Line 1317: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

1313: commit;
1314:
1315: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1316: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PERSON',l_params);
1317: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1318: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key), l_params);
1319: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1320: p_event_key => L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key),
1321: p_parameters => l_params);

Line 1318: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key), l_params);

1314:
1315: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1316: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PERSON',l_params);
1317: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1318: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key), l_params);
1319: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1320: p_event_key => L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key),
1321: p_parameters => l_params);
1322:

Line 1319: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

1315: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1316: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PERSON',l_params);
1317: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1318: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key), l_params);
1319: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1320: p_event_key => L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key),
1321: p_parameters => l_params);
1322:
1323: open csr_gen_msg(L_EMPLOYEE_NUMBER||'-'||to_char(p_unique_key));

Line 1615: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

1611: ,WorkForceDeltaType.EMPLID(1)||WorkForceDeltaType.BUSINESS_UNIT(1)||
1612: WorkForceDeltaType.JOBCODE(1)||'-'||to_char(p_unique_key));
1613: commit;
1614:
1615: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1616: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'WORKFORCE',l_params);
1617: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1618: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', WorkForceDeltaType.EMPLID(1)||WorkForceDeltaType.BUSINESS_UNIT(1)||
1619: WorkForceDeltaType.JOBCODE(1)||'-'||to_char(p_unique_key), l_params);

Line 1616: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'WORKFORCE',l_params);

1612: WorkForceDeltaType.JOBCODE(1)||'-'||to_char(p_unique_key));
1613: commit;
1614:
1615: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1616: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'WORKFORCE',l_params);
1617: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1618: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', WorkForceDeltaType.EMPLID(1)||WorkForceDeltaType.BUSINESS_UNIT(1)||
1619: WorkForceDeltaType.JOBCODE(1)||'-'||to_char(p_unique_key), l_params);
1620:

Line 1617: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

1613: commit;
1614:
1615: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1616: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'WORKFORCE',l_params);
1617: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1618: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', WorkForceDeltaType.EMPLID(1)||WorkForceDeltaType.BUSINESS_UNIT(1)||
1619: WorkForceDeltaType.JOBCODE(1)||'-'||to_char(p_unique_key), l_params);
1620:
1621: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 1618: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', WorkForceDeltaType.EMPLID(1)||WorkForceDeltaType.BUSINESS_UNIT(1)||

1614:
1615: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1616: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'WORKFORCE',l_params);
1617: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1618: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', WorkForceDeltaType.EMPLID(1)||WorkForceDeltaType.BUSINESS_UNIT(1)||
1619: WorkForceDeltaType.JOBCODE(1)||'-'||to_char(p_unique_key), l_params);
1620:
1621: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1622: p_event_key => WorkForceDeltaType.EMPLID(1)||WorkForceDeltaType.BUSINESS_UNIT(1)||

Line 1621: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

1617: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1618: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', WorkForceDeltaType.EMPLID(1)||WorkForceDeltaType.BUSINESS_UNIT(1)||
1619: WorkForceDeltaType.JOBCODE(1)||'-'||to_char(p_unique_key), l_params);
1620:
1621: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1622: p_event_key => WorkForceDeltaType.EMPLID(1)||WorkForceDeltaType.BUSINESS_UNIT(1)||
1623: WorkForceDeltaType.JOBCODE(1)||'-'||to_char(p_unique_key),
1624: p_parameters => l_params);
1625:

Line 1776: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

1772: ,WorkForceDeltaType.EMPLID(I)||WorkForceDeltaType.BUSINESS_UNIT(I)||
1773: WorkForceDeltaType.JOBCODE(I)||'-'||to_char(p_unique_key));
1774: commit;
1775:
1776: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1777: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'WORKFORCE',l_params);
1778: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1779: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', WorkForceDeltaType.EMPLID(I)||WorkForceDeltaType.BUSINESS_UNIT(I)||
1780: WorkForceDeltaType.JOBCODE(I)||'-'||to_char(p_unique_key), l_params);

Line 1777: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'WORKFORCE',l_params);

1773: WorkForceDeltaType.JOBCODE(I)||'-'||to_char(p_unique_key));
1774: commit;
1775:
1776: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1777: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'WORKFORCE',l_params);
1778: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1779: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', WorkForceDeltaType.EMPLID(I)||WorkForceDeltaType.BUSINESS_UNIT(I)||
1780: WorkForceDeltaType.JOBCODE(I)||'-'||to_char(p_unique_key), l_params);
1781:

Line 1778: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

1774: commit;
1775:
1776: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1777: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'WORKFORCE',l_params);
1778: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1779: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', WorkForceDeltaType.EMPLID(I)||WorkForceDeltaType.BUSINESS_UNIT(I)||
1780: WorkForceDeltaType.JOBCODE(I)||'-'||to_char(p_unique_key), l_params);
1781:
1782: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 1779: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', WorkForceDeltaType.EMPLID(I)||WorkForceDeltaType.BUSINESS_UNIT(I)||

1775:
1776: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1777: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'WORKFORCE',l_params);
1778: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1779: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', WorkForceDeltaType.EMPLID(I)||WorkForceDeltaType.BUSINESS_UNIT(I)||
1780: WorkForceDeltaType.JOBCODE(I)||'-'||to_char(p_unique_key), l_params);
1781:
1782: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1783: p_event_key => WorkForceDeltaType.EMPLID(I)||WorkForceDeltaType.BUSINESS_UNIT(I)||

Line 1782: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

1778: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1779: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', WorkForceDeltaType.EMPLID(I)||WorkForceDeltaType.BUSINESS_UNIT(I)||
1780: WorkForceDeltaType.JOBCODE(I)||'-'||to_char(p_unique_key), l_params);
1781:
1782: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1783: p_event_key => WorkForceDeltaType.EMPLID(I)||WorkForceDeltaType.BUSINESS_UNIT(I)||
1784: WorkForceDeltaType.JOBCODE(I)||'-'||to_char(p_unique_key),
1785: p_parameters => l_params);
1786:

Line 1982: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

1978: commit;
1979:
1980:
1981:
1982: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1983: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'JOBCODE',l_params);
1984: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1985: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID',Jobcodedeltatype.SETID(1)||Jobcodedeltatype.JOBCODE(1)||'-'||to_char(p_unique_key) , l_params);
1986: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 1983: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'JOBCODE',l_params);

1979:
1980:
1981:
1982: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1983: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'JOBCODE',l_params);
1984: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1985: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID',Jobcodedeltatype.SETID(1)||Jobcodedeltatype.JOBCODE(1)||'-'||to_char(p_unique_key) , l_params);
1986: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1987: p_event_key => Jobcodedeltatype.SETID(1)||Jobcodedeltatype.JOBCODE(1)||'-'||to_char(p_unique_key),

Line 1984: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

1980:
1981:
1982: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1983: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'JOBCODE',l_params);
1984: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1985: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID',Jobcodedeltatype.SETID(1)||Jobcodedeltatype.JOBCODE(1)||'-'||to_char(p_unique_key) , l_params);
1986: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1987: p_event_key => Jobcodedeltatype.SETID(1)||Jobcodedeltatype.JOBCODE(1)||'-'||to_char(p_unique_key),
1988: p_parameters => l_params);

Line 1985: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID',Jobcodedeltatype.SETID(1)||Jobcodedeltatype.JOBCODE(1)||'-'||to_char(p_unique_key) , l_params);

1981:
1982: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1983: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'JOBCODE',l_params);
1984: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1985: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID',Jobcodedeltatype.SETID(1)||Jobcodedeltatype.JOBCODE(1)||'-'||to_char(p_unique_key) , l_params);
1986: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1987: p_event_key => Jobcodedeltatype.SETID(1)||Jobcodedeltatype.JOBCODE(1)||'-'||to_char(p_unique_key),
1988: p_parameters => l_params);
1989:

Line 1986: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

1982: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
1983: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'JOBCODE',l_params);
1984: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
1985: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID',Jobcodedeltatype.SETID(1)||Jobcodedeltatype.JOBCODE(1)||'-'||to_char(p_unique_key) , l_params);
1986: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
1987: p_event_key => Jobcodedeltatype.SETID(1)||Jobcodedeltatype.JOBCODE(1)||'-'||to_char(p_unique_key),
1988: p_parameters => l_params);
1989:
1990: open csr_gen_msg(Jobcodedeltatype.SETID(1)||Jobcodedeltatype.JOBCODE(1)||'-'||to_char(p_unique_key));

Line 2094: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

2090: commit;
2091:
2092:
2093:
2094: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2095: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'JOBCODE',l_params);
2096: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2097: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID',Jobcodedeltatype.SETID(I)||Jobcodedeltatype.JOBCODE(I)||'-'||to_char(p_unique_key) , l_params);
2098: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 2095: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'JOBCODE',l_params);

2091:
2092:
2093:
2094: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2095: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'JOBCODE',l_params);
2096: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2097: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID',Jobcodedeltatype.SETID(I)||Jobcodedeltatype.JOBCODE(I)||'-'||to_char(p_unique_key) , l_params);
2098: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2099: p_event_key => Jobcodedeltatype.SETID(I)||Jobcodedeltatype.JOBCODE(I)||'-'||to_char(p_unique_key),

Line 2096: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

2092:
2093:
2094: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2095: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'JOBCODE',l_params);
2096: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2097: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID',Jobcodedeltatype.SETID(I)||Jobcodedeltatype.JOBCODE(I)||'-'||to_char(p_unique_key) , l_params);
2098: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2099: p_event_key => Jobcodedeltatype.SETID(I)||Jobcodedeltatype.JOBCODE(I)||'-'||to_char(p_unique_key),
2100: p_parameters => l_params);

Line 2097: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID',Jobcodedeltatype.SETID(I)||Jobcodedeltatype.JOBCODE(I)||'-'||to_char(p_unique_key) , l_params);

2093:
2094: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2095: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'JOBCODE',l_params);
2096: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2097: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID',Jobcodedeltatype.SETID(I)||Jobcodedeltatype.JOBCODE(I)||'-'||to_char(p_unique_key) , l_params);
2098: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2099: p_event_key => Jobcodedeltatype.SETID(I)||Jobcodedeltatype.JOBCODE(I)||'-'||to_char(p_unique_key),
2100: p_parameters => l_params);
2101:

Line 2098: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

2094: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2095: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'JOBCODE',l_params);
2096: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2097: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID',Jobcodedeltatype.SETID(I)||Jobcodedeltatype.JOBCODE(I)||'-'||to_char(p_unique_key) , l_params);
2098: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2099: p_event_key => Jobcodedeltatype.SETID(I)||Jobcodedeltatype.JOBCODE(I)||'-'||to_char(p_unique_key),
2100: p_parameters => l_params);
2101:
2102: open csr_gen_msg(Jobcodedeltatype.SETID(1)||Jobcodedeltatype.JOBCODE(1)||'-'||to_char(p_unique_key));

Line 2310: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

2306: values(p_bg_id,p_dept_id,p_bg_name,p_eff_date,p_eff_status,p_bg_id,p_bg_id,p_loc_id,p_person_id,p_full_name,p_last_update_date,'QUEUED',p_effective_date,
2307: to_char(p_dept_id)||'-'||to_char(p_unique_key));
2308: commit;
2309:
2310: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2311: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'ORGN',l_params);
2312: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2313: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_dept_id)||'-'||to_char(p_unique_key), l_params);
2314: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 2311: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'ORGN',l_params);

2307: to_char(p_dept_id)||'-'||to_char(p_unique_key));
2308: commit;
2309:
2310: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2311: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'ORGN',l_params);
2312: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2313: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_dept_id)||'-'||to_char(p_unique_key), l_params);
2314: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2315: p_event_key => to_char(p_dept_id)||'-'||to_char(p_unique_key),

Line 2312: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

2308: commit;
2309:
2310: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2311: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'ORGN',l_params);
2312: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2313: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_dept_id)||'-'||to_char(p_unique_key), l_params);
2314: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2315: p_event_key => to_char(p_dept_id)||'-'||to_char(p_unique_key),
2316: p_parameters => l_params);

Line 2313: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_dept_id)||'-'||to_char(p_unique_key), l_params);

2309:
2310: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2311: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'ORGN',l_params);
2312: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2313: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_dept_id)||'-'||to_char(p_unique_key), l_params);
2314: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2315: p_event_key => to_char(p_dept_id)||'-'||to_char(p_unique_key),
2316: p_parameters => l_params);
2317:

Line 2314: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

2310: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2311: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'ORGN',l_params);
2312: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2313: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_dept_id)||'-'||to_char(p_unique_key), l_params);
2314: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2315: p_event_key => to_char(p_dept_id)||'-'||to_char(p_unique_key),
2316: p_parameters => l_params);
2317:
2318: open csr_gen_msg(to_char(p_dept_id)||'-'||to_char(p_unique_key));

Line 2363: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

2359: )
2360: values(p_bg_id,p_dept_id,p_bg_name,p_eff_date,p_eff_status,p_bg_id,p_bg_id,p_loc_id,p_person_id,p_full_name,p_last_update_date,'QUEUED',p_effective_date,
2361: to_char(p_dept_id)||'-'||to_char(p_unique_key));
2362: commit;
2363: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2364: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'ORGN',l_params);
2365: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2366: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_dept_id)||'-'||to_char(p_unique_key), l_params);
2367: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 2364: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'ORGN',l_params);

2360: values(p_bg_id,p_dept_id,p_bg_name,p_eff_date,p_eff_status,p_bg_id,p_bg_id,p_loc_id,p_person_id,p_full_name,p_last_update_date,'QUEUED',p_effective_date,
2361: to_char(p_dept_id)||'-'||to_char(p_unique_key));
2362: commit;
2363: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2364: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'ORGN',l_params);
2365: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2366: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_dept_id)||'-'||to_char(p_unique_key), l_params);
2367: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2368: p_event_key => to_char(p_dept_id)||'-'||to_char(p_unique_key),

Line 2365: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

2361: to_char(p_dept_id)||'-'||to_char(p_unique_key));
2362: commit;
2363: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2364: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'ORGN',l_params);
2365: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2366: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_dept_id)||'-'||to_char(p_unique_key), l_params);
2367: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2368: p_event_key => to_char(p_dept_id)||'-'||to_char(p_unique_key),
2369: p_parameters => l_params);

Line 2366: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_dept_id)||'-'||to_char(p_unique_key), l_params);

2362: commit;
2363: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2364: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'ORGN',l_params);
2365: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2366: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_dept_id)||'-'||to_char(p_unique_key), l_params);
2367: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2368: p_event_key => to_char(p_dept_id)||'-'||to_char(p_unique_key),
2369: p_parameters => l_params);
2370:

Line 2367: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

2363: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2364: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'ORGN',l_params);
2365: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2366: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_dept_id)||'-'||to_char(p_unique_key), l_params);
2367: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2368: p_event_key => to_char(p_dept_id)||'-'||to_char(p_unique_key),
2369: p_parameters => l_params);
2370:
2371: open csr_gen_msg(to_char(p_dept_id)||'-'||to_char(p_unique_key));

Line 2539: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

2535: to_char(p_bg_id)||'-'||to_char(p_unique_key));
2536: commit;
2537:
2538:
2539: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2540: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'BGRP',l_params);
2541: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2542: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_bg_id)||'-'||to_char(p_unique_key), l_params);
2543: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 2540: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'BGRP',l_params);

2536: commit;
2537:
2538:
2539: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2540: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'BGRP',l_params);
2541: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2542: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_bg_id)||'-'||to_char(p_unique_key), l_params);
2543: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2544: p_event_key => to_char(p_bg_id)||'-'||to_char(p_unique_key),

Line 2541: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

2537:
2538:
2539: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2540: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'BGRP',l_params);
2541: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2542: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_bg_id)||'-'||to_char(p_unique_key), l_params);
2543: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2544: p_event_key => to_char(p_bg_id)||'-'||to_char(p_unique_key),
2545: p_parameters => l_params);

Line 2542: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_bg_id)||'-'||to_char(p_unique_key), l_params);

2538:
2539: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2540: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'BGRP',l_params);
2541: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2542: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_bg_id)||'-'||to_char(p_unique_key), l_params);
2543: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2544: p_event_key => to_char(p_bg_id)||'-'||to_char(p_unique_key),
2545: p_parameters => l_params);
2546:

Line 2543: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

2539: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2540: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'BGRP',l_params);
2541: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2542: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_bg_id)||'-'||to_char(p_unique_key), l_params);
2543: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2544: p_event_key => to_char(p_bg_id)||'-'||to_char(p_unique_key),
2545: p_parameters => l_params);
2546:
2547: open csr_gen_msg(to_char(p_bg_id)||'-'||to_char(p_unique_key));

Line 2579: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

2575: EVENT_KEY)
2576: values(p_bg_id,p_bg_name,p_eff_date,p_eff_status,p_last_update_date,'QUEUED',p_effective_date,
2577: to_char(p_bg_id)||'-'||to_char(p_unique_key));
2578: commit;
2579: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2580: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'BGRP',l_params);
2581: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2582: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_bg_id)||'-'||to_char(p_unique_key), l_params);
2583: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 2580: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'BGRP',l_params);

2576: values(p_bg_id,p_bg_name,p_eff_date,p_eff_status,p_last_update_date,'QUEUED',p_effective_date,
2577: to_char(p_bg_id)||'-'||to_char(p_unique_key));
2578: commit;
2579: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2580: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'BGRP',l_params);
2581: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2582: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_bg_id)||'-'||to_char(p_unique_key), l_params);
2583: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2584: p_event_key => to_char(p_bg_id)||'-'||to_char(p_unique_key),

Line 2581: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

2577: to_char(p_bg_id)||'-'||to_char(p_unique_key));
2578: commit;
2579: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2580: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'BGRP',l_params);
2581: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2582: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_bg_id)||'-'||to_char(p_unique_key), l_params);
2583: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2584: p_event_key => to_char(p_bg_id)||'-'||to_char(p_unique_key),
2585: p_parameters => l_params);

Line 2582: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_bg_id)||'-'||to_char(p_unique_key), l_params);

2578: commit;
2579: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2580: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'BGRP',l_params);
2581: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2582: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_bg_id)||'-'||to_char(p_unique_key), l_params);
2583: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2584: p_event_key => to_char(p_bg_id)||'-'||to_char(p_unique_key),
2585: p_parameters => l_params);
2586:

Line 2583: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

2579: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2580: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'BGRP',l_params);
2581: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2582: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_bg_id)||'-'||to_char(p_unique_key), l_params);
2583: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2584: p_event_key => to_char(p_bg_id)||'-'||to_char(p_unique_key),
2585: p_parameters => l_params);
2586:
2587: open csr_gen_msg(to_char(p_bg_id)||'-'||to_char(p_unique_key));

Line 2774: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

2770: to_char(p_pyrl_id)||'-'||to_char(p_unique_key));
2771: commit;
2772:
2773:
2774: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2775: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PYRL',l_params);
2776: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2777: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_pyrl_id)||'-'||to_char(p_unique_key), l_params);
2778: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 2775: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PYRL',l_params);

2771: commit;
2772:
2773:
2774: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2775: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PYRL',l_params);
2776: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2777: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_pyrl_id)||'-'||to_char(p_unique_key), l_params);
2778: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2779: p_event_key => to_char(p_pyrl_id)||'-'||to_char(p_unique_key),

Line 2776: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

2772:
2773:
2774: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2775: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PYRL',l_params);
2776: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2777: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_pyrl_id)||'-'||to_char(p_unique_key), l_params);
2778: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2779: p_event_key => to_char(p_pyrl_id)||'-'||to_char(p_unique_key),
2780: p_parameters => l_params);

Line 2777: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_pyrl_id)||'-'||to_char(p_unique_key), l_params);

2773:
2774: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2775: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PYRL',l_params);
2776: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2777: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_pyrl_id)||'-'||to_char(p_unique_key), l_params);
2778: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2779: p_event_key => to_char(p_pyrl_id)||'-'||to_char(p_unique_key),
2780: p_parameters => l_params);
2781:

Line 2778: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

2774: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2775: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PYRL',l_params);
2776: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2777: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_pyrl_id)||'-'||to_char(p_unique_key), l_params);
2778: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2779: p_event_key => to_char(p_pyrl_id)||'-'||to_char(p_unique_key),
2780: p_parameters => l_params);
2781:
2782: open csr_gen_msg(to_char(p_pyrl_id)||'-'||to_char(p_unique_key));

Line 2821: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);

2817: )
2818: values(p_pyrl_id,p_pyrl_name,p_bg_id,p_eff_date,p_eff_status,p_last_update_date,'QUEUED',p_effective_date,
2819: to_char(p_pyrl_id)||'-'||to_char(p_unique_key));
2820: commit;
2821: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2822: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PYRL',l_params);
2823: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2824: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_pyrl_id)||'-'||to_char(p_unique_key), l_params);
2825: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

Line 2822: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PYRL',l_params);

2818: values(p_pyrl_id,p_pyrl_name,p_bg_id,p_eff_date,p_eff_status,p_last_update_date,'QUEUED',p_effective_date,
2819: to_char(p_pyrl_id)||'-'||to_char(p_unique_key));
2820: commit;
2821: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2822: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PYRL',l_params);
2823: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2824: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_pyrl_id)||'-'||to_char(p_unique_key), l_params);
2825: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2826: p_event_key => to_char(p_pyrl_id)||'-'||to_char(p_unique_key),

Line 2823: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);

2819: to_char(p_pyrl_id)||'-'||to_char(p_unique_key));
2820: commit;
2821: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2822: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PYRL',l_params);
2823: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2824: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_pyrl_id)||'-'||to_char(p_unique_key), l_params);
2825: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2826: p_event_key => to_char(p_pyrl_id)||'-'||to_char(p_unique_key),
2827: p_parameters => l_params);

Line 2824: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_pyrl_id)||'-'||to_char(p_unique_key), l_params);

2820: commit;
2821: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2822: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PYRL',l_params);
2823: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2824: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_pyrl_id)||'-'||to_char(p_unique_key), l_params);
2825: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2826: p_event_key => to_char(p_pyrl_id)||'-'||to_char(p_unique_key),
2827: p_parameters => l_params);
2828:

Line 2825: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',

2821: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'HRHD', l_params);
2822: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'PYRL',l_params);
2823: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', to_char(p_party_site_id), l_params);
2824: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', to_char(p_pyrl_id)||'-'||to_char(p_unique_key), l_params);
2825: WF_EVENT.Raise(p_event_name => 'oracle.apps.per.hrhdrir.xml.out',
2826: p_event_key => to_char(p_pyrl_id)||'-'||to_char(p_unique_key),
2827: p_parameters => l_params);
2828:
2829: open csr_gen_msg(to_char(p_pyrl_id)||'-'||to_char(p_unique_key));