PACKAGE: APPS.ZX_AR_FORMULA_MIG_PKG

Source

1 PACKAGE ZX_AR_FORMULA_MIG_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxarformulamigs.pls 120.3 2005/10/30 01:52:39 appldev ship $ */
3 
4 PROCEDURE FORMULA_MIGRATION_MAIN(x_return_status     OUT NOCOPY  VARCHAR2) ;
5 
6 PROCEDURE CREATE_FORMULA
7 		(--for zx_formula_b
8 		p_taxable_basis		IN	ar_vat_tax_all.taxable_basis%TYPE,
9 		p_formula_code		IN	zx_formula_b.formula_code%TYPE,	-- tax_group_code||'_'||tax_code||'_TB'
10 		p_child_regime_code	IN	zx_tax_relations_t.child_regime_code %TYPE,
11 		p_child_tax_code	IN	zx_tax_relations_t.child_tax_code %TYPE,
12 		p_enabled_flag		IN	ar_vat_tax_all.enabled_flag%TYPE,
13 		p_discount_flag		IN	CHAR,
14 		p_charge_flag		IN	CHAR,
15 		-- for zx_formula_details
16 		p_parent_regime_code	IN	zx_tax_relations_t.parent_regime_code %TYPE,
17 		p_parent_tax_code	IN	zx_tax_relations_t.parent_tax_code %TYPE,
18 		p_group_id		IN	zx_tax_relations_t.tax_group_id%TYPE, --(used in where condition)
19 		p_content_owner_id	IN	zx_rates_b.content_owner_id%TYPE,
20 		p_start_date		IN	ar_vat_tax_all.start_date%TYPE,
21 		p_end_date		IN	ar_vat_tax_all.end_date%TYPE,
22 		p_tax_regime_code	IN	zx_rates_b.tax_regime_code %TYPE,
23 		p_tax_code		IN	zx_rates_b.tax %TYPE,
24 		x_return_status 	OUT NOCOPY VARCHAR2);
25 
26 PROCEDURE CREATE_RULES
27 		(--parameters rqrd  for zx_rules_b
28 			p_tax			IN	zx_rates_b.tax%TYPE	,
29 			p_tax_regime_code	IN	zx_rates_b.tax_regime_code%TYPE	,
30 			p_effective_from	IN	ar_vat_tax_all.start_date%TYPE	,
31 			p_effective_to		IN	ar_vat_tax_all.end_date%TYPE	,
32 			p_enabled_flag		IN	ar_tax_group_codes.enabled_flag%TYPE	,
33 			p_content_owner_id	IN	zx_rates_b.content_owner_id%TYPE,		 -- for zx_process_results
34 			p_condition_grp_cd 	IN	fnd_lookups.lookup_code%TYPE	,
35 			p_alphanumeric_result	IN	zx_process_results.alphanumeric_result%TYPE,
36 			p_condition_group_id	IN	zx_condition_groups_b.condition_group_id%TYPE,
37 			p_tax_condition_id	IN	ar_tax_group_codes_all.tax_condition_id%TYPE,
38 			p_tax_exception_id	IN	ar_tax_group_codes_all.tax_exception_id%TYPE,
39 			x_return_status 	OUT NOCOPY VARCHAR2 );
40 
41 END ZX_AR_FORMULA_MIG_PKG;
42