eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 OR
36: p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_INCLUDED) --9775352
37: AND p_line_rec.ato_line_id(p_line_index) = p_line_rec.line_id(p_line_index)
38: THEN

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

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 OR
36: p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_INCLUDED) --9775352
37: AND p_line_rec.ato_line_id(p_line_index) = p_line_rec.line_id(p_line_index)
38: THEN
39: oe_debug_pub.add( ' 3:');

Line 36: p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_INCLUDED) --9775352

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 OR
36: p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_INCLUDED) --9775352
37: AND p_line_rec.ato_line_id(p_line_index) = p_line_rec.line_id(p_line_index)
38: THEN
39: oe_debug_pub.add( ' 3:');
40: RETURN 'ATO_ITEM';

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 151: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_HDR

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

Line 157: wf_engine.additemattr (oe_globals.g_wfi_hdr,

153: ,p_header_rec.wf_process_name(p_index)
154: ,sales_order);
155:
156: --Bug 16582023
157: wf_engine.additemattr (oe_globals.g_wfi_hdr,
158: TO_CHAR (p_header_rec.header_id(p_index)),
159: '#WAITFORDETAIL',
160: NULL,
161: 0

Line 172: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);

168: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
169: l_aname(3) := 'RESPONSIBILITY_ID';
170: l_avalue(3) := FND_GLOBAL.RESP_ID;
171: l_aname(4) := 'ORG_ID';
172: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
173: l_aname(5) := 'ORDER_NUMBER'; -- Added for bug 6066313
174: l_avalue(5) := p_header_rec.order_number(p_index); -- Added for bug 6066313
175: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_HDR
176: , p_header_rec.header_id(p_index)

Line 175: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_HDR

171: l_aname(4) := 'ORG_ID';
172: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
173: l_aname(5) := 'ORDER_NUMBER'; -- Added for bug 6066313
174: l_avalue(5) := p_header_rec.order_number(p_index); -- Added for bug 6066313
175: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_HDR
176: , p_header_rec.header_id(p_index)
177: , l_aname
178: , l_avalue
179: );

Line 185: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_HDR

181: l_avaluetext(1) := p_header_rec.order_category_code(p_index);
182: l_aname2(2) := 'NOTIFICATION_APPROVER';
183: l_avaluetext(2) := OE_BULK_ORDER_PVT.G_NOTIFICATION_APPROVER;
184:
185: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_HDR
186: , p_header_rec.header_id(p_index)
187: , l_aname2
188: , l_avaluetext
189: );

Line 242: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_LIN

238:
239: line := substrb(fnd_message.get, 1, 240);
240:
241: -- Create Line Work item
242: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_LIN
243: ,to_char(p_line_rec.line_id(p_line_index))
244: ,p_line_rec.wf_process_name(p_line_index)
245: ,line);
246:

Line 256: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);

252: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
253: l_aname(3) := 'RESPONSIBILITY_ID';
254: l_avalue(3) := FND_GLOBAL.RESP_ID;
255: l_aname(4) := 'ORG_ID';
256: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
257:
258: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_LIN
259: , p_line_rec.line_id(p_line_index)
260: , l_aname

Line 258: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_LIN

254: l_avalue(3) := FND_GLOBAL.RESP_ID;
255: l_aname(4) := 'ORG_ID';
256: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
257:
258: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_LIN
259: , p_line_rec.line_id(p_line_index)
260: , l_aname
261: , l_avalue
262: );

Line 269: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_LIN

265: l_avaluetext(1) := p_line_rec.line_category_code(p_line_index);
266: l_aname2(2) := 'NOTIFICATION_APPROVER';
267: l_avaluetext(2) := OE_BULK_ORDER_PVT.G_NOTIFICATION_APPROVER;
268:
269: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_LIN
270: , p_line_rec.line_id(p_line_index)
271: , l_aname2
272: , l_avaluetext
273: );

Line 275: WF_ITEM.Set_Item_Parent(OE_Globals.G_WFI_LIN,

271: , l_aname2
272: , l_avaluetext
273: );
274:
275: WF_ITEM.Set_Item_Parent(OE_Globals.G_WFI_LIN,
276: to_char(p_line_rec.line_id(p_line_index)),
277: OE_GLOBALS.G_WFI_HDR,
278: to_char(p_line_rec.header_id(p_line_index)), '');
279:

Line 277: OE_GLOBALS.G_WFI_HDR,

273: );
274:
275: WF_ITEM.Set_Item_Parent(OE_Globals.G_WFI_LIN,
276: to_char(p_line_rec.line_id(p_line_index)),
277: OE_GLOBALS.G_WFI_HDR,
278: to_char(p_line_rec.header_id(p_line_index)), '');
279:
280:
281: EXCEPTION

Line 645: l_avalue(l_index_Attr_Num) := to_number(OE_GLOBALS.G_ORG_ID);

641:
642: l_index_Attr_Num := l_index_Attr_Num + 1;
643: l_itemkeys_4NAttr(l_index_Attr_Num) := to_char(p_line_rec.line_id(j));
644: l_aname(l_index_Attr_Num) := 'ORG_ID';
645: l_avalue(l_index_Attr_Num) := to_number(OE_GLOBALS.G_ORG_ID);
646:
647: -- Set various Line Attributes of Text datatype
648: l_index_Attr_Txt := l_index_Attr_Txt + 1;
649: l_itemkeys_4TAttr(l_index_Attr_Txt) := to_char(p_line_rec.line_id(j));

Line 714: l_avalue(l_index_Attr_Num) := to_number(OE_GLOBALS.G_ORG_ID);

710:
711: l_index_Attr_Num := l_index_Attr_Num + 1;
712: l_itemkeys_4NAttr(l_index_Attr_Num) := to_char(p_line_rec.line_id(l_ii_index));
713: l_aname(l_index_Attr_Num) := 'ORG_ID';
714: l_avalue(l_index_Attr_Num) := to_number(OE_GLOBALS.G_ORG_ID);
715:
716: -- Set various Line Attributes of Text datatype
717: l_index_Attr_Txt := l_index_Attr_Txt + 1;
718: l_itemkeys_4TAttr(l_index_Attr_Txt) := to_char(p_line_rec.line_id(l_ii_index));

Line 760: ( itemtype => OE_GLOBALS.G_WFI_LIN

756: END LOOP;
757:
758: -- Calling WF Bulk APIs for Creating the Workflow Process Definition
759: WF_ENGINE_BULK.CreateProcess
760: ( itemtype => OE_GLOBALS.G_WFI_LIN
761: , itemkeys => WF_Api_l_item_keys
762: , process => l_process_name_tbl(l_process_name_ind)
763: , user_keys => WF_Api_l_user_keys
764: , owner_roles => WF_Api_l_owner_roles

Line 765: , parent_itemtype => OE_GLOBALS.G_WFI_HDR

761: , itemkeys => WF_Api_l_item_keys
762: , process => l_process_name_tbl(l_process_name_ind)
763: , user_keys => WF_Api_l_user_keys
764: , owner_roles => WF_Api_l_owner_roles
765: , parent_itemtype => OE_GLOBALS.G_WFI_HDR
766: , parent_itemkey => l_header_id
767: , masterdetail => TRUE
768: );
769:

Line 780: ( itemtype => OE_GLOBALS.G_WFI_LIN

776: END IF;
777:
778: -- Calling WF Bulk APIs for setting Item attributes of Number and Text type
779: WF_ENGINE_BULK.SetItemAttrText
780: ( itemtype => OE_GLOBALS.G_WFI_LIN
781: , itemkeys => l_itemkeys_4TAttr
782: , anames => l_aname2
783: , avalues => l_avaluetext
784: );

Line 787: ( itemtype => OE_GLOBALS.G_WFI_LIN

783: , avalues => l_avaluetext
784: );
785:
786: WF_ENGINE_BULK.SetItemAttrNumber
787: ( itemtype => OE_GLOBALS.G_WFI_LIN
788: , itemkeys => l_itemkeys_4NAttr
789: , anames => l_aname
790: , avalues => l_avalue
791: );

Line 807: WF_ENGINE.StartProcess(OE_GLOBALS.G_WFI_HDR

803:
804: /* End of WF Bulk API ER #8601238 */
805:
806: /*Progress Both Header and Line Flows*/
807: WF_ENGINE.StartProcess(OE_GLOBALS.G_WFI_HDR
808: ,to_char(l_header_id));
809:
810: IF p_header_rec.booked_flag(i) = 'Y' THEN
811: -- Call WF_ENGINE to complete the BOOK_ELIGIBLE activity and proceed

Line 855: WF_ENGINE.StartProcess(OE_GLOBALS.G_WFI_LIN

851: ,p_header_rec => p_header_rec
852: );*/ --Line work flow already created Bug 5261216
853:
854: -- Start Workflow for this line
855: WF_ENGINE.StartProcess(OE_GLOBALS.G_WFI_LIN
856: ,to_char(p_line_rec.line_id(j)));
857:
858: -- Pricing Post-Processing
859: -- Not needed for included items.

Line 891: WF_ENGINE.StartProcess(OE_GLOBALS.G_WFI_LIN

887: ,p_line_rec => p_line_rec
888: ,p_header_rec => p_header_rec
889: );*/ --Line work flow already created Bug 5261216
890:
891: WF_ENGINE.StartProcess(OE_GLOBALS.G_WFI_LIN
892: ,to_char(p_line_rec.line_id(l_ii_index)));
893: l_ii_index := l_ii_index + 1;
894:
895: END LOOP;