APPS.PQH_SS_HISTORY dependencies on WF_ENGINE

Line 32: p_orig_system_id := wf_engine.getitemattrnumber(

28: -- get the orig_system and system id details
29: -- currently we have only two use cases
30: if(p_wf_ref_attr='FORWARD_TO_USERNAME') then
31: -- p_orig_system_id
32: p_orig_system_id := wf_engine.getitemattrnumber(
33: p_item_type,
34: p_item_key,
35: 'FORWARD_TO_PERSON_ID',
36: true);

Line 38: p_orig_system := nvl(wf_engine.getitemattrtext(

34: p_item_key,
35: 'FORWARD_TO_PERSON_ID',
36: true);
37: --p_orig_system
38: p_orig_system := nvl(wf_engine.getitemattrtext(
39: p_item_type,
40: p_item_key,
41: 'FORWARD_TO_ORIG_SYS_ATTR',
42: true),'PER');

Line 45: p_orig_system_id := wf_engine.getitemattrnumber(

41: 'FORWARD_TO_ORIG_SYS_ATTR',
42: true),'PER');
43: elsif(p_wf_ref_attr='CREATOR_PERSON_USERNAME') then
44: -- p_orig_system_id
45: p_orig_system_id := wf_engine.getitemattrnumber(
46: p_item_type,
47: p_item_key,
48: 'CREATOR_PERSON_ID',
49: true);

Line 304: wf_engine.GetItemAttrText(

300: l_orig_system wf_users.orig_system%type;
301: l_orig_system_id wf_users.orig_system_id%type;
302: BEGIN
303: /* l_username :=
304: wf_engine.GetItemAttrText(
305: itemtype => p_itemType,
306: itemkey => p_itemKey,
307: aname => 'FORWARD_TO_USERNAME');*/
308: getRoleOrigSysInfo(p_item_type=>p_itemType,

Line 358: wf_engine.GetItemAttrText(

354: --
355: BEGIN
356: if ( funmode = 'RUN' ) THEN
357: /* l_username :=
358: wf_engine.GetItemAttrText(
359: itemtype => itemType,
360: itemkey => itemKey,
361: aname => 'CREATOR_PERSON_USERNAME');*/
362: getRoleOrigSysInfo(p_item_type=>itemtype,

Line 574: wf_engine.getitemattrtext(p_ItemType,

570: if(p_action='SUBMIT') then
571: hr_trans_history_api.archive_submit(p_transactionId,
572: null,
573: p_username,
574: wf_engine.getitemattrtext(p_ItemType,
575: p_itemKey,
576: 'APPROVAL_COMMENT_COPY'));
577:
578: elsif(p_action='RESUBMIT') then

Line 582: wf_engine.getitemattrtext(p_ItemType,

578: elsif(p_action='RESUBMIT') then
579: hr_trans_history_api.archive_resubmit(p_transactionId,
580: null,
581: p_username,
582: wf_engine.getitemattrtext(p_ItemType,
583: p_itemKey,
584: 'APPROVAL_COMMENT_COPY'));
585: elsif(p_action='APPROVED') then
586: hr_trans_history_api.archive_approve(p_transactionId,

Line 589: wf_engine.getitemattrtext(p_ItemType,

585: elsif(p_action='APPROVED') then
586: hr_trans_history_api.archive_approve(p_transactionId,
587: null,
588: p_username,
589: wf_engine.getitemattrtext(p_ItemType,
590: p_itemKey,
591: 'WF_NOTE'));
592: elsif(p_action='REJECTED') then
593: hr_trans_history_api.archive_reject(p_transactionId,

Line 596: wf_engine.getitemattrtext(p_ItemType,

592: elsif(p_action='REJECTED') then
593: hr_trans_history_api.archive_reject(p_transactionId,
594: null,
595: p_username,
596: wf_engine.getitemattrtext(p_ItemType,
597: p_itemKey,
598: 'WF_NOTE'));
599: elsif(p_action='DELETED') then
600: hr_trans_history_api.archive_delete(p_transactionId,

Line 603: wf_engine.getitemattrtext(p_ItemType,

599: elsif(p_action='DELETED') then
600: hr_trans_history_api.archive_delete(p_transactionId,
601: null,
602: p_username,
603: wf_engine.getitemattrtext(p_ItemType,
604: p_itemKey,
605: 'WF_NOTE'));
606: elsif(p_action='RFC') then
607: hr_trans_history_api.archive_rfc(p_transactionId,

Line 610: wf_engine.getitemattrtext(p_ItemType,

606: elsif(p_action='RFC') then
607: hr_trans_history_api.archive_rfc(p_transactionId,
608: null,
609: p_username,
610: wf_engine.getitemattrtext(p_ItemType,
611: p_itemKey,
612: 'NOTE_FROM_APPR',true));
613: end if;
614: end if;