[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT /*+ INDEX (ZX_TRANSACTION_LINES_GT ZX_TRANSACTION_LINES_GT_U1)*/
adjusted_doc_date
INTO l_adj_doc_date
FROM ZX_TRANSACTION_LINES_GT
WHERE application_id = p_event_class_rec.application_id
AND entity_code = p_event_class_rec.entity_code
AND event_class_code = p_event_class_rec.event_class_code
AND trx_id = p_event_class_rec.trx_id
AND rownum = 1;
SELECT adjusted_doc_date
INTO l_adj_doc_date
FROM ZX_LINES_DET_FACTORS
WHERE application_id = p_event_class_rec.application_id
AND entity_code = p_event_class_rec.entity_code
AND event_class_code = p_event_class_rec.event_class_code
AND trx_id = p_event_class_rec.trx_id
AND rownum = 1;
ELSE --for calls from products via global structures eg. update_line_det_factors/insert_line_det_factors
l_adj_doc_date := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(1);
SELECT det_factor_templ_code,
default_rounding_level_code,
rounding_level_hier_1_code,
rounding_level_hier_2_code,
rounding_level_hier_3_code,
rounding_level_hier_4_code,
process_for_applicability_flag,
def_intrcmp_trx_biz_category,
exmptn_pty_basis_hier_1_code,
exmptn_pty_basis_hier_2_code,
allow_exemptions_flag
INTO p_event_class_rec.det_factor_templ_code,
p_event_class_rec.default_rounding_level_code,
p_event_class_rec.rounding_level_hier_1_code,
p_event_class_rec.rounding_level_hier_2_code,
p_event_class_rec.rounding_level_hier_3_code,
p_event_class_rec.rounding_level_hier_4_code,
p_event_class_rec.process_for_applicability_flag,
p_event_class_rec.DEF_INTRCMP_TRX_BIZ_CATEGORY,
p_event_class_rec.exmptn_pty_basis_hier_1_code,
p_event_class_rec.exmptn_pty_basis_hier_2_code,
p_event_class_rec.ALLOW_EXEMPTIONS_FLAG
FROM ZX_EVNT_CLS_OPTIONS
WHERE application_id = 222
AND entity_code = 'TRANSACTIONS'
AND event_class_code = 'INVOICE'
AND first_pty_org_id = p_event_class_rec.first_pty_org_id
AND p_trx_date >= EFFECTIVE_FROM and p_trx_date <= nvl(EFFECTIVE_TO,p_trx_date)
AND enabled_flag = 'Y';
SELECT det_factor_templ_code,
default_rounding_level_code,
rounding_level_hier_1_code,
rounding_level_hier_2_code,
rounding_level_hier_3_code,
rounding_level_hier_4_code,
process_for_applicability_flag,
def_intrcmp_trx_biz_category,
exmptn_pty_basis_hier_1_code,
exmptn_pty_basis_hier_2_code,
allow_exemptions_flag
INTO p_event_class_rec.det_factor_templ_code,
p_event_class_rec.default_rounding_level_code,
p_event_class_rec.rounding_level_hier_1_code,
p_event_class_rec.rounding_level_hier_2_code,
p_event_class_rec.rounding_level_hier_3_code,
p_event_class_rec.rounding_level_hier_4_code,
p_event_class_rec.process_for_applicability_flag,
p_event_class_rec.DEF_INTRCMP_TRX_BIZ_CATEGORY,
p_event_class_rec.exmptn_pty_basis_hier_1_code,
p_event_class_rec.exmptn_pty_basis_hier_2_code,
p_event_class_rec.ALLOW_EXEMPTIONS_FLAG
FROM ZX_EVNT_CLS_OPTIONS
WHERE application_id = 200
AND entity_code = 'AP_INVOICES'
AND event_class_code = 'STANDARD INVOICES'
AND first_pty_org_id = p_event_class_rec.first_pty_org_id
AND p_trx_date >= EFFECTIVE_FROM and p_trx_date <= nvl(EFFECTIVE_TO,p_trx_date)
AND enabled_flag = 'Y';
SELECT det_factor_templ_code,
default_rounding_level_code,
rounding_level_hier_1_code,
rounding_level_hier_2_code,
rounding_level_hier_3_code,
rounding_level_hier_4_code,
allow_manual_lin_recalc_flag,
allow_override_flag,
allow_manual_lines_flag,
perf_addnl_appl_for_imprt_flag,
enforce_tax_from_acct_flag,
offset_tax_basis_code,
tax_tolerance,
tax_tol_amt_range,
'N',
allow_offset_tax_calc_flag,
enter_ovrd_incl_tax_lines_flag ,
ctrl_eff_ovrd_calc_lines_flag,
enforce_tax_from_ref_doc_flag,
process_for_applicability_flag,
allow_exemptions_flag,
exmptn_pty_basis_hier_1_code,
exmptn_pty_basis_hier_2_code,
def_intrcmp_trx_biz_category
INTO p_event_class_rec.DET_FACTOR_TEMPL_CODE,
p_event_class_rec.DEFAULT_ROUNDING_LEVEL_CODE,
p_event_class_rec.ROUNDING_LEVEL_HIER_1_CODE,
p_event_class_rec.ROUNDING_LEVEL_HIER_2_CODE,
p_event_class_rec.ROUNDING_LEVEL_HIER_3_CODE,
p_event_class_rec.ROUNDING_LEVEL_HIER_4_CODE,
p_event_class_rec.ALLOW_MANUAL_LIN_RECALC_FLAG,
p_event_class_rec.ALLOW_OVERRIDE_FLAG,
p_event_class_rec.ALLOW_MANUAL_LINES_FLAG,
p_event_class_rec.PERF_ADDNL_APPL_FOR_IMPRT_FLAG,
p_event_class_rec.ENFORCE_TAX_FROM_ACCT_FLAG,
p_event_class_rec.OFFSET_TAX_BASIS_CODE,
p_event_class_rec.TAX_TOLERANCE,
p_event_class_rec.TAX_TOL_AMT_RANGE,
p_event_class_rec.CTRL_TOTAL_LINE_TX_AMT_FLG,
p_event_class_rec.ALLOW_OFFSET_TAX_CALC_FLAG,
p_event_class_rec.ENTER_OVRD_INCL_TAX_LINES_FLAG ,
p_event_class_rec.CTRL_EFF_OVRD_CALC_LINES_FLAG,
p_event_class_rec.ENFORCE_TAX_FROM_REF_DOC_FLAG,
p_event_class_rec.PROCESS_FOR_APPLICABILITY_FLAG,
p_event_class_rec.ALLOW_EXEMPTIONS_FLAG,
p_event_class_rec.EXMPTN_PTY_BASIS_HIER_1_CODE,
p_event_class_rec.EXMPTN_PTY_BASIS_HIER_2_CODE,
p_event_class_rec.DEF_INTRCMP_TRX_BIZ_CATEGORY
FROM ZX_EVNT_CLS_OPTIONS
WHERE application_id = p_event_class_rec.application_id
AND entity_code = p_event_class_rec.entity_code
AND event_class_code = p_event_class_rec.event_class_code
AND first_pty_org_id = p_event_class_rec.first_pty_org_id
AND p_trx_date >= EFFECTIVE_FROM and p_trx_date <= nvl(EFFECTIVE_TO,p_trx_date)
AND enabled_flag = 'Y';
SELECT opt.process_for_applicability_flag
INTO p_event_class_rec.source_process_for_appl_flag
FROM zx_evnt_cls_options opt,
zx_lines_det_factors det
WHERE opt.application_id = det.source_application_id
AND opt.entity_code = det.source_entity_code
AND opt.event_class_code = det.source_event_class_code
AND opt.first_pty_org_id = p_event_class_rec.first_pty_org_id
AND p_trx_date >= opt.EFFECTIVE_FROM and p_trx_date <= nvl(opt.EFFECTIVE_TO,p_trx_date)
AND opt.enabled_flag = 'Y'
AND det.trx_id = p_event_class_rec.trx_id
AND det.application_id = p_event_class_rec.application_id
AND det.entity_code = p_event_class_rec.entity_code
AND det.event_class_code = p_event_class_rec.event_class_code
AND det.source_event_class_code in ('TRADE_MGT_PAYABLES','TRADE_MGT_RECEIVABLES')
AND rownum=1;
SELECT opt.process_for_applicability_flag
INTO p_event_class_rec.source_process_for_appl_flag
FROM zx_evnt_cls_options opt
WHERE opt.application_id = zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_APPLICATION_ID(1)
AND opt.entity_code = zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_ENTITY_CODE(1)
AND opt.event_class_code = zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_EVENT_CLASS_CODE(1)
AND opt.first_pty_org_id = p_event_class_rec.first_pty_org_id
AND p_trx_date >= opt.EFFECTIVE_FROM and p_trx_date <= nvl(opt.EFFECTIVE_TO,p_trx_date)
AND opt.enabled_flag = 'Y';
SELECT opt.process_for_applicability_flag
INTO p_event_class_rec.source_process_for_appl_flag
FROM zx_evnt_cls_options opt,
zx_transaction_lines_gt lines
WHERE opt.application_id = lines.source_application_id
AND opt.entity_code = lines.source_entity_code
AND opt.event_class_code = lines.source_event_class_code
AND opt.first_pty_org_id = p_event_class_rec.first_pty_org_id
AND p_trx_date >= opt.EFFECTIVE_FROM and p_trx_date <= nvl(opt.EFFECTIVE_TO,p_trx_date)
AND opt.enabled_flag = 'Y'
AND lines.trx_id = p_event_class_rec.trx_id
AND lines.application_id = p_event_class_rec.application_id
AND lines .entity_code = p_event_class_rec.entity_code
AND lines.event_class_code = p_event_class_rec.event_class_code
AND lines.source_event_class_code in ('TRADE_MGT_PAYABLES','TRADE_MGT_RECEIVABLES')
AND rownum=1;
/* replaced the select from zx_product_options with cached structure
SELECT nvl(tax_method_code,'EBTAX'),
inclusive_tax_used_flag,
tax_use_customer_exempt_flag,
tax_use_product_exempt_flag,
tax_use_loc_exc_rate_flag,
tax_allow_compound_flag,
use_tax_classification_flag,
allow_tax_rounding_ovrd_flag,
home_country_default_flag
INTO p_event_class_rec.TAX_METHOD_CODE,
p_event_class_rec.INCLUSIVE_TAX_USED_FLAG,
p_event_class_rec.TAX_USE_CUSTOMER_EXEMPT_FLAG,
p_event_class_rec.TAX_USE_PRODUCT_EXEMPT_FLAG,
p_event_class_rec.TAX_USE_LOC_EXC_RATE_FLAG,
p_event_class_rec.TAX_ALLOW_COMPOUND_FLAG,
p_event_class_rec.USE_TAX_CLASSIFICATION_FLAG,
p_event_class_rec.ALLOW_TAX_ROUNDING_OVRD_FLAG,
p_event_class_rec.HOME_COUNTRY_DEFAULT_FLAG
FROM ZX_PRODUCT_OPTIONS_ALL
WHERE application_id = l_application_id
AND org_id = p_event_class_rec.internal_organization_id
AND rownum = 1;
SELECT tax_event_class_code,
reference_application_id,
record_flag, -- Bug 5200373
record_for_partners_flag, -- Bug 5200373
prod_family_grp_code, -- Bug 5200373
event_class_mapping_id,
summarization_flag -- Bug 5200373
INTO x_tx_evnt_cls_code,
x_ref_appln_id,
x_record_flag, -- Bug 5200373
x_record_for_partners_flag, -- Bug 5200373
x_prod_family_grp_code, -- Bug 5200373
x_event_class_mapping_id, -- Bug 5200373
x_summarization_flag
FROM ZX_EVNT_CLS_MAPPINGS
WHERE event_class_code = p_evnt_cls_code
AND application_id = p_appln_id
AND entity_code = p_entity_code;
SELECT 0,
zxevntclsmap.tax_event_class_code,
zxevntclsmap.det_factor_templ_code,
zxevntclsmap.default_rounding_level_code,
zxevntclsmap.rounding_level_hier_1_code,
zxevntclsmap.rounding_level_hier_2_code,
zxevntclsmap.rounding_level_hier_3_code,
zxevntclsmap.rounding_level_hier_4_code,
'N', --allow_manual_lin_recalc_flag
'N', --allow_override_flag,
'N', --allow_manual_lines_flag,
'N', --perf_addnl_appl_for_imprt_flag,
'N', --record_flag
'THIRD_PARTY', --ship_to_party_type
'LEGAL_ESTABLISHMENT', --ship_from_party_type
'THIRD_PARTY', --bill_to_party_type
'LEGAL_ESTABLISHMENT', --bill_from_party_type
'THIRD_PARTY_SITE', --ship_to_pty_site_type
'THIRD_PARTY_SITE', --bill_to_pty_site_type
'N', --enforce_tax_from_acct_flag,
null, --offset_tax_basis_code
'N', --allow_offset_tax_calc_flag
'N', --self_assess_tax_lines_flag
'N', --tax_recovery_flag
'N', --allow_cancel_tax_lines_flag
'N', --allow_man_tax_only_lines_flag
'N', --enable_mrc_flag
'N', --tax_reporting_flag,
'N', --enter_ovrd_incl_tax_lines_flag
'N', --ctrl_eff_ovrd_calc_lines_flag
'N', --summarization_flag
'N', --retain_summ_tax_line_id_flag
'N', --tax_variance_calc_flag
'O2C', --prod_family_grp_code
'N', --record_for_partners_flag
'N', --manual_lines_for_partner_flag
'N', --man_tax_only_lin_for_ptnr_flag
'N', --always_use_ebtax_for_calc_flag
'N', --enforce_tax_from_ref_doc_flag
zxevntclsmap.process_for_applicability_flag,
zxevntclsmap.allow_exemptions_flag, --allow_exemptions_flag
zxevntclsmap.sup_cust_acct_type_code,
'N', --intgrtn_det_factors_ui_flag
'N', --display_tax_classif_flag
zxcls.asc_intrcmp_tx_evnt_cls_code,
zxevntclsmap.intrcmp_tx_evnt_cls_code,
zxevntclsmap.intrcmp_src_appln_id,
zxevntclsmap.intrcmp_src_entity_code,
zxevntclsmap.intrcmp_src_evnt_cls_code
INTO p_event_class_rec.event_class_mapping_id,
p_event_class_rec.tax_event_class_code,
p_event_class_rec.det_factor_templ_code,
p_event_class_rec.default_rounding_level_code,
p_event_class_rec.rounding_level_hier_1_code,
p_event_class_rec.rounding_level_hier_2_code,
p_event_class_rec.rounding_level_hier_3_code,
p_event_class_rec.rounding_level_hier_4_code,
p_event_class_rec.allow_manual_lin_recalc_flag,
p_event_class_rec.allow_override_flag,
p_event_class_rec.allow_manual_lines_flag,
p_event_class_rec.perf_addnl_appl_for_imprt_flag,
p_event_class_rec.record_flag,
source_rec.ship_to_party_type,
source_rec.ship_from_party_type,
source_rec.bill_to_party_type,
source_rec.bill_from_party_type,
source_rec.ship_to_pty_site_type,
source_rec.bill_to_pty_site_type,
p_event_class_rec.enforce_tax_from_acct_flag,
p_event_class_rec.offset_tax_basis_code ,
p_event_class_rec.allow_offset_tax_calc_flag,
p_event_class_rec.self_assess_tax_lines_flag,
p_event_class_rec.tax_recovery_flag,
p_event_class_rec.allow_cancel_tax_lines_flag,
p_event_class_rec.allow_man_tax_only_lines_flag,
p_event_class_rec.enable_mrc_flag,
p_event_class_rec.tax_reporting_flag,
p_event_class_rec.enter_ovrd_incl_tax_lines_flag,
p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag,
p_event_class_rec.summarization_flag,
p_event_class_rec.retain_summ_tax_line_id_flag,
p_event_class_rec.tax_variance_calc_flag,
p_event_class_rec.prod_family_grp_code,
p_event_class_rec.record_for_partners_flag,
p_event_class_rec.manual_lines_for_partner_flag,
p_event_class_rec.man_tax_only_lin_for_ptnr_flag,
p_event_class_rec.always_use_ebtax_for_calc_flag,
p_event_class_rec.enforce_tax_from_ref_doc_flag,
p_event_class_rec.process_for_applicability_flag,
p_event_class_rec.allow_exemptions_flag,
p_event_class_rec.sup_cust_acct_type,
p_event_class_rec.intgrtn_det_factors_ui_flag,
p_event_class_rec.display_tax_classif_flag,
p_event_class_rec.asc_intrcmp_tx_evnt_cls_code,
p_event_class_rec.intrcmp_tx_evnt_cls_code,
p_event_class_rec.intrcmp_src_appln_id,
p_event_class_rec.intrcmp_src_entity_code,
p_event_class_rec.intrcmp_src_evnt_cls_code
FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,
ZX_EVENT_CLASSES_B zxcls
WHERE zxevntclsmap.event_class_code = 'INVOICE'
AND zxevntclsmap.application_id = 222
AND zxevntclsmap.entity_code = 'TRANSACTIONS'
AND zxevntclsmap.tax_event_class_code = zxcls.tax_event_class_code ;
SELECT -1,
zxevntclsmap.tax_event_class_code,
zxevntclsmap.det_factor_templ_code,
zxevntclsmap.default_rounding_level_code,
zxevntclsmap.rounding_level_hier_1_code,
zxevntclsmap.rounding_level_hier_2_code,
zxevntclsmap.rounding_level_hier_3_code,
zxevntclsmap.rounding_level_hier_4_code,
'N', --allow_manual_lin_recalc_flag
'N', --allow_override_flag,
'N', --allow_manual_lines_flag,
'N', --perf_addnl_appl_for_imprt_flag,
'N', --record_flag
'LEGAL_ESTABLISHMENT', --ship_to_party_type
'THIRD_PARTY', --ship_from_party_type
'LEGAL_ESTABLISHMENT', --bill_to_party_type
'THIRD_PARTY', --bill_from_party_type
'THIRD_PARTY_SITE', --ship_from_pty_site_type
'THIRD_PARTY_SITE', --bill_from_pty_site_type
'N', --enforce_tax_from_acct_flag,
null, --offset_tax_basis_code
'N', --allow_offset_tax_calc_flag
'N', --self_assess_tax_lines_flag
DECODE(p_event_class_rec.application_id,'8407','Y','N'), --tax_recovery_flag //Added decode logic for bug 6751638
'N', --allow_cancel_tax_lines_flag
'N', --allow_man_tax_only_lines_flag
'N', --enable_mrc_flag
'N', --tax_reporting_flag,
'N', --enter_ovrd_incl_tax_lines_flag
'N', --ctrl_eff_ovrd_calc_lines_flag
'N', --summarization_flag
'N', --retain_summ_tax_line_id_flag
'N', --tax_variance_calc_flag
'P2P', --prod_family_grp_code
'N', --record_for_partners_flag
'N', --manual_lines_for_partner_flag
'N', --man_tax_only_lin_for_ptnr_flag
'N', --always_use_ebtax_for_calc_flag
'N', --enforce_tax_from_ref_doc_flag
zxevntclsmap.process_for_applicability_flag,
zxevntclsmap.allow_exemptions_flag, --allow_exemptions_flag
zxevntclsmap.sup_cust_acct_type_code,
'N', --intgrtn_det_factors_ui_flag
'N', --display_tax_classif_flag
zxcls.asc_intrcmp_tx_evnt_cls_code,
zxevntclsmap.intrcmp_tx_evnt_cls_code,
zxevntclsmap.intrcmp_src_appln_id,
zxevntclsmap.intrcmp_src_entity_code,
zxevntclsmap.intrcmp_src_evnt_cls_code
INTO p_event_class_rec.event_class_mapping_id,
p_event_class_rec.tax_event_class_code,
p_event_class_rec.det_factor_templ_code,
p_event_class_rec.default_rounding_level_code,
p_event_class_rec.rounding_level_hier_1_code,
p_event_class_rec.rounding_level_hier_2_code,
p_event_class_rec.rounding_level_hier_3_code,
p_event_class_rec.rounding_level_hier_4_code,
p_event_class_rec.allow_manual_lin_recalc_flag,
p_event_class_rec.allow_override_flag,
p_event_class_rec.allow_manual_lines_flag,
p_event_class_rec.perf_addnl_appl_for_imprt_flag,
p_event_class_rec.record_flag,
source_rec.ship_to_party_type,
source_rec.ship_from_party_type,
source_rec.bill_to_party_type,
source_rec.bill_from_party_type,
source_rec.ship_from_pty_site_type,
source_rec.bill_from_pty_site_type,
p_event_class_rec.enforce_tax_from_acct_flag,
p_event_class_rec.offset_tax_basis_code ,
p_event_class_rec.allow_offset_tax_calc_flag,
p_event_class_rec.self_assess_tax_lines_flag,
p_event_class_rec.tax_recovery_flag,
p_event_class_rec.allow_cancel_tax_lines_flag,
p_event_class_rec.allow_man_tax_only_lines_flag,
p_event_class_rec.enable_mrc_flag,
p_event_class_rec.tax_reporting_flag,
p_event_class_rec.enter_ovrd_incl_tax_lines_flag,
p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag,
p_event_class_rec.summarization_flag,
p_event_class_rec.retain_summ_tax_line_id_flag,
p_event_class_rec.tax_variance_calc_flag,
p_event_class_rec.prod_family_grp_code,
p_event_class_rec.record_for_partners_flag,
p_event_class_rec.manual_lines_for_partner_flag,
p_event_class_rec.man_tax_only_lin_for_ptnr_flag,
p_event_class_rec.always_use_ebtax_for_calc_flag,
p_event_class_rec.enforce_tax_from_ref_doc_flag,
p_event_class_rec.process_for_applicability_flag,
p_event_class_rec.allow_exemptions_flag,
p_event_class_rec.sup_cust_acct_type,
p_event_class_rec.intgrtn_det_factors_ui_flag,
p_event_class_rec.display_tax_classif_flag,
p_event_class_rec.asc_intrcmp_tx_evnt_cls_code,
p_event_class_rec.intrcmp_tx_evnt_cls_code,
p_event_class_rec.intrcmp_src_appln_id,
p_event_class_rec.intrcmp_src_entity_code,
p_event_class_rec.intrcmp_src_evnt_cls_code
FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,
ZX_EVENT_CLASSES_B zxcls
WHERE zxevntclsmap.entity_code = 'AP_INVOICES'
AND zxevntclsmap.application_id = 200
AND zxevntclsmap.event_class_code = 'STANDARD INVOICES'
AND zxevntclsmap.tax_event_class_code = zxcls.tax_event_class_code ;
SELECT zxevntclsmap.event_class_mapping_id,
zxevntclsmap.tax_event_class_code,
zxevntclsmap.det_factor_templ_code,
zxevntclsmap.default_rounding_level_code,
zxevntclsmap.rounding_level_hier_1_code,
zxevntclsmap.rounding_level_hier_2_code,
zxevntclsmap.rounding_level_hier_3_code,
zxevntclsmap.rounding_level_hier_4_code,
zxevntclsmap.allow_manual_lin_recalc_flag,
zxevntclsmap.allow_override_flag,
zxevntclsmap.allow_manual_lines_flag,
zxevntclsmap.perf_addnl_appl_for_imprt_flag,
zxcls.normal_sign_flag,
zxevntclsmap.record_flag,
zxevntclsmap.ship_to_party_type,
zxevntclsmap.ship_from_party_type,
zxevntclsmap.poa_party_type,
zxevntclsmap.poo_party_type,
zxevntclsmap.paying_party_type,
zxevntclsmap.own_hq_party_type,
zxevntclsmap.trad_hq_party_type,
zxevntclsmap.poi_party_type,
zxevntclsmap.pod_party_type,
zxevntclsmap.bill_to_party_type,
zxevntclsmap.bill_from_party_type,
zxevntclsmap.ttl_trns_party_type,
zxevntclsmap.ship_to_pty_site_type,
zxevntclsmap.ship_from_pty_site_type,
zxevntclsmap.poa_pty_site_type,
zxevntclsmap.poo_pty_site_type,
zxevntclsmap.paying_pty_site_type,
zxevntclsmap.own_hq_pty_site_type,
zxevntclsmap.trad_hq_pty_site_type,
zxevntclsmap.poi_pty_site_type,
zxevntclsmap.pod_pty_site_type,
zxevntclsmap.bill_to_pty_site_type,
zxevntclsmap.bill_from_pty_site_type,
zxevntclsmap.ttl_trns_pty_site_type,
zxevntclsmap.merchant_party_type,
zxevntclsmap.reference_application_id,
zxevntclsmap.enforce_tax_from_acct_flag,
zxevntclsmap.offset_tax_basis_code ,
zxevntclsmap.allow_offset_tax_calc_flag,
zxevntclsmap.self_assess_tax_lines_flag,
zxevntclsmap.tax_recovery_flag,
zxevntclsmap.allow_cancel_tax_lines_flag,
zxevntclsmap.allow_man_tax_only_lines_flag,
zxevntclsmap.enable_mrc_flag,
zxevntclsmap.tax_reporting_flag,
zxevntclsmap.enter_ovrd_incl_tax_lines_flag,
zxevntclsmap.ctrl_eff_ovrd_calc_lines_flag,
zxevntclsmap.summarization_flag,
zxevntclsmap.retain_summ_tax_line_id_flag,
zxevntclsmap.tax_variance_calc_flag,
zxevntclsmap.prod_family_grp_code,
zxevntclsmap.record_for_partners_flag,
zxevntclsmap.manual_lines_for_partner_flag,
zxevntclsmap.man_tax_only_lin_for_ptnr_flag,
zxevntclsmap.always_use_ebtax_for_calc_flag,
zxevntclsmap.enforce_tax_from_ref_doc_flag,
zxevntclsmap.process_for_applicability_flag,
zxevntclsmap.allow_exemptions_flag,
zxevntclsmap.sup_cust_acct_type_code,
zxevntclsmap.intgrtn_det_factors_ui_flag,
zxevntclsmap.display_tax_classif_flag,
zxcls.asc_intrcmp_tx_evnt_cls_code,
zxevntclsmap.intrcmp_tx_evnt_cls_code,
zxevntclsmap.intrcmp_src_appln_id,
zxevntclsmap.intrcmp_src_entity_code,
zxevntclsmap.intrcmp_src_evnt_cls_code
INTO p_event_class_rec.event_class_mapping_id,
p_event_class_rec.tax_event_class_code,
p_event_class_rec.det_factor_templ_code,
p_event_class_rec.default_rounding_level_code,
p_event_class_rec.rounding_level_hier_1_code,
p_event_class_rec.rounding_level_hier_2_code,
p_event_class_rec.rounding_level_hier_3_code,
p_event_class_rec.rounding_level_hier_4_code,
p_event_class_rec.allow_manual_lin_recalc_flag,
p_event_class_rec.allow_override_flag,
p_event_class_rec.allow_manual_lines_flag,
p_event_class_rec.perf_addnl_appl_for_imprt_flag,
p_event_class_rec.normal_sign_flag,
p_event_class_rec.record_flag,
source_rec.ship_to_party_type,
source_rec.ship_from_party_type,
source_rec.poa_party_type,
source_rec.poo_party_type,
source_rec.paying_party_type,
source_rec.own_hq_party_type,
source_rec.trad_hq_party_type,
source_rec.poi_party_type,
source_rec.pod_party_type,
source_rec.bill_to_party_type,
source_rec.bill_from_party_type,
source_rec.ttl_trns_party_type,
source_rec.ship_to_pty_site_type,
source_rec.ship_from_pty_site_type,
source_rec.poa_pty_site_type,
source_rec.poo_pty_site_type,
source_rec.paying_pty_site_type,
source_rec.own_hq_pty_site_type,
source_rec.trad_hq_pty_site_type,
source_rec.poi_pty_site_type,
source_rec.pod_pty_site_type,
source_rec.bill_to_pty_site_type,
source_rec.bill_from_pty_site_type,
source_rec.ttl_trns_pty_site_type,
source_rec.merchant_party_type,
p_event_class_rec.reference_application_id,
p_event_class_rec.enforce_tax_from_acct_flag,
p_event_class_rec.offset_tax_basis_code ,
p_event_class_rec.allow_offset_tax_calc_flag,
p_event_class_rec.self_assess_tax_lines_flag,
p_event_class_rec.tax_recovery_flag,
p_event_class_rec.allow_cancel_tax_lines_flag,
p_event_class_rec.allow_man_tax_only_lines_flag,
p_event_class_rec.enable_mrc_flag,
p_event_class_rec.tax_reporting_flag,
p_event_class_rec.enter_ovrd_incl_tax_lines_flag,
p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag,
p_event_class_rec.summarization_flag,
p_event_class_rec.retain_summ_tax_line_id_flag,
p_event_class_rec.tax_variance_calc_flag,
p_event_class_rec.prod_family_grp_code,
p_event_class_rec.record_for_partners_flag,
p_event_class_rec.manual_lines_for_partner_flag,
p_event_class_rec.man_tax_only_lin_for_ptnr_flag,
p_event_class_rec.always_use_ebtax_for_calc_flag,
p_event_class_rec.enforce_tax_from_ref_doc_flag,
p_event_class_rec.process_for_applicability_flag,
p_event_class_rec.allow_exemptions_flag,
p_event_class_rec.sup_cust_acct_type,
p_event_class_rec.intgrtn_det_factors_ui_flag,
p_event_class_rec.display_tax_classif_flag,
p_event_class_rec.asc_intrcmp_tx_evnt_cls_code,
p_event_class_rec.intrcmp_tx_evnt_cls_code,
p_event_class_rec.intrcmp_src_appln_id,
p_event_class_rec.intrcmp_src_entity_code,
p_event_class_rec.intrcmp_src_evnt_cls_code
FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,
ZX_EVENT_CLASSES_B zxcls
WHERE zxevntclsmap.event_class_code = p_event_class_rec.event_class_code
AND zxevntclsmap.application_id = p_event_class_rec.application_id
AND zxevntclsmap.entity_code = p_event_class_rec.entity_code
AND zxevntclsmap.tax_event_class_code = zxcls.tax_event_class_code ;
SELECT mapp.event_class_mapping_id,
mapp.tax_event_class_code,
mapp.process_for_applicability_flag
INTO p_event_class_rec.source_event_class_mapping_id,
p_event_class_rec.source_tax_event_class_code,
p_event_class_rec.source_process_for_appl_flag
FROM zx_evnt_cls_mappings mapp,
zx_lines_det_factors det
WHERE mapp.application_id = det.source_application_id
AND mapp.entity_code = det.source_entity_code
AND mapp.event_class_code = det.source_event_class_code
AND det.trx_id = p_event_class_rec.trx_id
AND det.application_id = p_event_class_rec.application_id
AND det.entity_code = p_event_class_rec.entity_code
AND det.event_class_code = p_event_class_rec.event_class_code
AND rownum=1;
SELECT mapp.event_class_mapping_id,
mapp.tax_event_class_code,
mapp.process_for_applicability_flag
INTO p_event_class_rec.source_event_class_mapping_id,
p_event_class_rec.source_tax_event_class_code,
p_event_class_rec.source_process_for_appl_flag
FROM zx_evnt_cls_mappings mapp
WHERE mapp.application_id = zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_APPLICATION_ID(1)
AND mapp.entity_code = zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_ENTITY_CODE(1)
AND mapp.event_class_code = zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_EVENT_CLASS_CODE(1);
ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.delete;
ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl.delete;
ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.delete;
ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash.delete;
SELECT first_pty_org_id ,
related_doc_date,
adjusted_doc_date,
trx_date,
provnl_tax_determination_date
INTO p_event_class_rec.first_pty_org_id,
l_related_doc_date,
l_adjusted_doc_date,
l_trx_date,
l_prov_tax_det_date
FROM ZX_LINES_DET_FACTORS
WHERE application_id = p_event_class_rec.application_id
AND entity_code = p_event_class_rec.entity_code
AND event_class_code = p_event_class_rec.event_class_code
AND trx_id = p_event_class_rec.trx_id
AND rownum = 1;
SELECT first_pty_org_id ,
related_doc_date,
adjusted_doc_date,
trx_date,
provnl_tax_determination_date
INTO p_event_class_rec.first_pty_org_id,
l_related_doc_date,
l_adjusted_doc_date,
l_trx_date,
l_prov_tax_det_date
FROM ZX_LINES_DET_FACTORS
WHERE application_id = p_event_class_rec.application_id
AND entity_code = p_event_class_rec.entity_code
AND event_class_code = p_event_class_rec.event_class_code
AND trx_id = p_event_class_rec.trx_id
AND rownum = 1;
ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.delete;
ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl.delete;
ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.delete;
ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash.delete;
SELECT first_pty_org_id ,
related_doc_date,
adjusted_doc_date,
trx_date,
provnl_tax_determination_date
INTO l_first_pty_org_id,
l_related_doc_date,
l_adjusted_doc_date,
l_trx_date,
l_prov_tax_det_date
FROM ZX_LINES_DET_FACTORS
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 rownum = 1;
SELECT first_pty_org_id ,
related_doc_date,
adjusted_doc_date,
trx_date,
provnl_tax_determination_date
INTO l_first_pty_org_id,
l_related_doc_date,
l_adjusted_doc_date,
l_trx_date,
l_prov_tax_det_date
FROM ZX_LINES_DET_FACTORS
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 rownum = 1;
SELECT /*+ INDEX(ZX_REV_TRX_HEADERS_GT ZX_REV_TRX_HEADERS_GT_U1) INDEX(ZX_REVERSE_TRX_LINES_GT ZX_REVERSE_TRX_LINES_GT_U1) */
hdrgt.legal_entity_id ,
hdrgt.internal_organization_id,
zl.related_doc_date,
zl.adjusted_doc_date,
zl.trx_date,
zl.provnl_tax_determination_date,
hdrgt.reversing_appln_id ,
hdrgt.reversing_entity_code,
hdrgt.reversing_evnt_cls_code,
hdrgt.reversing_trx_id
INTO l_legal_entity_id,
l_ou_id,
l_related_doc_date,
l_adjusted_doc_date,
l_trx_date,
l_prov_tax_det_date,
l_application_id,
l_entity_code,
l_event_class_code,
l_trx_id
FROM ZX_REV_TRX_HEADERS_GT hdrgt,
ZX_REVERSE_TRX_LINES_GT lngt,
ZX_LINES_DET_FACTORS zl
WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
AND hdrgt.reversing_evnt_cls_code = p_event_class_rec.event_class_code
AND hdrgt.reversing_trx_id = p_event_class_rec.trx_id
AND lngt.reversing_trx_id = hdrgt.reversing_trx_id
AND lngt.reversing_appln_id = hdrgt.reversing_appln_id
AND lngt.reversing_entity_code = hdrgt.reversing_entity_code
AND lngt.reversing_evnt_cls_code = hdrgt.reversing_evnt_cls_code
AND zl.application_id = lngt.reversed_appln_id
AND zl.entity_code = lngt.reversed_entity_code
AND zl.event_class_code = lngt.reversed_evnt_cls_code
AND zl.trx_id = lngt.reversed_trx_id
AND zl.trx_line_id = lngt.reversed_trx_line_id
AND zl.trx_level_type = lngt.reversed_trx_level_type
AND rownum = 1; --bug6083282
SELECT /*+ INDEX(ZX_REV_TRX_HEADERS_GT ZX_REV_TRX_HEADERS_GT_U1) INDEX(ZX_REVERSE_TRX_LINES_GT ZX_REVERSE_TRX_LINES_GT_U1) */
hdrgt.legal_entity_id ,
hdrgt .internal_organization_id,
zl.related_doc_date,
zl.adjusted_doc_date,
zl.trx_date,
zl.provnl_tax_determination_date,
hdrgt.reversing_appln_id ,
hdrgt.reversing_entity_code,
hdrgt.reversing_evnt_cls_code,
hdrgt.reversing_trx_id
INTO l_legal_entity_id,
l_ou_id,
l_related_doc_date,
l_adjusted_doc_date,
l_trx_date,
l_prov_tax_det_date,
l_application_id,
l_entity_code,
l_event_class_code,
l_trx_id
FROM ZX_REV_TRX_HEADERS_GT hdrgt,
ZX_REVERSE_TRX_LINES_GT lngt,
ZX_LINES_DET_FACTORS zl
WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
AND hdrgt.reversing_evnt_cls_code = p_event_class_rec.event_class_code
AND hdrgt.reversing_trx_id = p_event_class_rec.trx_id
AND lngt.reversing_trx_id = hdrgt.reversing_trx_id
AND lngt.reversing_appln_id = hdrgt.reversing_appln_id
AND lngt.reversing_entity_code = hdrgt.reversing_entity_code
AND lngt.reversing_evnt_cls_code = hdrgt.reversing_evnt_cls_code
AND zl.application_id = lngt.reversed_appln_id
AND zl.entity_code = lngt.reversed_entity_code
AND zl.event_class_code = lngt.reversed_evnt_cls_code
AND zl.trx_id = lngt.reversed_trx_id
AND zl.trx_line_id = lngt.reversed_trx_line_id
AND zl.trx_level_type = lngt.reversed_trx_level_type;
SELECT record_flag
INTO l_record_flag
FROM ZX_EVNT_CLS_MAPPINGS
WHERE application_id = p_application_id
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code;
PROCEDURE Global_Document_Update
( x_return_status OUT NOCOPY VARCHAR2,
p_event_class_rec OUT NOCOPY ZX_API_PUB.event_class_rec_type,
p_trx_rec IN ZX_API_PUB.transaction_rec_type
)IS
l_api_name CONSTANT VARCHAR2(30):= 'GLOBAL_DOCUMENT_UPDATE';
END global_document_update;
| PROCEDURE Mark_tax_lines_deleted:Validates the input parameters of |
| Mark_tax_lines_deleted published |
| service |
* ======================================================================*/
PROCEDURE mark_tax_lines_deleted
( x_return_status OUT NOCOPY VARCHAR2,
p_transaction_line_rec IN ZX_API_PUB.transaction_line_rec_type
) IS
l_api_name CONSTANT VARCHAR2(30):= 'MARK_TAX_LINES_DELETED';
END mark_tax_lines_deleted;
SELECT reversing_appln_id,
reversing_entity_code,
reversing_evnt_cls_code,
reversing_trx_id
INTO p_event_class_rec.application_id,
p_event_class_rec.entity_code,
p_event_class_rec.event_class_code,
p_event_class_rec.trx_id
FROM ZX_REV_TRX_HEADERS_GT
WHERE rownum = 1;
SELECT reversing_appln_id,
reversing_entity_code,
reversing_evnt_cls_code,
reversing_trx_id
INTO l_appln_id,
l_entity_code,
l_evnt_cls_code,
l_trx_id
FROM ZX_REVERSE_DIST_GT
WHERE rownum = 1;
SELECT RELATED_DOC_DATE ,
TRX_DATE ,
PROVNL_TAX_DETERMINATION_DATE
INTO p_event_class_rec.REL_DOC_DATE,
p_event_class_rec.TRX_DATE ,
p_event_class_rec.PROVNL_TAX_DETERMINATION_DATE
FROM ZX_LINES_DET_FACTORS
WHERE APPLICATION_ID = p_trx_rec.APPLICATION_ID
AND EVENT_CLASS_CODE = p_trx_rec.EVENT_CLASS_CODE
AND ENTITY_CODE = p_trx_rec.ENTITY_CODE
AND TRX_ID = p_trx_rec.TRX_ID
AND ROWNUM = 1;
IF ZX_API_PUB.G_PUB_SRVC <> 'UPDATE_DET_FACTORS_HDR' THEN
get_loc_id_and_ptp_ids(p_event_class_rec => p_event_class_rec,
p_trx_line_index => p_trx_line_index,
x_return_status => l_return_status
);
IF ZX_API_PUB.G_PUB_SRVC <> 'COPY_INSERT_LINE_DET_FACTORS' THEN
ZX_CHECK_REQUIRED_PARAMS_PKG.check_trx_headers_tbl(l_return_status,
p_event_class_rec
);
END IF; --G_PUB_SRVC <> 'COPY_INSERT_LINE_DET_FACTORS'
END IF; --G_PUB_SRVC <> 'UPDATE_DET_FACTORS_HDR
SELECT
EVENT_CLASS_CODE
,APPLICATION_ID
,ENTITY_CODE
,TAX_EVENT_CLASS_CODE
,RECORD_FLAG
,DET_FACTOR_TEMPL_CODE
,DEFAULT_ROUNDING_LEVEL_CODE
,ROUNDING_LEVEL_HIER_1_CODE
,ROUNDING_LEVEL_HIER_2_CODE
,ROUNDING_LEVEL_HIER_3_CODE
,ROUNDING_LEVEL_HIER_4_CODE
,ALLOW_MANUAL_LIN_RECALC_FLAG
,ALLOW_OVERRIDE_FLAG
,ALLOW_MANUAL_LINES_FLAG
,PERF_ADDNL_APPL_FOR_IMPRT_FLAG
,SHIP_TO_PARTY_TYPE
,SHIP_FROM_PARTY_TYPE
,POA_PARTY_TYPE
,POO_PARTY_TYPE
,PAYING_PARTY_TYPE
,OWN_HQ_PARTY_TYPE
,TRAD_HQ_PARTY_TYPE
,POI_PARTY_TYPE
,POD_PARTY_TYPE
,BILL_TO_PARTY_TYPE
,BILL_FROM_PARTY_TYPE
,TTL_TRNS_PARTY_TYPE
,MERCHANT_PARTY_TYPE
,SHIP_TO_PTY_SITE_TYPE
,SHIP_FROM_PTY_SITE_TYPE
,POA_PTY_SITE_TYPE
,POO_PTY_SITE_TYPE
,PAYING_PTY_SITE_TYPE
,OWN_HQ_PTY_SITE_TYPE
,TRAD_HQ_PTY_SITE_TYPE
,POI_PTY_SITE_TYPE
,POD_PTY_SITE_TYPE
,BILL_TO_PTY_SITE_TYPE
,BILL_FROM_PTY_SITE_TYPE
,TTL_TRNS_PTY_SITE_TYPE
,ENFORCE_TAX_FROM_ACCT_FLAG
,OFFSET_TAX_BASIS_CODE
,REFERENCE_APPLICATION_ID
,PROD_FAMILY_GRP_CODE
,ALLOW_OFFSET_TAX_CALC_FLAG
,SELF_ASSESS_TAX_LINES_FLAG
,TAX_RECOVERY_FLAG
,ALLOW_CANCEL_TAX_LINES_FLAG
,ALLOW_MAN_TAX_ONLY_LINES_FLAG
,TAX_VARIANCE_CALC_FLAG
,TAX_REPORTING_FLAG
,ENTER_OVRD_INCL_TAX_LINES_FLAG
,CTRL_EFF_OVRD_CALC_LINES_FLAG
,SUMMARIZATION_FLAG
,RETAIN_SUMM_TAX_LINE_ID_FLAG
,RECORD_FOR_PARTNERS_FLAG
,MANUAL_LINES_FOR_PARTNER_FLAG
,MAN_TAX_ONLY_LIN_FOR_PTNR_FLAG
,ALWAYS_USE_EBTAX_FOR_CALC_FLAG
,PROCESSING_PRECEDENCE
,EVENT_CLASS_MAPPING_ID
,ENFORCE_TAX_FROM_REF_DOC_FLAG
,PROCESS_FOR_APPLICABILITY_FLAG
,SUP_CUST_ACCT_TYPE_CODE
,DISPLAY_TAX_CLASSIF_FLAG
,INTGRTN_DET_FACTORS_UI_FLAG
,INTRCMP_TX_EVNT_CLS_CODE
,INTRCMP_SRC_ENTITY_CODE
,INTRCMP_SRC_EVNT_CLS_CODE
,INTRCMP_SRC_APPLN_ID
,ALLOW_EXEMPTIONS_FLAG
,ENABLE_MRC_FLAG
from
ZX_EVNT_CLS_MAPPINGS
WHERE
application_id = p_application_id
AND entity_code = p_entity_code
AND event_class_Code = p_event_class_code;
SELECT
EVENT_CLASS_MAPPING_ID,
EVENT_TYPE_MAPPING_ID,
EVENT_CLASS_CODE,
EVENT_TYPE_CODE,
APPLICATION_ID,
ENTITY_CODE,
TAX_EVENT_CLASS_CODE,
TAX_EVENT_TYPE_CODE,
ENABLED_FLAG
from
ZX_EVNT_TYP_MAPPINGS
WHERE
application_id = P_APPLICATION_ID
AND entity_code = P_ENTITY_CODE
AND event_class_code = P_EVENT_CLASS_CODE
AND event_type_code = P_EVENT_TYPE_CODE ;
select TAX_EVENT_CLASS_CODE,
TAX_EVENT_TYPE_CODE,
STATUS_CODE
from zx_evnt_cls_typs;
select TAX_EVENT_CLASS_CODE,
NORMAL_SIGN_FLAG,
ASC_INTRCMP_TX_EVNT_CLS_CODE
from zx_event_classes_b;