[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row
(x_rowid IN OUT NOCOPY VARCHAR2,
p_summary_tax_line_id NUMBER,
p_internal_organization_id NUMBER,
p_application_id NUMBER,
p_entity_code VARCHAR2,
p_event_class_code VARCHAR2,
p_trx_id NUMBER,
p_summary_tax_line_number NUMBER,
p_trx_number VARCHAR2,
p_applied_from_application_id NUMBER,
p_applied_from_evt_class_code VARCHAR2,--reduced size p_applied_from_event_class_code
p_applied_from_entity_code VARCHAR2,
p_applied_from_trx_id NUMBER,
p_applied_from_trx_level_type VARCHAR2,
p_applied_from_line_id NUMBER,
p_adjusted_doc_application_id NUMBER,
p_adjusted_doc_entity_code VARCHAR2,
p_adjusted_doc_evt_class_code VARCHAR2,--reduced size p_adjusted_doc_event_class_code
p_adjusted_doc_trx_id NUMBER,
p_adjusted_doc_trx_level_type VARCHAR2,
p_applied_to_application_id NUMBER,
p_applied_to_event_class_code VARCHAR2,
p_applied_to_entity_code VARCHAR2,
p_applied_to_trx_id NUMBER,
p_applied_to_trx_level_type VARCHAR2,
p_applied_to_line_id NUMBER,
p_tax_exemption_id NUMBER,
p_tax_rate_before_exemption NUMBER,
p_tax_rate_name_before_exempt VARCHAR2, --reduced size p_tax_rate_name_before_exemption
p_exempt_rate_modifier NUMBER,
p_exempt_certificate_number VARCHAR2,
p_exempt_reason VARCHAR2,
p_exempt_reason_code VARCHAR2,
p_tax_rate_before_exception NUMBER,
p_tax_rate_name_before_except VARCHAR2, --reduced size p_tax_rate_name_before_exception
p_tax_exception_id NUMBER,
p_exception_rate NUMBER,
p_content_owner_id NUMBER,
p_tax_regime_code VARCHAR2,
p_tax VARCHAR2,
p_tax_status_code VARCHAR2,
p_tax_rate_id NUMBER,
p_tax_rate_code VARCHAR2,
p_tax_rate NUMBER,
p_tax_amt NUMBER,
p_tax_amt_tax_curr NUMBER,
p_tax_amt_funcl_curr NUMBER,
p_tax_jurisdiction_code VARCHAR2,
p_total_rec_tax_amt NUMBER,
p_total_rec_tax_amt_func_curr NUMBER,--reduced size p_total_rec_tax_amt_funcl_curr
p_total_rec_tax_amt_tax_curr NUMBER,
p_total_nrec_tax_amt NUMBER,
p_total_nrec_tax_amt_func_curr NUMBER,--reduced size p_total_nrec_tax_amt_funcl_curr
p_total_nrec_tax_amt_tax_curr NUMBER,
p_ledger_id NUMBER,
p_legal_entity_id NUMBER,
p_establishment_id NUMBER,
p_currency_conversion_date DATE,
p_currency_conversion_type VARCHAR2,
p_currency_conversion_rate NUMBER,
p_summarization_template_id NUMBER,
p_taxable_basis_formula VARCHAR2,
p_tax_calculation_formula VARCHAR2,
p_historical_flag VARCHAR2,
p_cancel_flag VARCHAR2,
p_delete_flag VARCHAR2,
p_tax_amt_included_flag VARCHAR2,
p_compounding_tax_flag VARCHAR2,
p_self_assessed_flag VARCHAR2,
p_overridden_flag VARCHAR2,
p_reporting_only_flag VARCHAR2,
p_assoc_child_frozen_flag VARCHAR2,--reduced size p_Associated_Child_Frozen_Flag
p_copied_from_other_doc_flag VARCHAR2,
p_manually_entered_flag VARCHAR2,
p_mrc_tax_line_flag VARCHAR2,
p_last_manual_entry VARCHAR2,
p_record_type_code VARCHAR2,
p_tax_provider_id NUMBER,
p_tax_only_line_flag VARCHAR2,
p_adjust_tax_amt_flag VARCHAR2,
p_attribute_category VARCHAR2,
p_attribute1 VARCHAR2,
p_attribute2 VARCHAR2,
p_attribute3 VARCHAR2,
p_attribute4 VARCHAR2,
p_attribute5 VARCHAR2,
p_attribute6 VARCHAR2,
p_attribute7 VARCHAR2,
p_attribute8 VARCHAR2,
p_attribute9 VARCHAR2,
p_attribute10 VARCHAR2,
p_attribute11 VARCHAR2,
p_attribute12 VARCHAR2,
p_attribute13 VARCHAR2,
p_attribute14 VARCHAR2,
p_attribute15 VARCHAR2,
p_global_attribute_category VARCHAR2,
p_global_attribute1 VARCHAR2,
p_global_attribute2 VARCHAR2,
p_global_attribute3 VARCHAR2,
p_global_attribute4 VARCHAR2,
p_global_attribute5 VARCHAR2,
p_global_attribute6 VARCHAR2,
p_global_attribute7 VARCHAR2,
p_global_attribute8 VARCHAR2,
p_global_attribute9 VARCHAR2,
p_global_attribute10 VARCHAR2,
p_global_attribute11 VARCHAR2,
p_global_attribute12 VARCHAR2,
p_global_attribute13 VARCHAR2,
p_global_attribute14 VARCHAR2,
p_global_attribute15 VARCHAR2,
p_global_attribute16 VARCHAR2,
p_global_attribute17 VARCHAR2,
p_global_attribute18 VARCHAR2,
p_global_attribute19 VARCHAR2,
p_global_attribute20 VARCHAR2,
p_object_version_number NUMBER,
p_created_by NUMBER,
p_creation_date DATE,
p_last_updated_by NUMBER,
p_last_update_date DATE,
p_last_update_login NUMBER) IS
CURSOR C IS
SELECT rowid
FROM ZX_LINES_SUMMARY
WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row.BEGIN',
'ZX_TRL_SUMMARY_OVERRIDE_PKG: Insert_Row (+)');
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row',
'Insert into zx_lines_summary (+)');
INSERT INTO ZX_LINES_SUMMARY (SUMMARY_TAX_LINE_ID,
INTERNAL_ORGANIZATION_ID,
APPLICATION_ID,
ENTITY_CODE,
EVENT_CLASS_CODE,
TRX_ID,
TRX_NUMBER,
SUMMARY_TAX_LINE_NUMBER,
APPLIED_FROM_APPLICATION_ID,
APPLIED_FROM_EVENT_CLASS_CODE,
APPLIED_FROM_ENTITY_CODE,
APPLIED_FROM_TRX_ID,
APPLIED_FROM_TRX_LEVEL_TYPE,
APPLIED_FROM_LINE_ID,
ADJUSTED_DOC_APPLICATION_ID,
ADJUSTED_DOC_ENTITY_CODE,
ADJUSTED_DOC_EVENT_CLASS_CODE,
ADJUSTED_DOC_TRX_ID,
ADJUSTED_DOC_TRX_LEVEL_TYPE,
APPLIED_TO_APPLICATION_ID,
APPLIED_TO_EVENT_CLASS_CODE,
APPLIED_TO_ENTITY_CODE,
APPLIED_TO_TRX_ID,
APPLIED_TO_TRX_LEVEL_TYPE,
APPLIED_TO_LINE_ID,
TAX_EXEMPTION_ID,
TAX_RATE_BEFORE_EXEMPTION,
TAX_RATE_NAME_BEFORE_EXEMPTION,
EXEMPT_RATE_MODIFIER,
EXEMPT_CERTIFICATE_NUMBER,
EXEMPT_REASON,
EXEMPT_REASON_CODE,
TAX_RATE_BEFORE_EXCEPTION,
TAX_RATE_NAME_BEFORE_EXCEPTION,
TAX_EXCEPTION_ID,
EXCEPTION_RATE,
CONTENT_OWNER_ID,
TAX_REGIME_CODE,
TAX,
TAX_STATUS_CODE,
TAX_RATE_ID,
TAX_RATE_CODE,
TAX_RATE,
TAX_JURISDICTION_CODE,
TAX_AMT,
TAX_AMT_TAX_CURR,
TAX_AMT_FUNCL_CURR,
TOTAL_REC_TAX_AMT,
TOTAL_REC_TAX_AMT_FUNCL_CURR,
TOTAL_REC_TAX_AMT_TAX_CURR,
TOTAL_NREC_TAX_AMT,
TOTAL_NREC_TAX_AMT_FUNCL_CURR,
TOTAL_NREC_TAX_AMT_TAX_CURR,
LEDGER_ID,
LEGAL_ENTITY_ID,
ESTABLISHMENT_ID,
CURRENCY_CONVERSION_DATE,
CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE,
SUMMARIZATION_TEMPLATE_ID,
TAXABLE_BASIS_FORMULA,
TAX_CALCULATION_FORMULA,
HISTORICAL_FLAG,
CANCEL_FLAG,
DELETE_FLAG,
RECORD_TYPE_CODE,
TAX_AMT_INCLUDED_FLAG,
SELF_ASSESSED_FLAG,
OVERRIDDEN_FLAG,
COMPOUNDING_TAX_FLAG,
TAX_PROVIDER_ID,
MANUALLY_ENTERED_FLAG,
TAX_ONLY_LINE_FLAG,
ADJUST_TAX_AMT_FLAG,
MRC_TAX_LINE_FLAG,
REPORTING_ONLY_FLAG,
ASSOCIATED_CHILD_FROZEN_FLAG,
COPIED_FROM_OTHER_DOC_FLAG,
LAST_MANUAL_ENTRY,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
GLOBAL_ATTRIBUTE_CATEGORY,
GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN)
VALUES (p_summary_tax_line_id,
p_internal_organization_id,
p_application_id,
p_entity_code,
p_event_class_code,
p_trx_id,
p_trx_number,
p_summary_tax_line_number,
p_applied_from_application_id,
p_applied_from_evt_class_code,
p_applied_from_entity_code,
p_applied_from_trx_id,
p_applied_from_trx_level_type,
p_applied_from_line_id,
p_adjusted_doc_application_id,
p_adjusted_doc_entity_code,
p_adjusted_doc_evt_class_code,
p_adjusted_doc_trx_id,
p_adjusted_doc_trx_level_type,
p_applied_to_application_id,
p_applied_to_event_class_code,
p_applied_to_entity_code,
p_applied_to_trx_id,
p_applied_to_trx_level_type,
p_applied_to_line_id,
p_tax_exemption_id,
p_tax_rate_before_exemption,
p_tax_rate_name_before_exempt,
p_exempt_rate_modifier,
p_exempt_certificate_number,
p_exempt_reason,
p_exempt_reason_code,
p_tax_rate_before_exception,
p_tax_rate_name_before_except,
p_tax_exception_id,
p_exception_rate,
p_content_owner_id,
p_tax_regime_code,
p_tax,
p_tax_status_code,
p_tax_rate_id,
p_tax_rate_code,
p_tax_rate,
p_tax_jurisdiction_code,
p_tax_amt,
p_tax_amt_tax_curr,
p_tax_amt_funcl_curr,
p_total_rec_tax_amt,
p_total_rec_tax_amt_func_curr,
p_total_rec_tax_amt_tax_curr,
p_total_nrec_tax_amt,
p_total_nrec_tax_amt_func_curr,
p_total_nrec_tax_amt_tax_curr,
p_ledger_id,
p_legal_entity_id,
p_establishment_id,
p_currency_conversion_date,
p_currency_conversion_type,
p_currency_conversion_rate,
p_summarization_template_id,
p_taxable_basis_formula,
p_tax_calculation_formula,
'N', -- historical_flag
p_cancel_flag,
p_delete_flag,
p_record_type_code,
p_tax_amt_included_flag,
p_self_assessed_flag,
p_overridden_flag,
p_compounding_tax_flag,
p_tax_provider_id,
p_manually_entered_flag,
p_tax_only_line_flag,
'Y', --p_adjust_tax_amt_flag,
'N', -- mrc_tax_line_flag
'N', -- reporting_only_flag
'N', -- associated_child_frozen_flag
'N', -- copied_from_other_doc_flag
decode(p_cancel_flag,'N',p_last_manual_entry,'TAX_AMOUNT'), --setting last_manual_entry flag on the basis of cancel_flag.
p_attribute_category,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_global_attribute_category,
p_global_attribute1,
p_global_attribute2,
p_global_attribute3,
p_global_attribute4,
p_global_attribute5,
p_global_attribute6,
p_global_attribute7,
p_global_attribute8,
p_global_attribute9,
p_global_attribute10,
p_global_attribute11,
p_global_attribute12,
p_global_attribute13,
p_global_attribute14,
p_global_attribute15,
1, --p_object_version_number,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.login_id);
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row',
'Insert into zx_lines_summary (-)');
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row.END',
'ZX_TRL_SUMMARY_OVERRIDE_PKG: Insert_Row (-)');
END Insert_Row;
p_delete_flag VARCHAR2,
p_tax_amt_included_flag VARCHAR2,
p_compounding_tax_flag VARCHAR2,
p_self_assessed_flag VARCHAR2,
p_overridden_flag VARCHAR2,
p_reporting_only_flag VARCHAR2,
p_assoc_child_frozen_flag VARCHAR2,--reduced size p_Associated_Child_Frozen_Flag
p_copied_from_other_doc_flag VARCHAR2,
p_manually_entered_flag VARCHAR2,
p_mrc_tax_line_flag VARCHAR2,
p_last_manual_entry VARCHAR2,
p_record_type_code VARCHAR2,
p_tax_provider_id NUMBER,
p_tax_only_line_flag VARCHAR2,
p_adjust_tax_amt_flag VARCHAR2,
p_attribute_category VARCHAR2,
p_attribute1 VARCHAR2,
p_attribute2 VARCHAR2,
p_attribute3 VARCHAR2,
p_attribute4 VARCHAR2,
p_attribute5 VARCHAR2,
p_attribute6 VARCHAR2,
p_attribute7 VARCHAR2,
p_attribute8 VARCHAR2,
p_attribute9 VARCHAR2,
p_attribute10 VARCHAR2,
p_attribute11 VARCHAR2,
p_attribute12 VARCHAR2,
p_attribute13 VARCHAR2,
p_attribute14 VARCHAR2,
p_attribute15 VARCHAR2,
p_global_attribute_category VARCHAR2,
p_global_attribute1 VARCHAR2,
p_global_attribute2 VARCHAR2,
p_global_attribute3 VARCHAR2,
p_global_attribute4 VARCHAR2,
p_global_attribute5 VARCHAR2,
p_global_attribute6 VARCHAR2,
p_global_attribute7 VARCHAR2,
p_global_attribute8 VARCHAR2,
p_global_attribute9 VARCHAR2,
p_global_attribute10 VARCHAR2,
p_global_attribute11 VARCHAR2,
p_global_attribute12 VARCHAR2,
p_global_attribute13 VARCHAR2,
p_global_attribute14 VARCHAR2,
p_global_attribute15 VARCHAR2,
p_global_attribute16 VARCHAR2,
p_global_attribute17 VARCHAR2,
p_global_attribute18 VARCHAR2,
p_global_attribute19 VARCHAR2,
p_global_attribute20 VARCHAR2,
p_object_version_number NUMBER,
p_created_by NUMBER,
p_creation_date DATE,
p_last_updated_by NUMBER,
p_last_update_date DATE,
p_last_update_login NUMBER) IS
CURSOR summary_lines_csr IS
SELECT SUMMARY_TAX_LINE_ID,
INTERNAL_ORGANIZATION_ID,
APPLICATION_ID,
ENTITY_CODE,
EVENT_CLASS_CODE,
TRX_ID,
SUMMARY_TAX_LINE_NUMBER,
TRX_NUMBER,
APPLIED_FROM_APPLICATION_ID,
APPLIED_FROM_EVENT_CLASS_CODE,
APPLIED_FROM_ENTITY_CODE,
APPLIED_FROM_TRX_ID,
APPLIED_FROM_TRX_LEVEL_TYPE,
APPLIED_FROM_LINE_ID,
ADJUSTED_DOC_APPLICATION_ID,
ADJUSTED_DOC_ENTITY_CODE,
ADJUSTED_DOC_EVENT_CLASS_CODE,
ADJUSTED_DOC_TRX_ID,
ADJUSTED_DOC_TRX_LEVEL_TYPE,
APPLIED_TO_APPLICATION_ID,
APPLIED_TO_EVENT_CLASS_CODE,
APPLIED_TO_ENTITY_CODE,
APPLIED_TO_TRX_ID,
APPLIED_TO_TRX_LEVEL_TYPE,
APPLIED_TO_LINE_ID,
TAX_EXEMPTION_ID,
TAX_RATE_BEFORE_EXEMPTION,
TAX_RATE_NAME_BEFORE_EXEMPTION,
EXEMPT_RATE_MODIFIER,
EXEMPT_CERTIFICATE_NUMBER,
EXEMPT_REASON,
EXEMPT_REASON_CODE ,
TAX_RATE_BEFORE_EXCEPTION,
TAX_RATE_NAME_BEFORE_EXCEPTION,
TAX_EXCEPTION_ID,
EXCEPTION_RATE,
CONTENT_OWNER_ID,
TAX_REGIME_CODE,
TAX,
TAX_STATUS_CODE,
TAX_RATE_ID,
TAX_RATE_CODE,
TAX_RATE,
TAX_AMT,
TAX_AMT_TAX_CURR,
TAX_AMT_FUNCL_CURR,
TAX_JURISDICTION_CODE,
TOTAL_REC_TAX_AMT,
TOTAL_REC_TAX_AMT_FUNCL_CURR,
TOTAL_REC_TAX_AMT_TAX_CURR,
TOTAL_NREC_TAX_AMT,
TOTAL_NREC_TAX_AMT_FUNCL_CURR,
TOTAL_NREC_TAX_AMT_TAX_CURR,
LEDGER_ID,
LEGAL_ENTITY_ID,
ESTABLISHMENT_ID,
CURRENCY_CONVERSION_DATE,
CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE,
SUMMARIZATION_TEMPLATE_ID,
TAXABLE_BASIS_FORMULA,
TAX_CALCULATION_FORMULA,
HISTORICAL_FLAG,
CANCEL_FLAG,
DELETE_FLAG,
TAX_AMT_INCLUDED_FLAG,
COMPOUNDING_TAX_FLAG,
SELF_ASSESSED_FLAG,
OVERRIDDEN_FLAG,
REPORTING_ONLY_FLAG,
ASSOCIATED_CHILD_FROZEN_FLAG,
COPIED_FROM_OTHER_DOC_FLAG,
MANUALLY_ENTERED_FLAG,
MRC_TAX_LINE_FLAG,
LAST_MANUAL_ENTRY,
RECORD_TYPE_CODE,
TAX_PROVIDER_ID,
TAX_ONLY_LINE_FLAG,
ADJUST_TAX_AMT_FLAG,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
GLOBAL_ATTRIBUTE_CATEGORY,
GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15,
GLOBAL_ATTRIBUTE16,
GLOBAL_ATTRIBUTE17,
GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM ZX_LINES_SUMMARY
WHERE ROWID = X_Rowid;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
(Recinfo.DELETE_FLAG = NVL(p_Delete_Flag, 'N')) AND
(Recinfo.TAX_AMT_INCLUDED_FLAG = NVL(p_Tax_Amt_Included_Flag, 'N')) AND
(Recinfo.COMPOUNDING_TAX_FLAG = NVL(p_Compounding_Tax_Flag, 'N')) AND
(Recinfo.SELF_ASSESSED_FLAG = NVL(p_Self_Assessed_Flag, 'N')) AND
(Recinfo.OVERRIDDEN_FLAG = NVL(p_Overridden_Flag, 'N')) AND
(Recinfo.REPORTING_ONLY_FLAG = NVL(p_Reporting_Only_Flag, 'N')) AND
(Recinfo.ASSOCIATED_CHILD_FROZEN_FLAG = NVL(p_assoc_child_frozen_flag, 'N')) AND
(Recinfo.COPIED_FROM_OTHER_DOC_FLAG = NVL(p_Copied_From_Other_Doc_Flag, 'N')) AND
(Recinfo.MANUALLY_ENTERED_FLAG = NVL(p_Manually_Entered_Flag, 'N')) AND
((Recinfo.MRC_TAX_LINE_FLAG = p_MRC_TAX_LINE_FLAG) OR
((Recinfo.MRC_TAX_LINE_FLAG IS NULL) AND
(p_MRC_TAX_LINE_FLAG IS NULL))) AND
((Recinfo.LAST_MANUAL_ENTRY = p_last_manual_entry) OR
((Recinfo.LAST_MANUAL_ENTRY IS NULL) AND
(p_last_manual_entry IS NULL))) AND
((Recinfo.Record_Type_Code = p_Record_Type_Code) OR
((Recinfo.Record_Type_Code IS NULL) AND
(p_Record_Type_Code IS NULL))) AND
((Recinfo.TAX_PROVIDER_ID = p_tax_provider_id) OR
((Recinfo.TAX_PROVIDER_ID IS NULL) AND
(p_tax_provider_id IS NULL))) AND
(NVL(Recinfo.Tax_Only_Line_Flag, 'N') = NVL(p_Tax_Only_Line_Flag, 'N')) AND
(NVL(Recinfo.adjust_tax_amt_flag, 'N') = NVL(p_adjust_tax_amt_flag, 'N')) AND
((Recinfo.ATTRIBUTE_CATEGORY = p_attribute_category) OR
((Recinfo.ATTRIBUTE_CATEGORY IS NULL) AND
(p_attribute_category IS NULL))) AND
((Recinfo.ATTRIBUTE1 = p_attribute1) OR
((Recinfo.ATTRIBUTE1 IS NULL) AND
(p_attribute1 IS NULL))) AND
((Recinfo.ATTRIBUTE2 = p_attribute2) OR
((Recinfo.ATTRIBUTE2 IS NULL) AND
(p_attribute2 IS NULL))) AND
((Recinfo.ATTRIBUTE3 = p_attribute3) OR
((Recinfo.ATTRIBUTE3 IS NULL) AND
(p_attribute3 IS NULL))) AND
((Recinfo.ATTRIBUTE4 = p_attribute4) OR
((Recinfo.ATTRIBUTE4 IS NULL) AND
(p_attribute4 IS NULL))) AND
((Recinfo.ATTRIBUTE5 = p_attribute5) OR
((Recinfo.ATTRIBUTE5 IS NULL) AND
(p_attribute5 IS NULL))) AND
((Recinfo.ATTRIBUTE6 = p_attribute6) OR
((Recinfo.ATTRIBUTE6 IS NULL) AND
(p_attribute6 IS NULL))) AND
((Recinfo.ATTRIBUTE7 = p_attribute7) OR
((Recinfo.ATTRIBUTE7 IS NULL) AND
(p_attribute7 IS NULL))) AND
((Recinfo.ATTRIBUTE8 = p_attribute8) OR
((Recinfo.ATTRIBUTE8 IS NULL) AND
(p_attribute8 IS NULL))) AND
((Recinfo.ATTRIBUTE9 = p_attribute9) OR
((Recinfo.ATTRIBUTE9 IS NULL) AND
(p_attribute9 IS NULL))) AND
((Recinfo.ATTRIBUTE10 = p_attribute10) OR
((Recinfo.ATTRIBUTE10 IS NULL) AND
(p_attribute10 IS NULL))) AND
((Recinfo.ATTRIBUTE11 = p_attribute11) OR
((Recinfo.ATTRIBUTE11 IS NULL) AND
(p_attribute11 IS NULL))) AND
((Recinfo.ATTRIBUTE12 = p_attribute12) OR
((Recinfo.ATTRIBUTE12 IS NULL) AND
(p_attribute12 IS NULL))) AND
((Recinfo.ATTRIBUTE13 = p_attribute13) OR
((Recinfo.ATTRIBUTE13 IS NULL) AND
(p_attribute13 IS NULL))) AND
((Recinfo.ATTRIBUTE14 = p_attribute14) OR
((Recinfo.ATTRIBUTE14 IS NULL) AND
(p_attribute14 IS NULL))) AND
((Recinfo.ATTRIBUTE15 = p_attribute15) OR
((Recinfo.ATTRIBUTE15 IS NULL) AND
(p_attribute15 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE_CATEGORY = p_global_attribute_category) OR
((Recinfo.GLOBAL_ATTRIBUTE_CATEGORY IS NULL) AND
(p_global_attribute_category IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE1 = p_global_attribute1) OR
((Recinfo.GLOBAL_ATTRIBUTE1 IS NULL) AND
(p_global_attribute1 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE2 = p_global_attribute2) OR
((Recinfo.GLOBAL_ATTRIBUTE2 IS NULL) AND
(p_global_attribute2 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE3 = p_global_attribute3) OR
((Recinfo.GLOBAL_ATTRIBUTE3 IS NULL) AND
(p_global_attribute3 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE4 = p_global_attribute4) OR
((Recinfo.GLOBAL_ATTRIBUTE4 IS NULL) AND
(p_global_attribute4 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE5 = p_global_attribute5) OR
((Recinfo.GLOBAL_ATTRIBUTE5 IS NULL) AND
(p_global_attribute5 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE6 = p_global_attribute6) OR
((Recinfo.GLOBAL_ATTRIBUTE6 IS NULL) AND
(p_global_attribute6 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE7 = p_global_attribute7) OR
((Recinfo.GLOBAL_ATTRIBUTE7 IS NULL) AND
(p_global_attribute7 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE8 = p_global_attribute8) OR
((Recinfo.GLOBAL_ATTRIBUTE8 IS NULL) AND
(p_global_attribute8 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE9 = p_global_attribute9) OR
((Recinfo.GLOBAL_ATTRIBUTE9 IS NULL) AND
(p_global_attribute9 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE10 = p_global_attribute10) OR
((Recinfo.GLOBAL_ATTRIBUTE10 IS NULL) AND
(p_global_attribute10 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE11 = p_global_attribute11) OR
((Recinfo.GLOBAL_ATTRIBUTE11 IS NULL) AND
(p_global_attribute11 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE12 = p_global_attribute12) OR
((Recinfo.GLOBAL_ATTRIBUTE12 IS NULL) AND
(p_global_attribute12 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE13 = p_global_attribute13) OR
((Recinfo.GLOBAL_ATTRIBUTE13 IS NULL) AND
(p_global_attribute13 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE14 = p_global_attribute14) OR
((Recinfo.GLOBAL_ATTRIBUTE14 IS NULL) AND
(p_global_attribute14 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE15 = p_global_attribute15) OR
((Recinfo.GLOBAL_ATTRIBUTE15 IS NULL) AND
(p_global_attribute15 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE16 = p_global_attribute16) OR
((Recinfo.GLOBAL_ATTRIBUTE16 IS NULL) AND
(p_global_attribute16 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE17 = p_global_attribute17) OR
((Recinfo.GLOBAL_ATTRIBUTE17 IS NULL) AND
(p_global_attribute17 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE18 = p_global_attribute18) OR
((Recinfo.GLOBAL_ATTRIBUTE18 IS NULL) AND
(p_global_attribute18 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE19 = p_global_attribute19) OR
((Recinfo.GLOBAL_ATTRIBUTE19 IS NULL) AND
(p_global_attribute19 IS NULL))) AND
((Recinfo.GLOBAL_ATTRIBUTE20 = p_global_attribute20) OR
((Recinfo.GLOBAL_ATTRIBUTE20 IS NULL) AND
(p_global_attribute20 IS NULL))) AND
(Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER) AND
(Recinfo.CREATED_BY = p_CREATED_BY) AND
(Recinfo.CREATION_DATE = p_CREATION_DATE) AND
(Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY) AND
(Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE) AND
((Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN) OR
((Recinfo.LAST_UPDATE_LOGIN IS NULL) AND
(p_LAST_UPDATE_LOGIN IS NULL))) ) THEN
l_transaction_rec.APPLICATION_ID := Recinfo.APPLICATION_ID;
PROCEDURE Update_Row
(--x_rowid IN OUT NOCOPY VARCHAR2,
p_summary_tax_line_id NUMBER,
p_internal_organization_id NUMBER,
p_application_id NUMBER,
p_entity_code VARCHAR2,
p_event_class_code VARCHAR2,
p_trx_id NUMBER,
p_summary_tax_line_number NUMBER,
p_trx_number VARCHAR2,
p_applied_from_application_id NUMBER,
p_applied_from_evt_class_code VARCHAR2,--reduced size p_applied_from_event_class_code
p_applied_from_entity_code VARCHAR2,
p_applied_from_trx_id NUMBER,
p_applied_from_trx_level_type VARCHAR2,
p_applied_from_line_id NUMBER,
p_adjusted_doc_application_id NUMBER,
p_adjusted_doc_entity_code VARCHAR2,
p_adjusted_doc_evt_class_code VARCHAR2,--reduced size p_adjusted_doc_event_class_code
p_adjusted_doc_trx_id NUMBER,
p_adjusted_doc_trx_level_type VARCHAR2,
p_applied_to_application_id NUMBER,
p_applied_to_event_class_code VARCHAR2,
p_applied_to_entity_code VARCHAR2,
p_applied_to_trx_id NUMBER,
p_applied_to_trx_level_type VARCHAR2,
p_applied_to_line_id NUMBER,
p_tax_exemption_id NUMBER,
p_tax_rate_before_exemption NUMBER,
p_tax_rate_name_before_exempt VARCHAR2, --reduced size p_tax_rate_name_before_exemption
p_exempt_rate_modifier NUMBER,
p_exempt_certificate_number VARCHAR2,
p_exempt_reason VARCHAR2,
p_exempt_reason_code VARCHAR2,
p_tax_rate_before_exception NUMBER,
p_tax_rate_name_before_except VARCHAR2, --reduced size p_tax_rate_name_before_exception
p_tax_exception_id NUMBER,
p_exception_rate NUMBER,
p_content_owner_id NUMBER,
p_tax_regime_code VARCHAR2,
p_tax VARCHAR2,
p_tax_status_id NUMBER,
p_tax_status_code VARCHAR2,
p_tax_rate_id NUMBER,
p_tax_rate_code VARCHAR2,
p_tax_rate NUMBER,
p_tax_amt NUMBER,
p_tax_amt_tax_curr NUMBER,
p_tax_amt_funcl_curr NUMBER,
p_tax_jurisdiction_code VARCHAR2,
p_total_rec_tax_amt NUMBER,
p_total_rec_tax_amt_func_curr NUMBER,--reduced size p_total_rec_tax_amt_funcl_curr
p_total_rec_tax_amt_tax_curr NUMBER,
p_total_nrec_tax_amt NUMBER,
p_total_nrec_tax_amt_func_curr NUMBER,--reduced size p_total_nrec_tax_amt_funcl_curr
p_total_nrec_tax_amt_tax_curr NUMBER,
p_ledger_id NUMBER,
p_legal_entity_id NUMBER,
p_establishment_id NUMBER,
p_currency_conversion_date DATE,
p_currency_conversion_type VARCHAR2,
p_currency_conversion_rate NUMBER,
p_summarization_template_id NUMBER,
p_taxable_basis_formula VARCHAR2,
p_tax_calculation_formula VARCHAR2,
p_historical_flag VARCHAR2,
p_cancel_flag VARCHAR2,
p_delete_flag VARCHAR2,
p_tax_amt_included_flag VARCHAR2,
p_compounding_tax_flag VARCHAR2,
p_self_assessed_flag VARCHAR2,
p_overridden_flag VARCHAR2,
p_reporting_only_flag VARCHAR2,
p_assoc_child_frozen_flag VARCHAR2,--reduced size p_Associated_Child_Frozen_Flag
p_copied_from_other_doc_flag VARCHAR2,
p_manually_entered_flag VARCHAR2,
p_mrc_tax_line_flag VARCHAR2,
p_last_manual_entry VARCHAR2,
p_record_type_code VARCHAR2,
p_tax_provider_id NUMBER,
p_tax_only_line_flag VARCHAR2,
p_adjust_tax_amt_flag VARCHAR2,
--p_ctrl_ef_ov_cal_line_flag VARCHAR2,
p_attribute_category VARCHAR2,
p_attribute1 VARCHAR2,
p_attribute2 VARCHAR2,
p_attribute3 VARCHAR2,
p_attribute4 VARCHAR2,
p_attribute5 VARCHAR2,
p_attribute6 VARCHAR2,
p_attribute7 VARCHAR2,
p_attribute8 VARCHAR2,
p_attribute9 VARCHAR2,
p_attribute10 VARCHAR2,
p_attribute11 VARCHAR2,
p_attribute12 VARCHAR2,
p_attribute13 VARCHAR2,
p_attribute14 VARCHAR2,
p_attribute15 VARCHAR2,
p_global_attribute_category VARCHAR2,
p_global_attribute1 VARCHAR2,
p_global_attribute2 VARCHAR2,
p_global_attribute3 VARCHAR2,
p_global_attribute4 VARCHAR2,
p_global_attribute5 VARCHAR2,
p_global_attribute6 VARCHAR2,
p_global_attribute7 VARCHAR2,
p_global_attribute8 VARCHAR2,
p_global_attribute9 VARCHAR2,
p_global_attribute10 VARCHAR2,
p_global_attribute11 VARCHAR2,
p_global_attribute12 VARCHAR2,
p_global_attribute13 VARCHAR2,
p_global_attribute14 VARCHAR2,
p_global_attribute15 VARCHAR2,
p_global_attribute16 VARCHAR2,
p_global_attribute17 VARCHAR2,
p_global_attribute18 VARCHAR2,
p_global_attribute19 VARCHAR2,
p_global_attribute20 VARCHAR2,
p_object_version_number NUMBER,
--p_created_by NUMBER,
--p_creation_date DATE,
p_last_updated_by NUMBER,
p_last_update_date DATE,
p_last_update_login NUMBER) IS
Cursor c_det ( p_application_id NUMBER,
p_entity_code VARCHAR2,
p_event_class_code VARCHAR2,
p_trx_id NUMBER)
is select trx_line_id, summary_tax_line_id from zx_lines
where application_id = p_application_id
and entity_code = p_entity_code
and event_class_code = p_event_class_code
and trx_id = p_trx_id;
IS SELECT
tax_status_code,
tax_rate_id,
tax_rate_code,
tax_rate,
tax_jurisdiction_code,
ledger_id,
legal_entity_id,
establishment_id,
TRUNC(currency_conversion_date) currency_conversion_date,
currency_conversion_type,
currency_conversion_rate,
taxable_basis_formula,
tax_calculation_formula,
tax_amt_included_flag,
compounding_tax_flag,
self_assessed_flag,
reporting_only_flag,
copied_from_other_doc_flag,
record_type_code,
tax_provider_id,
historical_flag,
delete_flag,
overridden_flag,
manually_entered_flag,
tax_exemption_id,
tax_rate_before_exemption,
tax_rate_name_before_exemption,
exempt_rate_modifier,
exempt_certificate_number,
exempt_reason,
exempt_reason_code,
tax_rate_before_exception,
tax_rate_name_before_exception,
tax_exception_id,
exception_rate,
mrc_tax_line_flag,
tax_only_line_flag
FROM zx_lines
WHERE application_id = p_application_id
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code
AND trx_id = p_trx_id
AND tax_line_id = p_tax_line_id;
SELECT
tax_line_id,
internal_organization_id ,
application_id ,
entity_code ,
event_class_code ,
event_type_code ,
trx_id ,
trx_line_id ,
trx_level_type ,
trx_line_number ,
doc_event_status ,
tax_event_class_code ,
tax_event_type_code ,
tax_line_number ,
content_owner_id ,
tax_regime_id ,
tax_regime_code ,
tax_id ,
tax ,
tax_status_id ,
tax_status_code ,
tax_rate_id ,
tax_rate_code ,
tax_rate ,
tax_rate_type ,
tax_apportionment_line_number ,--reduced in size tax_apportionment_line_number
trx_id_level2 ,
trx_id_level3 ,
trx_id_level4 ,
trx_id_level5 ,
trx_id_level6 ,
trx_user_key_level1 ,
trx_user_key_level2 ,
trx_user_key_level3 ,
trx_user_key_level4 ,
trx_user_key_level5 ,
trx_user_key_level6 ,
mrc_tax_line_flag ,
mrc_link_to_tax_line_id ,
ledger_id ,
establishment_id ,
legal_entity_id ,
hq_estb_reg_number ,
hq_estb_party_tax_prof_id ,
currency_conversion_date ,
currency_conversion_type ,
currency_conversion_rate ,
tax_currency_conversion_date ,--reduced in size tax_currency_conversion_date
tax_currency_conversion_type ,--reduced in sizetax_currency_conversion_type
tax_currency_conversion_rate ,--reduced in sizetax_currency_conversion_rate
trx_currency_code ,
reporting_currency_code ,
minimum_accountable_unit ,
precision ,
trx_number ,
trx_date ,
unit_price ,
line_amt ,
trx_line_quantity ,
tax_base_modifier_rate ,
ref_doc_application_id ,
ref_doc_entity_code ,
ref_doc_event_class_code ,
ref_doc_trx_id ,
ref_doc_trx_level_type ,
ref_doc_line_id ,
ref_doc_line_quantity ,
other_doc_line_amt ,
other_doc_line_tax_amt ,
other_doc_line_taxable_amt ,
unrounded_taxable_amt ,
unrounded_tax_amt ,
related_doc_application_id ,
related_doc_entity_code ,
related_doc_event_class_code ,--reduced in sizerelated_doc_event_class_code
related_doc_trx_id ,
related_doc_trx_level_type ,
related_doc_number ,
related_doc_date ,
applied_from_application_id ,--reduced in sizeapplied_from_application_id
applied_from_event_class_code ,--reduced in sizeapplied_from_event_class_code
applied_from_entity_code ,
applied_from_trx_id ,
applied_from_trx_level_type ,
applied_from_line_id ,
applied_from_trx_number ,
adjusted_doc_application_id , -- reduced in size adjusted_doc_application_id
adjusted_doc_entity_code ,
adjusted_doc_event_class_code , -- reduced in size adjusted_doc_event_class_code
adjusted_doc_trx_id ,
adjusted_doc_trx_level_type ,
adjusted_doc_line_id ,
adjusted_doc_number ,
adjusted_doc_date ,
applied_to_application_id ,
applied_to_event_class_code ,--reduced in sizeapplied_to_event_class_code
applied_to_entity_code ,
applied_to_trx_id ,
applied_to_trx_level_type ,
applied_to_line_id ,
summary_tax_line_id ,
offset_link_to_tax_line_id ,
offset_flag ,
process_for_recovery_flag ,
tax_jurisdiction_id ,
tax_jurisdiction_code ,
place_of_supply ,
place_of_supply_type_code ,
place_of_supply_result_id ,
tax_date_rule_id ,
tax_date ,
tax_determine_date ,
tax_point_date ,
trx_line_date ,
tax_type_code ,
tax_code ,
tax_registration_id ,
tax_registration_number ,
registration_party_type ,
rounding_level_code ,
rounding_rule_code ,
rounding_lvl_party_tax_prof_id , -- reduced in size rounding_lvl_party_tax_prof_id
rounding_lvl_party_type ,
compounding_tax_flag ,
orig_tax_status_id ,
orig_tax_status_code ,
orig_tax_rate_id ,
orig_tax_rate_code ,
orig_tax_rate ,
orig_tax_jurisdiction_id ,
orig_tax_jurisdiction_code ,
orig_tax_amt_included_flag ,
orig_self_assessed_flag ,
tax_currency_code ,
tax_amt ,
tax_amt_tax_curr ,
tax_amt_funcl_curr ,
taxable_amt ,
taxable_amt_tax_curr ,
taxable_amt_funcl_curr ,
orig_taxable_amt ,
orig_taxable_amt_tax_curr ,
cal_tax_amt ,
cal_tax_amt_tax_curr ,
cal_tax_amt_funcl_curr ,
orig_tax_amt ,
orig_tax_amt_tax_curr ,
rec_tax_amt ,
rec_tax_amt_tax_curr ,
rec_tax_amt_funcl_curr ,
nrec_tax_amt ,
nrec_tax_amt_tax_curr ,
nrec_tax_amt_funcl_curr ,
tax_exemption_id ,
tax_rate_before_exemption ,
tax_rate_name_before_exemption ,
exempt_rate_modifier ,
exempt_certificate_number ,
exempt_reason ,
exempt_reason_code ,
tax_exception_id ,
tax_rate_before_exception ,
tax_rate_name_before_exception ,
exception_rate ,
tax_apportionment_flag ,
historical_flag ,
taxable_basis_formula ,
tax_calculation_formula ,
cancel_flag ,
purge_flag ,
delete_flag ,
tax_amt_included_flag ,
self_assessed_flag ,
overridden_flag ,
manually_entered_flag ,
reporting_only_flag ,
freeze_until_overridden_flag , -- reduced in size Freeze_Until_Overridden_Flag
copied_from_other_doc_flag ,
recalc_required_flag ,
settlement_flag ,
item_dist_changed_flag ,
associated_child_frozen_flag , -- reduced in size Associated_Child_Frozen_Flag
tax_only_line_flag ,
compounding_dep_tax_flag ,
compounding_tax_miss_flag ,
sync_with_prvdr_flag ,
last_manual_entry ,
tax_provider_id ,
record_type_code ,
reporting_period_id ,
legal_justification_text1 ,
legal_justification_text2 ,
legal_justification_text3 ,
legal_message_appl_2 ,
legal_message_status ,
legal_message_rate ,
legal_message_basis ,
legal_message_calc ,
legal_message_threshold ,
legal_message_pos ,
legal_message_trn ,
legal_message_exmpt ,
legal_message_excpt ,
tax_regime_template_id ,
tax_applicability_result_id ,--reduced in sizetax_applicability_result_id
direct_rate_result_id ,
status_result_id ,
rate_result_id ,
basis_result_id ,
thresh_result_id ,
calc_result_id ,
tax_reg_num_det_result_id ,
eval_exmpt_result_id ,
eval_excpt_result_id ,
enforce_from_natural_acct_flag ,--reduced in sizeEnforce_From_Natural_Acct_Flag
tax_hold_code ,
tax_hold_released_code ,
prd_total_tax_amt ,
prd_total_tax_amt_tax_curr ,
prd_total_tax_amt_funcl_curr ,
trx_line_index ,
offset_tax_rate_code ,
proration_code ,
other_doc_source ,
internal_org_location_id ,
line_assessable_value ,
ctrl_total_line_tx_amt ,
applied_to_trx_number ,
attribute_category ,
attribute1 ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute6 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute10 ,
attribute11 ,
attribute12 ,
attribute13 ,
attribute14 ,
attribute15 ,
global_attribute_category ,
global_attribute1 ,
global_attribute2 ,
global_attribute3 ,
global_attribute4 ,
global_attribute5 ,
global_attribute6 ,
global_attribute7 ,
global_attribute8 ,
global_attribute9 ,
global_attribute10 ,
global_attribute11 ,
global_attribute12 ,
global_attribute13 ,
global_attribute14 ,
global_attribute15 ,
numeric1 ,
numeric2 ,
numeric3 ,
numeric4 ,
numeric5 ,
numeric6 ,
numeric7 ,
numeric8 ,
numeric9 ,
numeric10 ,
char1 ,
char2 ,
char3 ,
char4 ,
char5 ,
char6 ,
char7 ,
char8 ,
char9 ,
char10 ,
date1 ,
date2 ,
date3 ,
date4 ,
date5 ,
date6 ,
date7 ,
date8 ,
date9 ,
date10 ,
interface_entity_code ,
interface_tax_line_id ,
taxing_juris_geography_id ,
adjusted_doc_tax_line_id ,
object_version_number ,
last_updated_by ,
last_update_date ,
last_update_login
FROM zx_lines
WHERE application_id = p_application_id
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code
AND trx_id = p_trx_id
AND summary_tax_line_id = p_summary_tax_line_id
AND nvl(cancel_flag,'N') <> 'Y'
ORDER by associated_child_frozen_flag DESC NULLS LAST;
SELECT summary_tax_line_id
FROM zx_lines_summary
WHERE application_id = p_application_id
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code
AND trx_id = p_trx_id
AND tax_status_code = p_tax_status_code
AND tax_rate_id = p_tax_rate_id
AND tax_rate_code = p_tax_rate_code
AND tax_rate = l_tax_rate
AND NVL(tax_jurisdiction_code, 'x') = NVL(p_tax_jurisdiction_code, 'x')
AND NVL(ledger_id, -999) = NVL(p_ledger_id, -999)
AND NVL(legal_entity_id, -999) = NVL(p_legal_entity_id, -999)
AND NVL(establishment_id, -999) = NVL(p_establishment_id, -999)
AND NVL(TRUNC(currency_conversion_date), DATE_DUMMY) = NVL(TRUNC(p_currency_conversion_date), DATE_DUMMY)
AND NVL(currency_conversion_type, 'x') = NVL(p_currency_conversion_type, 'x')
AND NVL(currency_conversion_rate, 1) = NVL(p_currency_conversion_rate, 1)
AND NVL(taxable_basis_formula, 'x') = NVL(p_taxable_basis_formula, 'x')
AND NVL(tax_calculation_formula, 'x') = NVL(p_tax_calculation_formula, 'x')
AND NVL(tax_amt_included_flag,'N') = NVL(p_tax_amt_included_flag,'N')
AND NVL(compounding_tax_flag,'N') = NVL(p_compounding_tax_flag,'N')
AND NVL(self_assessed_flag,'N') = NVL(p_self_assessed_flag,'N')
AND NVL(reporting_only_flag,'N') = NVL(p_reporting_only_flag,'N')
-- AND NVL(copied_from_other_doc_flag,'N') = NVL(p_copied_from_other_doc_flag,'N')
AND NVL(record_type_code, 'x') = NVL(p_record_type_code, 'x')
AND NVL(tax_provider_id, -999) = NVL(p_tax_provider_id, -999)
AND NVL(historical_flag,'N') = NVL(p_historical_flag,'N')
AND NVL(delete_flag,'N') = NVL(p_delete_flag,'N')
-- AND NVL(overridden_flag,'N') = NVL(p_overridden_flag,'N')
AND NVL(manually_entered_flag,'N') = NVL(p_manually_entered_flag,'N')
AND NVL(tax_exemption_id, -999) = NVL(p_tax_exemption_id, -999)
-- AND NVL(tax_rate_before_exemption, -999) = NVL(p_tax_rate_before_exemption, -999)
-- AND NVL(tax_rate_name_before_exemption, 'x') = NVL(p_tax_rate_name_before_exempt, 'x')
-- AND NVL(exempt_rate_modifier, -999) = NVL(p_exempt_rate_modifier, -999)
AND NVL(exempt_certificate_number, 'x') = NVL(p_exempt_certificate_number, 'x')
-- AND NVL(exempt_reason, 'x') = NVL(p_exempt_reason, 'x')
AND NVL(exempt_reason_code, 'x') = NVL(p_exempt_reason_code, 'x')
-- AND NVL(tax_rate_before_exception, -999) = NVL(p_tax_rate_before_exception, -999)
-- AND NVL(tax_rate_name_before_exception, 'x') = NVL(p_tax_rate_name_before_except, 'x')
AND NVL(tax_exception_id, -999) = NVL(p_tax_exception_id, -999)
-- AND NVL(exception_rate, -999) = NVL(p_exception_rate, -999)
AND NVL(mrc_tax_line_flag,'N') = NVL(p_mrc_tax_line_flag,'N')
AND NVL(tax_only_line_flag,'N') = NVL(p_tax_only_line_flag,'N');
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (+)'||p_self_assessed_flag);
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
'Self assessed flag '||p_self_assessed_flag);
SELECT tax_amt, overridden_flag INTO l_summary_tax_amt, l_overridden_flag
FROM zx_lines_summary
WHERE summary_tax_line_id = p_summary_tax_line_id;
SELECT sum(unrounded_tax_amt), SUM(unrounded_taxable_amt), COUNT(*)
INTO l_total_detail_tax_amt, l_total_detail_taxable_amt, l_num_det_lines
FROM zx_lines
WHERE summary_tax_line_id = p_summary_tax_line_id
AND application_id = p_application_id
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code
AND trx_id = p_trx_id
AND NVL(cancel_flag, 'N') <> 'Y';
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
'No Lines to Update ');
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.END',
'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (-)');
SELECT allow_adhoc_tax_rate_flag, adj_for_adhoc_amt_code
INTO l_allow_adhoc_tax_rate_flag, l_adj_for_adhoc_amt_code
FROM zx_rates_b
WHERE tax_rate_id = p_tax_rate_id;
SELECT CTRL_EFF_OVRD_CALC_LINES_FLAG
INTO l_ctrl_ef_ov_cal_line_flag
FROM ZX_EVNT_CLS_OPTIONS
WHERE EVENT_CLASS_CODE = p_event_class_code
AND APPLICATION_ID = p_application_id
AND ENTITY_CODE = p_entity_code
AND ENABLED_FLAG = 'Y'
AND FIRST_PTY_ORG_ID = p_internal_organization_id
AND EFFECTIVE_FROM <= sysdate
AND (EFFECTIVE_TO >= sysdate OR
EFFECTIVE_TO IS NULL);
SELECT CTRL_EFF_OVRD_CALC_LINES_FLAG
INTO l_ctrl_ef_ov_cal_line_flag
FROM ZX_EVNT_CLS_MAPPINGS
WHERE EVENT_CLASS_CODE = p_event_class_code
AND APPLICATION_ID = p_application_id
AND ENTITY_CODE = p_entity_code;
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
'Update zx_lines_summary (+)');
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
'tax only line flag ='||rec.tax_only_line_flag);
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
'tax only line flag ='||rec.associated_child_frozen_flag);
OR NVL(rec.delete_flag,'N') <> NVL(p_delete_flag,'N')
-- OR NVL(rec.overridden_flag,'N') <> NVL(p_overridden_flag,'N')
OR NVL(rec.manually_entered_flag,'N') <> NVL(p_manually_entered_flag,'N')
OR NVL(rec.tax_exemption_id, -999) <> NVL(p_tax_exemption_id, -999)
-- OR NVL(rec.tax_rate_before_exemption, -999) <> NVL(p_tax_rate_before_exemption, -999)
-- OR NVL(rec.tax_rate_name_before_exemption, 'x') <> NVL(p_tax_rate_name_before_exempt, 'x')
-- OR NVL(rec.exempt_rate_modifier, -999) <> NVL(p_exempt_rate_modifier, -999)
OR NVL(rec.exempt_certificate_number,'x') <> NVL(p_exempt_certificate_number, 'x')
-- OR NVL(rec.exempt_reason, 'x') <> NVL(p_exempt_reason, 'x')
OR NVL(rec.exempt_reason_code,'x') <> NVL(p_exempt_reason_code, 'x')
-- OR NVL(rec.tax_rate_before_exception, -999) <> NVL(p_tax_rate_before_exception, -999)
-- OR NVL(rec.tax_rate_name_before_exception, 'x') <> NVL(p_tax_rate_name_before_except, 'x')
OR NVL(rec.tax_exception_id, -999) <> NVL(p_tax_exception_id, -999)
-- OR NVL(rec.exception_rate, -999) <> NVL(p_exception_rate, -999)
OR NVL(rec.mrc_tax_line_flag,'N') <> NVL(p_mrc_tax_line_flag,'N')
OR NVL(rec.tax_only_line_flag,'N') <> NVL(p_tax_only_line_flag,'N')
-- OR (NVL(l_summary_tax_amt,-999999999) <> NVL(p_tax_amt,-999999999)
-- AND NVL(l_overridden_flag,'N')='N')
)
THEN
IF NVL(rec.associated_child_frozen_flag,'N') = 'Y' THEN
SELECT zx_lines_s.NEXTVAL INTO l_tax_line_id FROM DUAL;
SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;
SELECT max(abs(tax_apportionment_line_number))+1
INTO l_tax_apportionment_line_num
FROM zx_lines
WHERE application_id = p_application_id
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code
AND trx_id = p_trx_id
AND trx_line_id = rec.trx_line_id;
SELECT nvl(max(tax_line_number),0)+1
INTO l_tax_line_number
FROM zx_lines
WHERE application_id = p_application_id
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code
AND trx_id = p_trx_id
AND trx_line_id = rec.trx_line_id
AND trx_level_type = rec.trx_level_type;
UPDATE ZX_LINES
SET cancel_flag = 'Y',
tax_apportionment_line_number = -1*l_tax_apportionment_line_num,
tax_amt = 0,
tax_amt_tax_curr = 0,
tax_amt_funcl_curr = 0,
unrounded_tax_amt = 0
WHERE tax_line_id = rec.tax_line_id;
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
'Tax line id updated'||to_char(rec.tax_line_id));
select tax_line_id into l_offset_tax_line_id
FROM zx_lines
where application_id = p_application_id
and entity_code = p_entity_code
and event_class_code = p_event_class_code
and offset_link_to_tax_line_id = rec.tax_line_id;
SELECT trx_line_id into l_offset_trx_line_id
FROM zx_lines
WHERE tax_line_id = l_offset_tax_line_id;
SELECT MAX(ABS(tax_apportionment_line_number)) + 1
INTO l_tax_apportionment_line_num
FROM zx_lines
WHERE application_id = p_application_id
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code
AND trx_id = p_trx_id
AND trx_line_id = l_offset_trx_line_id;
UPDATE ZX_LINES
SET cancel_flag = 'Y',
tax_amt = 0,
tax_apportionment_line_number = -1*l_tax_apportionment_line_num,
unrounded_tax_amt = 0,
tax_amt_tax_curr = 0,
tax_amt_funcl_curr = 0,
process_for_recovery_flag = 'Y'
WHERE tax_line_id = l_offset_tax_line_id;
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
'Tax line id updated'||to_char(l_offset_tax_line_id));
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
'tax apportionment line number '||l_tax_apportionment_line_num);
zx_trl_detail_override_pkg.Insert_Row
(l_row_id ,
l_tax_line_id ,
p_internal_organization_id ,
rec.application_id ,
rec.entity_code ,
rec.event_class_code ,
rec.event_type_code ,
rec.trx_id ,
rec.trx_line_id ,
rec.trx_level_type ,
rec.trx_line_number ,
rec.doc_event_status ,
rec.tax_event_class_code ,
rec.tax_event_type_code ,
l_tax_line_number ,
rec.content_owner_id ,
rec.tax_regime_id ,
rec.tax_regime_code ,
rec.tax_id ,
rec.tax ,
p_tax_status_id ,
p_tax_status_code ,
p_tax_rate_id ,
p_tax_rate_code ,
l_tax_rate , --tax_rate
rec.tax_rate_type ,
rec.tax_apportionment_line_number , --reduced in size tax_apportionment_line_number
rec.trx_id_level2 ,
rec.trx_id_level3 ,
rec.trx_id_level4 ,
rec.trx_id_level5 ,
rec.trx_id_level6 ,
rec.trx_user_key_level1 ,
rec.trx_user_key_level2 ,
rec.trx_user_key_level3 ,
rec.trx_user_key_level4 ,
rec.trx_user_key_level5 ,
rec.trx_user_key_level6 ,
rec.mrc_tax_line_flag ,
rec.mrc_link_to_tax_line_id ,
rec.ledger_id ,
rec.establishment_id ,
rec.legal_entity_id ,
rec.hq_estb_reg_number ,
rec.hq_estb_party_tax_prof_id ,
rec.currency_conversion_date ,
rec.currency_conversion_type ,
rec.currency_conversion_rate ,
rec.tax_currency_conversion_date , --reduced in size tax_currency_conversion_date
rec.tax_currency_conversion_type , --reduced in size rec.tax_currency_conversion_type
rec.tax_currency_conversion_rate , --reduced in size rec.tax_currency_conversion_rate
rec.trx_currency_code ,
rec.reporting_currency_code ,
rec.minimum_accountable_unit ,
rec.precision ,
p_trx_number ,
rec.trx_date ,
rec.unit_price ,
rec.line_amt ,
rec.trx_line_quantity ,
rec.tax_base_modifier_rate ,
rec.ref_doc_application_id ,
rec.ref_doc_entity_code ,
rec.ref_doc_event_class_code ,
rec.ref_doc_trx_id ,
rec.ref_doc_trx_level_type ,
rec.ref_doc_line_id ,
rec.ref_doc_line_quantity ,
rec.other_doc_line_amt ,
rec.other_doc_line_tax_amt ,
rec.other_doc_line_taxable_amt ,
rec.unrounded_taxable_amt ,
rec.unrounded_tax_amt ,
rec.related_doc_application_id ,
rec.related_doc_entity_code ,
rec.related_doc_event_class_code , --reduced in size rec.related_doc_event_class_code
rec.related_doc_trx_id ,
rec.related_doc_trx_level_type ,
rec.related_doc_number ,
rec.related_doc_date ,
p_applied_from_application_id , --reduced in size rec.applied_from_application_id
rec.applied_from_event_class_code , --reduced in size rec.applied_from_event_class_code
p_applied_from_entity_code ,
rec.applied_from_trx_id ,
rec.applied_from_trx_level_type ,
rec.applied_from_line_id ,
rec.applied_from_trx_number ,
rec.adjusted_doc_application_id , --reduced in size rec.adjusted_doc_application_id
rec.adjusted_doc_entity_code ,
rec.adjusted_doc_event_class_code , --reduced in size rec.adjusted_doc_event_class_code
rec.adjusted_doc_trx_id ,
rec.adjusted_doc_trx_level_type ,
rec.adjusted_doc_line_id ,
rec.adjusted_doc_number ,
rec.adjusted_doc_date ,
rec.applied_to_application_id ,
rec.applied_to_event_class_code , --reduced in size rec.applied_to_event_class_code
rec.applied_to_entity_code ,
rec.applied_to_trx_id ,
rec.applied_to_trx_level_type ,
rec.applied_to_line_id ,
l_summary_tax_line_id , --summary_tax_line_id
rec.offset_link_to_tax_line_id ,
rec.offset_flag ,
rec.process_for_recovery_flag ,
rec.tax_jurisdiction_id ,
p_tax_jurisdiction_code ,
rec.place_of_supply ,
rec.place_of_supply_type_code ,
rec.place_of_supply_result_id ,
rec.tax_date_rule_id ,
rec.tax_date ,
rec.tax_determine_date ,
rec.tax_point_date ,
rec.trx_line_date ,
rec.tax_type_code ,
rec.tax_code ,
rec.tax_registration_id ,
rec.tax_registration_number ,
rec.registration_party_type ,
rec.rounding_level_code ,
rec.rounding_rule_code ,
rec.rounding_lvl_party_tax_prof_id , --reduced in size rec.rounding_lvl_party_tax_prof_id
rec.rounding_lvl_party_type ,
rec.compounding_tax_flag ,
rec.orig_tax_status_id ,
rec.orig_tax_status_code ,
rec.orig_tax_rate_id ,
rec.orig_tax_rate_code ,
rec.orig_tax_rate ,
rec.orig_tax_jurisdiction_id ,
rec.orig_tax_jurisdiction_code ,
l_orig_tax_amt_included_flag ,
l_orig_self_assessed_flag ,
rec.tax_currency_code ,
rec.tax_amt ,
rec.tax_amt_tax_curr ,
rec.tax_amt_funcl_curr ,
rec.taxable_amt ,
rec.taxable_amt_tax_curr ,
rec.taxable_amt_funcl_curr ,
rec.orig_taxable_amt ,
rec.orig_taxable_amt_tax_curr ,
rec.cal_tax_amt ,
rec.cal_tax_amt_tax_curr ,
rec.cal_tax_amt_funcl_curr ,
rec.orig_tax_amt ,
rec.orig_tax_amt_tax_curr ,
rec.rec_tax_amt ,
rec.rec_tax_amt_tax_curr ,
rec.rec_tax_amt_funcl_curr ,
rec.nrec_tax_amt ,
rec.nrec_tax_amt_tax_curr ,
rec.nrec_tax_amt_funcl_curr ,
rec.tax_exemption_id ,
rec.tax_rate_before_exemption ,
rec.tax_rate_name_before_exemption ,
rec.exempt_rate_modifier ,
rec.exempt_certificate_number ,
rec.exempt_reason ,
rec.exempt_reason_code ,
rec.tax_exception_id ,
rec.tax_rate_before_exception ,
rec.tax_rate_name_before_exception ,
rec.exception_rate ,
rec.tax_apportionment_flag ,
rec.historical_flag ,
p_taxable_basis_formula ,
p_tax_calculation_formula ,
nvl(rec.cancel_flag,'N') ,
rec.purge_flag ,
rec.delete_flag ,
p_tax_amt_included_flag ,
p_self_assessed_flag ,
'C' ,
p_manually_entered_flag ,
p_reporting_only_flag ,
rec.freeze_until_overridden_flag , --reduced in size rec.Freeze_Until_Overridden_Flag
rec.copied_from_other_doc_flag ,
rec.recalc_required_flag ,
rec.settlement_flag ,
rec.item_dist_changed_flag ,
NULL , --reduced in size rec.Associated_Child_Frozen_Flag
rec.tax_only_line_flag ,
rec.compounding_tax_flag ,
rec.compounding_tax_miss_flag ,
rec.sync_with_prvdr_flag ,
rec.last_manual_entry ,
rec.tax_provider_id ,
p_record_type_code ,
rec.reporting_period_id ,
rec.legal_justification_text1 ,
rec.legal_justification_text2 ,
rec.legal_justification_text3 ,
rec.legal_message_appl_2 ,
rec.legal_message_status ,
rec.legal_message_rate ,
rec.legal_message_basis ,
rec.legal_message_calc ,
rec.legal_message_threshold ,
rec.legal_message_pos ,
rec.legal_message_trn ,
rec.legal_message_exmpt ,
rec.legal_message_excpt ,
rec.tax_regime_template_id ,
rec.tax_applicability_result_id , --reduced in size rec.tax_applicability_result_id
rec.direct_rate_result_id ,
rec.status_result_id ,
rec.rate_result_id ,
rec.basis_result_id ,
rec.thresh_result_id ,
rec.calc_result_id ,
rec.tax_reg_num_det_result_id ,
rec.eval_exmpt_result_id ,
rec.eval_excpt_result_id ,
rec.enforce_from_natural_acct_flag , --reduced in size rec.Enforce_From_Natural_Acct_Flag
rec.tax_hold_code ,
rec.tax_hold_released_code ,
rec.prd_total_tax_amt ,
rec.prd_total_tax_amt_tax_curr ,
rec.prd_total_tax_amt_funcl_curr ,
rec.trx_line_index ,
rec.offset_tax_rate_code ,
rec.proration_code ,
rec.other_doc_source ,
rec.internal_org_location_id ,
rec.line_assessable_value ,
rec.ctrl_total_line_tx_amt ,
rec.applied_to_trx_number ,
rec.attribute_category ,
rec.attribute1 ,
rec.attribute2 ,
rec.attribute3 ,
rec.attribute4 ,
rec.attribute5 ,
rec.attribute6 ,
rec.attribute7 ,
rec.attribute8 ,
rec.attribute9 ,
rec.attribute10 ,
rec.attribute11 ,
rec.attribute12 ,
rec.attribute13 ,
rec.attribute14 ,
rec.attribute15 ,
rec.global_attribute_category ,
rec.global_attribute1 ,
rec.global_attribute2 ,
rec.global_attribute3 ,
rec.global_attribute4 ,
rec.global_attribute5 ,
rec.global_attribute6 ,
rec.global_attribute7 ,
rec.global_attribute8 ,
rec.global_attribute9 ,
rec.global_attribute10 ,
rec.global_attribute11 ,
rec.global_attribute12 ,
rec.global_attribute13 ,
rec.global_attribute14 ,
rec.global_attribute15 ,
rec.numeric1 ,
rec.numeric2 ,
rec.numeric3 ,
rec.numeric4 ,
rec.numeric5 ,
rec.numeric6 ,
rec.numeric7 ,
rec.numeric8 ,
rec.numeric9 ,
rec.numeric10 ,
rec.char1 ,
rec.char2 ,
rec.char3 ,
rec.char4 ,
rec.char5 ,
rec.char6 ,
rec.char7 ,
rec.char8 ,
rec.char9 ,
rec.char10 ,
rec.date1 ,
rec.date2 ,
rec.date3 ,
rec.date4 ,
rec.date5 ,
rec.date6 ,
rec.date7 ,
rec.date8 ,
rec.date9 ,
rec.date10 ,
rec.interface_entity_code ,
rec.interface_tax_line_id ,
rec.taxing_juris_geography_id ,
rec.adjusted_doc_tax_line_id ,
rec.object_version_number ,
rec.last_updated_by ,
rec.last_update_date ,
rec.last_updated_by ,
rec.last_update_date ,
rec.last_update_login);
SELECT count(*) INTO l_num_canceled_detail_lines
FROM zx_lines
WHERE application_id = p_application_id
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code
AND trx_id = p_trx_id
AND summary_tax_line_id = p_summary_tax_line_id
AND nvl(cancel_flag,'N')= 'Y';
SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;
UPDATE ZX_LINES
SET summary_tax_line_id = l_summary_tax_line_id
WHERE tax_line_id = rec.tax_line_id;
UPDATE ZX_LINES_SUMMARY
SET TAX_STATUS_CODE = p_tax_status_code,
TAX_RATE_ID = p_tax_rate_Id,
SUMMARY_TAX_LINE_ID = nvl(l_summary_tax_line_id,p_summary_tax_line_id) ,
TAX_RATE_CODE = p_tax_rate_code,
TAX_RATE = l_tax_rate,
TAX_AMT = p_tax_amt,
OVERRIDDEN_FLAG = p_overridden_flag,
LAST_MANUAL_ENTRY = decode (nvl(p_cancel_flag,'N'), 'N', p_last_manual_entry, 'TAX_AMOUNT'),
ADJUST_TAX_AMT_FLAG = decode (nvl(p_cancel_flag,'N'), 'N', 'Y', ADJUST_TAX_AMT_FLAG),
CANCEL_FLAG = NVL(p_cancel_flag,'N'),
TAX_AMT_INCLUDED_FLAG = p_tax_amt_included_flag,
SELF_ASSESSED_FLAG = p_self_assessed_flag,
TAX_ONLY_LINE_FLAG = p_tax_only_line_flag,
OBJECT_VERSION_NUMBER = NVL(p_object_version_number, OBJECT_VERSION_NUMBER + 1),
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATE_LOGIN = fnd_global.login_id
WHERE summary_tax_line_id = p_summary_tax_line_id;
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
'cancel flag is '||p_cancel_flag);
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
'tot detail tax amt'||to_char(l_total_detail_tax_amt));
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
'tot detail taxable amt'||to_char(l_total_detail_taxable_amt));
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
'before cancel flag = N');
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
'no of det lines 1');
UPDATE ZX_LINES
SET UNROUNDED_TAX_AMT = p_tax_amt
WHERE APPLICATION_ID = p_application_id
AND ENTITY_CODE = p_entity_code
AND EVENT_CLASS_CODE = p_event_class_code
AND TRX_ID = p_trx_id
AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
AND nvl(cancel_flag,'N') <> 'Y';
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
'tot det tax amt <> 0');
UPDATE ZX_LINES
SET UNROUNDED_TAX_AMT = decode(nvl(p_cancel_flag,'N'), 'N', ((unrounded_tax_amt * p_tax_amt)/l_total_detail_tax_amt), 0)
WHERE APPLICATION_ID = p_application_id
AND ENTITY_CODE = p_entity_code
AND EVENT_CLASS_CODE = p_event_class_code
AND TRX_ID = p_trx_id
AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
AND nvl(cancel_flag,'N') <> 'Y';
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
'tot det taxable amt <> 0');
UPDATE ZX_LINES
SET UNROUNDED_TAX_AMT = decode(nvl(p_cancel_flag,'N'), 'N', ((unrounded_taxable_amt * p_tax_amt)/l_total_detail_taxable_amt), 0)
WHERE APPLICATION_ID = p_application_id
AND ENTITY_CODE = p_entity_code
AND EVENT_CLASS_CODE = p_event_class_code
AND TRX_ID = p_trx_id
AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
AND nvl(cancel_flag,'N') <> 'Y';
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
'exception');
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
'exception -- Tax amount is Not Zero');
FND_MESSAGE.Set_Name ('ZX','ZX_TAX_AMT_UPDATE_NOT_ALLOWED');
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
'before manually entered flag = N');
UPDATE ZX_LINES
SET RECALC_REQUIRED_FLAG = 'Y'
WHERE APPLICATION_ID = p_application_id
AND ENTITY_CODE = p_entity_code
AND EVENT_CLASS_CODE = p_event_class_code
AND TRX_ID = p_trx_id
AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
AND nvl(MANUALLY_ENTERED_FLAG,'N') = 'N'
AND nvl(CANCEL_FLAG,'N') = 'N';
UPDATE ZX_LINES
SET RECALC_REQUIRED_FLAG = 'Y'
WHERE APPLICATION_ID = p_application_id
AND ENTITY_CODE = p_entity_code
AND EVENT_CLASS_CODE = p_event_class_code
AND TRX_ID = p_trx_id
AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
AND nvl(COMPOUNDING_DEP_TAX_FLAG,'N') = 'Y'
AND nvl(CANCEL_FLAG,'N') = 'N';
UPDATE ZX_LINES
SET ORIG_TAX_STATUS_ID = nvl(ORIG_TAX_STATUS_ID, TAX_STATUS_ID),
ORIG_TAX_STATUS_CODE = nvl(ORIG_TAX_STATUS_CODE, TAX_STATUS_CODE),
ORIG_TAX_RATE_ID = nvl(ORIG_TAX_RATE_ID, TAX_RATE_ID),
ORIG_TAX_RATE_CODE = nvl(ORIG_TAX_RATE_CODE, TAX_RATE_CODE),
ORIG_TAX_RATE = nvl(ORIG_TAX_RATE, TAX_RATE),
ORIG_TAXABLE_AMT = nvl(ORIG_TAXABLE_AMT, TAXABLE_AMT),
ORIG_TAXABLE_AMT_TAX_CURR = nvl(ORIG_TAXABLE_AMT_TAX_CURR, TAXABLE_AMT_TAX_CURR),
ORIG_TAX_AMT = nvl(ORIG_TAX_AMT, TAX_AMT),
ORIG_TAX_AMT_TAX_CURR = nvl(ORIG_TAX_AMT_TAX_CURR, TAX_AMT_TAX_CURR),
SYNC_WITH_PRVDR_FLAG = decode(p_tax_provider_id, NULL, 'N', 'Y'),
TAX_STATUS_ID = p_tax_status_id,
TAX_STATUS_CODE = p_tax_status_code,
TAX_RATE_ID = p_tax_rate_id,
TAX_RATE_CODE = p_tax_rate_code,
TAX_RATE = l_tax_rate,
--TAX_AMT = decode(nvl(p_cancel_flag,'N'), 'N', NULL, 0),
TAX_AMT = decode(nvl(p_cancel_flag,'N'), 'N', NULL, 0),
RECALC_REQUIRED_FLAG = decode(nvl(p_cancel_flag,'N'), 'N', 'Y', 'N'),
OVERRIDDEN_FLAG = decode(nvl(p_cancel_flag,'N'), 'N', p_overridden_flag, 'Y'),
SELF_ASSESSED_FLAG = p_self_assessed_flag,
ORIG_SELF_ASSESSED_FLAG = decode(ORIG_SELF_ASSESSED_FLAG,NULL,decode(p_self_assessed_flag,SELF_ASSESSED_FLAG,ORIG_SELF_ASSESSED_FLAG,SELF_ASSESSED_FLAG),ORIG_SELF_ASSESSED_FLAG),
ORIG_TAX_AMT_INCLUDED_FLAG = decode(ORIG_TAX_AMT_INCLUDED_FLAG,NULL,decode(p_tax_amt_included_flag,TAX_AMT_INCLUDED_FLAG,ORIG_TAX_AMT_INCLUDED_FLAG,TAX_AMT_INCLUDED_FLAG),ORIG_TAX_AMT_INCLUDED_FLAG),
LAST_MANUAL_ENTRY = decode(nvl(p_cancel_flag,'N'), 'N', p_last_manual_entry, 'TAX_AMOUNT'),
CANCEL_FLAG = nvl(p_cancel_flag,'N'),
OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
UNROUNDED_TAX_AMT = decode(nvl(p_cancel_flag,'N'),'Y',0,UNROUNDED_TAX_AMT),
PROCESS_FOR_RECOVERY_FLAG = decode(p_reporting_only_flag, 'N', 'Y', 'N'),
SUMMARY_TAX_LINE_ID = nvl(l_existing_summary_tax_line_id,l_summary_tax_line_id) -- new changes
WHERE APPLICATION_ID = p_application_id
AND ENTITY_CODE = p_entity_code
AND EVENT_CLASS_CODE = p_event_class_code
AND TRX_ID = p_trx_id
AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
AND nvl(cancel_flag,'N') <> 'Y';
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
'Update zx_lines_summary (-)');
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.END',
'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (-)');
END Update_Row;
PROCEDURE Delete_Row
(x_rowid IN OUT NOCOPY VARCHAR2,
p_summary_tax_line_id NUMBER,
p_internal_organization_id NUMBER,
p_application_id NUMBER,
p_entity_code VARCHAR2,
p_event_class_code VARCHAR2,
p_trx_id NUMBER,
p_summary_tax_line_number NUMBER,
p_trx_number VARCHAR2,
p_applied_from_application_id NUMBER,
p_applied_from_evt_class_code VARCHAR2,--reduced size p_applied_from_event_class_code
p_applied_from_entity_code VARCHAR2,
p_applied_from_trx_id NUMBER,
p_applied_from_trx_level_type VARCHAR2,
p_applied_from_line_id NUMBER,
p_adjusted_doc_application_id NUMBER,
p_adjusted_doc_entity_code VARCHAR2,
p_adjusted_doc_evt_class_code VARCHAR2,--reduced size p_adjusted_doc_event_class_code
p_adjusted_doc_trx_id NUMBER,
p_adjusted_doc_trx_level_type VARCHAR2,
p_applied_to_application_id NUMBER,
p_applied_to_event_class_code VARCHAR2,
p_applied_to_entity_code VARCHAR2,
p_applied_to_trx_id NUMBER,
p_applied_to_trx_level_type VARCHAR2,
p_applied_to_line_id NUMBER,
p_tax_exemption_id NUMBER,
p_tax_rate_before_exemption NUMBER,
p_tax_rate_name_before_exempt VARCHAR2, --reduced size p_tax_rate_name_before_exemption
p_exempt_rate_modifier NUMBER,
p_exempt_certificate_number VARCHAR2,
p_exempt_reason VARCHAR2,
p_exempt_reason_code VARCHAR2,
p_tax_rate_before_exception NUMBER,
p_tax_rate_name_before_except VARCHAR2, --reduced size p_tax_rate_name_before_exception
p_tax_exception_id NUMBER,
p_exception_rate NUMBER,
p_content_owner_id NUMBER,
p_tax_regime_code VARCHAR2,
p_tax VARCHAR2,
p_tax_status_code VARCHAR2,
p_tax_rate_id NUMBER,
p_tax_rate_code VARCHAR2,
p_tax_rate NUMBER,
p_tax_amt NUMBER,
p_tax_amt_tax_curr NUMBER,
p_tax_amt_funcl_curr NUMBER,
p_tax_jurisdiction_code VARCHAR2,
p_total_rec_tax_amt NUMBER,
p_total_rec_tax_amt_func_curr NUMBER,--reduced size p_total_rec_tax_amt_funcl_curr
p_total_rec_tax_amt_tax_curr NUMBER,
p_total_nrec_tax_amt NUMBER,
p_total_nrec_tax_amt_func_curr NUMBER,--reduced size p_total_nrec_tax_amt_funcl_curr
p_total_nrec_tax_amt_tax_curr NUMBER,
p_ledger_id NUMBER,
p_legal_entity_id NUMBER,
p_establishment_id NUMBER,
p_currency_conversion_date DATE,
p_currency_conversion_type VARCHAR2,
p_currency_conversion_rate NUMBER,
p_summarization_template_id NUMBER,
p_taxable_basis_formula VARCHAR2,
p_tax_calculation_formula VARCHAR2,
p_historical_flag VARCHAR2,
p_cancel_flag VARCHAR2,
p_delete_flag VARCHAR2,
p_tax_amt_included_flag VARCHAR2,
p_compounding_tax_flag VARCHAR2,
p_self_assessed_flag VARCHAR2,
p_overridden_flag VARCHAR2,
p_reporting_only_flag VARCHAR2,
p_assoc_child_frozen_flag VARCHAR2,--reduced size p_Associated_Child_Frozen_Flag
p_copied_from_other_doc_flag VARCHAR2,
p_manually_entered_flag VARCHAR2,
p_mrc_tax_line_flag VARCHAR2,
p_last_manual_entry VARCHAR2,
p_record_type_code VARCHAR2,
p_tax_provider_id NUMBER,
p_tax_only_line_flag VARCHAR2,
p_adjust_tax_amt_flag VARCHAR2,
p_attribute_category VARCHAR2,
p_attribute1 VARCHAR2,
p_attribute2 VARCHAR2,
p_attribute3 VARCHAR2,
p_attribute4 VARCHAR2,
p_attribute5 VARCHAR2,
p_attribute6 VARCHAR2,
p_attribute7 VARCHAR2,
p_attribute8 VARCHAR2,
p_attribute9 VARCHAR2,
p_attribute10 VARCHAR2,
p_attribute11 VARCHAR2,
p_attribute12 VARCHAR2,
p_attribute13 VARCHAR2,
p_attribute14 VARCHAR2,
p_attribute15 VARCHAR2,
p_global_attribute_category VARCHAR2,
p_global_attribute1 VARCHAR2,
p_global_attribute2 VARCHAR2,
p_global_attribute3 VARCHAR2,
p_global_attribute4 VARCHAR2,
p_global_attribute5 VARCHAR2,
p_global_attribute6 VARCHAR2,
p_global_attribute7 VARCHAR2,
p_global_attribute8 VARCHAR2,
p_global_attribute9 VARCHAR2,
p_global_attribute10 VARCHAR2,
p_global_attribute11 VARCHAR2,
p_global_attribute12 VARCHAR2,
p_global_attribute13 VARCHAR2,
p_global_attribute14 VARCHAR2,
p_global_attribute15 VARCHAR2,
p_global_attribute16 VARCHAR2,
p_global_attribute17 VARCHAR2,
p_global_attribute18 VARCHAR2,
p_global_attribute19 VARCHAR2,
p_global_attribute20 VARCHAR2,
p_object_version_number NUMBER,
p_created_by NUMBER,
p_creation_date DATE,
p_last_updated_by NUMBER,
p_last_update_date DATE,
p_last_update_login NUMBER) IS
BEGIN
g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.BEGIN',
'ZX_TRL_SUMMARY_OVERRIDE_PKG: Delete_Row (+)');
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
'Update zx_lines_summary for DELETE (+)');
UPDATE ZX_LINES_SUMMARY
SET DELETE_FLAG = 'Y',
OBJECT_VERSION_NUMBER = NVL(p_object_version_number, OBJECT_VERSION_NUMBER + 1)
WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
UPDATE ZX_LINES
SET DELETE_FLAG = 'Y',
SYNC_WITH_PRVDR_FLAG = DECODE(p_tax_provider_id,
NULL, 'N', 'Y'),
OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
WHERE APPLICATION_ID = p_application_id
AND ENTITY_CODE = p_entity_code
AND EVENT_CLASS_CODE = p_event_class_code
AND TRX_ID = p_trx_id
AND SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
'Update zx_lines_summary for DELETE (-)');
'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.END',
'ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row (-)');
END Delete_Row;
'Update zx_lines_det_factors (+)');
UPDATE ZX_LINES_DET_FACTORS
SET EVENT_ID = p_event_id
WHERE APPLICATION_ID = p_application_id
AND ENTITY_CODE = p_entity_code
AND EVENT_CLASS_CODE = p_event_class_code
AND TRX_ID = p_trx_id
AND (TRX_LINE_ID, TRX_LEVEL_TYPE)
IN (SELECT TRX_LINE_ID, TRX_LEVEL_TYPE
FROM ZX_LINES
WHERE APPLICATION_ID = p_application_id
AND ENTITY_CODE = p_entity_code
AND EVENT_CLASS_CODE = p_event_class_code
AND TRX_ID = p_trx_id
AND SUMMARY_TAX_LINE_ID = p_summary_tax_line_id);
'Update zx_lines_det_factors (-)');
SELECT count(*)
INTO l_key_check
FROM ZX_LINES_SUMMARY LS
WHERE APPLICATION_ID = p_application_id
AND ENTITY_CODE = p_entity_code
AND EVENT_CLASS_CODE = p_event_class_code
AND INTERNAL_ORGANIZATION_ID = p_internal_organization_id
AND TRX_ID = p_trx_id
AND TAX_REGIME_CODE = p_tax_regime_code
AND TAX = p_tax
AND TAX_STATUS_CODE = p_tax_status_code
AND TAX_RATE_CODE = p_tax_rate_code;
SELECT *
FROM ZX_LINES_SUMMARY
WHERE application_id = c_application_id
AND entity_code = c_entity_code
AND event_class_code = c_event_class_code
AND trx_id = c_trx_id
FOR UPDATE NOWAIT;