DBA Data[Home] [Help]

APPS.OE_BULK_WF_UTIL dependencies on OE_GLOBALS

Line 34: IF ( p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_STANDARD OR

30: END IF;
31:
32: oe_debug_pub.add( ' 1:');
33:
34: IF ( p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_STANDARD OR
35: p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_OPTION)
36: AND p_line_rec.ato_line_id(p_line_index) = p_line_rec.line_id(p_line_index)
37: THEN
38: oe_debug_pub.add( ' 3:');

Line 35: p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_OPTION)

31:
32: oe_debug_pub.add( ' 1:');
33:
34: IF ( p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_STANDARD OR
35: p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_OPTION)
36: AND p_line_rec.ato_line_id(p_line_index) = p_line_rec.line_id(p_line_index)
37: THEN
38: oe_debug_pub.add( ' 3:');
39: RETURN 'ATO_ITEM';

Line 40: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_MODEL AND

36: AND p_line_rec.ato_line_id(p_line_index) = p_line_rec.line_id(p_line_index)
37: THEN
38: oe_debug_pub.add( ' 3:');
39: RETURN 'ATO_ITEM';
40: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_MODEL AND
41: p_line_rec.line_id(p_line_index) =
42: p_line_rec.ato_line_id(p_line_index)) THEN
43: oe_debug_pub.add( ' 4:');
44: RETURN 'ATO_MODEL';

Line 45: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_CONFIG) THEN

41: p_line_rec.line_id(p_line_index) =
42: p_line_rec.ato_line_id(p_line_index)) THEN
43: oe_debug_pub.add( ' 4:');
44: RETURN 'ATO_MODEL';
45: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_CONFIG) THEN
46: oe_debug_pub.add( ' 5:');
47: RETURN 'CONFIGURATION';
48: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_INCLUDED)
49: THEN

Line 48: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_INCLUDED)

44: RETURN 'ATO_MODEL';
45: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_CONFIG) THEN
46: oe_debug_pub.add( ' 5:');
47: RETURN 'CONFIGURATION';
48: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_INCLUDED)
49: THEN
50: oe_debug_pub.add( ' 6:');
51: RETURN 'II';
52: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_KIT) THEN

Line 52: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_KIT) THEN

48: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_INCLUDED)
49: THEN
50: oe_debug_pub.add( ' 6:');
51: RETURN 'II';
52: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_KIT) THEN
53: oe_debug_pub.add( ' 7:');
54: RETURN 'KIT';
55: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_MODEL AND
56: p_line_rec.line_id(p_line_index) =

Line 55: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_MODEL AND

51: RETURN 'II';
52: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_KIT) THEN
53: oe_debug_pub.add( ' 7:');
54: RETURN 'KIT';
55: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_MODEL AND
56: p_line_rec.line_id(p_line_index) =
57: p_line_rec.top_model_line_id(p_line_index) AND
58: p_line_rec.ato_line_id(p_line_index) IS NULL) THEN
59: oe_debug_pub.add( ' 8:');

Line 61: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_CLASS AND

57: p_line_rec.top_model_line_id(p_line_index) AND
58: p_line_rec.ato_line_id(p_line_index) IS NULL) THEN
59: oe_debug_pub.add( ' 8:');
60: RETURN 'PTO_MODEL';
61: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_CLASS AND
62: p_line_rec.ato_line_id(p_line_index) IS NULL) THEN
63: oe_debug_pub.add( ' 9:');
64: RETURN 'PTO_CLASS';
65: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_OPTION AND

Line 65: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_OPTION AND

61: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_CLASS AND
62: p_line_rec.ato_line_id(p_line_index) IS NULL) THEN
63: oe_debug_pub.add( ' 9:');
64: RETURN 'PTO_CLASS';
65: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_OPTION AND
66: p_line_rec.ato_line_id(p_line_index) IS NULL) THEN
67: oe_debug_pub.add( ' 10:');
68: RETURN 'PTO_OPTION';
69: -- for ato under pto, we want to start ato model flow

Line 73: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_CLASS AND

69: -- for ato under pto, we want to start ato model flow
70: -- even if the item_type_code is class. For ato under ato
71: -- start standard flow.
72: oe_debug_pub.add( ' 11:');
73: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_CLASS AND
74: p_line_rec.ato_line_id(p_line_index) IS NOT NULL) THEN
75:
76: IF p_line_rec.ato_line_id(p_line_index) = p_line_rec.line_id(p_line_index)
77: THEN

Line 84: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_OPTION AND

80: ELSE
81: oe_debug_pub.add( ' 12:');
82: RETURN 'ATO_CLASS'; -- changed from STANDARD for 4572204
83: END IF;
84: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_OPTION AND
85: p_line_rec.ato_line_id(p_line_index) IS NOT NULL) THEN
86: oe_debug_pub.add( ' 13:');
87: RETURN 'ATO_OPTION'; -- changed from STANDARD for 4572204
88: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_STANDARD)

Line 88: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_STANDARD)

84: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_OPTION AND
85: p_line_rec.ato_line_id(p_line_index) IS NOT NULL) THEN
86: oe_debug_pub.add( ' 13:');
87: RETURN 'ATO_OPTION'; -- changed from STANDARD for 4572204
88: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_STANDARD)
89: THEN
90: oe_debug_pub.add( ' 14:');
91: RETURN 'STANDARD';
92: /* ELSIF OE_OTA_UTIL.Is_OTA_Line(p_line_rec.order_quantity_uom(p_line_index)) THEN

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 164: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);

160: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
161: l_aname(3) := 'RESPONSIBILITY_ID';
162: l_avalue(3) := FND_GLOBAL.RESP_ID;
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)

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 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 248: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);

244: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
245: l_aname(3) := 'RESPONSIBILITY_ID';
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

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 267: WF_ITEM.Set_Item_Parent(OE_Globals.G_WFI_LIN,

263: , l_aname2
264: , l_avaluetext
265: );
266:
267: WF_ITEM.Set_Item_Parent(OE_Globals.G_WFI_LIN,
268: to_char(p_line_rec.line_id(p_line_index)),
269: OE_GLOBALS.G_WFI_HDR,
270: to_char(p_line_rec.header_id(p_line_index)), '');
271:

Line 269: OE_GLOBALS.G_WFI_HDR,

265: );
266:
267: WF_ITEM.Set_Item_Parent(OE_Globals.G_WFI_LIN,
268: to_char(p_line_rec.line_id(p_line_index)),
269: OE_GLOBALS.G_WFI_HDR,
270: to_char(p_line_rec.header_id(p_line_index)), '');
271:
272:
273: EXCEPTION

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 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;