DBA Data[Home] [Help]

APPS.PQH_SS_UTILITY dependencies on WF_ENGINE

Line 672: l_approval_process_version := wf_engine.GetItemAttrText(

668: function get_approval_process_version(p_itemType varchar2, p_itemKey varchar2 )
669: return varchar2 is
670: l_approval_process_version varchar2(10);
671: begin
672: l_approval_process_version := wf_engine.GetItemAttrText(
673: itemtype => p_itemType,
674: itemkey => p_itemKey,
675: aname => 'HR_APPROVAL_PRC_VERSION');
676: return l_approval_process_version;

Line 853: l_rehire_flow := wf_engine.GetItemAttrText(l_item_type,l_item_key,'HR_FLOW_IDENTIFIER',true);

849: OPEN cur_txnStep (p_txnId);
850: FETCH cur_txnStep INTO l_item_type,l_item_key;
851: CLOSE cur_txnStep;
852: if l_item_type is not null and l_item_key is not null then
853: l_rehire_flow := wf_engine.GetItemAttrText(l_item_type,l_item_key,'HR_FLOW_IDENTIFIER',true);
854: end if;
855: /*
856: l_person_id := wf_engine.GetItemAttrText(l_item_type,l_item_key,'CURRENT_PERSON_ID',true);
857:

Line 856: l_person_id := wf_engine.GetItemAttrText(l_item_type,l_item_key,'CURRENT_PERSON_ID',true);

852: if l_item_type is not null and l_item_key is not null then
853: l_rehire_flow := wf_engine.GetItemAttrText(l_item_type,l_item_key,'HR_FLOW_IDENTIFIER',true);
854: end if;
855: /*
856: l_person_id := wf_engine.GetItemAttrText(l_item_type,l_item_key,'CURRENT_PERSON_ID',true);
857:
858: open chk_ex_emp(l_person_id, p_effectiveDate);
859: fetch chk_ex_emp into l_ex_emp;
860: close chk_ex_emp;