DBA Data[Home] [Help]

APPS.OE_VERSION_PRICE_ADJUST_COMP dependencies on DUAL

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

6199:
6200: IF l_line_id IS NOT NULL THEN
6201: -- bug 9299752
6202: begin
6203: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
6204: exception
6205: when others then
6206: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
6207: end;

Line 6206: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;

6202: begin
6203: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
6204: exception
6205: when others then
6206: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
6207: end;
6208: -- bug 9299752
6209: END IF;
6210: IF x_line_number IS NULL THEN

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

6207: end;
6208: -- bug 9299752
6209: END IF;
6210: IF x_line_number IS NULL THEN
6211: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
6212: END IF;
6213:
6214: COMPARE_line_adj_ATTRIBUTES(p_header_id => p_header_id,
6215: p_price_adjustment_id => l_price_adjustment_id,

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

6248: oe_debug_pub.add('*************before call total price adjustments ******************'||ind1);
6249: END IF;
6250: -- bug 9299752
6251: begin
6252: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
6253: exception
6254: when others then
6255: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual; -- bug 9299752
6256: end;

Line 6255: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual; -- bug 9299752

6251: begin
6252: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
6253: exception
6254: when others then
6255: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual; -- bug 9299752
6256: end;
6257: -- bug 9299752
6258: COMPARE_line_adj_ATTRIBUTES(p_header_id => p_header_id,
6259: p_price_adjustment_id => l_price_adjustment_id,