[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT location_id
FROM hr_organization_units
WHERE ORGANIZATION_ID = cp_org_id;
| This procedure is called by update tax common components for setting the
| tax security context before invoking Tax Determinant Lov's
|
| CALLED FROM Tax Common components
|
|
| CALLS PROCEDURES/FUNCTIONS
| zx_api_pub.set_tax_security_context()
|
|
| PARAMETERS
| p_internal_org_id -- Operatng Unit Identifier
| p_legal_entity_id -- Legal Entity Identifier
| p_transaction_date -- Transaction Date
|
| KNOWN ISSUES
|
| NOTES
|
|
| MODIFICATION HISTORY
| Date Author Description of Changes
| 24-JAN-07 RRAVIKIR Created
*=======================================================================*/
PROCEDURE set_tax_security_context(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_internal_org_id IN NUMBER,
p_legal_entity_id IN NUMBER,
p_transaction_date IN DATE) IS
l_api_version CONSTANT NUMBER := 1;
SELECT trx_line_id, application_id, event_class_code, entity_code, trx_date,
khr_id, trx_currency_code, currency_conversion_type,
currency_conversion_rate, currency_conversion_date, org_id,
legal_entity_id, trx_level_type, line_amt, bill_to_cust_acct_id,
default_taxation_country, tax_classification_code, assessable_value,
inventory_item_id, product_type, ship_to_cust_acct_site_use_id,
bill_to_cust_acct_site_use_id, bill_to_party_site_id, bill_to_location_id,
bill_to_party_id, ship_to_party_site_id, ship_to_location_id,
ship_to_party_id, adjusted_doc_entity_code, adjusted_doc_event_class_code,
adjusted_doc_trx_id, adjusted_doc_trx_line_id, adjusted_doc_trx_level_type,
adjusted_doc_number, adjusted_doc_date, tax_reporting_flag
FROM okl_tax_sources
WHERE id = cp_tax_sources_id;
SELECT cust_trx_type_id
FROM ra_cust_trx_types_all
WHERE name = 'Invoice-OKL';
SELECT precision, minimum_accountable_unit
FROM fnd_currencies
WHERE currency_code = cp_currency_code
AND enabled_flag = 'Y'
AND nvl(start_date_active, sysdate) <= sysdate
AND nvl(end_date_active, sysdate) >= sysdate;
SELECT location_id
FROM hr_organization_units
WHERE ORGANIZATION_ID = cp_org_id;
ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.line_level_action (1) := OKL_PROCESS_SALES_TAX_PVT.G_UPDATE_LINE_LEVEL_ACTION ;
ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.insert_update_flag (1) := 'U';
SELECT tax_determine_date,
tax_rate_id,
tax_rate_code,
taxable_amt,
tax_exemption_id,
tax_rate,
tax_amt,
tax_date,
line_amt,
internal_organization_id,
application_id,
entity_code,
event_class_code,
event_type_code ,
trx_id,
trx_line_id,
trx_level_type,
trx_line_number,
tax_line_number ,
tax_regime_id ,
tax_regime_code ,
tax_id,
tax,
tax_status_id,
tax_status_code,
tax_apportionment_line_number,
legal_entity_id,
trx_number,
trx_date,
tax_jurisdiction_id,
tax_jurisdiction_code,
tax_type_code,
tax_currency_code ,
taxable_amt_tax_curr,
trx_currency_code,
minimum_accountable_unit,
precision,
currency_conversion_type,
currency_conversion_rate,
currency_conversion_date
FROM okl_tax_trx_details
WHERE trx_id = p_trx_id
AND trx_line_id = p_trx_line_id
AND application_id = p_application_id
AND trx_level_type = p_trx_level_type
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code;
'INSERT INTO zx_detail_tax_lines_gt');
DELETE
FROM zx_detail_tax_lines_gt
WHERE trx_id = p_trx_id
AND trx_line_id = p_trx_line_id;
INSERT INTO zx_detail_tax_lines_gt(
tax_line_id,
tax_determine_date,
tax_rate_id,
tax_rate_code,
taxable_amt,
tax_exemption_id,
tax_rate,
tax_amt,
tax_date,
line_amt,
internal_organization_id,
application_id,
entity_code,
event_class_code,
event_type_code ,
trx_id,
trx_line_id,
trx_level_type,
trx_line_number,
tax_line_number ,
tax_regime_id ,
tax_regime_code ,
tax_id,
tax,
tax_status_id,
tax_status_code,
tax_apportionment_line_number,
legal_entity_id,
trx_number,
trx_date,
tax_jurisdiction_id,
tax_jurisdiction_code,
tax_type_code,
tax_currency_code ,
taxable_amt_tax_curr,
trx_currency_code,
minimum_accountable_unit,
precision,
currency_conversion_type,
currency_conversion_rate,
currency_conversion_date,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
object_version_number) VALUES
(
zx_lines_s.nextval,
l_get_tax_data_rec.tax_determine_date,
l_get_tax_data_rec.tax_rate_id,
l_get_tax_data_rec.tax_rate_code,
l_get_tax_data_rec.taxable_amt,
l_get_tax_data_rec.tax_exemption_id,
l_get_tax_data_rec.tax_rate,
l_get_tax_data_rec.tax_amt,
l_get_tax_data_rec.tax_date,
l_get_tax_data_rec.line_amt,
l_get_tax_data_rec.internal_organization_id,
l_get_tax_data_rec.application_id,
l_get_tax_data_rec.entity_code,
l_get_tax_data_rec.event_class_code,
l_get_tax_data_rec.event_type_code ,
l_get_tax_data_rec.trx_id,
l_get_tax_data_rec.trx_line_id,
l_get_tax_data_rec.trx_level_type,
l_get_tax_data_rec.trx_line_number,
l_get_tax_data_rec.tax_line_number ,
l_get_tax_data_rec.tax_regime_id ,
l_get_tax_data_rec.tax_regime_code ,
l_get_tax_data_rec.tax_id,
l_get_tax_data_rec.tax,
l_get_tax_data_rec.tax_status_id,
l_get_tax_data_rec.tax_status_code,
l_get_tax_data_rec.tax_apportionment_line_number,
l_get_tax_data_rec.legal_entity_id,
l_get_tax_data_rec.trx_number,
l_get_tax_data_rec.trx_date,
l_get_tax_data_rec.tax_jurisdiction_id,
l_get_tax_data_rec.tax_jurisdiction_code,
l_get_tax_data_rec.tax_type_code,
l_get_tax_data_rec.tax_currency_code,
l_get_tax_data_rec.taxable_amt_tax_curr,
l_get_tax_data_rec.trx_currency_code,
l_get_tax_data_rec.minimum_accountable_unit,
l_get_tax_data_rec.precision,
l_get_tax_data_rec.currency_conversion_type,
l_get_tax_data_rec.currency_conversion_rate,
l_get_tax_data_rec.currency_conversion_date,
G_USER_ID,
SYSDATE,
G_USER_ID,
SYSDATE,
G_LOGIN_ID,
1);
| PUBLIC PROCEDURE update_document
|
| DESCRIPTION
| This procedure is called by billing and disbursement modules to fetch tax
| determinants
|
| CALLED FROM
|
|
| CALLS PROCEDURES/FUNCTIONS
| ZX_API_PUB.global_document_update
|
| PARAMETERS
| p_source_trx_id - ID of Pre-Rebook or Rebook transaction in okl_trx_contracts
| p_source_trx_name - Pre-Rebook or Rebook
| p_source_table - OKL_TRX_CONTRACTS
|
| KNOWN ISSUES
|
| NOTES
|
|
| MODIFICATION HISTORY
| Date Author Description of Changes
| 01-MAR-07 RRAVIKIR Created
|
*=======================================================================*/
PROCEDURE update_document (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_transaction_rec transaction_rec_type) IS
-- Local variables
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'update_document';
FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,'OKL_TAX_INTERFACE_PVT.update_document','Begin(+)');
FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_TAX_INTERFACE_PVT.update_document.',
'p_init_msg_list :'||p_init_msg_list);
FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_TAX_INTERFACE_PVT.update_document.',
'Calling ZX_API_PUB.global_document_update');
ZX_API_PUB.global_document_update(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => 'F' ,
p_validation_level => 1,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_transaction_rec => l_transaction_rec);
FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_TAX_INTERFACE_PVT.update_document.',
'Return Status' || l_return_status);
FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,'OKL_TAX_INTERFACE_PVT.update_document ','End(-)');
FND_LOG.STRING(G_DEBUG_LEVEL_EXCEPTION,'OKL_TAX_INTERFACE_PVT.update_document ',
'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
FND_LOG.STRING(G_DEBUG_LEVEL_EXCEPTION,'OKL_TAX_INTERFACE_PVT.update_document ',
'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
FND_LOG.STRING(G_DEBUG_LEVEL_EXCEPTION,'OKL_TAX_INTERFACE_PVT.update_document ',
'EXCEPTION :'||sqlerrm);
END update_document;
'INSERT INTO zx_rev_trx_headers_gt');
INSERT INTO zx_rev_trx_headers_gt(internal_organization_id,
reversing_appln_id,
reversing_entity_code,
reversing_evnt_cls_code,
reversing_trx_id,
legal_entity_id)
VALUES
(p_rev_trx_hdr_rec.internal_organization_id,
p_rev_trx_hdr_rec.application_id,
p_rev_trx_hdr_rec.entity_code,
p_rev_trx_hdr_rec.event_class_code,
p_rev_trx_hdr_rec.trx_id,
p_rev_trx_hdr_rec.legal_entity_id);
'INSERT INTO zx_reverse_trx_lines_gt');
INSERT INTO ZX_REVERSE_TRX_LINES_GT(internal_organization_id,
reversing_appln_id,
reversing_entity_code,
reversing_evnt_cls_code,
reversing_trx_id,
reversing_trx_level_type,
reversing_trx_line_id,
reversed_appln_id,
reversed_entity_code,
reversed_evnt_cls_code,
reversed_trx_id,
reversed_trx_level_type,
reversed_trx_line_id)
VALUES
(l_rev_trx_lines_tbl(k).internal_organization_id,
l_rev_trx_lines_tbl(k).reversing_appln_id,
l_rev_trx_lines_tbl(k).reversing_entity_code,
l_rev_trx_lines_tbl(k).reversing_evnt_cls_code,
l_rev_trx_lines_tbl(k).reversing_trx_id,
l_rev_trx_lines_tbl(k).reversing_trx_level_type,
l_rev_trx_lines_tbl(k).reversing_trx_line_id,
l_rev_trx_lines_tbl(k).reversed_appln_id,
l_rev_trx_lines_tbl(k).reversed_entity_code,
l_rev_trx_lines_tbl(k).reversed_evnt_cls_code,
l_rev_trx_lines_tbl(k).reversed_trx_id,
l_rev_trx_lines_tbl(k).reversed_trx_level_type,
l_rev_trx_lines_tbl(k).reversed_trx_line_id );