APPS.OE_INBOUND_INT dependencies on DUAL

Line 5301: FROM DUAL;

5297: Decode(l_action_request_tbl(i).entity_code, NULL, 'LINE',
5298: Fnd_Api.G_Miss_Char, 'LINE',
5299: l_action_request_tbl(i).entity_code)
5300: INTO l_action_request_tbl(i).entity_code
5301: FROM DUAL;
5302:
5303: ---
5304: -- Hold Definition ID
5305: ---

Line 5479: -- 2(c). When the freight charges roll-up at each individual line level is required.

5475: x_header_rec.freight_charge :=
5476: Oe_Oe_Totals_Summary.Charges(x_header_rec.header_id);
5477: END IF;
5478:
5479: -- 2(c). When the freight charges roll-up at each individual line level is required.
5480: IF Nvl(fnd_profile.Value('ONT_CHARGES_ROLLUP_LINE_AIA'), fnd_api.g_miss_char)
5481: = 'Y'
5482: THEN
5483: BEGIN

Line 5498: -- 2(d). Correct signing of taxes on individual line level -- Bug 8977354

5494: Oe_Debug_Pub.ADD('Error at step 2c: ' || SQLERRM);
5495: END;
5496: END IF;
5497:
5498: -- 2(d). Correct signing of taxes on individual line level -- Bug 8977354
5499: --
5500: -- This step 2(d) would no longer be required because this
5501: -- 'signing' behavior is implemented directly in OEXUGNIB.pls,
5502: -- line_to_line_rec25(...), as a part of 9151484. Hence the commenting.

Line 5701: SELECT OE_XML_MESSAGE_SEQ_S.NEXTVAL INTO l_sso_seq FROM dual;

5697: l_hdr_rec oe_order_pub.header_rec_type;
5698: BEGIN
5699: oe_debug_pub.ADD(' Price Changed on line ' || repr_line_tbl(1).line_id);
5700:
5701: SELECT OE_XML_MESSAGE_SEQ_S.NEXTVAL INTO l_sso_seq FROM dual;
5702:
5703: oe_header_util.query_row(repr_line_tbl(1).header_id, l_hdr_rec);
5704:
5705: oe_debug_pub.ADD(' Calling Insert_Sync_Line...');