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 525: ZX_DETAIL_TAX_LINES_GT

521: CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type)
522: -- p_line_id oe_order_lines.line_id%type)
523: is
524: select * from
525: ZX_DETAIL_TAX_LINES_GT
526: where
527: application_id = l_application_id
528: and entity_code = l_entity_code_crsr --'OE_ORDER_HEADERS'
529: and event_class_code = l_event_class_code_crsr --'SALES_TRANSACTION_TAX_QUOTE'