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_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 485: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

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

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

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

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

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

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

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

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

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

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

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

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

758:
759:
760: begin
761:
762: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
763: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
764: p_event_data := p_event_message.event_data;
765:
766: -- extract the person id from the xml event message

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

759:
760: begin
761:
762: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
763: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
764: p_event_data := p_event_message.event_data;
765:
766: -- extract the person id from the xml event message
767: v_document := dbms_xmldom.newdomdocument(p_event_data);

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

949:
950:
951: begin
952:
953: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
954: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
955: p_event_data := p_event_message.event_data;
956: p_event_name := p_event_message.event_name;
957:

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

950:
951: begin
952:
953: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
954: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
955: p_event_data := p_event_message.event_data;
956: p_event_name := p_event_message.event_name;
957:
958: -- extract the person id from the xml event message

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

1149:
1150:
1151: begin
1152:
1153: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1154: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1155: p_event_data := p_event_message.event_data;
1156:
1157: -- extract the person id from the xml event message

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

1150:
1151: begin
1152:
1153: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1154: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1155: p_event_data := p_event_message.event_data;
1156:
1157: -- extract the person id from the xml event message
1158: v_document := dbms_xmldom.newdomdocument(p_event_data);

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

1273: and p_eff_date between date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
1274:
1275: begin
1276:
1277: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1278: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1279: p_event_data := p_event_message.event_data;
1280:
1281: -- extract the person id from the xml event message

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

1274:
1275: begin
1276:
1277: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1278: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1279: p_event_data := p_event_message.event_data;
1280:
1281: -- extract the person id from the xml event message
1282: v_document := dbms_xmldom.newdomdocument(p_event_data);

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

1388: l_transaction_id_canonical Varchar2(30);
1389:
1390: begin
1391:
1392: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1393: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1394: p_event_data := p_event_message.event_data;
1395: v_document := dbms_xmldom.newdomdocument(p_event_data);
1396:

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

1389:
1390: begin
1391:
1392: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1393: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1394: p_event_data := p_event_message.event_data;
1395: v_document := dbms_xmldom.newdomdocument(p_event_data);
1396:
1397:

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

1507: l_transaction_id_canonical Varchar2(30);
1508:
1509: begin
1510:
1511: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1512: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1513: p_event_data := p_event_message.event_data;
1514: v_document := dbms_xmldom.newdomdocument(p_event_data);
1515:

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

1508:
1509: begin
1510:
1511: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');
1512: p_event_message := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'EVENT_MSG');
1513: p_event_data := p_event_message.event_data;
1514: v_document := dbms_xmldom.newdomdocument(p_event_data);
1515:
1516: