DBA Data[Home] [Help]

APPS.PA_DCTN_APRV_NOTIFICATION dependencies on WF_ENGINE

Line 87: WF_ENGINE.CreateProcess( itemtype => itemtype,

83: l_workflow_started_by_id := FND_GLOBAL.user_id;
84: l_resp_id := FND_GLOBAL.resp_id;
85:
86: -- Create a new Wf process
87: WF_ENGINE.CreateProcess( itemtype => itemtype,
88: itemkey => itemkey,
89: process => l_process);
90:
91:

Line 131: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

127: );
128: END IF;
129:
130: IF l_proj_info_rec.project_id IS NOT NULL THEN
131: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
132: ,itemkey => itemkey
133: ,aname => 'PROJECT_ID'
134: ,avalue => l_proj_info_rec.project_id
135: );

Line 139: WF_ENGINE.SetItemAttrText (itemtype => itemtype

135: );
136: END IF;
137:
138: IF l_proj_info_rec.project_number IS NOT NULL THEN
139: WF_ENGINE.SetItemAttrText (itemtype => itemtype
140: ,itemkey => itemkey
141: ,aname => 'PROJECT_NUMBER'
142: ,avalue => l_proj_info_rec.project_number
143: );

Line 147: WF_ENGINE.SetItemAttrText (itemtype => itemtype

143: );
144: END IF;
145:
146: IF l_proj_info_rec.project_name IS NOT NULL THEN
147: WF_ENGINE.SetItemAttrText (itemtype => itemtype
148: ,itemkey => itemkey
149: ,aname => 'PROJECT_NAME'
150: ,avalue => l_proj_info_rec.project_name
151: );

Line 155: WF_ENGINE.SetItemAttrText (itemtype => itemtype

151: );
152: END IF;
153:
154: IF c_dctn_hdr_rec.deduction_req_num IS NOT NULL THEN
155: WF_ENGINE.SetItemAttrText (itemtype => itemtype
156: ,itemkey => itemkey
157: ,aname => 'DEDUCTION_REQ_NUM'
158: ,avalue => c_dctn_hdr_rec.deduction_req_num
159: );

Line 163: WF_ENGINE.SetItemAttrText (itemtype => itemtype

159: );
160: END IF;
161:
162: IF c_dctn_hdr_rec.currency_code IS NOT NULL THEN
163: WF_ENGINE.SetItemAttrText (itemtype => itemtype
164: ,itemkey => itemkey
165: ,aname => 'CURRENCY_CODE'
166: ,avalue => c_dctn_hdr_rec.currency_code
167: );

Line 171: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

167: );
168: END IF;
169:
170: IF c_dctn_hdr_rec.total_amount IS NOT NULL THEN
171: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
172: ,itemkey => itemkey
173: ,aname => 'APPLIED_AMOUNT'
174: ,avalue => c_dctn_hdr_rec.total_amount
175: );

Line 179: WF_ENGINE.SetItemAttrText (itemtype => itemtype

175: );
176: END IF;
177:
178: IF c_dctn_hdr_rec.debit_memo_num IS NOT NULL THEN
179: WF_ENGINE.SetItemAttrText (itemtype => itemtype
180: ,itemkey => itemkey
181: ,aname => 'DEBIT_MEMO_NUM'
182: ,avalue => c_dctn_hdr_rec.debit_memo_num
183: );

Line 188: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

184: END IF;
185:
186: IF c_dctn_hdr_rec.vendor_id IS NOT NULL THEN
187:
188: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
189: ,itemkey => itemkey
190: ,aname => 'VENDOR_ID'
191: ,avalue => c_dctn_hdr_rec.vendor_id
192: );

Line 194: WF_ENGINE.SetItemAttrText (itemtype => itemtype

190: ,aname => 'VENDOR_ID'
191: ,avalue => c_dctn_hdr_rec.vendor_id
192: );
193:
194: WF_ENGINE.SetItemAttrText (itemtype => itemtype
195: ,itemkey => itemkey
196: ,aname => 'VENDOR_NAME'
197: ,avalue => l_vendor_name
198: );

Line 203: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

199: END IF;
200:
201:
202: IF l_content_id IS NOT NULL THEN
203: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
204: ,itemkey => itemkey
205: ,aname => 'CONTENT_ID'
206: ,avalue => l_content_id
207: );

Line 211: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

207: );
208: END IF;
209:
210: IF l_workflow_started_by_id IS NOT NULL THEN
211: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
212: ,itemkey => itemkey
213: ,aname => 'WORKFLOW_STARTED_BY_ID'
214: ,avalue => l_workflow_started_by_id
215: );

Line 219: WF_ENGINE.SetItemAttrText (itemtype => itemtype

215: );
216: END IF;
217:
218: IF l_user_name IS NOT NULL THEN
219: WF_ENGINE.SetItemAttrText (itemtype => itemtype
220: ,itemkey => itemkey
221: ,aname => 'WORKFLOW_STARTED_BY_NAME'
222: ,avalue => l_user_name
223: );

Line 227: WF_ENGINE.SetItemAttrText (itemtype => itemtype

223: );
224: END IF;
225:
226: IF l_user_full_name IS NOT NULL THEN
227: WF_ENGINE.SetItemAttrText (itemtype => itemtype
228: ,itemkey => itemkey
229: ,aname => 'WORKFLOW_STARTED_BY_FULL_NAME'
230: ,avalue => l_user_full_name
231: );

Line 235: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

231: );
232: END IF;
233:
234: IF l_resp_id IS NOT NULL THEN
235: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
236: ,itemkey => itemkey
237: ,aname => 'RESPONSIBILITY_ID'
238: ,avalue => l_resp_id
239: );

Line 243: WF_ENGINE.SetItemAttrText (itemtype => itemtype

239: );
240: END IF;
241:
242: IF l_wf_started_date IS NOT NULL THEN
243: WF_ENGINE.SetItemAttrText (itemtype => itemtype
244: ,itemkey => itemkey
245: ,aname => 'WF_STARTED_DATE'
246: ,avalue => l_wf_started_date
247: );

Line 250: WF_ENGINE.StartProcess (itemtype => itemtype

246: ,avalue => l_wf_started_date
247: );
248: END IF;
249:
250: WF_ENGINE.StartProcess (itemtype => itemtype
251: ,itemkey => itemkey
252: );
253:
254:

Line 661: IF (funcmode <> wf_engine.eng_run) THEN

657: BEGIN
658: --
659: -- Return if WF Not Running
660: --
661: IF (funcmode <> wf_engine.eng_run) THEN
662: resultout := wf_engine.eng_null;
663: RETURN;
664: END IF;
665:

Line 662: resultout := wf_engine.eng_null;

658: --
659: -- Return if WF Not Running
660: --
661: IF (funcmode <> wf_engine.eng_run) THEN
662: resultout := wf_engine.eng_null;
663: RETURN;
664: END IF;
665:
666: l_resp_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

Line 666: l_resp_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

662: resultout := wf_engine.eng_null;
663: RETURN;
664: END IF;
665:
666: l_resp_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
667: ,itemkey => itemkey
668: ,aname => 'RESPONSIBILITY_ID');
669:
670: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

Line 670: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

666: l_resp_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
667: ,itemkey => itemkey
668: ,aname => 'RESPONSIBILITY_ID');
669:
670: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
671: ,itemkey => itemkey
672: ,aname => 'PROJECT_ID');
673:
674: l_workflow_started_by_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

Line 674: l_workflow_started_by_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

670: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
671: ,itemkey => itemkey
672: ,aname => 'PROJECT_ID');
673:
674: l_workflow_started_by_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
675: ,itemkey => itemkey
676: ,aname => 'WORKFLOW_STARTED_BY_ID');
677:
678: -- Based on the Responsibility, Intialize the Application

Line 708: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

704: IF (c_manager%FOUND) THEN
705: IF c_manager%ISOPEN THEN
706: CLOSE c_manager;
707: END IF;
708: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
709: ,itemkey => itemkey
710: ,aname => 'PROJECT_MANAGER_ID'
711: ,avalue => l_manager_user_id );
712: WF_ENGINE.SetItemAttrText (itemtype => itemtype

Line 712: WF_ENGINE.SetItemAttrText (itemtype => itemtype

708: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
709: ,itemkey => itemkey
710: ,aname => 'PROJECT_MANAGER_ID'
711: ,avalue => l_manager_user_id );
712: WF_ENGINE.SetItemAttrText (itemtype => itemtype
713: ,itemkey => itemkey
714: ,aname => 'PROJECT_MANAGER_NAME'
715: ,avalue => l_manager_user_name);
716: WF_ENGINE.SetItemAttrText (itemtype => itemtype

Line 716: WF_ENGINE.SetItemAttrText (itemtype => itemtype

712: WF_ENGINE.SetItemAttrText (itemtype => itemtype
713: ,itemkey => itemkey
714: ,aname => 'PROJECT_MANAGER_NAME'
715: ,avalue => l_manager_user_name);
716: WF_ENGINE.SetItemAttrText (itemtype => itemtype
717: ,itemkey => itemkey
718: ,aname => 'PROJECT_MANAGER_FULL_NAME'
719: ,avalue => l_manager_full_name);
720:

Line 721: resultout := WF_ENGINE.eng_completed||':'||'T';

717: ,itemkey => itemkey
718: ,aname => 'PROJECT_MANAGER_FULL_NAME'
719: ,avalue => l_manager_full_name);
720:
721: resultout := WF_ENGINE.eng_completed||':'||'T';
722: ELSE
723: IF c_manager%ISOPEN THEN
724: CLOSE c_manager;
725: END IF;

Line 726: resultout := WF_ENGINE.eng_completed||':'||'F';

722: ELSE
723: IF c_manager%ISOPEN THEN
724: CLOSE c_manager;
725: END IF;
726: resultout := WF_ENGINE.eng_completed||':'||'F';
727: END IF;
728: ELSE
729: resultout := WF_ENGINE.eng_completed||':'||'F';
730: END IF;

Line 729: resultout := WF_ENGINE.eng_completed||':'||'F';

725: END IF;
726: resultout := WF_ENGINE.eng_completed||':'||'F';
727: END IF;
728: ELSE
729: resultout := WF_ENGINE.eng_completed||':'||'F';
730: END IF;
731:
732: EXCEPTION
733: WHEN FND_API.G_EXC_ERROR THEN

Line 857: WF_ENGINE.GetItemAttrText

853: l_return_status VARCHAR2(4000);
854: BEGIN
855: resultout := 'COMPLETE : SUCCESS';
856: l_deduction_req_num:=
857: WF_ENGINE.GetItemAttrText
858: (itemtype => itemtype
859: ,itemkey => itemkey
860: ,aname => 'DEDUCTION_REQ_NUM' );
861: