DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on OE_TRANSACTION_TYPES_ALL

Line 595: FROM oe_transaction_types_all

591: THEN
592:
593: SELECT TAX_CALCULATION_EVENT_CODE
594: INTO l_tax_calculation_event_code
595: FROM oe_transaction_types_all
596: WHERE transaction_type_id
597: = OE_Order_Cache.g_header_rec.order_type_id;
598:
599: IF nvl(l_tax_calculation_event_code, 'ENTERING') IN ('ENTERING', 'BOOKING') THEN

Line 1212: into lline_category_code from oe_transaction_types_all

1208: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1209: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1210: END IF;
1211: select ORDER_CATEGORY_CODE
1212: into lline_category_code from oe_transaction_types_all
1213: where transaction_type_id = p_line_rec.line_type_id;
1214:
1215: if p_line_rec.line_category_code <> lline_category_code then
1216: IF l_debug_level > 0 then