DBA Data[Home] [Help]

APPS.PQP_SS_VEHICLE_MILEAGE_CLAIMS dependencies on WF_ENGINE

Line 59: l_attr:= wf_engine.GetItemAttrText(

55: BEGIN
56:
57: --Get the status whether the process is in Update or Insert mode
58:
59: l_attr:= wf_engine.GetItemAttrText(
60: itemtype => itemtype,
61: itemkey =>itemkey,
62: aname =>'PQP_DML_STATUS_TYPE_ATTR',
63: ignore_notfound =>l_ignore);

Line 83: l_transaction_id:= wf_engine.GetItemAttrNumber(

79: l_transaction_id number;
80: l_attr varchar2(30);
81: l_ignore boolean ;
82: BEGIN
83: l_transaction_id:= wf_engine.GetItemAttrNumber(
84: itemtype => itemtype,
85: itemkey =>itemkey,
86: aname => 'TRANSACTION_ID',
87: ignore_notfound =>l_ignore);

Line 91: l_attr:= wf_engine.GetActivityAttrText(

87: ignore_notfound =>l_ignore);
88:
89: --Check if approval flag is set to yes in the WF
90:
91: l_attr:= wf_engine.GetActivityAttrText(
92: itemtype => itemtype,
93: itemkey =>itemkey,
94: aname =>'PQP_APPROVAL_REQUIRED',
95: actid =>actid , --'PQP_APPROVAL_REQUIRED',

Line 99: wf_engine.SetItemAttrText(itemtype => itemtype,

95: actid =>actid , --'PQP_APPROVAL_REQUIRED',
96: ignore_notfound =>l_ignore);
97:
98: --Set the same value to determine the process
99: wf_engine.SetItemAttrText(itemtype => itemtype,
100: itemkey =>itemkey,
101: aname =>'HR_RUNTIME_APPROVAL_REQ_FLAG',
102: avalue =>'YES');
103:

Line 123: wf_engine.setItemAttrNumber (

119: BEGIN
120: --
121: savepoint rollback_transaction;
122: --
123: wf_engine.setItemAttrNumber (
124: itemType => itemType,
125: itemKey => itemKey,
126: aname => 'TRANSACTION_ID',
127: avalue => null );

Line 921: wf_engine.setitemattrnumber

917: ,p_effective_date_option =>x_effective_date_option
918: ,p_transaction_id => l_transaction_id
919: );
920:
921: wf_engine.setitemattrnumber
922: (itemtype => x_item_type
923: ,itemkey => x_item_key
924: ,aname => 'TRANSACTION_ID'
925: ,avalue => l_transaction_id);

Line 1286: nval1 := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey,actid, 'VALUE1');

1282: l_resultout varchar2(200) := resultout;
1283: --
1284: BEGIN
1285: --
1286: nval1 := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey,actid, 'VALUE1');
1287: nval2 := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey,actid, 'VALUE2');
1288:
1289: IF nval1 = nval2 THEN
1290: resultout := 'SELF';

Line 1287: nval2 := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey,actid, 'VALUE2');

1283: --
1284: BEGIN
1285: --
1286: nval1 := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey,actid, 'VALUE1');
1287: nval2 := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey,actid, 'VALUE2');
1288:
1289: IF nval1 = nval2 THEN
1290: resultout := 'SELF';
1291: ELSE