[Home] [Help]
76: l_bill_to_postal_code VARCHAR2(60);
77: l_internal_org_location_id NUMBER;
78: l_bill_to_customer_name VARCHAR2(360);
79: l_bill_to_customer_number VARCHAR2(30);
80: l_header_id oe_order_headers.header_id%type;
81: l_tax_date oe_order_lines.tax_date%type;
82: l_ordered_quantity oe_order_lines.ordered_quantity%type;
83: l_unit_selling_price oe_order_lines.unit_selling_price%type;
84: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
184: select * from
185: ZX_DETAIL_TAX_LINES_GT
186: where
187: application_id = l_application_id
188: and entity_code = l_entity_code_crsr --'OE_ORDER_HEADERS'
189: and event_class_code = l_event_class_code_crsr --'SALES_TRANSACTION_TAX_QUOTE'
190: and trx_id = p_header_id
191: and trx_line_id = p_line_id
192: and trx_level_type = l_trx_level_type_crsr; --'LINE';
207: END IF;
208:
209: l_line_rec := p_line_rec;
210: l_return_status := FND_API.G_RET_STS_SUCCESS;
211: l_entity_code_crsr := 'OE_ORDER_HEADERS';
212: l_event_class_code_crsr := 'SALES_TRANSACTION_TAX_QUOTE';
213: l_trx_level_type_crsr := 'LINE';
214: l_line_id := l_line_rec.line_id;
215: l_call_tax := 'N';
604:
605: i:= 1;
606: zx_global_structures_pkg.init_trx_line_dist_tbl(i);
607: zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID(i) := 660;
608: zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE(i) := 'OE_ORDER_HEADERS';
609: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE(i) := 'SALES_TRANSACTION_TAX_QUOTE';
610: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := L_HEADER_ID;
611: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(i) := 'LINE';
612:
1061:
1062: l_call_tax := 'Y';
1063:
1064: l_transaction_rec.application_id := 660;
1065: l_transaction_rec.entity_code := 'OE_ORDER_HEADERS';
1066: l_transaction_rec.event_class_code := 'SALES_TRANSACTION_TAX_QUOTE';
1067: l_transaction_rec.event_type_code := 'CREATE';
1068: l_transaction_rec.trx_id := l_line_rec.header_id;
1069: l_transaction_rec.internal_organization_id := l_line_rec.org_id;
1708: INTO l_org_id
1709: ,l_sold_to_customer_id
1710: ,l_invoice_to_org_id
1711: ,l_order_type_id
1712: FROM oe_order_headers_all
1713: WHERE header_id = p_header_id;
1714:
1715: IF (l_invoice_to_org_id IS NOT NULL) THEN
1716: SELECT acct_site.cust_account_id