DBA Data[Home] [Help]

APPS.OE_VERSION_COMP dependencies on OE_ORDER_MISC_PUB

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

8617: END IF;
8618: END IF;
8619:
8620:
8621: --select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
8622:
8623: IF l_debug_level > 0 THEN
8624: oe_debug_pub.add(' before finding new lines ');
8625: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);

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

18187: IF l_line_id IS NOT NULL THEN
18188: IF l_debug_level > 0 THEN
18189: oe_debug_pub.add('*************before call total lines(trans) ******************'||ind1);
18190: END IF;
18191: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
18192: IF x_line_number IS NULL THEN
18193: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18194: END IF;
18195: IF l_debug_level > 0 THEN

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

18189: oe_debug_pub.add('*************before call total lines(trans) ******************'||ind1);
18190: END IF;
18191: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
18192: IF x_line_number IS NULL THEN
18193: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18194: END IF;
18195: IF l_debug_level > 0 THEN
18196: oe_debug_pub.add('*************line_number ******************'||x_line_number);
18197: END IF;

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

18230: IF l_line_id IS NOT NULL THEN
18231: IF l_debug_level > 0 THEN
18232: oe_debug_pub.add('*************before call total lines ******************'||ind1);
18233: END IF;
18234: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18235: COMPARE_LINE_ATTRIBUTES(p_header_id => p_header_id,
18236: p_line_id => l_line_id,
18237: p_prior_version => p_prior_version,
18238: p_current_version => p_current_version,

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

21097: oe_debug_pub.add('*************before call total sales_credits(trans) ******************'||ind1);
21098: END IF;
21099:
21100: IF l_line_id IS NOT NULL THEN
21101: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21102: END IF;
21103: IF x_line_number IS NULL THEN
21104: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
21105: END IF;

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

21100: IF l_line_id IS NOT NULL THEN
21101: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21102: END IF;
21103: IF x_line_number IS NULL THEN
21104: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
21105: END IF;
21106:
21107: COMPARE_line_SC_ATTRIBUTES(p_header_id => p_header_id,
21108: p_sales_credit_id => l_sales_credit_id,

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

21139: IF l_sales_credit_id IS NOT NULL THEN
21140: IF l_debug_level > 0 THEN
21141: oe_debug_pub.add('*************before call total sales_credits ******************'||ind1);
21142: END IF;
21143: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21144: COMPARE_line_SC_ATTRIBUTES(p_header_id => p_header_id,
21145: p_sales_credit_id => l_sales_credit_id,
21146: p_prior_version => p_prior_version,
21147: p_current_version => p_current_version,