[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT batch_source_id
INTO l_invoice_source_id
FROM ra_batch_sources
WHERE name = l_invoice_source;
SELECT hsecs INTO l_start_time from v$timer;
SELECT hsecs INTO l_end_time from v$timer;
SELECT hsecs INTO l_start_time from v$timer;
SELECT 'VALID'
INTO l_dummy
FROM AR_VAT_TAX V
WHERE V.TAX_CODE = OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index)
AND V.SET_OF_BOOKS_ID = l_sob_id
AND NVL(V.ENABLED_FLAG,'Y')='Y'
AND NVL(V.TAX_CLASS,'O')='O'
AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
AND TRUNC(OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index))
BETWEEN TRUNC(V.START_DATE) AND
TRUNC(NVL(V.END_DATE, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index)))
AND ROWNUM = 1;
SELECT 'VALID'
INTO l_dummy
FROM AR_VAT_TAX V,
AR_SYSTEM_PARAMETERS P
WHERE V.TAX_CODE = OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index)
AND V.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
AND NVL(V.ENABLED_FLAG,'Y')='Y'
AND NVL(V.TAX_CLASS,'O')='O'
AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
AND TRUNC(OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index))
BETWEEN TRUNC(V.START_DATE) AND
TRUNC(NVL(V.END_DATE, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index)))
AND ROWNUM = 1;
SELECT hsecs INTO l_end_time from v$timer;
(p_post_insert IN BOOLEAN
)
IS
-- 11510
l_index NUMBER;
select location_id
from hr_organization_units
where organization_id = p_organization_id;
SELECT /* MOAC_SQL_CHANGE */ s_ship.site_use_id,
s_ship.cust_acct_site_id,
acct_site_ship.cust_account_id,
loc_ship.postal_code,
party.party_name,
cust_acct.account_number,
party.party_id,
party_site_ship.party_site_id,
loc_ship.location_id
FROM
HZ_CUST_SITE_USES S_SHIP ,
HZ_CUST_ACCT_SITES_ALL ACCT_SITE_SHIP,
HZ_PARTY_SITES PARTY_SITE_SHIP,
HZ_LOCATIONS LOC_SHIP,
HZ_PARTIES PARTY,
HZ_CUST_ACCOUNTS_ALL CUST_ACCT
WHERE s_ship.site_use_id = p_site_org_id
AND s_ship.cust_acct_site_id = acct_site_ship.cust_acct_site_id
and acct_site_ship.cust_account_id = cust_acct.cust_account_id
and cust_acct.party_id = party.party_id
and acct_site_ship.party_site_id = party_site_ship.party_site_id
and party_site_ship.location_id = loc_ship.location_id;
select * from
ZX_DETAIL_TAX_LINES_GT
where
application_id = l_application_id
and entity_code = l_entity_code_crsr --'OE_ORDER_HEADERS'
and event_class_code = l_event_class_code_crsr --'SALES_TRANSACTION_TAX_QUOTE'
and trx_id = p_header_id
--and trx_line_id = p_line_id
and trx_level_type = 'LINE';
IF p_post_insert THEN
oe_debug_pub.add( 'Post_insert : TRUE');
oe_debug_pub.add( 'Post_insert : FALSE');
select location_id
into l_bill_from_location_id
from HR_ALL_ORGANIZATION_UNITS
where organization_id = OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index);
select c.minimum_accountable_unit,
c.precision
into l_minimum_accountable_unit,
l_precision
from fnd_currencies c
where c.currency_code = l_currency_code;
select /* MOAC_SQL_CHANGE */ nvl(cust_type.subsequent_trx_type_id, cust_type.cust_trx_type_id)
into l_cust_trx_type_id
from ra_cust_trx_types_all cust_type,
ra_customer_trx cust_trx
where
cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
and cust_type.org_id = cust_trx.org_id
and cust_trx.customer_trx_id = l_commitment_id;
SELECT location_id
INTO l_ship_from_location_id
FROM hr_all_organization_units hu
WHERE hu.organization_id = OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(l_index);
zx_global_structures_pkg.trx_line_dist_tbl.INSERT_UPDATE_FLAG(l_index) := NULL; -- VARCHAR2_1_tbl_type,
SELECT hsecs INTO l_start_time from v$timer;
SELECT hsecs INTO l_start_time from v$timer;
SELECT hsecs INTO l_end_time from v$timer;
Insert_Tax_Records(p_post_insert => p_post_insert);
G_LINE_ADJ_REC.PRICE_ADJUSTMENT_ID.delete;
G_LINE_ADJ_REC.CREATED_BY.delete;
G_LINE_ADJ_REC.CREATION_DATE.delete;
G_LINE_ADJ_REC.LAST_UPDATE_DATE.delete;
G_LINE_ADJ_REC.LAST_UPDATED_BY.delete;
G_LINE_ADJ_REC.HEADER_ID.delete;
G_LINE_ADJ_REC.LINE_ID.delete;
G_LINE_ADJ_REC.TAX_CODE.delete;
G_LINE_ADJ_REC.OPERAND.delete;
G_LINE_ADJ_REC.ADJUSTED_AMOUNT.delete;
G_LINE_ADJ_REC.AUTOMATIC_FLAG.delete;
G_LINE_ADJ_REC.LIST_LINE_TYPE_CODE.delete;
G_LINE_ADJ_REC.ARITHMETIC_OPERATOR.delete;
G_LINE_ADJ_REC.TAX_RATE_ID.delete;
p_adj_rec.LAST_UPDATE_DATE.extend(p_count);
p_adj_rec.LAST_UPDATED_BY.extend(p_count);
PROCEDURE Insert_Tax_Records
(p_post_insert IN BOOLEAN
)
IS
l_start_time NUMBER;
oe_debug_pub.add( 'ENTERING OE_BULK_TAX_UTIL.INSERT_TAX_RECORDS' ) ;
SELECT hsecs INTO l_start_time from v$timer;
DELETE FROM OE_PRICE_ADJUSTMENTS
where list_line_type_code = 'TAX'
and LINE_ID = G_LINE_ADJ_REC.LINE_ID(i);
oe_debug_pub.add( 'Exception in delete existing tax records' ) ;
INSERT INTO OE_PRICE_ADJUSTMENTS
( PRICE_ADJUSTMENT_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, HEADER_ID
, LINE_ID
, TAX_CODE
, OPERAND
, adjusted_amount
, automatic_flag
, list_line_type_code
, arithmetic_operator
, tax_rate_id --bug7685103
)
VALUES
( oe_price_adjustments_s.nextval
, FND_GLOBAL.USER_ID
, SYSDATE
, SYSDATE
, FND_GLOBAL.USER_ID
, G_LINE_ADJ_REC.header_id(i)
, G_LINE_ADJ_REC.line_id(i)
, G_LINE_ADJ_REC.tax_code(i)
, G_LINE_ADJ_REC.operand(i)
, G_LINE_ADJ_REC.adjusted_amount(i)
, 'N'
, 'TAX'
, 'AMT'
, G_LINE_ADJ_REC.tax_rate_id(i) --bug7685103
);
SELECT hsecs INTO l_end_time from v$timer;
FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent inserting adjustment records is (sec) '||((l_end_time-l_start_time)/100));
IF p_post_insert AND G_Tax_Line_Id.COUNT > 0
THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add( 'post insert mode, so update tax on lines in base table' ) ;
UPDATE OE_ORDER_LINES
SET TAX_VALUE = 0
WHERE LINE_ID = G_Tax_Line_Id(i);
UPDATE OE_ORDER_LINES
SET TAX_VALUE = TAX_VALUE + G_Tax_Line_Value(i)
WHERE LINE_ID = G_Tax_Line_Id(i);
oe_debug_pub.add( 'EXITING OE_BULK_TAX_UTIL.INSERT_TAX_RECORDS' ) ;
,'Insert_Tax_Records'
);
END Insert_Tax_Records;