DBA Data[Home] [Help]

APPS.FUN_WF_AUTHORIZATION_LIMIT dependencies on WF_ENGINE

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

75: * If user does not have approval limit set l_result = 'N'
76: */
77:
78: /*
79: wf_engine.SetItemAttrText(itemtype => itemtype,
80: itemkey => itemkey,
81: aname => 'AUTHORIZATION_ERROR',
82: avalue => l_authorization_error);
83: l_transaction_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 83: l_transaction_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

79: wf_engine.SetItemAttrText(itemtype => itemtype,
80: itemkey => itemkey,
81: aname => 'AUTHORIZATION_ERROR',
82: avalue => l_authorization_error);
83: l_transaction_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
84: itemkey => itemkey,
85: aname => 'TRX_ID');
86: l_batch_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,
87: itemkey => itemkey,

Line 86: l_batch_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,

82: avalue => l_authorization_error);
83: l_transaction_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
84: itemkey => itemkey,
85: aname => 'TRX_ID');
86: l_batch_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,
87: itemkey => itemkey,
88: aname => 'BATCH_NUMBER');
89: l_authorization_error := 'Batch Number:'||l_batch_number||', recipients of the Approval Hierarchy do not have the required authorization limits';
90: SELECT nvl(min(authorization_limit), -1)

Line 120: resultout := wf_engine.eng_completed||':T';

116:
117: END IF;*/
118:
119: IF (l_result = 'Y') THEN
120: resultout := wf_engine.eng_completed||':T';
121: RETURN;
122: ELSE
123: resultout := wf_engine.eng_completed||':F';
124: RETURN;

Line 123: resultout := wf_engine.eng_completed||':F';

119: IF (l_result = 'Y') THEN
120: resultout := wf_engine.eng_completed||':T';
121: RETURN;
122: ELSE
123: resultout := wf_engine.eng_completed||':F';
124: RETURN;
125: END IF;
126:
127: resultout := wf_engine.eng_null;

Line 127: resultout := wf_engine.eng_null;

123: resultout := wf_engine.eng_completed||':F';
124: RETURN;
125: END IF;
126:
127: resultout := wf_engine.eng_null;
128: RETURN;
129:
130: EXCEPTION
131:

Line 166: l_transaction_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

162: * If user does not have approval limit set l_result = 'N'
163: */
164:
165: /*
166: l_transaction_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
167: itemkey => itemkey,
168: aname => 'TRX_ID');
169: SELECT nvl(min(authorization_limit), -1)
170: INTO l_limit

Line 190: resultout := wf_engine.eng_completed||':T';

186: l_result := 'N';
187: END IF; */
188:
189: IF (l_result = 'Y') THEN
190: resultout := wf_engine.eng_completed||':T';
191: RETURN;
192: ELSE
193: resultout := wf_engine.eng_completed||':F';
194: RETURN;

Line 193: resultout := wf_engine.eng_completed||':F';

189: IF (l_result = 'Y') THEN
190: resultout := wf_engine.eng_completed||':T';
191: RETURN;
192: ELSE
193: resultout := wf_engine.eng_completed||':F';
194: RETURN;
195: END IF;
196:
197: resultout := wf_engine.eng_null;

Line 197: resultout := wf_engine.eng_null;

193: resultout := wf_engine.eng_completed||':F';
194: RETURN;
195: END IF;
196:
197: resultout := wf_engine.eng_null;
198: RETURN;
199:
200: EXCEPTION
201: