DBA Data[Home] [Help]

APPS.OE_DEALS_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 1004: select price_adjustment_id, operand into l_price_adj_id, l_adjusted_amount from oe_price_adjustments where

1000: l_line_tbl(i).ordered_quantity := l_ordered_qty;
1001: l_line_tbl(i).payment_term_id := l_payment_term_id;
1002:
1003: BEGIN
1004: select price_adjustment_id, operand into l_price_adj_id, l_adjusted_amount from oe_price_adjustments where
1005: header_id=p_header_id AND
1006: line_id =l_lines.line_id AND
1007: list_line_id =l_list_line_id and list_header_id = l_list_header_id
1008: and applied_flag='Y' and rownum <2;

Line 1020: l_line_adj_tbl(i).list_header_id := l_list_header_id; --oe_price_adjustments

1016:
1017: --Order Line Adjustment Information
1018: l_line_adj_tbl(i) := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
1019: l_line_adj_tbl(i).line_index := i; --adjustment for the line above
1020: l_line_adj_tbl(i).list_header_id := l_list_header_id; --oe_price_adjustments
1021: l_line_adj_tbl(i).list_line_id := l_list_line_id;
1022: l_line_adj_tbl(i).arithmetic_operator := 'AMT';
1023: l_line_adj_tbl(i).change_reason_code := 'DEALS';
1024: l_line_adj_tbl(i).updated_flag := 'Y';