DBA Data[Home] [Help]

APPS.OE_VERSION_COMP dependencies on OE_ORDER_MISC_PUB

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

8774: END IF;
8775: END IF;
8776:
8777:
8778: --select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
8779:
8780: IF l_debug_level > 0 THEN
8781: oe_debug_pub.add(' before finding new lines ');
8782: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);

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

18698: IF l_line_id IS NOT NULL THEN
18699: IF l_debug_level > 0 THEN
18700: oe_debug_pub.add('*************before call total lines(trans) ******************'||ind1);
18701: END IF;
18702: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
18703: IF x_line_number IS NULL THEN
18704: -- bug 9299752
18705: begin
18706: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;

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

18702: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
18703: IF x_line_number IS NULL THEN
18704: -- bug 9299752
18705: begin
18706: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18707: exception
18708: when others then
18709: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
18710: end;

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

18705: begin
18706: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18707: exception
18708: when others then
18709: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
18710: end;
18711: -- bug 9299752
18712: END IF;
18713: IF l_debug_level > 0 THEN

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

18750: oe_debug_pub.add('*************before call total lines ******************'||ind1);
18751: END IF;
18752: -- bug 9299752
18753: begin
18754: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18755: exception
18756: when others then
18757: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
18758: end;

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

18753: begin
18754: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18755: exception
18756: when others then
18757: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
18758: end;
18759: -- bug 9299752
18760: COMPARE_LINE_ATTRIBUTES(p_header_id => p_header_id,
18761: p_line_id => l_line_id,

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

21634:
21635: IF l_line_id IS NOT NULL THEN
21636: -- bug 9299752
21637: begin
21638: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21639: exception
21640: when others then
21641: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
21642: end;

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

21637: begin
21638: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21639: exception
21640: when others then
21641: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
21642: end;
21643: -- bug 9299752
21644: END IF;
21645: IF x_line_number IS NULL THEN

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

21642: end;
21643: -- bug 9299752
21644: END IF;
21645: IF x_line_number IS NULL THEN
21646: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
21647: END IF;
21648:
21649: COMPARE_line_SC_ATTRIBUTES(p_header_id => p_header_id,
21650: p_sales_credit_id => l_sales_credit_id,

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

21683: oe_debug_pub.add('*************before call total sales_credits ******************'||ind1);
21684: END IF;
21685: -- bug 9299752
21686: begin
21687: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21688: exception
21689: when others then
21690: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
21691: end;

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

21686: begin
21687: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21688: exception
21689: when others then
21690: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
21691: end;
21692: -- bug 9299752
21693: COMPARE_line_SC_ATTRIBUTES(p_header_id => p_header_id,
21694: p_sales_credit_id => l_sales_credit_id,