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_CERT_APPROVAL_SS dependencies on WF_ENGINE

Line 41: l_item_value := wf_engine.getItemAttrText(itemtype => itemtype

37:
38:
39:
40:
41: l_item_value := wf_engine.getItemAttrText(itemtype => itemtype
42: ,itemkey => itemkey
43: , aname => 'HR_RUNTIME_APPROVAL_REQ_FLAG');
44:
45:

Line 49: /* l_cert_id := wf_engine.getItemAttrNumber(itemtype => itemtype

45:
46:
47: if l_item_value = 'NO' then
48:
49: /* l_cert_id := wf_engine.getItemAttrNumber(itemtype => itemtype
50: ,itemkey => itemkey
51: , aname => 'BOOKING_ID');
52:
53: open get_cert_details(l_cert_id);

Line 57: wf_engine.setItemAttrText(itemtype,itemkey,'OTA_ACTIVITY_VERSION_NAME',l_certification_name);

53: open get_cert_details(l_cert_id);
54: fetch get_cert_details into l_certification_name,l_comp_date;
55: close get_cert_details;
56:
57: wf_engine.setItemAttrText(itemtype,itemkey,'OTA_ACTIVITY_VERSION_NAME',l_certification_name);
58: wf_engine.setItemAttrText(itemtype,itemkey,'OTA_COURSE_START_DATE',l_comp_date);
59:
60: */
61:

Line 58: wf_engine.setItemAttrText(itemtype,itemkey,'OTA_COURSE_START_DATE',l_comp_date);

54: fetch get_cert_details into l_certification_name,l_comp_date;
55: close get_cert_details;
56:
57: wf_engine.setItemAttrText(itemtype,itemkey,'OTA_ACTIVITY_VERSION_NAME',l_certification_name);
58: wf_engine.setItemAttrText(itemtype,itemkey,'OTA_COURSE_START_DATE',l_comp_date);
59:
60: */
61:
62: resultout:='COMPLETE:N';

Line 378: WF_ENGINE.setitemattrnumber(p_item_type,

374: (p_item_type => p_item_type
375: ,p_item_key => p_item_key
376: ,p_name => 'OTA_TRANSACTION_STEP_ID');
377:
378: WF_ENGINE.setitemattrnumber(p_item_type,
379: p_item_key,
380: 'OTA_TRANSACTION_STEP_ID',
381: l_transaction_step_id);
382:

Line 390: WF_ENGINE.setitemattrnumber(p_item_type,

386: (p_item_type => p_item_type
387: ,p_item_key => p_item_key
388: ,p_name => 'OTA_CERTIFICATION_ID');
389:
390: WF_ENGINE.setitemattrnumber(p_item_type,
391: p_item_key,
392: 'OTA_CERTIFICATION_ID',
393: p_certification_id);
394:

Line 396: WF_ENGINE.setitemattrtext(p_item_type,

392: 'OTA_CERTIFICATION_ID',
393: p_certification_id);
394:
395: -- bug 4146681
396: WF_ENGINE.setitemattrtext(p_item_type,
397: p_item_key,
398: 'HR_RESTRICT_EDIT_ATTR',
399: 'Y');
400: --bug 4146681

Line 461: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type

457:
458:
459: BEGIN
460:
461: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
462: ,itemkey => p_item_key
463: ,aname => 'OTA_TRANSACTION_STEP_ID');
464:
465:

Line 640: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type

636: BEGIN
637:
638:
639: --added new
640: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
641: ,itemkey => p_item_key
642: ,aname => 'OTA_TRANSACTION_STEP_ID');
643: get_review_data(
644: p_transaction_step_id => l_trans_step_id

Line 925: wf_engine.setItemAttrNumber(l_item_type, l_item_key, 'EVENT_ID',l_cert_enrollment_id );

921: ,p_item_type => l_item_type
922: ,p_item_key => l_item_key
923: ,p_activity_id => l_activity_id);
924:
925: wf_engine.setItemAttrNumber(l_item_type, l_item_key, 'EVENT_ID',l_cert_enrollment_id );
926:
927: --set certification name
928: --moved to java layer for approval mode off convenience
929: /*

Line 934: wf_engine.setItemAttrText(l_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME',l_certification_name);

930: open get_cert_name(l_certification_id);
931: fetch get_cert_name into l_certification_name;
932: close get_cert_name;
933:
934: wf_engine.setItemAttrText(l_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME',l_certification_name);
935: */
936: hr_utility.trace ('AFTER EVENT_ID ' ||'10');
937: end create_cert_enrollment_tt;
938:

Line 1011: l_Cert_enrollment_id := wf_engine.GetItemAttrNumber(itemtype => l_item_type

1007: ,p_activity_id => l_activity_id);
1008: end if;
1009:
1010: if p_cert_enroll_id is null then
1011: l_Cert_enrollment_id := wf_engine.GetItemAttrNumber(itemtype => l_item_type
1012: ,itemkey => l_item_key
1013: ,aname => 'EVENT_ID');
1014:
1015: else

Line 1263: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

1259: l_trans_step_id number;
1260:
1261: begin
1262:
1263: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1264: ,itemkey => itemkey
1265: ,aname => 'OTA_TRANSACTION_STEP_ID');
1266:
1267: if ( funmode = 'RUN' ) then

Line 1298: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

1294:
1295:
1296: begin
1297:
1298: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1299: ,itemkey => itemkey
1300: ,aname => 'OTA_TRANSACTION_STEP_ID');
1301:
1302: if ( funmode = 'RUN' ) then

Line 1328: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type

1324:
1325: l_transaction_step_id number;
1326: begin
1327:
1328: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
1329: ,itemkey => p_item_key
1330: ,aname => 'OTA_TRANSACTION_STEP_ID');
1331: process_api(true,l_transaction_step_id);
1332: p_message := 'S' ;

Line 1357: wf_engine.setItemAttrText (itemtype => itemtype

1353:
1354: BEGIN
1355:
1356: IF (funcmode='RUN') THEN
1357: wf_engine.setItemAttrText (itemtype => itemtype
1358: ,itemkey => itemkey
1359: ,aname => 'APPROVAL_RESULT'
1360: ,avalue => 'ACCEPTED');
1361: resultout:='COMPLETE';