APPS.OE_FREIGHT_RATING_PVT dependencies on OE_GLOBALS

Line 5: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8636027

1: PACKAGE BODY OE_FREIGHT_RATING_PVT AS
2: /* $Header: OEXVFRRB.pls 120.0.12010000.2 2009/06/26 12:28:41 nitagarw ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_FREIGHT_RATING_PVT';
5: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8636027
6:
7: PROCEDURE Print_Time(p_msg IN VARCHAR2);
8:
9: PROCEDURE Prepare_Adj_Detail

Line 239: AND ool.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG

235: FROM oe_order_lines ool
236: ,oe_price_adjustments opa
237: WHERE opa.charge_type_code IN ('FTEPRICE','FTECHARGE')
238: AND ool.line_id = opa.line_id
239: AND ool.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
240: AND ool.ato_line_id = p_ato_line_id;
241:
242: --
243: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 266: p_operation => OE_GLOBALS.G_OPR_UPDATE);

262:
263: OE_LINE_ADJ_UTIL.Register_Changed_Lines
264: (p_line_id => l_line_id_tbl(k),
265: p_header_id => p_header_id,
266: p_operation => OE_GLOBALS.G_OPR_UPDATE);
267: k := l_line_id_tbl.NEXT(k);
268: END LOOP;
269:
270: IF l_debug_level > 0 THEN

Line 335: p_operation => OE_GLOBALS.G_OPR_UPDATE);

331: oe_debug_pub.add('Register changed line: '||p_fte_rates_tab(I).source_line_id,1);
332: OE_LINE_ADJ_UTIL.Register_Changed_Lines
333: (p_line_id => p_fte_rates_tab(I).source_line_id,
334: p_header_id => p_header_id,
335: p_operation => OE_GLOBALS.G_OPR_UPDATE);
336:
337: l_adj_index := l_adj_index + 1;
338: I := p_fte_rates_tab.NEXT(I);
339:

Line 388: p_operation => OE_GLOBALS.G_OPR_UPDATE);

384: -- register changed line for config item line.
385: OE_LINE_ADJ_UTIL.Register_Changed_Lines
386: (p_line_id => l_line_id,
387: p_header_id => p_header_id,
388: p_operation => OE_GLOBALS.G_OPR_UPDATE);
389:
390: -- deleting the parents of the config line.
391: -- these deleted parent lines have been registered in
392: -- previous loop looping through p_fte_rates_tab, so

Line 410: AND p_x_line_tbl(J).item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN

406: J := p_x_line_tbl.FIRST;
407: WHILE J IS NOT NULL LOOP
408: -- delete those non-shippable ATO parent lines
409: IF p_x_line_tbl(J).ato_line_id IS NOT NULL
410: AND p_x_line_tbl(J).item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
411: p_x_line_tbl.delete(J);
412: END IF;
413:
414: J := p_x_line_tbl.NEXT(J);