DBA Data[Home] [Help]

APPS.OE_BULK_WF_UTIL dependencies on WF_ENGINE

Line 124: l_aname wf_engine.nametabtyp;

120: ( p_index IN NUMBER
121: , p_header_rec IN OE_BULK_ORDER_PVT.HEADER_REC_TYPE
122: )
123: IS
124: l_aname wf_engine.nametabtyp;
125: l_aname2 wf_engine.nametabtyp;
126: l_avalue wf_engine.numtabtyp;
127: l_avaluetext wf_engine.texttabtyp;
128: sales_order VARCHAR2(240);

Line 125: l_aname2 wf_engine.nametabtyp;

121: , p_header_rec IN OE_BULK_ORDER_PVT.HEADER_REC_TYPE
122: )
123: IS
124: l_aname wf_engine.nametabtyp;
125: l_aname2 wf_engine.nametabtyp;
126: l_avalue wf_engine.numtabtyp;
127: l_avaluetext wf_engine.texttabtyp;
128: sales_order VARCHAR2(240);
129: --

Line 126: l_avalue wf_engine.numtabtyp;

122: )
123: IS
124: l_aname wf_engine.nametabtyp;
125: l_aname2 wf_engine.nametabtyp;
126: l_avalue wf_engine.numtabtyp;
127: l_avaluetext wf_engine.texttabtyp;
128: sales_order VARCHAR2(240);
129: --
130: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 127: l_avaluetext wf_engine.texttabtyp;

123: IS
124: l_aname wf_engine.nametabtyp;
125: l_aname2 wf_engine.nametabtyp;
126: l_avalue wf_engine.numtabtyp;
127: l_avaluetext wf_engine.texttabtyp;
128: sales_order VARCHAR2(240);
129: --
130: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
131: --

Line 150: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_HDR

146: , to_char(p_header_rec.order_number(p_index)));
147: sales_order := substrb(fnd_message.get, 1, 240);
148:
149: -- Create Header Work item
150: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_HDR
151: ,to_char(p_header_rec.header_id(p_index))
152: ,p_header_rec.wf_process_name(p_index)
153: ,sales_order);
154:

Line 167: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_HDR

163: l_aname(4) := 'ORG_ID';
164: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
165: l_aname(5) := 'ORDER_NUMBER'; -- Added for bug 6066313
166: l_avalue(5) := p_header_rec.order_number(p_index); -- Added for bug 6066313
167: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_HDR
168: , p_header_rec.header_id(p_index)
169: , l_aname
170: , l_avalue
171: );

Line 177: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_HDR

173: l_avaluetext(1) := p_header_rec.order_category_code(p_index);
174: l_aname2(2) := 'NOTIFICATION_APPROVER';
175: l_avaluetext(2) := OE_BULK_ORDER_PVT.G_NOTIFICATION_APPROVER;
176:
177: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_HDR
178: , p_header_rec.header_id(p_index)
179: , l_aname2
180: , l_avaluetext
181: );

Line 203: l_aname wf_engine.nametabtyp;

199: l_process_name VARCHAR2(30);
200: l_wf_item_type VARCHAR2(30);
201: l_wf_assigned BOOLEAN;
202: l_order_number NUMBER;
203: l_aname wf_engine.nametabtyp;
204: l_aname2 wf_engine.nametabtyp;
205: l_avalue wf_engine.numtabtyp;
206: l_avaluetext wf_engine.texttabtyp;
207: line VARCHAR2(240);

Line 204: l_aname2 wf_engine.nametabtyp;

200: l_wf_item_type VARCHAR2(30);
201: l_wf_assigned BOOLEAN;
202: l_order_number NUMBER;
203: l_aname wf_engine.nametabtyp;
204: l_aname2 wf_engine.nametabtyp;
205: l_avalue wf_engine.numtabtyp;
206: l_avaluetext wf_engine.texttabtyp;
207: line VARCHAR2(240);
208: --

Line 205: l_avalue wf_engine.numtabtyp;

201: l_wf_assigned BOOLEAN;
202: l_order_number NUMBER;
203: l_aname wf_engine.nametabtyp;
204: l_aname2 wf_engine.nametabtyp;
205: l_avalue wf_engine.numtabtyp;
206: l_avaluetext wf_engine.texttabtyp;
207: line VARCHAR2(240);
208: --
209: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 206: l_avaluetext wf_engine.texttabtyp;

202: l_order_number NUMBER;
203: l_aname wf_engine.nametabtyp;
204: l_aname2 wf_engine.nametabtyp;
205: l_avalue wf_engine.numtabtyp;
206: l_avaluetext wf_engine.texttabtyp;
207: line VARCHAR2(240);
208: --
209: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
210: --

Line 234: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_LIN

230:
231: line := substrb(fnd_message.get, 1, 240);
232:
233: -- Create Line Work item
234: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_LIN
235: ,to_char(p_line_rec.line_id(p_line_index))
236: ,p_line_rec.wf_process_name(p_line_index)
237: ,line);
238:

Line 250: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_LIN

246: l_avalue(3) := FND_GLOBAL.RESP_ID;
247: l_aname(4) := 'ORG_ID';
248: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
249:
250: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_LIN
251: , p_line_rec.line_id(p_line_index)
252: , l_aname
253: , l_avalue
254: );

Line 261: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_LIN

257: l_avaluetext(1) := p_line_rec.line_category_code(p_line_index);
258: l_aname2(2) := 'NOTIFICATION_APPROVER';
259: l_avaluetext(2) := OE_BULK_ORDER_PVT.G_NOTIFICATION_APPROVER;
260:
261: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_LIN
262: , p_line_rec.line_id(p_line_index)
263: , l_aname2
264: , l_avaluetext
265: );

Line 590: WF_ENGINE.StartProcess(OE_GLOBALS.G_WFI_HDR

586:
587: END LOOP; /*Bug 5261216*/
588:
589: /*Progress Both Header and Line Flows*/
590: WF_ENGINE.StartProcess(OE_GLOBALS.G_WFI_HDR
591: ,to_char(l_header_id));
592:
593: IF p_header_rec.booked_flag(i) = 'Y' THEN
594: -- Call WF_ENGINE to complete the BOOK_ELIGIBLE activity and proceed

Line 594: -- Call WF_ENGINE to complete the BOOK_ELIGIBLE activity and proceed

590: WF_ENGINE.StartProcess(OE_GLOBALS.G_WFI_HDR
591: ,to_char(l_header_id));
592:
593: IF p_header_rec.booked_flag(i) = 'Y' THEN
594: -- Call WF_ENGINE to complete the BOOK_ELIGIBLE activity and proceed
595: -- to the next activity in the order workflow
596: WF_ENGINE.CompleteActivityInternalName
597: ( itemtype => 'OEOH'
598: , itemkey => to_char(l_header_id)

Line 596: WF_ENGINE.CompleteActivityInternalName

592:
593: IF p_header_rec.booked_flag(i) = 'Y' THEN
594: -- Call WF_ENGINE to complete the BOOK_ELIGIBLE activity and proceed
595: -- to the next activity in the order workflow
596: WF_ENGINE.CompleteActivityInternalName
597: ( itemtype => 'OEOH'
598: , itemkey => to_char(l_header_id)
599: , activity => 'BOOK_ELIGIBLE'
600: , result => NULL

Line 638: WF_ENGINE.StartProcess(OE_GLOBALS.G_WFI_LIN

634: ,p_header_rec => p_header_rec
635: );*/ --Line work flow already created Bug 5261216
636:
637: -- Start Workflow for this line
638: WF_ENGINE.StartProcess(OE_GLOBALS.G_WFI_LIN
639: ,to_char(p_line_rec.line_id(j)));
640:
641: -- Pricing Post-Processing
642: -- Not needed for included items.

Line 673: WF_ENGINE.StartProcess(OE_GLOBALS.G_WFI_LIN

669: ,p_line_rec => p_line_rec
670: ,p_header_rec => p_header_rec
671: );*/ --Line work flow already created Bug 5261216
672:
673: WF_ENGINE.StartProcess(OE_GLOBALS.G_WFI_LIN
674: ,to_char(p_line_rec.line_id(l_ii_index)));
675: l_ii_index := l_ii_index + 1;
676:
677: END LOOP;