DBA Data[Home] [Help]

APPS.OE_BULK_TAX_UTIL dependencies on ZX_DETAIL_TAX_LINES_GT

Line 483: l_entity_code_crsr zx_detail_tax_lines_gt.entity_code%TYPE := 'OE_ORDER_HEADERS';

479: l_bill_to_postal_code VARCHAR2(60);
480: l_internal_org_location_id NUMBER;
481: l_bill_to_customer_name VARCHAR2(360);
482: l_transaction_rec zx_api_pub.transaction_rec_type;
483: l_entity_code_crsr zx_detail_tax_lines_gt.entity_code%TYPE := 'OE_ORDER_HEADERS';
484: l_event_class_code_crsr zx_detail_tax_lines_gt.event_class_code%TYPE := 'SALES_TRANSACTION_TAX_QUOTE';
485: l_trx_level_type_crsr zx_detail_tax_lines_gt.trx_level_type%TYPE;
486: l_application_id NUMBER := 660;
487: l_bill_from_location_id NUMBER;

Line 484: l_event_class_code_crsr zx_detail_tax_lines_gt.event_class_code%TYPE := 'SALES_TRANSACTION_TAX_QUOTE';

480: l_internal_org_location_id NUMBER;
481: l_bill_to_customer_name VARCHAR2(360);
482: l_transaction_rec zx_api_pub.transaction_rec_type;
483: l_entity_code_crsr zx_detail_tax_lines_gt.entity_code%TYPE := 'OE_ORDER_HEADERS';
484: l_event_class_code_crsr zx_detail_tax_lines_gt.event_class_code%TYPE := 'SALES_TRANSACTION_TAX_QUOTE';
485: l_trx_level_type_crsr zx_detail_tax_lines_gt.trx_level_type%TYPE;
486: l_application_id NUMBER := 660;
487: l_bill_from_location_id NUMBER;
488: l_POO_LOCATION_ID NUMBER;

Line 485: l_trx_level_type_crsr zx_detail_tax_lines_gt.trx_level_type%TYPE;

481: l_bill_to_customer_name VARCHAR2(360);
482: l_transaction_rec zx_api_pub.transaction_rec_type;
483: l_entity_code_crsr zx_detail_tax_lines_gt.entity_code%TYPE := 'OE_ORDER_HEADERS';
484: l_event_class_code_crsr zx_detail_tax_lines_gt.event_class_code%TYPE := 'SALES_TRANSACTION_TAX_QUOTE';
485: l_trx_level_type_crsr zx_detail_tax_lines_gt.trx_level_type%TYPE;
486: l_application_id NUMBER := 660;
487: l_bill_from_location_id NUMBER;
488: l_POO_LOCATION_ID NUMBER;
489: l_doc_level_recalc_flag VARCHAR2(30);

Line 502: trx_level_type zx_detail_tax_lines_gt.trx_level_type%TYPE,

498: (
499: trx_id NUMBER,
500: trx_line_id NUMBER,
501: line_id NUMBER,
502: trx_level_type zx_detail_tax_lines_gt.trx_level_type%TYPE,
503: header_index NUMBER,
504: line_index NUMBER,
505: charge_amt NUMBER );
506: TYPE Entity_info_rec_tbl

Line 539: FROM ZX_DETAIL_TAX_LINES_GT

535: CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type)
536: -- p_line_id oe_order_lines.line_id%type)
537: IS
538: SELECT *
539: FROM ZX_DETAIL_TAX_LINES_GT
540: WHERE application_id = l_application_id
541: AND entity_code = l_entity_code_crsr --'OE_ORDER_HEADERS'
542: AND event_class_code = l_event_class_code_crsr --'SALES_TRANSACTION_TAX_QUOTE'
543: AND trx_id = p_header_id ;