DBA Data[Home] [Help]

APPS.PQH_BUDGET dependencies on WF_ENGINE

Line 286: wf_engine.completeactivity(l_workflow_name,l_itemkey,'DELEGATE_BLOCK-1','COMPLETE');

282: -- at delegate_block activity, moving it from there to end reject
283:
284: begin
285: hr_utility.set_location('going for block activity completion',77);
286: wf_engine.completeactivity(l_workflow_name,l_itemkey,'DELEGATE_BLOCK-1','COMPLETE');
287: hr_utility.set_location('block activity completed',78);
288: exception
289: when others then
290: hr_utility.set_location(substr(sqlerrm,1,55),80);

Line 301: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

297: elsif i.status ='DELEGATED' then
298: -- if the delegated worksheet is waiting in inbox for the sender then it can be directly rejected
299: begin
300: hr_utility.set_location('coming to approve the delegated transaction',95);
301: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
302: itemkey => l_itemkey,
303: aname => 'TRANSACTION_STATUS',
304: avalue => 'FRC_RJCT');
305: wf_engine.completeactivity(l_workflow_name,l_itemkey,'NTF_NEXT_USER','FRC_RJCT');

Line 305: wf_engine.completeactivity(l_workflow_name,l_itemkey,'NTF_NEXT_USER','FRC_RJCT');

301: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
302: itemkey => l_itemkey,
303: aname => 'TRANSACTION_STATUS',
304: avalue => 'FRC_RJCT');
305: wf_engine.completeactivity(l_workflow_name,l_itemkey,'NTF_NEXT_USER','FRC_RJCT');
306: exception
307: when others then
308: hr_utility.set_location(substr(sqlerrm,1,55),100);
309: hr_utility.set_location(substr(sqlerrm,56,55),101);

Line 365: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

361: hr_utility.set_location('wf completed for children of '||i.worksheet_detail_id||l_proc,153);
362: l_itemkey := to_char(p_transaction_category_id) ||'-'||to_char(i.worksheet_detail_id);
363: if i.status = 'DELEGATED' then
364: begin
365: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
366: itemkey => l_itemkey,
367: aname => 'TRANSACTION_STATUS',
368: avalue => 'FRC_RJCT');
369: wf_engine.completeactivity(l_workflow_name,l_itemkey,'NTF_NEXT_USER','FRC_RJCT');

Line 369: wf_engine.completeactivity(l_workflow_name,l_itemkey,'NTF_NEXT_USER','FRC_RJCT');

365: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
366: itemkey => l_itemkey,
367: aname => 'TRANSACTION_STATUS',
368: avalue => 'FRC_RJCT');
369: wf_engine.completeactivity(l_workflow_name,l_itemkey,'NTF_NEXT_USER','FRC_RJCT');
370: exception
371: when others then
372: hr_utility.set_location(substr(sqlerrm,1,55),160);
373: hr_utility.set_location(substr(sqlerrm,56,55),161);