4: PROCEDURE FORMULA_MIGRATION_MAIN
5: (x_return_status OUT NOCOPY VARCHAR2) IS
6: i number;
7:
8: l_child_taxable_basis ar_vat_tax_all.taxable_basis%TYPE;
9: l_tax_code ar_vat_tax_all.tax_code%TYPE;
10: l_enabled_flag ar_vat_tax_all.enabled_flag%TYPE;
11: l_start_date ar_vat_tax_all.start_date%TYPE;
12: l_end_date ar_vat_tax_all.end_date%TYPE;
5: (x_return_status OUT NOCOPY VARCHAR2) IS
6: i number;
7:
8: l_child_taxable_basis ar_vat_tax_all.taxable_basis%TYPE;
9: l_tax_code ar_vat_tax_all.tax_code%TYPE;
10: l_enabled_flag ar_vat_tax_all.enabled_flag%TYPE;
11: l_start_date ar_vat_tax_all.start_date%TYPE;
12: l_end_date ar_vat_tax_all.end_date%TYPE;
13: l_tax_constraint_id ar_vat_tax_all.tax_constraint_id%TYPE;
6: i number;
7:
8: l_child_taxable_basis ar_vat_tax_all.taxable_basis%TYPE;
9: l_tax_code ar_vat_tax_all.tax_code%TYPE;
10: l_enabled_flag ar_vat_tax_all.enabled_flag%TYPE;
11: l_start_date ar_vat_tax_all.start_date%TYPE;
12: l_end_date ar_vat_tax_all.end_date%TYPE;
13: l_tax_constraint_id ar_vat_tax_all.tax_constraint_id%TYPE;
14:
7:
8: l_child_taxable_basis ar_vat_tax_all.taxable_basis%TYPE;
9: l_tax_code ar_vat_tax_all.tax_code%TYPE;
10: l_enabled_flag ar_vat_tax_all.enabled_flag%TYPE;
11: l_start_date ar_vat_tax_all.start_date%TYPE;
12: l_end_date ar_vat_tax_all.end_date%TYPE;
13: l_tax_constraint_id ar_vat_tax_all.tax_constraint_id%TYPE;
14:
15: l_tax zx_rates_b.tax%TYPE;
8: l_child_taxable_basis ar_vat_tax_all.taxable_basis%TYPE;
9: l_tax_code ar_vat_tax_all.tax_code%TYPE;
10: l_enabled_flag ar_vat_tax_all.enabled_flag%TYPE;
11: l_start_date ar_vat_tax_all.start_date%TYPE;
12: l_end_date ar_vat_tax_all.end_date%TYPE;
13: l_tax_constraint_id ar_vat_tax_all.tax_constraint_id%TYPE;
14:
15: l_tax zx_rates_b.tax%TYPE;
16: l_tax_regime_code zx_rates_b.tax_regime_code%TYPE;
9: l_tax_code ar_vat_tax_all.tax_code%TYPE;
10: l_enabled_flag ar_vat_tax_all.enabled_flag%TYPE;
11: l_start_date ar_vat_tax_all.start_date%TYPE;
12: l_end_date ar_vat_tax_all.end_date%TYPE;
13: l_tax_constraint_id ar_vat_tax_all.tax_constraint_id%TYPE;
14:
15: l_tax zx_rates_b.tax%TYPE;
16: l_tax_regime_code zx_rates_b.tax_regime_code%TYPE;
17:
59: vat.end_date,
60: rate.tax,
61: rate.tax_regime_code,
62: rate.content_owner_id
63: FROM ar_vat_tax_all vat, zx_rates_b rate
64: WHERE vat.taxable_basis IN ('AFTER_EPD', 'QUANTITY')
65: AND vat.tax_class = 'O'
66: AND vat.global_attribute_category is null
67: AND vat.tax_type <> 'TAX_GROUP'
385: arp_util_tax.debug('case 3:bef select');
386:
387: SELECT vat.tax_constraint_id
388: INTO l_tax_constraint_id
389: FROM ar_vat_tax_all vat
390: WHERE vat.vat_tax_id = l_tax_group_id;
391:
392: SELECT condition_group_id, condition_group_code
393: INTO l_condition_grp_id, l_condition_grp_cd
512: arp_util_tax.debug('case 4:before select of cond grp');
513:
514: SELECT vat.tax_constraint_id
515: INTO l_tax_constraint_id
516: FROM ar_vat_tax_all vat
517: WHERE vat.vat_tax_id = l_tax_group_id;
518:
519: SELECT condition_group_id, condition_group_code
520: INTO l_condition_grp_id, l_condition_grp_cd
732:
733:
734: PROCEDURE CREATE_FORMULA
735: (--for zx_formula_b
736: p_taxable_basis IN ar_vat_tax_all.taxable_basis%TYPE,
737: p_formula_code IN zx_formula_b.formula_code%TYPE,
738: p_child_regime_code IN zx_tax_relations_t.child_regime_code %TYPE,
739: p_child_tax_code IN zx_tax_relations_t.child_tax_code %TYPE,
740: p_enabled_flag IN ar_vat_tax_all.enabled_flag%TYPE,
736: p_taxable_basis IN ar_vat_tax_all.taxable_basis%TYPE,
737: p_formula_code IN zx_formula_b.formula_code%TYPE,
738: p_child_regime_code IN zx_tax_relations_t.child_regime_code %TYPE,
739: p_child_tax_code IN zx_tax_relations_t.child_tax_code %TYPE,
740: p_enabled_flag IN ar_vat_tax_all.enabled_flag%TYPE,
741: p_discount_flag IN CHAR,
742: p_charge_flag IN CHAR,
743: -- for zx_formula_details
744: p_parent_regime_code IN zx_tax_relations_t.parent_regime_code %TYPE,
744: p_parent_regime_code IN zx_tax_relations_t.parent_regime_code %TYPE,
745: p_parent_tax_code IN zx_tax_relations_t.parent_tax_code %TYPE,
746: p_group_id IN zx_tax_relations_t.tax_group_id%TYPE, --(used in where condition)
747: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE,
748: p_start_date IN ar_vat_tax_all.start_date%TYPE,
749: p_end_date IN ar_vat_tax_all.end_date%TYPE,
750: p_tax_regime_code IN zx_rates_b.tax_regime_code %TYPE,
751: p_tax_code IN zx_rates_b.tax %TYPE,
752: x_return_status OUT NOCOPY VARCHAR2) IS
745: p_parent_tax_code IN zx_tax_relations_t.parent_tax_code %TYPE,
746: p_group_id IN zx_tax_relations_t.tax_group_id%TYPE, --(used in where condition)
747: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE,
748: p_start_date IN ar_vat_tax_all.start_date%TYPE,
749: p_end_date IN ar_vat_tax_all.end_date%TYPE,
750: p_tax_regime_code IN zx_rates_b.tax_regime_code %TYPE,
751: p_tax_code IN zx_rates_b.tax %TYPE,
752: x_return_status OUT NOCOPY VARCHAR2) IS
753:
1039: PROCEDURE CREATE_RULES
1040: ( --parameters rqrd for zx_rules_b
1041: p_tax IN zx_rates_b.tax%TYPE,
1042: p_tax_regime_code IN zx_rates_b.tax_regime_code%TYPE,
1043: p_effective_from IN ar_vat_tax_all.start_date%TYPE,
1044: p_effective_to IN ar_vat_tax_all.end_date%TYPE,
1045: p_enabled_flag IN ar_tax_group_codes.enabled_flag%TYPE,
1046: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE, -- for zx_process_results
1047: p_condition_grp_cd IN fnd_lookups.lookup_code%TYPE,
1040: ( --parameters rqrd for zx_rules_b
1041: p_tax IN zx_rates_b.tax%TYPE,
1042: p_tax_regime_code IN zx_rates_b.tax_regime_code%TYPE,
1043: p_effective_from IN ar_vat_tax_all.start_date%TYPE,
1044: p_effective_to IN ar_vat_tax_all.end_date%TYPE,
1045: p_enabled_flag IN ar_tax_group_codes.enabled_flag%TYPE,
1046: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE, -- for zx_process_results
1047: p_condition_grp_cd IN fnd_lookups.lookup_code%TYPE,
1048: p_alphanumeric_result IN zx_process_results.alphanumeric_result%TYPE,