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

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

143: ,p_object_version_number => l_trans_obj_vers_nums
144: ,p_rows => l_trans_step_rows);
145: */
146: --added new
147: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
148: ,itemkey => p_item_key
149: ,aname => 'OTA_TRANSACTION_STEP_ID');
150: get_review_data_from_tt(
151: p_transaction_step_id => l_trans_step_id

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

332: --
333: hr_utility.set_location('Me Entering Create transaction step'||l_proc, 5);
334:
335: if p_from ='SS' then
336: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
337: ,itemkey => p_item_key
338: ,aname => 'OTA_TRANSACTION_STEP_ID');
339:
340: l_business_group_id := hr_transaction_api.get_varchar2_value

Line 440: WF_ENGINE.setitemattrnumber(p_item_type,

436: (p_item_type => p_item_type
437: ,p_item_key => p_item_key
438: ,p_name => 'OTA_TRANSACTION_STEP_ID');
439:
440: WF_ENGINE.setitemattrnumber(p_item_type,
441: p_item_key,
442: 'OTA_TRANSACTION_STEP_ID',
443: l_transaction_step_id);
444:

Line 520: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

516:
517: IF (funcmode='RUN') THEN
518: savepoint commit_transaction;
519:
520: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
521: ,itemkey => itemkey
522: ,aname => 'OTA_TRANSACTION_STEP_ID');
523:
524:

Line 527: l_result := wf_engine.GetItemAttrText(itemtype => itemtype

523:
524:
525:
526: process_api(false,l_transaction_step_id);
527: l_result := wf_engine.GetItemAttrText(itemtype => itemtype
528: ,itemkey => itemkey
529: ,aname => 'HR_FLOW_NAME_ATTR');
530: if l_result = 'PROCEED' then
531: resultout := 'COMPLETE:Y' ;

Line 562: wf_engine.setitemattrtext

558: if l_error_text is null then
559: l_error_text := fnd_message.get;
560: end if;
561: -- 1903606
562: wf_engine.setitemattrtext
563: (itemtype => itemtype
564: ,itemkey => itemkey
565: ,aname => 'TRAN_SUBMIT'
566: ,avalue => 'E');

Line 569: wf_engine.setitemattrtext

565: ,aname => 'TRAN_SUBMIT'
566: ,avalue => 'E');
567:
568: -- set the ERROR_MESSAGE_TEXT
569: wf_engine.setitemattrtext
570: (itemtype => itemtype
571: ,itemkey => itemkey
572: ,aname => 'ERROR_MESSAGE_TEXT'
573: ,avalue => nvl(l_error_text, sqlerrm));

Line 610: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

606: hr_multi_message.disable_message_list;
607: IF (funcmode='RUN') THEN
608: -- savepoint commit_transaction;
609:
610: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
611: ,itemkey => itemkey
612: ,aname => 'OTA_TRANSACTION_STEP_ID');
613:
614:

Line 617: l_result := wf_engine.GetItemAttrText(itemtype => itemtype

613:
614:
615:
616: process_api(true,l_transaction_step_id);
617: l_result := wf_engine.GetItemAttrText(itemtype => itemtype
618: ,itemkey => itemkey
619: ,aname => 'HR_FLOW_NAME_ATTR');
620: hr_utility.trace('l_result chk_proceed' || l_result);
621: if l_result = 'PROCEED' then

Line 652: wf_engine.setitemattrtext

648: if l_error_text is null then
649: l_error_text := fnd_message.get;
650: end if;
651: -- 1903606
652: wf_engine.setitemattrtext
653: (itemtype => itemtype
654: ,itemkey => itemkey
655: ,aname => 'TRAN_SUBMIT'
656: ,avalue => 'E');

Line 659: wf_engine.setitemattrtext

655: ,aname => 'TRAN_SUBMIT'
656: ,avalue => 'E');
657:
658: -- set the ERROR_MESSAGE_TEXT
659: wf_engine.setitemattrtext
660: (itemtype => itemtype
661: ,itemkey => itemkey
662: ,aname => 'ERROR_MESSAGE_TEXT'
663: ,avalue => nvl(l_error_text, sqlerrm));

Line 740: l_cert_id := wf_engine.getItemAttrNumber(itemtype => itemtype

736: BEGIN
737: hr_utility.set_location('ENTERING get_approval_req', 10);
738: IF (funcmode='RUN') THEN
739:
740: l_cert_id := wf_engine.getItemAttrNumber(itemtype => itemtype
741: ,itemkey => itemkey
742: , aname => 'RECRUITER_ID');
743: l_LP_id := wf_engine.getItemAttrNumber(itemtype => itemtype
744: ,itemkey => itemkey

Line 743: l_LP_id := wf_engine.getItemAttrNumber(itemtype => itemtype

739:
740: l_cert_id := wf_engine.getItemAttrNumber(itemtype => itemtype
741: ,itemkey => itemkey
742: , aname => 'RECRUITER_ID');
743: l_LP_id := wf_engine.getItemAttrNumber(itemtype => itemtype
744: ,itemkey => itemkey
745: , aname => 'BOOKING_ID');
746: l_event_id := wf_engine.getItemAttrNumber(itemtype => itemtype
747: ,itemkey => itemkey

Line 746: l_event_id := wf_engine.getItemAttrNumber(itemtype => itemtype

742: , aname => 'RECRUITER_ID');
743: l_LP_id := wf_engine.getItemAttrNumber(itemtype => itemtype
744: ,itemkey => itemkey
745: , aname => 'BOOKING_ID');
746: l_event_id := wf_engine.getItemAttrNumber(itemtype => itemtype
747: ,itemkey => itemkey
748: , aname => 'EVENT_ID');
749: l_person_id := wf_engine.GetItemAttrText(itemtype => itemtype
750: ,itemkey => itemkey

Line 749: l_person_id := wf_engine.GetItemAttrText(itemtype => itemtype

745: , aname => 'BOOKING_ID');
746: l_event_id := wf_engine.getItemAttrNumber(itemtype => itemtype
747: ,itemkey => itemkey
748: , aname => 'EVENT_ID');
749: l_person_id := wf_engine.GetItemAttrText(itemtype => itemtype
750: ,itemkey => itemkey
751: ,aname => 'CURRENT_PERSON_ID');
752:
753: --added for bug 7308160

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

794: end if;
795: -- if getActAttrValue%FOUND then
796:
797: /*
798: l_item_value := wf_engine.getItemAttrText(itemtype => itemtype
799: ,itemkey => itemkey
800: , aname => 'HR_APPROVAL_REQ_FLAG');
801:
802: wf_engine.*/

Line 802: wf_engine.*/

798: l_item_value := wf_engine.getItemAttrText(itemtype => itemtype
799: ,itemkey => itemkey
800: , aname => 'HR_APPROVAL_REQ_FLAG');
801:
802: wf_engine.*/
803:
804: if l_item_value = 'NONOTIFY' then
805:
806: resultout:='COMPLETE:NONOTIFY';

Line 826: WF_ENGINE.setitemattrtext(itemtype, itemkey, 'APPROVAL_GENERIC_URL', l_ntf_url);

822:
823: end if;
824: hr_utility.trace('l_resultout' || resultout);
825: l_ntf_url := generate_url(l_item_value);
826: WF_ENGINE.setitemattrtext(itemtype, itemkey, 'APPROVAL_GENERIC_URL', l_ntf_url);
827: WF_ENGINE.setitemattrtext(itemtype, itemkey, 'HR_REVIEW_TEMPLATE_RN_ATTR', 'OTA_LIST_COMP_NTF');
828: /* END IF; -- cursor
829: CLOSE getActAttrValue;*/
830: RETURN;

Line 827: WF_ENGINE.setitemattrtext(itemtype, itemkey, 'HR_REVIEW_TEMPLATE_RN_ATTR', 'OTA_LIST_COMP_NTF');

823: end if;
824: hr_utility.trace('l_resultout' || resultout);
825: l_ntf_url := generate_url(l_item_value);
826: WF_ENGINE.setitemattrtext(itemtype, itemkey, 'APPROVAL_GENERIC_URL', l_ntf_url);
827: WF_ENGINE.setitemattrtext(itemtype, itemkey, 'HR_REVIEW_TEMPLATE_RN_ATTR', 'OTA_LIST_COMP_NTF');
828: /* END IF; -- cursor
829: CLOSE getActAttrValue;*/
830: RETURN;
831: END IF; --RUN

Line 1205: -- WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_FLOW_NAME_ATTR', 'PROCEED');

1201:
1202:
1203: if l_competence_created <> 0 and (l_attr_chk) then
1204: l_attr_chk := false;
1205: -- WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_FLOW_NAME_ATTR', 'PROCEED');
1206: -- elsif (l_attr_chk) then
1207: -- WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_FLOW_NAME_ATTR', 'STOP');
1208: end if;
1209: --end if; --level_id

Line 1207: -- WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_FLOW_NAME_ATTR', 'STOP');

1203: if l_competence_created <> 0 and (l_attr_chk) then
1204: l_attr_chk := false;
1205: -- WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_FLOW_NAME_ATTR', 'PROCEED');
1206: -- elsif (l_attr_chk) then
1207: -- WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_FLOW_NAME_ATTR', 'STOP');
1208: end if;
1209: --end if; --level_id
1210:
1211: if l_comp_endPos =0 then --implies end of string has been reached

Line 1226: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_FLOW_NAME_ATTR', 'STOP');

1222: if p_validate then
1223: rollback to validate_competence;
1224: end if;
1225: if l_attr_chk then
1226: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_FLOW_NAME_ATTR', 'STOP');
1227: else
1228: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_FLOW_NAME_ATTR', 'PROCEED');
1229: end if;
1230: hr_utility.set_location('Leaving'||l_proc, 5);

Line 1228: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_FLOW_NAME_ATTR', 'PROCEED');

1224: end if;
1225: if l_attr_chk then
1226: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_FLOW_NAME_ATTR', 'STOP');
1227: else
1228: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_FLOW_NAME_ATTR', 'PROCEED');
1229: end if;
1230: hr_utility.set_location('Leaving'||l_proc, 5);
1231:
1232: EXCEPTION

Line 1238: l_fwd_to_username:= nvl(wf_engine.getitemattrtext

1234: hr_utility.set_location('Leaving with error:'||l_proc, 25);
1235: rollback to validate_competence;
1236: -- In case of Approvla required Error notification shud go to approving manager
1237: -- In case of auto competence update error notification shud go to learner
1238: l_fwd_to_username:= nvl(wf_engine.getitemattrtext
1239: (l_item_type,
1240: l_item_key,
1241: 'FORWARD_TO_USERNAME'
1242: ),

Line 1243: wf_engine.getitemattrtext

1239: (l_item_type,
1240: l_item_key,
1241: 'FORWARD_TO_USERNAME'
1242: ),
1243: wf_engine.getitemattrtext
1244: (l_item_type,
1245: l_item_key,
1246: 'CURRENT_PERSON_USERNAME'
1247: )

Line 1249: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'APPROVAL_CREATOR_USERNAME', l_fwd_to_username);

1245: l_item_key,
1246: 'CURRENT_PERSON_USERNAME'
1247: )
1248: );
1249: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'APPROVAL_CREATOR_USERNAME', l_fwd_to_username);
1250: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_REVIEW_TEMPLATE_RN_ATTR', 'HR_CHKERRORSRN_NTF');
1251: /*wf_engine.SetItemAttrText ( l_item_type, l_item_key,
1252: 'APPROVAL_CREATOR_DISPLAY_NAME',l_fwd_to_username
1253: );

Line 1250: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_REVIEW_TEMPLATE_RN_ATTR', 'HR_CHKERRORSRN_NTF');

1246: 'CURRENT_PERSON_USERNAME'
1247: )
1248: );
1249: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'APPROVAL_CREATOR_USERNAME', l_fwd_to_username);
1250: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_REVIEW_TEMPLATE_RN_ATTR', 'HR_CHKERRORSRN_NTF');
1251: /*wf_engine.SetItemAttrText ( l_item_type, l_item_key,
1252: 'APPROVAL_CREATOR_DISPLAY_NAME',l_fwd_to_username
1253: );
1254: */

Line 1251: /*wf_engine.SetItemAttrText ( l_item_type, l_item_key,

1247: )
1248: );
1249: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'APPROVAL_CREATOR_USERNAME', l_fwd_to_username);
1250: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_REVIEW_TEMPLATE_RN_ATTR', 'HR_CHKERRORSRN_NTF');
1251: /*wf_engine.SetItemAttrText ( l_item_type, l_item_key,
1252: 'APPROVAL_CREATOR_DISPLAY_NAME',l_fwd_to_username
1253: );
1254: */
1255: -- change date message to a more meaningful one.

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

1278:
1279:
1280: begin
1281:
1282: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
1283: ,itemkey => p_item_key
1284: ,aname => 'OTA_TRANSACTION_STEP_ID');
1285:
1286:

Line 1678: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);

1674: into l_item_key
1675: from sys.dual;
1676:
1677:
1678: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1679:
1680: if p_Learningpath_ids is not null then
1681: hr_utility.set_location('before OTA_OBJECT_TYPE'||l_proc, 140);
1682: WF_ENGINE.setitemattrtext(l_item_type,

Line 1682: WF_ENGINE.setitemattrtext(l_item_type,

1678: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1679:
1680: if p_Learningpath_ids is not null then
1681: hr_utility.set_location('before OTA_OBJECT_TYPE'||l_proc, 140);
1682: WF_ENGINE.setitemattrtext(l_item_type,
1683: l_item_key,
1684: 'REVIEW_OBJECT',
1685: l_LP_lookup_meaning);
1686: hr_utility.set_location('after OTA_OBJECT_TYPE'||l_proc, 240);

Line 1689: WF_ENGINE.setitemattrtext(l_item_type,

1685: l_LP_lookup_meaning);
1686: hr_utility.set_location('after OTA_OBJECT_TYPE'||l_proc, 240);
1687: elsif p_eventid is not null then
1688: hr_utility.set_location('before OTA_OBJECT_TYPE 2'||l_proc, 340);
1689: WF_ENGINE.setitemattrtext(l_item_type,
1690: l_item_key,
1691: 'REVIEW_OBJECT',
1692: l_CRS_lookup_meaning);
1693: hr_utility.set_location('after OTA_OBJECT_TYPE 2'||l_proc, 440);

Line 1695: WF_ENGINE.setitemattrtext(l_item_type,

1691: 'REVIEW_OBJECT',
1692: l_CRS_lookup_meaning);
1693: hr_utility.set_location('after OTA_OBJECT_TYPE 2'||l_proc, 440);
1694: else
1695: WF_ENGINE.setitemattrtext(l_item_type,
1696: l_item_key,
1697: 'REVIEW_OBJECT',
1698: l_CERT_lookup_meaning);
1699: end if;

Line 1701: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_ID', p_person_id);

1697: 'REVIEW_OBJECT',
1698: l_CERT_lookup_meaning);
1699: end if;
1700:
1701: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_ID', p_person_id);
1702: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);
1703: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_current_username);
1704: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1705: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);

Line 1702: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);

1698: l_CERT_lookup_meaning);
1699: end if;
1700:
1701: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_ID', p_person_id);
1702: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);
1703: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_current_username);
1704: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1705: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1706: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);

Line 1703: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_current_username);

1699: end if;
1700:
1701: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_ID', p_person_id);
1702: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);
1703: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_current_username);
1704: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1705: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1706: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1707: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);

Line 1704: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);

1700:
1701: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_ID', p_person_id);
1702: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);
1703: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_current_username);
1704: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1705: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1706: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1707: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
1708: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );

Line 1705: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);

1701: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_ID', p_person_id);
1702: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);
1703: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_current_username);
1704: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1705: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1706: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1707: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
1708: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );
1709: --hard coded date format required by pqh

Line 1706: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);

1702: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);
1703: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_current_username);
1704: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1705: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1706: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1707: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
1708: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );
1709: --hard coded date format required by pqh
1710: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));

Line 1707: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);

1703: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_current_username);
1704: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1705: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1706: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1707: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
1708: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );
1709: --hard coded date format required by pqh
1710: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
1711: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',trunc(sysdate));

Line 1708: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );

1704: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1705: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1706: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1707: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
1708: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );
1709: --hard coded date format required by pqh
1710: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
1711: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',trunc(sysdate));
1712: WF_ENGINE.setitemattrDate(p_itemtype, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));

Line 1710: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));

1706: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1707: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
1708: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );
1709: --hard coded date format required by pqh
1710: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
1711: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',trunc(sysdate));
1712: WF_ENGINE.setitemattrDate(p_itemtype, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));
1713: -- Get and set owner role
1714:

Line 1711: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',trunc(sysdate));

1707: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
1708: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );
1709: --hard coded date format required by pqh
1710: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
1711: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',trunc(sysdate));
1712: WF_ENGINE.setitemattrDate(p_itemtype, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));
1713: -- Get and set owner role
1714:
1715: hr_utility.set_location('Before Getting Owner'||l_proc, 10);

Line 1712: WF_ENGINE.setitemattrDate(p_itemtype, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));

1708: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );
1709: --hard coded date format required by pqh
1710: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
1711: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',trunc(sysdate));
1712: WF_ENGINE.setitemattrDate(p_itemtype, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));
1713: -- Get and set owner role
1714:
1715: hr_utility.set_location('Before Getting Owner'||l_proc, 10);
1716:

Line 1723: WF_ENGINE.SetItemOwner(

1719: p_name =>l_role_name,
1720: p_display_name =>l_role_display_name);
1721:
1722:
1723: WF_ENGINE.SetItemOwner(
1724: itemtype => l_item_type,
1725: itemkey =>l_item_key,
1726: owner =>l_role_name);
1727:

Line 1735: WF_ENGINE.setitemattrtext(l_item_type,

1731:
1732: /*l_person_details := ota_learner_enroll_ss.Get_Person_To_Enroll_Details(p_person_id => p_person_id);
1733:
1734: IF l_person_details.full_name is not null then
1735: WF_ENGINE.setitemattrtext(l_item_type,
1736: l_item_key,
1737: 'CURRENT_PERSON_DISPLAY_NAME',
1738: l_person_details.full_name);
1739: WF_ENGINE.setitemattrtext(l_item_type,

Line 1739: WF_ENGINE.setitemattrtext(l_item_type,

1735: WF_ENGINE.setitemattrtext(l_item_type,
1736: l_item_key,
1737: 'CURRENT_PERSON_DISPLAY_NAME',
1738: l_person_details.full_name);
1739: WF_ENGINE.setitemattrtext(l_item_type,
1740: l_item_key,
1741: 'CREATOR_PERSON_DISPLAY_NAME',
1742: l_person_details.full_name);
1743: END IF;*/

Line 1746: WF_ENGINE.setitemattrtext(l_item_type,

1742: l_person_details.full_name);
1743: END IF;*/
1744:
1745: IF l_person_full_name is not null then
1746: WF_ENGINE.setitemattrtext(l_item_type,
1747: l_item_key,
1748: 'CURRENT_PERSON_DISPLAY_NAME',
1749: l_person_full_name);
1750: WF_ENGINE.setitemattrtext(l_item_type,

Line 1750: WF_ENGINE.setitemattrtext(l_item_type,

1746: WF_ENGINE.setitemattrtext(l_item_type,
1747: l_item_key,
1748: 'CURRENT_PERSON_DISPLAY_NAME',
1749: l_person_full_name);
1750: WF_ENGINE.setitemattrtext(l_item_type,
1751: l_item_key,
1752: 'CREATOR_PERSON_DISPLAY_NAME',
1753: l_person_full_name);
1754: END IF;

Line 1774: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_CUSTOM_RETURN_FOR_CORR','Y');

1770: p_date_to => l_eff_date_to);
1771:
1772:
1773: hr_utility.set_location('before supervisor'||l_proc, 30);
1774: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_CUSTOM_RETURN_FOR_CORR','Y');
1775:
1776: --always set to Y
1777: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'YES');
1778: hr_utility.set_location('before supervisor'||l_proc, 40);

Line 1777: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'YES');

1773: hr_utility.set_location('before supervisor'||l_proc, 30);
1774: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_CUSTOM_RETURN_FOR_CORR','Y');
1775:
1776: --always set to Y
1777: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'YES');
1778: hr_utility.set_location('before supervisor'||l_proc, 40);
1779: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'P_ASSIGNMENT_ID', l_assignment);
1780: hr_utility.set_location('before supervisor'||l_proc, 50);
1781: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'CURRENT_ASSIGNMENT_ID', to_number(l_assignment));

Line 1779: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'P_ASSIGNMENT_ID', l_assignment);

1775:
1776: --always set to Y
1777: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'YES');
1778: hr_utility.set_location('before supervisor'||l_proc, 40);
1779: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'P_ASSIGNMENT_ID', l_assignment);
1780: hr_utility.set_location('before supervisor'||l_proc, 50);
1781: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'CURRENT_ASSIGNMENT_ID', to_number(l_assignment));
1782:
1783: if p_eventId is not null then

Line 1781: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'CURRENT_ASSIGNMENT_ID', to_number(l_assignment));

1777: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'YES');
1778: hr_utility.set_location('before supervisor'||l_proc, 40);
1779: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'P_ASSIGNMENT_ID', l_assignment);
1780: hr_utility.set_location('before supervisor'||l_proc, 50);
1781: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'CURRENT_ASSIGNMENT_ID', to_number(l_assignment));
1782:
1783: if p_eventId is not null then
1784: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_EVENT_TITLE', l_event_name);
1785: end if;

Line 1784: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_EVENT_TITLE', l_event_name);

1780: hr_utility.set_location('before supervisor'||l_proc, 50);
1781: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'CURRENT_ASSIGNMENT_ID', to_number(l_assignment));
1782:
1783: if p_eventId is not null then
1784: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_EVENT_TITLE', l_event_name);
1785: end if;
1786:
1787: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', l_course_name);
1788: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','SSHRMS');

Line 1787: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', l_course_name);

1783: if p_eventId is not null then
1784: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_EVENT_TITLE', l_event_name);
1785: end if;
1786:
1787: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', l_course_name);
1788: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','SSHRMS');
1789: -- bug 3483960
1790: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
1791: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);

Line 1788: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','SSHRMS');

1784: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_EVENT_TITLE', l_event_name);
1785: end if;
1786:
1787: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', l_course_name);
1788: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','SSHRMS');
1789: -- bug 3483960
1790: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
1791: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
1792: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'TRAN_SUBMIT','Y');

Line 1790: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');

1786:
1787: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', l_course_name);
1788: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','SSHRMS');
1789: -- bug 3483960
1790: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
1791: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
1792: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'TRAN_SUBMIT','Y');
1793: --WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);
1794: hr_utility.set_location('before supervisor'||l_proc, 20);

Line 1791: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);

1787: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', l_course_name);
1788: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','SSHRMS');
1789: -- bug 3483960
1790: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
1791: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
1792: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'TRAN_SUBMIT','Y');
1793: --WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);
1794: hr_utility.set_location('before supervisor'||l_proc, 20);
1795:

Line 1792: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'TRAN_SUBMIT','Y');

1788: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','SSHRMS');
1789: -- bug 3483960
1790: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
1791: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
1792: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'TRAN_SUBMIT','Y');
1793: --WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);
1794: hr_utility.set_location('before supervisor'||l_proc, 20);
1795:
1796: FOR a IN csr_supervisor_id LOOP

Line 1793: --WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);

1789: -- bug 3483960
1790: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
1791: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
1792: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'TRAN_SUBMIT','Y');
1793: --WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);
1794: hr_utility.set_location('before supervisor'||l_proc, 20);
1795:
1796: FOR a IN csr_supervisor_id LOOP
1797: l_supervisor_id := a.supervisor_id;

Line 1808: wf_engine.setitemattrtext

1804: END LOOP;
1805:
1806: hr_utility.set_location('after supervisor cursor'||l_proc, 20);
1807:
1808: wf_engine.setitemattrtext
1809: (l_item_type,
1810: l_item_key,
1811: 'SUPERVISOR_USERNAME',
1812: l_supervisor_username);

Line 1815: wf_engine.setitemattrtext

1811: 'SUPERVISOR_USERNAME',
1812: l_supervisor_username);
1813: hr_utility.set_location('after supervisor username'||l_proc, 20);
1814:
1815: wf_engine.setitemattrtext
1816: (l_item_type,
1817: l_item_key,
1818: 'SUPERVISOR_DISPLAY_NAME',
1819: l_supervisor_full_name);

Line 1821: wf_engine.setitemattrtext

1817: l_item_key,
1818: 'SUPERVISOR_DISPLAY_NAME',
1819: l_supervisor_full_name);
1820: hr_utility.set_location('after supervisor disp name'||l_proc, 20);
1821: wf_engine.setitemattrtext
1822: (l_item_type,
1823: l_item_key,
1824: 'SUPERVISOR_ID',
1825: l_supervisor_id);

Line 1834: WF_ENGINE.setitemattrnumber(l_item_type,

1830: (p_item_type => l_item_type
1831: ,p_item_key => l_item_key
1832: ,p_name => 'OTA_LP_ID');*/
1833:
1834: WF_ENGINE.setitemattrnumber(l_item_type,
1835: l_item_key,
1836: 'BOOKING_ID',
1837: p_learningpath_ids);
1838:

Line 1842: WF_ENGINE.setitemattrnumber(l_item_type,

1838:
1839: elsif p_eventId is not null then
1840:
1841:
1842: WF_ENGINE.setitemattrnumber(l_item_type,
1843: l_item_key,
1844: 'EVENT_ID',
1845: p_eventid);
1846: else

Line 1848: WF_ENGINE.setitemattrnumber(l_item_type,

1844: 'EVENT_ID',
1845: p_eventid);
1846: else
1847:
1848: WF_ENGINE.setitemattrnumber(l_item_type,
1849: l_item_key,
1850: 'RECRUITER_ID',
1851: p_certification_id);
1852: end if;

Line 1853: WF_ENGINE.STARTPROCESS(p_itemtype,l_item_key);

1849: l_item_key,
1850: 'RECRUITER_ID',
1851: p_certification_id);
1852: end if;
1853: WF_ENGINE.STARTPROCESS(p_itemtype,l_item_key);
1854:
1855: end if;
1856: else
1857: CLOSE chk_person_business_grp;