DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on WF_ENGINE

Line 5420: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

5416:
5417:
5418: -- Get the workflow attribute values
5419: --
5420: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5421: itemkey => itemkey,
5422: aname => 'PERSON_ID' );
5423:
5424: --get the future_term_wf_flag from pa_resources

Line 5442: resultout := wf_engine.eng_completed||':'||'E';

5438: FETCH c_act_term_date INTO l_end_date;
5439:
5440: IF c_act_term_date%NOTFOUND THEN
5441: CLOSE c_act_term_date;
5442: resultout := wf_engine.eng_completed||':'||'E';
5443: IF (l_pa_debug_mode = 'Y') THEN
5444: pa_debug.write('PA_RESOURCE_UTILS',
5445: 'log: ' || 'in procedure is_term_as_of_sys_date, no end date found', 3);
5446: END IF;

Line 5458: resultout := wf_engine.eng_completed||':'||'S';

5454: END IF;
5455:
5456:
5457: IF ((l_future_term_wf_flag = 'Y') AND (l_end_date <= trunc(sysdate))) THEN --Bug#9463127
5458: resultout := wf_engine.eng_completed||':'||'S';
5459: ELSE
5460: resultout := wf_engine.eng_completed||':'||'E';
5461: END IF ;
5462:

Line 5460: resultout := wf_engine.eng_completed||':'||'E';

5456:
5457: IF ((l_future_term_wf_flag = 'Y') AND (l_end_date <= trunc(sysdate))) THEN --Bug#9463127
5458: resultout := wf_engine.eng_completed||':'||'S';
5459: ELSE
5460: resultout := wf_engine.eng_completed||':'||'E';
5461: END IF ;
5462:
5463: END IF ; --IF c_act_term_date%NOTFOUND
5464:

Line 5479: resultout := wf_engine.eng_completed||':'||'U';

5475: itemtype,
5476: itemkey,
5477: to_char(actid),
5478: funcmode);
5479: resultout := wf_engine.eng_completed||':'||'U';
5480:
5481:
5482:
5483: END is_term_as_of_sys_date;