DBA Data[Home] [Help]

APPS.AMS_LIST_WF dependencies on WF_ENGINE

Line 149: WF_ENGINE.CreateProcess (itemtype => 'AMSLISTG', --itemtype,

145: --dbms_output.put_line('listname ->' || l_clistheader_rec.list_name);
146: --dbms_output.put_line('object->' || l_clistheader_rec.object_version_number);
147: itemkey := p_list_header_id ||'_'||
148: l_clistheader_rec.object_version_number;
149: WF_ENGINE.CreateProcess (itemtype => 'AMSLISTG', --itemtype,
150: itemkey => itemkey ,
151: process => 'LIST_GENERATION');
152:
153:

Line 156: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

152:
153:
154:
155: --dbms_output.put_line('listname ->' || l_clistheader_rec.list_name);
156: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
157: itemkey => itemkey,
158: aname => 'LIST_NAME',
159: avalue => l_clistheader_rec.list_name);
160:

Line 161: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

157: itemkey => itemkey,
158: aname => 'LIST_NAME',
159: avalue => l_clistheader_rec.list_name);
160:
161: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
162: itemkey => itemkey,
163: aname => 'LIST_TYPE',
164: avalue => l_clistheader_rec.list_type);
165:

Line 167: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

163: aname => 'LIST_TYPE',
164: avalue => l_clistheader_rec.list_type);
165:
166: --dbms_output.put_line('listname ->' || l_clistheader_rec.list_header_id);
167: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
168: itemkey => itemkey,
169: aname => 'LIST_HEADER_ID',
170: avalue => l_clistheader_rec.list_header_id);
171:

Line 173: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

169: aname => 'LIST_HEADER_ID',
170: avalue => l_clistheader_rec.list_header_id);
171:
172: --dbms_output.put_line('status ifd ->' || l_clistheader_rec.user_status_id);
173: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
174: itemkey => itemkey,
175: aname => 'LIST_STATUS_ID',
176: avalue => l_clistheader_rec.user_status_id);
177:

Line 179: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

175: aname => 'LIST_STATUS_ID',
176: avalue => l_clistheader_rec.user_status_id);
177:
178: --dbms_output.put_line('status cde ->' || l_clistheader_rec.status_code);
179: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
180: itemkey => itemkey,
181: aname => 'LIST_STATUS_CODE',
182: avalue => l_clistheader_rec.status_code);
183:

Line 184: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

180: itemkey => itemkey,
181: aname => 'LIST_STATUS_CODE',
182: avalue => l_clistheader_rec.status_code);
183:
184: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
185: itemkey => itemkey,
186: aname => 'MONITOR_URL',
187: avalue => wf_monitor.geturl(
188: wf_core.TRANSLATE('WF_WEB_AGENT'),

Line 194: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

190: itemkey,
191: 'NO'));
192:
193: --dbms_output.put_line('status ifd ->' || l_clistheader_rec.user_entered_start_time);
194: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
195: itemkey => itemkey,
196: aname => 'WAITING_TIME',
197: avalue => l_clistheader_rec.user_entered_start_time);
198: --bmuthukr for bug 3895455. Getting last updated user's id and passing..instead of passing owner id.

Line 214: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

210: RAISE FND_API.G_EXC_ERROR;
211: END IF;
212:
213:
214: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
215: itemkey => itemkey,
216: aname => 'LIST_OWNER',
217: avalue => l_requester_role );
218:

Line 221: WF_ENGINE.SetItemOwner(itemtype => itemtype,

217: avalue => l_requester_role );
218:
219:
220:
221: WF_ENGINE.SetItemOwner(itemtype => itemtype,
222: itemkey => itemkey,
223: owner => l_requester_role);
224:
225:

Line 228: WF_ENGINE.StartProcess (itemtype => itemtype,

224:
225:
226:
227:
228: WF_ENGINE.StartProcess (itemtype => itemtype,
229: itemkey => itemkey);
230:
231: EXCEPTION
232: WHEN OTHERS THEN

Line 280: l_list_header_id := WF_ENGINE.getItemAttrNumber

276: l_error_msg VARCHAR2(4000);
277: BEGIN
278: -- RUN mode - Normal Process Execution
279: IF (funcmode = 'RUN') THEN
280: l_list_header_id := WF_ENGINE.getItemAttrNumber
281: (itemtype => itemtype,
282: itemkey => itemkey,
283: aname => 'LIST_HEADER_ID');
284:

Line 345: l_list_header_id := WF_ENGINE.getItemAttrNumber

341: l_error_msg VARCHAR2(4000);
342: BEGIN
343: -- RUN mode - Normal Process Execution
344: IF (funcmode = 'RUN') THEN
345: l_list_header_id := WF_ENGINE.getItemAttrNumber
346: (itemtype => itemtype,
347: itemkey => itemkey,
348: aname => 'LIST_HEADER_ID');
349:

Line 350: l_gen_date := WF_ENGINE.getItemAttrDate

346: (itemtype => itemtype,
347: itemkey => itemkey,
348: aname => 'LIST_HEADER_ID');
349:
350: l_gen_date := WF_ENGINE.getItemAttrDate
351: (itemtype => itemtype,
352: itemkey => itemkey,
353: aname => 'WAITING_TIME');
354: if l_gen_date > sysdate then

Line 418: l_list_header_id := WF_ENGINE.getItemAttrNumber

414: l_list_type varchar2(30);
415: BEGIN
416: -- RUN mode - Normal Process Execution
417: IF (funcmode = 'RUN') THEN
418: l_list_header_id := WF_ENGINE.getItemAttrNumber
419: (itemtype => itemtype,
420: itemkey => itemkey,
421: aname => 'LIST_HEADER_ID');
422: l_list_type := WF_ENGINE.getItemAttrText

Line 422: l_list_type := WF_ENGINE.getItemAttrText

418: l_list_header_id := WF_ENGINE.getItemAttrNumber
419: (itemtype => itemtype,
420: itemkey => itemkey,
421: aname => 'LIST_HEADER_ID');
422: l_list_type := WF_ENGINE.getItemAttrText
423: (itemtype => itemtype,
424: itemkey => itemkey,
425: aname => 'LIST_TYPE');
426: update ams_list_headers_all

Line 489: l_list_header_id := WF_ENGINE.getItemAttrNumber

485:
486: BEGIN
487: -- RUN mode - Normal Process Execution
488: IF (funcmode = 'RUN') THEN
489: l_list_header_id := WF_ENGINE.getItemAttrNumber
490: (itemtype => itemtype,
491: itemkey => itemkey,
492: aname => 'LIST_HEADER_ID');
493:

Line 714: l_list_header_id := WF_ENGINE.GetItemAttrText(

710: Ams_Utility_pvt.debug_message('Start');
711: END IF;
712:
713: --dbms_output.put_line('Start');
714: l_list_header_id := WF_ENGINE.GetItemAttrText(
715: itemtype => itemtype,
716: itemkey => itemkey ,
717: aname => 'LIST_HEADER_ID');
718:

Line 738: WF_ENGINE.CreateProcess (itemtype => 'AMSLISTG', --itemtype,

734: update ams_list_headers_all
735: set object_version_number = object_version_number + 1
736: where list_header_id = l_list_header_id;
737: /*
738: WF_ENGINE.CreateProcess (itemtype => 'AMSLISTG', --itemtype,
739: itemkey => itemkey ,
740: process => 'LIST_GENERATION');
741: */
742: --dbms_output.put_line('listname ->' || l_clistheader_rec.list_name);

Line 743: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

739: itemkey => itemkey ,
740: process => 'LIST_GENERATION');
741: */
742: --dbms_output.put_line('listname ->' || l_clistheader_rec.list_name);
743: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
744: itemkey => itemkey,
745: aname => 'LIST_NAME',
746: avalue => l_clistheader_rec.list_name);
747:

Line 748: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

744: itemkey => itemkey,
745: aname => 'LIST_NAME',
746: avalue => l_clistheader_rec.list_name);
747:
748: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
749: itemkey => itemkey,
750: aname => 'LIST_TYPE',
751: avalue => l_clistheader_rec.list_type);
752:

Line 754: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

750: aname => 'LIST_TYPE',
751: avalue => l_clistheader_rec.list_type);
752:
753: --dbms_output.put_line('listname ->' || l_clistheader_rec.list_header_id);
754: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
755: itemkey => itemkey,
756: aname => 'LIST_HEADER_ID',
757: avalue => l_clistheader_rec.list_header_id);
758:

Line 760: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

756: aname => 'LIST_HEADER_ID',
757: avalue => l_clistheader_rec.list_header_id);
758:
759: --dbms_output.put_line('status ifd ->' || l_clistheader_rec.user_status_id);
760: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
761: itemkey => itemkey,
762: aname => 'LIST_STATUS_ID',
763: avalue => l_clistheader_rec.user_status_id);
764:

Line 766: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

762: aname => 'LIST_STATUS_ID',
763: avalue => l_clistheader_rec.user_status_id);
764:
765: --dbms_output.put_line('status cde ->' || l_clistheader_rec.status_code);
766: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
767: itemkey => itemkey,
768: aname => 'LIST_STATUS_CODE',
769: avalue => l_clistheader_rec.status_code);
770:

Line 771: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

767: itemkey => itemkey,
768: aname => 'LIST_STATUS_CODE',
769: avalue => l_clistheader_rec.status_code);
770:
771: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
772: itemkey => itemkey,
773: aname => 'MONITOR_URL',
774: avalue => wf_monitor.geturl(
775: wf_core.TRANSLATE('WF_WEB_AGENT'),

Line 780: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

776: itemtype,
777: itemkey,
778: 'NO'));
779: --dbms_output.put_line('status ifd ->' || l_clistheader_rec.user_entered_start_time);
780: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
781: itemkey => itemkey,
782: aname => 'WAITING_TIME',
783: avalue => l_clistheader_rec.user_entered_start_time);
784: --bmuthukr for bug 3895455. Getting last updated user's id and passing..instead of passing owner id.

Line 799: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

795: RAISE FND_API.G_EXC_ERROR;
796: END IF;
797:
798:
799: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
800: itemkey => itemkey,
801: aname => 'LIST_OWNER',
802: avalue => l_requester_role );
803:

Line 806: WF_ENGINE.SetItemOwner(itemtype => itemtype,

802: avalue => l_requester_role );
803:
804:
805:
806: WF_ENGINE.SetItemOwner(itemtype => itemtype,
807: itemkey => itemkey,
808: owner => l_requester_role);
809:
810:

Line 813: WF_ENGINE.StartProcess (itemtype => itemtype,

809:
810:
811: /*
812:
813: WF_ENGINE.StartProcess (itemtype => itemtype,
814: itemkey => itemkey);
815: */
816:
817: END IF;

Line 871: WF_ENGINE.abortProcess(l_item_type ,

867: fetch check_wf into l_item_key;
868: close check_wf ;
869: if l_item_key is not null then
870: begin
871: WF_ENGINE.abortProcess(l_item_type ,
872: l_item_key);
873: exception
874: when no_data_found then
875: null;

Line 902: l_list_header_id := WF_ENGINE.GetItemAttrText(

898: BEGIN
899: -- RUN mode - Normal Process Execution
900: IF (funcmode = 'RUN')
901: THEN
902: l_list_header_id := WF_ENGINE.GetItemAttrText(
903: itemtype => itemtype,
904: itemkey => itemkey ,
905: aname => 'LIST_HEADER_ID');
906: AMS_Utility_PVT.Create_Log (