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.

[Home] [Help]

APPS.HR_HRHD_RIR_WF dependencies on WF_ENGINE

Line 30: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

26: p_date_to VARCHAR2(100);
27:
28: begin
29:
30: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
31: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
32: p_event_data := p_event_message.event_data;
33:
34: -- extract the job id from the xml event message

Line 31: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');

27:
28: begin
29:
30: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
31: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
32: p_event_data := p_event_message.event_data;
33:
34: -- extract the job id from the xml event message
35: v_document := dbms_xmldom.newdomdocument(p_event_data);

Line 111: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

107: p_date_to VARCHAR2(100);
108:
109: begin
110:
111: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
112: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
113: p_event_data := p_event_message.event_data;
114:
115: -- extract the job id from the xml event message

Line 112: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');

108:
109: begin
110:
111: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
112: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
113: p_event_data := p_event_message.event_data;
114:
115: -- extract the job id from the xml event message
116: v_document := dbms_xmldom.newdomdocument(p_event_data);

Line 188: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

184: p_date_to VARCHAR2(100);
185:
186: begin
187:
188: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
189: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
190: p_event_data := p_event_message.event_data;
191:
192: -- extract the job id from the xml event message

Line 189: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');

185:
186: begin
187:
188: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
189: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
190: p_event_data := p_event_message.event_data;
191:
192: -- extract the job id from the xml event message
193: v_document := dbms_xmldom.newdomdocument(p_event_data);

Line 247: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

243: p_inactive_date VARCHAR2(100);
244:
245: begin
246:
247: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
248: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
249: p_event_data := p_event_message.event_data;
250:
251: -- extract the location id from the xml event message

Line 248: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');

244:
245: begin
246:
247: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
248: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
249: p_event_data := p_event_message.event_data;
250:
251: -- extract the location id from the xml event message
252: v_document := dbms_xmldom.newdomdocument(p_event_data);

Line 332: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

328: p_inactive_date VARCHAR2(100);
329:
330: begin
331:
332: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
333: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
334: p_event_data := p_event_message.event_data;
335:
336: -- extract the location id from the xml event message

Line 333: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');

329:
330: begin
331:
332: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
333: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
334: p_event_data := p_event_message.event_data;
335:
336: -- extract the location id from the xml event message
337: v_document := dbms_xmldom.newdomdocument(p_event_data);

Line 414: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

410: p_inactive_date VARCHAR2(100);
411:
412: begin
413:
414: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
415: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
416: p_event_data := p_event_message.event_data;
417:
418: -- extract the location id from the xml event message

Line 415: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');

411:
412: begin
413:
414: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
415: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
416: p_event_data := p_event_message.event_data;
417:
418: -- extract the location id from the xml event message
419: v_document := dbms_xmldom.newdomdocument(p_event_data);

Line 484: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

480:
481:
482: begin
483:
484: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
485: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
486: p_event_data := p_event_message.event_data;
487:
488: -- extract the organization id from the xml event message

Line 485: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');

481:
482: begin
483:
484: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
485: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
486: p_event_data := p_event_message.event_data;
487:
488: -- extract the organization id from the xml event message
489: v_document := dbms_xmldom.newdomdocument(p_event_data);

Line 584: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

580: and org.organization_id = p_org_id;
581:
582: begin
583:
584: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
585: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
586: p_event_data := p_event_message.event_data;
587:
588: -- extract the organization id from the xml event message

Line 585: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');

581:
582: begin
583:
584: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
585: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
586: p_event_data := p_event_message.event_data;
587:
588: -- extract the organization id from the xml event message
589: v_document := dbms_xmldom.newdomdocument(p_event_data);

Line 681: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

677: and org.organization_id = p_org_id;
678:
679: begin
680:
681: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
682: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
683: p_event_data := p_event_message.event_data;
684:
685: -- extract the organization id from the xml event message

Line 682: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');

678:
679: begin
680:
681: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
682: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
683: p_event_data := p_event_message.event_data;
684:
685: -- extract the organization id from the xml event message
686: v_document := dbms_xmldom.newdomdocument(p_event_data);

Line 750: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

746:
747:
748: begin
749:
750: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
751: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
752: p_event_data := p_event_message.event_data;
753:
754: -- extract the person id from the xml event message

Line 751: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');

747:
748: begin
749:
750: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
751: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
752: p_event_data := p_event_message.event_data;
753:
754: -- extract the person id from the xml event message
755: v_document := dbms_xmldom.newdomdocument(p_event_data);

Line 877: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

873:
874:
875: begin
876:
877: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
878: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
879: p_event_data := p_event_message.event_data;
880:
881: -- extract the person id from the xml event message

Line 878: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');

874:
875: begin
876:
877: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
878: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
879: p_event_data := p_event_message.event_data;
880:
881: -- extract the person id from the xml event message
882: v_document := dbms_xmldom.newdomdocument(p_event_data);

Line 1000: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

996:
997:
998: begin
999:
1000: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1001: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1002: p_event_data := p_event_message.event_data;
1003:
1004: -- extract the person id from the xml event message

Line 1001: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');

997:
998: begin
999:
1000: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1001: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1002: p_event_data := p_event_message.event_data;
1003:
1004: -- extract the person id from the xml event message
1005: v_document := dbms_xmldom.newdomdocument(p_event_data);

Line 1117: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

1113: and p_eff_date between date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
1114:
1115: begin
1116:
1117: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1118: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1119: p_event_data := p_event_message.event_data;
1120:
1121: -- extract the person id from the xml event message

Line 1118: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');

1114:
1115: begin
1116:
1117: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1118: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1119: p_event_data := p_event_message.event_data;
1120:
1121: -- extract the person id from the xml event message
1122: v_document := dbms_xmldom.newdomdocument(p_event_data);

Line 1225: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

1221: p_eff_start_date per_all_assignments_f.effective_start_date%type;
1222:
1223: begin
1224:
1225: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1226: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1227: p_event_data := p_event_message.event_data;
1228: v_document := dbms_xmldom.newdomdocument(p_event_data);
1229:

Line 1226: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');

1222:
1223: begin
1224:
1225: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1226: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1227: p_event_data := p_event_message.event_data;
1228: v_document := dbms_xmldom.newdomdocument(p_event_data);
1229:
1230:

Line 1337: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

1333: p_eff_start_date per_all_assignments_f.effective_start_date%type;
1334:
1335: begin
1336:
1337: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1338: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1339: p_event_data := p_event_message.event_data;
1340: v_document := dbms_xmldom.newdomdocument(p_event_data);
1341:

Line 1338: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');

1334:
1335: begin
1336:
1337: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1338: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1339: p_event_data := p_event_message.event_data;
1340: v_document := dbms_xmldom.newdomdocument(p_event_data);
1341:
1342: