DBA Data[Home] [Help]

APPS.OE_VERSION_PRICE_ADJUST_COMP dependencies on DUAL

Line 6201: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;

6197: oe_debug_pub.add('*************before call total adjustments(trans) ******************'||ind1);
6198: END IF;
6199:
6200: IF l_line_id IS NOT NULL THEN
6201: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
6202: END IF;
6203: IF x_line_number IS NULL THEN
6204: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
6205: END IF;

Line 6204: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;

6200: IF l_line_id IS NOT NULL THEN
6201: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
6202: END IF;
6203: IF x_line_number IS NULL THEN
6204: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
6205: END IF;
6206:
6207: COMPARE_line_adj_ATTRIBUTES(p_header_id => p_header_id,
6208: p_price_adjustment_id => l_price_adjustment_id,

Line 6243: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;

6239: IF l_price_adjustment_id IS NOT NULL THEN
6240: IF l_debug_level > 0 THEN
6241: oe_debug_pub.add('*************before call total price adjustments ******************'||ind1);
6242: END IF;
6243: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
6244: COMPARE_line_adj_ATTRIBUTES(p_header_id => p_header_id,
6245: p_price_adjustment_id => l_price_adjustment_id,
6246: p_prior_version => p_prior_version,
6247: p_current_version => p_current_version,