5898: l_superceding_proc_param := p_source_type||', '||p_source_code||', '||
5899: g_payroll_id||', '||p_time_period_id||', '||p_batch_name;
5900: end if;
5901:
5902: wf_engine.CreateProcess(itemtype => 'PSPERAVL',
5903: itemkey => l_wf_itemkey,
5904: process => 'SUPERCEDE_PROCESS');
5905:
5906:
5904: process => 'SUPERCEDE_PROCESS');
5905:
5906:
5907: /*Added for bug 7004679 */
5908: wf_engine.setitemowner(itemtype => 'PSPERAVL',
5909: itemkey => l_wf_itemkey,
5910: owner => p_wf_user);
5911:
5912:
5910: owner => p_wf_user);
5911:
5912:
5913:
5914: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
5915: itemkey => l_wf_itemkey,
5916: aname => 'SUPERCEDING_PROC_NAME',
5917: avalue => l_superceding_process);
5918:
5915: itemkey => l_wf_itemkey,
5916: aname => 'SUPERCEDING_PROC_NAME',
5917: avalue => l_superceding_process);
5918:
5919: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
5920: itemkey => l_wf_itemkey,
5921: aname => 'SUPERCEDING_PAYROLL_SOURCE',
5922: avalue => p_source_type);
5923:
5920: itemkey => l_wf_itemkey,
5921: aname => 'SUPERCEDING_PAYROLL_SOURCE',
5922: avalue => p_source_type);
5923:
5924: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
5925: itemkey => l_wf_itemkey,
5926: aname => 'SUPERCEDING_PROC_PARAM',
5927: avalue => l_superceding_proc_param);
5928:
5925: itemkey => l_wf_itemkey,
5926: aname => 'SUPERCEDING_PROC_PARAM',
5927: avalue => l_superceding_proc_param);
5928:
5929: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
5930: itemkey => l_wf_itemkey,
5931: aname => 'SUPERCEDED_ER_REQ_ID_STR',
5932: avalue => p_supercede_reqid_str);
5933:
5930: itemkey => l_wf_itemkey,
5931: aname => 'SUPERCEDED_ER_REQ_ID_STR',
5932: avalue => p_supercede_reqid_str);
5933:
5934: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',
5935: itemkey => l_wf_itemkey,
5936: aname => 'SUPERCEDING_S_AND_T_REQID',
5937: avalue => p_SandT_reqid);
5938:
5935: itemkey => l_wf_itemkey,
5936: aname => 'SUPERCEDING_S_AND_T_REQID',
5937: avalue => p_SandT_reqid);
5938:
5939: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
5940: itemkey => l_wf_itemkey,
5941: aname => 'SUPERCEDE_RECIPIENT_TYPE',
5942: avalue => p_approver_type); --- initiatior, final recipients,
5943: ---- employee, past approvers
5940: itemkey => l_wf_itemkey,
5941: aname => 'SUPERCEDE_RECIPIENT_TYPE',
5942: avalue => p_approver_type); --- initiatior, final recipients,
5943: ---- employee, past approvers
5944: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
5945: itemkey => l_wf_itemkey,
5946: aname => 'TEMPLATE_NAME',
5947: avalue => l_template_name);
5948:
5945: itemkey => l_wf_itemkey,
5946: aname => 'TEMPLATE_NAME',
5947: avalue => l_template_name);
5948:
5949: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',
5950: itemkey => l_wf_itemkey,
5951: aname => 'PERSON_ID',
5952: avalue => p_person_id);
5953:
5950: itemkey => l_wf_itemkey,
5951: aname => 'PERSON_ID',
5952: avalue => p_person_id);
5953:
5954: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
5955: itemkey => l_wf_itemkey,
5956: aname => 'APPROVER_ROLE_NAME',
5957: avalue => p_wf_user);
5958:
5955: itemkey => l_wf_itemkey,
5956: aname => 'APPROVER_ROLE_NAME',
5957: avalue => p_wf_user);
5958:
5959: wf_engine.StartProcess(itemtype => 'PSPERAVL',
5960: itemkey => l_wf_itemkey);
5961: EXCEPTION
5962: when others then
5963: hr_utility.trace( 'SandT_Supercede-->send notifications --> call_wf when others '||sqlerrm);