234: FROM oe_order_lines ool
235: ,oe_price_adjustments opa
236: WHERE opa.charge_type_code IN ('FTEPRICE','FTECHARGE')
237: AND ool.line_id = opa.line_id
238: AND ool.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
239: AND ool.ato_line_id = p_ato_line_id;
240:
241: --
242: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
261:
262: OE_LINE_ADJ_UTIL.Register_Changed_Lines
263: (p_line_id => l_line_id_tbl(k),
264: p_header_id => p_header_id,
265: p_operation => OE_GLOBALS.G_OPR_UPDATE);
266: k := l_line_id_tbl.NEXT(k);
267: END LOOP;
268:
269: IF l_debug_level > 0 THEN
330: oe_debug_pub.add('Register changed line: '||p_fte_rates_tab(I).source_line_id,1);
331: OE_LINE_ADJ_UTIL.Register_Changed_Lines
332: (p_line_id => p_fte_rates_tab(I).source_line_id,
333: p_header_id => p_header_id,
334: p_operation => OE_GLOBALS.G_OPR_UPDATE);
335:
336: l_adj_index := l_adj_index + 1;
337: I := p_fte_rates_tab.NEXT(I);
338:
383: -- register changed line for config item line.
384: OE_LINE_ADJ_UTIL.Register_Changed_Lines
385: (p_line_id => l_line_id,
386: p_header_id => p_header_id,
387: p_operation => OE_GLOBALS.G_OPR_UPDATE);
388:
389: -- deleting the parents of the config line.
390: -- these deleted parent lines have been registered in
391: -- previous loop looping through p_fte_rates_tab, so
405: J := p_x_line_tbl.FIRST;
406: WHILE J IS NOT NULL LOOP
407: -- delete those non-shippable ATO parent lines
408: IF p_x_line_tbl(J).ato_line_id IS NOT NULL
409: AND p_x_line_tbl(J).item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
410: p_x_line_tbl.delete(J);
411: END IF;
412:
413: J := p_x_line_tbl.NEXT(J);