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 1690: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);

1686: into l_item_key
1687: from sys.dual;
1688:
1689:
1690: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1691:
1692: if p_Learningpath_ids is not null then
1693: hr_utility.set_location('before OTA_OBJECT_TYPE'||l_proc, 140);
1694: WF_ENGINE.setitemattrtext(l_item_type,

Line 1694: WF_ENGINE.setitemattrtext(l_item_type,

1690: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1691:
1692: if p_Learningpath_ids is not null then
1693: hr_utility.set_location('before OTA_OBJECT_TYPE'||l_proc, 140);
1694: WF_ENGINE.setitemattrtext(l_item_type,
1695: l_item_key,
1696: 'REVIEW_OBJECT',
1697: l_LP_lookup_meaning);
1698: hr_utility.set_location('after OTA_OBJECT_TYPE'||l_proc, 240);

Line 1701: WF_ENGINE.setitemattrtext(l_item_type,

1697: l_LP_lookup_meaning);
1698: hr_utility.set_location('after OTA_OBJECT_TYPE'||l_proc, 240);
1699: elsif p_eventid is not null then
1700: hr_utility.set_location('before OTA_OBJECT_TYPE 2'||l_proc, 340);
1701: WF_ENGINE.setitemattrtext(l_item_type,
1702: l_item_key,
1703: 'REVIEW_OBJECT',
1704: l_CRS_lookup_meaning);
1705: hr_utility.set_location('after OTA_OBJECT_TYPE 2'||l_proc, 440);

Line 1707: WF_ENGINE.setitemattrtext(l_item_type,

1703: 'REVIEW_OBJECT',
1704: l_CRS_lookup_meaning);
1705: hr_utility.set_location('after OTA_OBJECT_TYPE 2'||l_proc, 440);
1706: else
1707: WF_ENGINE.setitemattrtext(l_item_type,
1708: l_item_key,
1709: 'REVIEW_OBJECT',
1710: l_CERT_lookup_meaning);
1711: end if;

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

1709: 'REVIEW_OBJECT',
1710: l_CERT_lookup_meaning);
1711: end if;
1712:
1713: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_ID', p_person_id);
1714: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);
1715: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_current_username);
1716: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1717: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);

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

1710: l_CERT_lookup_meaning);
1711: end if;
1712:
1713: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_ID', p_person_id);
1714: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);
1715: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_current_username);
1716: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1717: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1718: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);

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

1711: end if;
1712:
1713: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_ID', p_person_id);
1714: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);
1715: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_current_username);
1716: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1717: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1718: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1719: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);

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

1712:
1713: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_ID', p_person_id);
1714: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);
1715: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_current_username);
1716: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1717: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1718: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1719: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
1720: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );

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

1713: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_ID', p_person_id);
1714: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);
1715: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_current_username);
1716: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1717: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1718: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1719: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
1720: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );
1721: --hard coded date format required by pqh

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

1714: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);
1715: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_current_username);
1716: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1717: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1718: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1719: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
1720: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );
1721: --hard coded date format required by pqh
1722: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));

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

1715: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_current_username);
1716: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1717: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1718: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1719: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
1720: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );
1721: --hard coded date format required by pqh
1722: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
1723: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',trunc(sysdate));

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

1716: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', p_person_id);
1717: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1718: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1719: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
1720: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );
1721: --hard coded date format required by pqh
1722: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
1723: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',trunc(sysdate));
1724: WF_ENGINE.setitemattrDate(p_itemtype, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));

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

1718: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1719: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
1720: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );
1721: --hard coded date format required by pqh
1722: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
1723: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',trunc(sysdate));
1724: WF_ENGINE.setitemattrDate(p_itemtype, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));
1725:
1726: open getFYINtfParamVal('pFyiNtfDetails');

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

1719: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
1720: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );
1721: --hard coded date format required by pqh
1722: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
1723: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',trunc(sysdate));
1724: WF_ENGINE.setitemattrDate(p_itemtype, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));
1725:
1726: open getFYINtfParamVal('pFyiNtfDetails');
1727: fetch getFYINtfParamVal into l_ntfFyiParamVal;

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

1720: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'PROCESS_NAME',p_process );
1721: --hard coded date format required by pqh
1722: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
1723: --WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'P_EFFECTIVE_DATE',trunc(sysdate));
1724: WF_ENGINE.setitemattrDate(p_itemtype, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));
1725:
1726: open getFYINtfParamVal('pFyiNtfDetails');
1727: fetch getFYINtfParamVal into l_ntfFyiParamVal;
1728: close getFYINtfParamVal;

Line 1731: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'FYI_NTF_DETAILS','Y');

1727: fetch getFYINtfParamVal into l_ntfFyiParamVal;
1728: close getFYINtfParamVal;
1729:
1730: if(trim(l_ntfFyiParamVal) = 'Y') then
1731: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'FYI_NTF_DETAILS','Y');
1732: end if;
1733:
1734: -- Get and set owner role
1735:

Line 1744: WF_ENGINE.SetItemOwner(

1740: p_name =>l_role_name,
1741: p_display_name =>l_role_display_name);
1742:
1743:
1744: WF_ENGINE.SetItemOwner(
1745: itemtype => l_item_type,
1746: itemkey =>l_item_key,
1747: owner =>l_role_name);
1748:

Line 1756: WF_ENGINE.setitemattrtext(l_item_type,

1752:
1753: /*l_person_details := ota_learner_enroll_ss.Get_Person_To_Enroll_Details(p_person_id => p_person_id);
1754:
1755: IF l_person_details.full_name is not null then
1756: WF_ENGINE.setitemattrtext(l_item_type,
1757: l_item_key,
1758: 'CURRENT_PERSON_DISPLAY_NAME',
1759: l_person_details.full_name);
1760: WF_ENGINE.setitemattrtext(l_item_type,

Line 1760: WF_ENGINE.setitemattrtext(l_item_type,

1756: WF_ENGINE.setitemattrtext(l_item_type,
1757: l_item_key,
1758: 'CURRENT_PERSON_DISPLAY_NAME',
1759: l_person_details.full_name);
1760: WF_ENGINE.setitemattrtext(l_item_type,
1761: l_item_key,
1762: 'CREATOR_PERSON_DISPLAY_NAME',
1763: l_person_details.full_name);
1764: END IF;*/

Line 1767: WF_ENGINE.setitemattrtext(l_item_type,

1763: l_person_details.full_name);
1764: END IF;*/
1765:
1766: IF l_person_full_name is not null then
1767: WF_ENGINE.setitemattrtext(l_item_type,
1768: l_item_key,
1769: 'CURRENT_PERSON_DISPLAY_NAME',
1770: l_person_full_name);
1771: WF_ENGINE.setitemattrtext(l_item_type,

Line 1771: WF_ENGINE.setitemattrtext(l_item_type,

1767: WF_ENGINE.setitemattrtext(l_item_type,
1768: l_item_key,
1769: 'CURRENT_PERSON_DISPLAY_NAME',
1770: l_person_full_name);
1771: WF_ENGINE.setitemattrtext(l_item_type,
1772: l_item_key,
1773: 'CREATOR_PERSON_DISPLAY_NAME',
1774: l_person_full_name);
1775: END IF;

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

1791: p_date_to => l_eff_date_to);
1792:
1793:
1794: hr_utility.set_location('before supervisor'||l_proc, 30);
1795: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_CUSTOM_RETURN_FOR_CORR','Y');
1796:
1797: --always set to Y
1798: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'YES');
1799: hr_utility.set_location('before supervisor'||l_proc, 40);

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

1794: hr_utility.set_location('before supervisor'||l_proc, 30);
1795: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_CUSTOM_RETURN_FOR_CORR','Y');
1796:
1797: --always set to Y
1798: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'YES');
1799: hr_utility.set_location('before supervisor'||l_proc, 40);
1800: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'P_ASSIGNMENT_ID', l_assignment);
1801: hr_utility.set_location('before supervisor'||l_proc, 50);
1802: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'CURRENT_ASSIGNMENT_ID', to_number(l_assignment));

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

1796:
1797: --always set to Y
1798: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'YES');
1799: hr_utility.set_location('before supervisor'||l_proc, 40);
1800: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'P_ASSIGNMENT_ID', l_assignment);
1801: hr_utility.set_location('before supervisor'||l_proc, 50);
1802: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'CURRENT_ASSIGNMENT_ID', to_number(l_assignment));
1803:
1804: if p_eventId is not null then

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

1798: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'YES');
1799: hr_utility.set_location('before supervisor'||l_proc, 40);
1800: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'P_ASSIGNMENT_ID', l_assignment);
1801: hr_utility.set_location('before supervisor'||l_proc, 50);
1802: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'CURRENT_ASSIGNMENT_ID', to_number(l_assignment));
1803:
1804: if p_eventId is not null then
1805: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_EVENT_TITLE', l_event_name);
1806: end if;

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

1801: hr_utility.set_location('before supervisor'||l_proc, 50);
1802: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'CURRENT_ASSIGNMENT_ID', to_number(l_assignment));
1803:
1804: if p_eventId is not null then
1805: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_EVENT_TITLE', l_event_name);
1806: end if;
1807:
1808: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', l_course_name);
1809: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','SSHRMS');

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

1804: if p_eventId is not null then
1805: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_EVENT_TITLE', l_event_name);
1806: end if;
1807:
1808: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', l_course_name);
1809: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','SSHRMS');
1810: -- bug 3483960
1811: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
1812: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);

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

1805: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_EVENT_TITLE', l_event_name);
1806: end if;
1807:
1808: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', l_course_name);
1809: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','SSHRMS');
1810: -- bug 3483960
1811: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
1812: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
1813: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'TRAN_SUBMIT','Y');

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

1807:
1808: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', l_course_name);
1809: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','SSHRMS');
1810: -- bug 3483960
1811: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
1812: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
1813: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'TRAN_SUBMIT','Y');
1814: --WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);
1815: hr_utility.set_location('before supervisor'||l_proc, 20);

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

1808: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', l_course_name);
1809: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','SSHRMS');
1810: -- bug 3483960
1811: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
1812: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
1813: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'TRAN_SUBMIT','Y');
1814: --WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);
1815: hr_utility.set_location('before supervisor'||l_proc, 20);
1816:

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

1809: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','SSHRMS');
1810: -- bug 3483960
1811: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
1812: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
1813: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'TRAN_SUBMIT','Y');
1814: --WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);
1815: hr_utility.set_location('before supervisor'||l_proc, 20);
1816:
1817: FOR a IN csr_supervisor_id LOOP

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

1810: -- bug 3483960
1811: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
1812: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
1813: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'TRAN_SUBMIT','Y');
1814: --WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);
1815: hr_utility.set_location('before supervisor'||l_proc, 20);
1816:
1817: FOR a IN csr_supervisor_id LOOP
1818: l_supervisor_id := a.supervisor_id;

Line 1829: wf_engine.setitemattrtext

1825: END LOOP;
1826:
1827: hr_utility.set_location('after supervisor cursor'||l_proc, 20);
1828:
1829: wf_engine.setitemattrtext
1830: (l_item_type,
1831: l_item_key,
1832: 'SUPERVISOR_USERNAME',
1833: l_supervisor_username);

Line 1836: wf_engine.setitemattrtext

1832: 'SUPERVISOR_USERNAME',
1833: l_supervisor_username);
1834: hr_utility.set_location('after supervisor username'||l_proc, 20);
1835:
1836: wf_engine.setitemattrtext
1837: (l_item_type,
1838: l_item_key,
1839: 'SUPERVISOR_DISPLAY_NAME',
1840: l_supervisor_full_name);

Line 1842: wf_engine.setitemattrtext

1838: l_item_key,
1839: 'SUPERVISOR_DISPLAY_NAME',
1840: l_supervisor_full_name);
1841: hr_utility.set_location('after supervisor disp name'||l_proc, 20);
1842: wf_engine.setitemattrtext
1843: (l_item_type,
1844: l_item_key,
1845: 'SUPERVISOR_ID',
1846: l_supervisor_id);

Line 1855: WF_ENGINE.setitemattrnumber(l_item_type,

1851: (p_item_type => l_item_type
1852: ,p_item_key => l_item_key
1853: ,p_name => 'OTA_LP_ID');*/
1854:
1855: WF_ENGINE.setitemattrnumber(l_item_type,
1856: l_item_key,
1857: 'BOOKING_ID',
1858: p_learningpath_ids);
1859:

Line 1863: WF_ENGINE.setitemattrnumber(l_item_type,

1859:
1860: elsif p_eventId is not null then
1861:
1862:
1863: WF_ENGINE.setitemattrnumber(l_item_type,
1864: l_item_key,
1865: 'EVENT_ID',
1866: p_eventid);
1867: else

Line 1869: WF_ENGINE.setitemattrnumber(l_item_type,

1865: 'EVENT_ID',
1866: p_eventid);
1867: else
1868:
1869: WF_ENGINE.setitemattrnumber(l_item_type,
1870: l_item_key,
1871: 'RECRUITER_ID',
1872: p_certification_id);
1873: end if;

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

1870: l_item_key,
1871: 'RECRUITER_ID',
1872: p_certification_id);
1873: end if;
1874: WF_ENGINE.STARTPROCESS(p_itemtype,l_item_key);
1875:
1876: end if;
1877: else
1878: CLOSE chk_person_business_grp;