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.OTA_WF dependencies on WF_ENGINE

Line 36: -- step must be performed. A call to wf_engine.CompleteActivty

32: -- - DEFERED
33: -- execution should be defered to background
34: -- - NOTIFIED[::]
35: -- activity has notified an external entity that this
36: -- step must be performed. A call to wf_engine.CompleteActivty
37: -- will signal when this step is complete. Optional
38: -- return of notification ID and assigned user.
39: -- - ERROR[:]
40: -- function encountered an err--

Line 135: l_header_id := WF_ENGINE.getitemattrnumber(

131: hr_utility.set_location('Entering:'||l_proc, 5);
132:
133: IF (funcmode = 'RUN') THEN
134:
135: l_header_id := WF_ENGINE.getitemattrnumber(
136: itemtype => itemtype,
137: itemkey => itemkey,
138: aname => 'HEADER_ID');
139: l_org_id := WF_ENGINE.getitemattrnumber(

Line 139: l_org_id := WF_ENGINE.getitemattrnumber(

135: l_header_id := WF_ENGINE.getitemattrnumber(
136: itemtype => itemtype,
137: itemkey => itemkey,
138: aname => 'HEADER_ID');
139: l_org_id := WF_ENGINE.getitemattrnumber(
140: itemtype => itemtype,
141: itemkey => itemkey,
142: aname => 'ORG_ID');
143: MO_GLOBAL.SET_POLICY_CONTEXT ('S', l_org_id); -- For MOAC support

Line 275: -- step must be performed. A call to wf_engine.CompleteActivty

271: -- - DEFERED
272: -- execution should be defered to background
273: -- - NOTIFIED[::]
274: -- activity has notified an external entity that this
275: -- step must be performed. A call to wf_engine.CompleteActivty
276: -- will signal when this step is complete. Optional
277: -- return of notification ID and assigned user.
278: -- - ERROR[:]
279: -- function encountered an err--

Line 372: l_header_id := WF_ENGINE.getitemattrnumber(

368: hr_utility.set_location('Entering:'||l_proc, 5);
369:
370: IF (funcmode = 'RUN') THEN
371:
372: l_header_id := WF_ENGINE.getitemattrnumber(
373: itemtype => itemtype,
374: itemkey => itemkey,
375: aname => 'HEADER_ID');
376:

Line 378: l_org_id := WF_ENGINE.getitemattrnumber(

374: itemkey => itemkey,
375: aname => 'HEADER_ID');
376:
377:
378: l_org_id := WF_ENGINE.getitemattrnumber(
379: itemtype => itemtype,
380: itemkey => itemkey,
381: aname => 'ORG_ID');
382:

Line 540: -- step must be performed. A call to wf_engine.CompleteActivty

536: -- - DEFERED
537: -- execution should be defered to background
538: -- - NOTIFIED[::]
539: -- activity has notified an external entity that this
540: -- step must be performed. A call to wf_engine.CompleteActivty
541: -- will signal when this step is complete. Optional
542: -- return of notification ID and assigned user.
543: -- - ERROR[:]
544: -- function encountered an err--

Line 655: /*l_header_id := WF_ENGINE.getitemattrnumber(

651: OPEN C_EVENT;
652: FETCH C_EVENT INTO l_course_end_date;
653: IF C_EVENT%found THEN
654:
655: /*l_header_id := WF_ENGINE.getitemattrnumber(
656: itemtype => itemtype,
657: itemkey => itemkey,
658: aname => 'HEADER_ID'); */
659:

Line 661: /*l_org_id := WF_ENGINE.getitemattrnumber(

657: itemkey => itemkey,
658: aname => 'HEADER_ID'); */
659:
660:
661: /*l_org_id := WF_ENGINE.getitemattrnumber(
662: itemtype => itemtype,
663: itemkey => itemkey,
664: aname => 'ORG_ID'); */
665: MO_GLOBAL.SET_POLICY_CONTEXT ('S', l_org_id); -- For MOAC support

Line 790: -- step must be performed. A call to wf_engine.CompleteActivty

786: -- - DEFERED
787: -- execution should be defered to background
788: -- - NOTIFIED[::]
789: -- activity has notified an external entity that this
790: -- step must be performed. A call to wf_engine.CompleteActivty
791: -- will signal when this step is complete. Optional
792: -- return of notification ID and assigned user.
793: -- - ERROR[:]
794: -- function encountered an err--

Line 836: resultout := wf_engine.eng_completed || ':' || 'Y';

832: OPEN c_invoice;
833: FETCH c_invoice into l_invoice_quantity;
834: IF c_invoice%found THEN
835: IF l_invoice_quantity = 1 then
836: resultout := wf_engine.eng_completed || ':' || 'Y';
837: ELSE
838: resultout := wf_engine.eng_completed || ':' || 'N';
839: END IF;
840: END IF;

Line 838: resultout := wf_engine.eng_completed || ':' || 'N';

834: IF c_invoice%found THEN
835: IF l_invoice_quantity = 1 then
836: resultout := wf_engine.eng_completed || ':' || 'Y';
837: ELSE
838: resultout := wf_engine.eng_completed || ':' || 'N';
839: END IF;
840: END IF;
841: CLOSE c_invoice;
842: END IF;

Line 906: -- step must be performed. A call to wf_engine.CompleteActivty

902: -- - DEFERED
903: -- execution should be defered to background
904: -- - NOTIFIED[::]
905: -- activity has notified an external entity that this
906: -- step must be performed. A call to wf_engine.CompleteActivty
907: -- will signal when this step is complete. Optional
908: -- return of notification ID and assigned user.
909: -- - ERROR[:]
910: -- function encountered an err--

Line 979: -- WF_ENGINE.SetItemattrnumber(itemtype,itemkey,'NOTIFICATION_APPROVER',l_email_address);

975: ELSIF l_uom= 'EVT' THEN
976:
977: -- OPEN c_event;
978: -- FETCH c_event into l_email_address;
979: -- WF_ENGINE.SetItemattrnumber(itemtype,itemkey,'NOTIFICATION_APPROVER',l_email_address);
980: -- WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'LIN_SHORT_DESCRIPTOR',l_order_number);
981:
982: resultout := 'COMPLETE:EVT';
983: END IF;

Line 980: -- WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'LIN_SHORT_DESCRIPTOR',l_order_number);

976:
977: -- OPEN c_event;
978: -- FETCH c_event into l_email_address;
979: -- WF_ENGINE.SetItemattrnumber(itemtype,itemkey,'NOTIFICATION_APPROVER',l_email_address);
980: -- WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'LIN_SHORT_DESCRIPTOR',l_order_number);
981:
982: resultout := 'COMPLETE:EVT';
983: END IF;
984: END IF;

Line 1047: -- step must be performed. A call to wf_engine.CompleteActivty

1043: -- - DEFERED
1044: -- execution should be defered to background
1045: -- - NOTIFIED[::]
1046: -- activity has notified an external entity that this
1047: -- step must be performed. A call to wf_engine.CompleteActivty
1048: -- will signal when this step is complete. Optional
1049: -- return of notification ID and assigned user.
1050: -- - ERROR[:]
1051: -- function encountered an err--

Line 1120: resultout := wf_engine.eng_completed || ':' || 'Y';

1116: IF l_uom = 'ENR' then
1117: OPEN C_ENR;
1118: FETCH c_enr INTO l_exist;
1119: IF c_enr%found then
1120: resultout := wf_engine.eng_completed || ':' || 'Y';
1121: ELSE
1122: resultout := wf_engine.eng_completed || ':' || 'N';
1123: END IF;
1124: CLOSE c_enr;

Line 1122: resultout := wf_engine.eng_completed || ':' || 'N';

1118: FETCH c_enr INTO l_exist;
1119: IF c_enr%found then
1120: resultout := wf_engine.eng_completed || ':' || 'Y';
1121: ELSE
1122: resultout := wf_engine.eng_completed || ':' || 'N';
1123: END IF;
1124: CLOSE c_enr;
1125: ELSIF l_uom= 'EVT' THEN
1126: OPEN C_EVT;

Line 1129: resultout := wf_engine.eng_completed || ':' || 'Y';

1125: ELSIF l_uom= 'EVT' THEN
1126: OPEN C_EVT;
1127: FETCH c_evt INTO l_exist;
1128: IF c_evt%found then
1129: resultout := wf_engine.eng_completed || ':' || 'Y';
1130: ELSE
1131: resultout := wf_engine.eng_completed || ':' || 'N';
1132: END IF;
1133: CLOSE c_evt;

Line 1131: resultout := wf_engine.eng_completed || ':' || 'N';

1127: FETCH c_evt INTO l_exist;
1128: IF c_evt%found then
1129: resultout := wf_engine.eng_completed || ':' || 'Y';
1130: ELSE
1131: resultout := wf_engine.eng_completed || ':' || 'N';
1132: END IF;
1133: CLOSE c_evt;
1134: END IF;
1135: END IF;

Line 1193: -- step must be performed. A call to wf_engine.CompleteActivty

1189: -- - DEFERED
1190: -- execution should be defered to background
1191: -- - NOTIFIED[::]
1192: -- activity has notified an external entity that this
1193: -- step must be performed. A call to wf_engine.CompleteActivty
1194: -- will signal when this step is complete. Optional
1195: -- return of notification ID and assigned user.
1196: -- - ERROR[:]
1197: -- function encountered an err--

Line 1306: -- step must be performed. A call to wf_engine.CompleteActivty

1302: -- - DEFERED
1303: -- execution should be defered to background
1304: -- - NOTIFIED[::]
1305: -- activity has notified an external entity that this
1306: -- step must be performed. A call to wf_engine.CompleteActivty
1307: -- will signal when this step is complete. Optional
1308: -- return of notification ID and assigned user.
1309: -- - ERROR[:]
1310: -- function encountered an err--

Line 1424: -- step must be performed. A call to wf_engine.CompleteActivty

1420: -- - DEFERED
1421: -- execution should be defered to background
1422: -- - NOTIFIED[::]
1423: -- activity has notified an external entity that this
1424: -- step must be performed. A call to wf_engine.CompleteActivty
1425: -- will signal when this step is complete. Optional
1426: -- return of notification ID and assigned user.
1427: -- - ERROR[:]
1428: -- function encountered an err--

Line 1588: l_org_id := WF_ENGINE.getitemattrnumber(

1584: l_booking_status_type;
1585:
1586: IF c_booking_status%found then
1587: IF l_booking_status_type <>'C' then
1588: l_org_id := WF_ENGINE.getitemattrnumber(
1589: itemtype => itemtype,
1590: itemkey => itemkey,
1591: aname => 'ORG_ID');
1592:

Line 1670: -- step must be performed. A call to wf_engine.CompleteActivty

1666: -- - DEFERED
1667: -- execution should be defered to background
1668: -- - NOTIFIED[::]
1669: -- activity has notified an external entity that this
1670: -- step must be performed. A call to wf_engine.CompleteActivty
1671: -- will signal when this step is complete. Optional
1672: -- return of notification ID and assigned user.
1673: -- - ERROR[:]
1674: -- function encountered an err--

Line 1731: WF_ENGINE.SetItemattrtext(itemtype,itemkey,'NOTIFICATION_APPROVER',l_user_name);

1727: IF (funcmode = 'RUN') THEN
1728:
1729: OPEN c_event;
1730: FETCH c_event into l_user_name;
1731: WF_ENGINE.SetItemattrtext(itemtype,itemkey,'NOTIFICATION_APPROVER',l_user_name);
1732: resultout := 'COMPLETE';
1733: CLOSE c_event;
1734: END IF;
1735: --

Line 1791: -- step must be performed. A call to wf_engine.CompleteActivty

1787: -- - DEFERED
1788: -- execution should be defered to background
1789: -- - NOTIFIED[::]
1790: -- activity has notified an external entity that this
1791: -- step must be performed. A call to wf_engine.CompleteActivty
1792: -- will signal when this step is complete. Optional
1793: -- return of notification ID and assigned user.
1794: -- - ERROR[:]
1795: -- function encountered an err--