The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_tax_selection ZX_TAX_TAXWARE_GEN.SELPARMTYP%TYPE;
delete_flag VARCHAR2_1_tbl_type
);
'Tax selection parameter was not 1, 2, 3, or space.';
PROCEDURE PERFORM_UPDATE (p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
X_RETURN_STATUS OUT NOCOPY VARCHAR2);
tax_selection IN ZX_TAX_TAXWARE_GEN.SELPARMTYP%TYPE,
errTaxParm IN ZX_TAX_TAXWARE_GEN.TaxParm,
errJurParm IN ZX_TAX_TAXWARE_GEN.JurParm );
select
internal_organization_id ,
document_type_id ,
transaction_id ,
application_code ,
document_level_action ,
trx_date ,
trx_currency_code ,
/* Bug 5090593:
quote_flag ,
*/
legal_entity_number ,
establishment_number ,
transaction_number ,
transaction_description ,
document_sequence_value ,
transaction_due_date ,
/* Bug 5090593:
transaction_solution_origin ,
*/
allow_tax_calculation ,
transaction_line_id ,
trx_level_type ,
line_level_action ,
line_class ,
transaction_shipping_date ,
transaction_receipt_date ,
transaction_line_type ,
transaction_line_date ,
trx_business_category ,
line_intended_use ,
line_amt_includes_tax_flag ,
line_amount ,
other_inclusive_tax_amount ,
transaction_line_quantity ,
unit_price ,
cash_discount ,
volume_discount ,
trading_discount ,
transportation_charge ,
insurance_charge ,
other_charge ,
product_id ,
uom_code ,
product_type ,
product_code ,
fob_point ,
ship_to_party_number ,
ship_to_party_name ,
ship_from_party_number ,
ship_from_party_name ,
ship_to_loc_id , -- Bug 5090593
ship_to_geography_type1 ,
ship_to_geography_value1 ,
ship_to_geography_type2 ,
ship_to_geography_value2 ,
ship_to_geography_type3 ,
ship_to_geography_value3 ,
ship_to_geography_type4 ,
ship_to_geography_value4 ,
ship_to_geography_type5 ,
ship_to_geography_value5 ,
ship_to_geography_type6 ,
ship_to_geography_value6 ,
ship_to_geography_type7 ,
ship_to_geography_value7 ,
ship_to_geography_type8 ,
ship_to_geography_value8 ,
ship_to_geography_type9 ,
ship_to_geography_value9 ,
ship_to_geography_type10 ,
ship_to_geography_value10 ,
ship_from_loc_id , -- Bug 5090593
ship_from_geography_type1 ,
ship_from_geography_value1 ,
ship_from_geography_type2 ,
ship_from_geography_value2 ,
ship_from_geography_type3 ,
ship_from_geography_value3 ,
ship_from_geography_type4 ,
ship_from_geography_value4 ,
ship_from_geography_type5 ,
ship_from_geography_value5 ,
ship_from_geography_type6 ,
ship_from_geography_value6 ,
ship_from_geography_type7 ,
ship_from_geography_value7 ,
ship_from_geography_type8 ,
ship_from_geography_value8 ,
ship_from_geography_type9 ,
ship_from_geography_value9 ,
ship_from_geography_type10 ,
ship_from_geography_value10 ,
poa_loc_id , -- Bug 5090593
poa_geography_type1 ,
poa_geography_value1 ,
poa_geography_type2 ,
poa_geography_value2 ,
poa_geography_type3 ,
poa_geography_value3 ,
poa_geography_type4 ,
poa_geography_value4 ,
poa_geography_type5 ,
poa_geography_value5 ,
poa_geography_type6 ,
poa_geography_value6 ,
poa_geography_type7 ,
poa_geography_value7 ,
poa_geography_type8 ,
poa_geography_value8 ,
poa_geography_type9 ,
poa_geography_value9 ,
poa_geography_type10 ,
poa_geography_value10 ,
poo_loc_id , -- Bug 5090593
poo_geography_type1 ,
poo_geography_value1 ,
poo_geography_type2 ,
poo_geography_value2 ,
poo_geography_type3 ,
poo_geography_value3 ,
poo_geography_type4 ,
poo_geography_value4 ,
poo_geography_type5 ,
poo_geography_value5 ,
poo_geography_type6 ,
poo_geography_value6 ,
poo_geography_type7 ,
poo_geography_value7 ,
poo_geography_type8 ,
poo_geography_value8 ,
poo_geography_type9 ,
poo_geography_value9 ,
poo_geography_type10 ,
poo_geography_value10 ,
bill_to_party_number ,
bill_to_party_name ,
bill_from_party_number ,
bill_from_party_name ,
bill_to_loc_id , -- Bug 5090593
bill_to_geography_type1 ,
bill_to_geography_value1 ,
bill_to_geography_type2 ,
bill_to_geography_value2 ,
bill_to_geography_type3 ,
bill_to_geography_value3 ,
bill_to_geography_type4 ,
bill_to_geography_value4 ,
bill_to_geography_type5 ,
bill_to_geography_value5 ,
bill_to_geography_type6 ,
bill_to_geography_value6 ,
bill_to_geography_type7 ,
bill_to_geography_value7 ,
bill_to_geography_type8 ,
bill_to_geography_value8 ,
bill_to_geography_type9 ,
bill_to_geography_value9 ,
bill_to_geography_type10 ,
bill_to_geography_value10 ,
bill_from_loc_id , -- Bug 5090593
bill_from_geography_type1 ,
bill_from_geography_value1 ,
bill_from_geography_type2 ,
bill_from_geography_value2 ,
bill_from_geography_type3 ,
bill_from_geography_value3 ,
bill_from_geography_type4 ,
bill_from_geography_value4 ,
bill_from_geography_type5 ,
bill_from_geography_value5 ,
bill_from_geography_type6 ,
bill_from_geography_value6 ,
bill_from_geography_type7 ,
bill_from_geography_value7 ,
bill_from_geography_type8 ,
bill_from_geography_value8 ,
bill_from_geography_type9 ,
bill_from_geography_value9 ,
bill_from_geography_type10 ,
bill_from_geography_value10 ,
account_ccid ,
applied_from_document_type_id ,
applied_from_transaction_id ,
applied_from_line_id ,
applied_from_trx_level_type,
applied_from_doc_number ,
adjusted_doc_document_type_id ,
adjusted_doc_transaction_id ,
adjusted_doc_line_id ,
adjusted_doc_number ,
adjusted_doc_trx_level_type,
adjusted_doc_date ,
assessable_value ,
trx_line_number ,
trx_line_description ,
product_description ,
header_char1 ,
header_char2 ,
header_char3 ,
header_char4 ,
header_char5 ,
header_char6 ,
header_char7 ,
header_char8 ,
header_char9 ,
header_char10 ,
header_char11 ,
header_char12 ,
header_char13 ,
header_char14 ,
header_char15 ,
header_numeric1 ,
header_numeric2 ,
header_numeric3 ,
header_numeric4 ,
header_numeric5 ,
header_numeric6 ,
header_numeric7 ,
header_numeric8 ,
header_numeric9 ,
header_numeric10 ,
header_date1 ,
header_date2 ,
header_date3 ,
header_date4 ,
header_date5 ,
line_char1 ,
line_char2 ,
line_char3 ,
line_char4 ,
line_char5 ,
line_char6 ,
line_char7 ,
line_char8 ,
line_char9 ,
line_char10 ,
line_char11 ,
line_char12 ,
line_char13 ,
line_char14 ,
line_char15 ,
line_char16 ,
line_char17 ,
line_char18 ,
line_char19 ,
line_char20 ,
line_char21 ,
line_char22 ,
line_char23 ,
line_char24 ,
line_char25 ,
line_char26 ,
line_char27 ,
line_char28 ,
line_char29 ,
line_char30 ,
line_numeric1 ,
line_numeric2 ,
line_numeric3 ,
line_numeric4 ,
line_numeric5 ,
line_numeric6 ,
line_numeric7 ,
line_numeric8 ,
line_numeric9 ,
line_numeric10 ,
line_date1 ,
line_date2 ,
line_date3 ,
line_date4 ,
line_date5 ,
exempt_certificate_number ,
exempt_reason ,
exemption_control_flag
From ZX_O2C_CALC_TXN_INPUT_V;
delete from zx_jurisdictions_gt;
' Selecting document type for event_class_mapping id '||pg_doc_type_id_tab(I));
select event_class_code
into l_document_type
from zx_evnt_cls_mappings
where event_class_mapping_id = pg_doc_type_id_tab(I);
ELSIF(pg_doc_level_action_tab(i) = 'UPDATE') then
IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
' Calling PERFORM_UPDATE procedure to update an entry in TAXWARE' );
Perform_update(l_tax_lines_tbl,p_currency_tab,l_return_status);
g_string :='Failed in performing the update';
Delete from zx_ptnr_neg_line_gt
WHERE event_class_mapping_id = pg_doc_type_id_tab(I) and
trx_id = pg_trx_id_tab(I) and
trx_line_id = pg_trx_line_id_tab(I) and
trx_level_type = pg_trx_level_type_tab(I);
elsif(pg_doc_level_action_tab(i) = 'UPDATE') Then
if(pg_line_level_action_tab(i) NOT IN ('CREATE', 'UPDATE', 'QUOTE', 'CANCEL', 'DELETE', 'SYNCHRONIZE','RECORD_WITH_NO_TAX')) Then
IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown line level action');
g_line_level_action:='DELETE';
PROCEDURE PERFORM_UPDATE (p_tax_lines_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_lines_tbl_type,
p_currency_tab IN OUT NOCOPY ZX_TAX_PARTNER_PKG.tax_currencies_tbl_type,
x_return_status OUT NOCOPY VARCHAR2) is
l_api_name CONSTANT VARCHAR2(30) := 'PERFORM_UPDATE';
elsif(pg_line_level_action_tab(i) in ('UPDATE')) Then
/*First make contra entry*/
IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Calling PERFORM_LINE_DELETION procedure' );
elsif(pg_line_level_action_tab(i) in ('DELETE','CANCEL')) Then
-- g_line_level_action := pg_line_level_action_tab(i);
End PERFORM_UPDATE;
SELECT tax_jurisdiction_code
INTO x_tax_jurisdiction_code
FROM
(SELECT tax_jurisdiction_code
FROM zx_jurisdictions_gt
WHERE tax_regime_code = p_regime_code
AND tax = p_tax
AND precedence_level = (SELECT max(precedence_level)
FROM zx_jurisdictions_gt
WHERE tax_regime_code = p_regime_code
AND tax = p_tax)
ORDER BY tax_jurisdiction_code)
WHERE ROWNUM = 1;
else /*Line level action is delete*/
IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
'Selecting data from ZX_PTNR_NEG_LINE_GT');
select
line_amt,
trx_line_quantity,
trx_id,
trx_number,
adjusted_doc_date,
trx_date,
exemption_control_flag,
fob_point,
line_ext_varchar_attribute1 ,
line_ext_varchar_attribute2 ,
line_ext_varchar_attribute3 ,
line_ext_varchar_attribute4 ,
line_ext_varchar_attribute5 ,
line_ext_varchar_attribute6 ,
line_ext_varchar_attribute7 ,
line_ext_varchar_attribute8 ,
line_ext_varchar_attribute9 ,
line_ext_varchar_attribute10 ,
line_ext_varchar_attribute11 ,
line_ext_varchar_attribute12 ,
line_ext_varchar_attribute13 ,
line_ext_varchar_attribute14 ,
line_ext_varchar_attribute15 ,
line_ext_varchar_attribute16 ,
line_ext_varchar_attribute17 ,
line_ext_varchar_attribute18 ,
line_ext_varchar_attribute19 ,
line_ext_varchar_attribute20 ,
line_ext_varchar_attribute21 ,
line_ext_varchar_attribute22 ,
line_ext_varchar_attribute23 ,
line_ext_varchar_attribute24 ,
line_ext_number_attribute1 ,
line_ext_number_attribute2 ,
line_ext_number_attribute3 ,
line_ext_number_attribute4 ,
line_ext_number_attribute5 ,
line_ext_number_attribute6 ,
line_ext_date_attribute1
Into arp_line_amount,
arp_quantity,
arp_trx_id,
arp_trx_number,
arp_adj_doc_date,
arp_trx_date,
arp_exempt_control_flag,
arp_fob_point,
arp_tax_type ,
arp_product_code ,
use_step ,
arp_state_exempt_reason ,
arp_county_exempt_reason ,
arp_city_exempt_reason ,
step_proc_flag ,
arp_audit_flag ,
arp_ship_to_add ,
arp_ship_from_add ,
arp_poa_add_code ,
arp_customer_code ,
arp_customer_name ,
arp_company_code ,
arp_division_code ,
arp_vnd_ctrl_exmpt ,
arp_use_nexpro ,
arp_service_ind ,
crit_flag ,
arp_poo_add_code ,
calculation_flag ,
state_cert_no ,
county_cert_no ,
city_cert_no ,
arp_state_exempt_percent ,
arp_county_exempt_pct ,
arp_city_exempt_pct ,
sec_county_exempt_pct ,
sec_city_exempt_pct ,
arp_tax_sel_param ,
arp_transaction_date
from ZX_PTNR_NEG_LINE_GT
WHERE trx_line_id= pg_trx_line_id_tab(I);
g_tax_SELECTION := ZX_TAX_TAXWARE_GEN.SELPRM_TAX_JUR;
g_tax_SELECTION := ZX_TAX_TAXWARE_GEN.SELPRM_JUR_ONLY;
g_tax_SELECTION := ZX_TAX_TAXWARE_GEN.SELPRM_TAXES_ONLY;
g_tax_SELECTION := ZX_TAX_TAXWARE_GEN.SELPRM_TAX_JUR;
IF (g_tax_SELECTION IN
(ZX_TAX_TAXWARE_GEN.SELPRM_JUR_ONLY, ZX_TAX_TAXWARE_GEN.SELPRM_TAX_JUR) ) THEN
-- POO Code
IF ( l_poo_code IS NULL ) THEN
stack_error('GENERIC_MESSAGE', 'GENERIC_TEXT',
'Taxware Error: Point Of Order Origin(POO) Information is not passed.',null,null);
END IF; -- Tax selection uses Jurisdictions?
elsif(g_line_level_action ='DELETE') then
l_Tax_link.GrossAmt := abs(arp_line_amount);
elsif(g_line_level_action ='DELETE') then
l_Tax_link.GrossAmt := abs(arp_line_amount);
elsif(g_line_level_action ='DELETE') then
l_Tax_link.GrossAmt := 0;
elsif(g_line_level_action ='DELETE') then
l_Tax_link.GrossAmt := 0;
IF (g_tax_SELECTION = ZX_TAX_TAXWARE_GEN.SELPRM_TAXES_ONLY ) THEN
-- Only (primary)Ship To information is required.
l_Tax_link.StateCode := substrb(l_ship_to_code,2,2);
g_tax_selection,
l_JurLink);
Get_Vendor_Error(g_tax_selection,
l_TaxLink,
l_JurLink);
select nvl(ship_to_location_id, bill_to_location_id)
INTO p_location_id
From zx_lines_det_factors
WHERE
event_class_mapping_id = pg_doc_type_id_tab(I) and
trx_id = pg_trx_id_tab(I) and
trx_line_id = pg_trx_line_id_tab(I) and
trx_level_type = pg_trx_level_type_tab(I);
select nvl(ship_from_location_id, bill_from_location_id)
INTO p_location_id
From zx_lines_det_factors
WHERE
event_class_mapping_id = pg_doc_type_id_tab(I) and
trx_id = pg_trx_id_tab(I) and
trx_line_id = pg_trx_line_id_tab(I) and
trx_level_type = pg_trx_level_type_tab(I);
tax_selection IN ZX_TAX_TAXWARE_GEN.SELPARMTYP%TYPE,
errTaxParm IN ZX_TAX_TAXWARE_GEN.TaxParm,
errJurParm IN ZX_TAX_TAXWARE_GEN.JurParm ) IS
error_location VARCHAR2(30);
IF ( tax_selection IN
(zx_tax_taxware_GEN.SELPRM_JUR_ONLY, zx_tax_taxware_GEN.SELPRM_TAX_JUR) ) THEN
-- Check for Jurisdiction errors
IF ( errJurParm.ReturnCode <> zx_tax_taxware_GEN.JURSUCCESS ) THEN
Jur_Error := TRUE;
tax_selection IN
(zx_tax_taxware_GEN.SELPRM_TAXES_ONLY, zx_tax_taxware_GEN.SELPRM_TAX_JUR) ) THEN
-- Check for Calculation errors
IF ( nvl(errTaxParm.GenCmplCd,0) <> zx_tax_taxware_GEN.SUCCESSCC ) THEN
Calc_Error := TRUE;
END IF; -- Tax Selection type
select EVNT_CLS_MAPPING_ID,
TRX_ID,
TAX_REGIME_CODE
from ZX_TRX_PRE_PROC_OPTIONS_GT;
select column_name, column_position
from all_ind_columns
where table_name = p_table_name and table_owner = p_table_owner;
SELECT table_owner, table_name into l_table_owner, l_table_name
FROM user_synonyms
WHERE synonym_name = l_synonym_name;
g_line_level_action:='DELETE';
select
APPLICATION_ID,
ENTITY_CODE ,
EVENT_CLASS_CODE,
TRX_ID ,
TRX_LINE_ID,
TRX_LEVEL_TYPE
into
l_APPLICATION_ID,
l_ENTITY_CODE ,
l_EVENT_CLASS_CODE,
l_TRX_ID ,
l_TRX_LINE_ID,
l_TRX_LEVEL_TYPE
From zx_lines_det_factors
where
event_class_mapping_id = p_evnt_cls_mapping_id
AND trx_id = p_transaction_id
AND trx_line_id = p_transaction_line_id
AND trx_level_type = p_trx_level_type;
p_update_index => 1,
p_trx_copy_for_tax_update => 'N' ,
p_regime_code => p_regime_code,
p_tax_provider_id => p_tax_provider_id,
x_return_status => l_return_status);
SELECT
DOCUMENT_TYPE_ID ,
TRANSACTION_ID ,
TRANSACTION_LINE_ID ,
TRX_LEVEL_TYPE ,
COUNTRY_CODE ,
TAX ,
SITUS ,
TAX_JURISDICTION ,
TAX_CURRENCY_CODE ,
TAX_AMOUNT ,
TAX_CURR_TAX_AMT ,
TAX_RATE_PERCENTAGE ,
TAXABLE_AMOUNT ,
EXEMPT_RATE_MODIFIER ,
EXEMPT_REASON ,
TAX_ONLY_LINE_FLAG ,
INCLUSIVE_TAX_LINE_FLAG ,
USE_TAX_FLAG ,
EBIZ_OVERRIDE_FLAG ,
USER_OVERRIDE_FLAG ,
LAST_MANUAL_ENTRY ,
MANUALLY_ENTERED_FLAG ,
CANCEL_FLAG ,
DELETE_FLAG
FROM ZX_SYNC_TAX_LINES_INPUT_V
ORDER BY DOCUMENT_TYPE_ID,
TRANSACTION_ID,
TRANSACTION_LINE_ID,
TRX_LEVEL_TYPE;
SELECT internal_organization_id,
document_type_id,
transaction_id,
legal_entity_number,
establishment_number
INTO l_internal_organization_id,
l_document_type_id,
l_transaction_id,
l_legal_entity_number,
l_establishment_number -- Bug 5139731
FROM ZX_SYNC_HDR_INPUT_V;
SYNC_TAX_LINES.delete_flag
LIMIT C_LINES_PER_COMMIT;
SELECT event_class_code
, application_id
, entity_code
INTO l_event_class_code
, l_application_id
, l_entity_code
FROM zx_evnt_cls_mappings
WHERE EVENT_CLASS_MAPPING_ID = SYNC_TAX_LINES.document_type_id(1);
SELECT count(*)
INTO l_count
FROM ZX_PTNR_NEG_TAX_LINE_GT
WHERE document_type_id = SYNC_TAX_LINES.document_type_id(sync_tax_cnt)
AND trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt)
AND trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt)
AND country_code = SYNC_TAX_LINES.country_code(sync_tax_cnt)
AND tax = SYNC_TAX_LINES.tax(sync_tax_cnt)
AND situs = SYNC_TAX_LINES.situs(sync_tax_cnt);
Deleted line is passed thru zx_sync_tax_lines_input_v and there is
no corresponding line in ZX_PTNR_NEG_TAX_LINE_GT */
IF (l_count=1) THEN /*Line is present. Hence, it is an UPDATE action */
l_event_type :='TAX_LINE_UPDATE';
IF (SYNC_TAX_LINES.delete_flag(sync_tax_cnt) ='Y') THEN /* Delete action */
l_event_type :='TAX_LINE_DELETE';
IF (l_event_type='TAX_LINE_UPDATE') THEN
/*Taxware does not have this feature*/
x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
ELSIF(l_event_type='TAX_LINE_DELETE')then
select tax_amount
into l_amount
from ZX_PTNR_NEG_TAX_LINE_GT
where trx_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt) and
trx_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt);
FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, ' in the update part ');
SELECT TRANSACTION_NUMBER, TRANSACTION_ID
INTO l_trx_number, ctrx_id
FROM ZX_SYNC_HDR_INPUT_V;
l_statements := 'UPDATE ZX_TAX_TAXWARE_AUDIT_HEADER '||
'SET INVNUM = :1' ||
' WHERE ORACLEID = :2 ';
FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updated Rows in taxware table == ' || to_char(SQL%ROWCOUNT));
FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'ZX_TAX_TAXWARE_AUDIT_HEADER is updated');
Procedure GLOBAL_DOCUMENT_UPDATE
(x_transaction_rec IN zx_tax_partner_pkg.trx_rec_type,
x_return_status OUT NOCOPY varchar2,
x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) is
l_cnt_of_options_gt NUMBER;
l_api_name CONSTANT VARCHAR2(100) := 'GLOBAL_DOCUMENT_UPDATE';
SELECT count(*)
INTO l_cnt_of_det_factors
FROM ZX_LINES_DET_FACTORS
WHERE event_class_mapping_id = x_transaction_rec.document_type_id
AND trx_id = x_transaction_rec.transaction_id;
SELECT count(*)
INTO l_cnt_of_options_gt
FROM ZX_TRX_PRE_PROC_OPTIONS_GT;
SELECT count(*)
INTO l_cnt_of_hdr_extns_gt
FROM ZX_PRVDR_HDR_EXTNS_GT;
SELECT count(*)
INTO l_cnt_of_line_extns_gt
FROM ZX_PRVDR_HDR_EXTNS_GT;
SELECT count(*)
INTO l_cnt_of_loc_info_gt
FROM ZX_PTNR_LOCATION_INFO_GT;
SELECT count(*)
INTO l_cnt_of_neg_line_gt
FROM ZX_PTNR_NEG_LINE_GT;
SELECT trx_line_id
BULK COLLECT INTO pg_trx_line_id_tab
FROM ZX_PTNR_NEG_LINE_GT
WHERE event_class_mapping_id = x_transaction_rec.document_type_id
AND trx_id = x_transaction_rec.transaction_id;
SELECT event_class_code
INTO l_document_type
FROM zx_evnt_cls_mappings
WHERE event_class_mapping_id = x_transaction_rec.document_type_id;
End GLOBAL_DOCUMENT_UPDATE;
--FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'vendor_param.tax_selection = ['||vendor_param.tax_selection||']');