[Home] [Help]
PACKAGE: APPS.ZX_TCM_CONTROL_PKG
Source
1 PACKAGE ZX_TCM_CONTROL_PKG AS
2 /* $Header: zxccontrols.pls 120.30 2006/08/11 17:37:05 nipatel ship $ */
3
4 TYPE zx_fiscal_class_info_rec IS RECORD(
5 classification_category zx_fc_types_b.Classification_Type_Categ_Code%type,
6 classification_type zx_fc_types_b.classification_type_code%type,
7 condition_value zx_conditions.alphanumeric_value%type,
8 event_class_code zx_lines_det_factors.trx_business_category%TYPE, -- event_class_code here used as trx_business_category, hence hold the same type
9 tax_determine_date date,
10 tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
11 classified_entity_id number,
12 application_id number,
13 item_org_id number,
14 effective_from date,
15 effective_to date,
16 fsc_code zx_conditions.alphanumeric_value%type);
17
18 TYPE zx_fsc_class_info_cache IS TABLE OF zx_fiscal_class_info_rec
19 INDEX BY BINARY_INTEGER;
20
21 TYPE zx_category_code_info_rec IS RECORD(
22 classification_category zx_fc_types_b.Classification_Type_Categ_Code%type,
23 classification_type zx_fc_types_b.classification_type_code%type,
24 parameter_value zx_conditions.alphanumeric_value%type,
25 condition_subclass fnd_lookups.lookup_code%type,
26 condition_value zx_conditions.alphanumeric_value%type,
27 tax_determine_date date,
28 effective_from date,
29 effective_to date);
30
31 TYPE zx_registration_info_rec IS RECORD(
32 -- The dummy flag has been added to avoid hitting the database again for the same combination
33 -- of PARTY_TAX_PROFILE_ID, TAX_REGIME_CODE, TAX, JURISDICTION_CODE if a value is not found in the
34 -- cache. This is important because we always try to search for true registrations first,
35 -- but during migration,we do not have information to create true registrations. Hence during
36 -- calculationwe do not find any registration record in the database and cache and we keep on
37 -- searching the databse for a registration record for every tax line only to find that a
38 -- record does not exist in the database.
39 dummy_flag VARCHAR2(1),
40 registration_id zx_registrations.registration_id%type,
41 registration_type_code zx_registrations.registration_type_code%type,
42 registration_number zx_registrations.registration_number%type,
43 validation_rule zx_registrations.validation_rule%type,
44 tax_authority_id zx_registrations.tax_authority_id%type,
45 rep_tax_authority_id zx_registrations.rep_tax_authority_id%type,
46 coll_Tax_authority_id zx_registrations.coll_tax_authority_id%type,
47 rounding_rule_code zx_registrations.rounding_rule_code%type,
48 tax_jurisdiction_code zx_registrations.tax_jurisdiction_code%type,
49 self_assess_flag zx_registrations.self_assess_flag%type,
50 registration_status_code zx_registrations.registration_status_code%type,
51 registration_source_code zx_registrations.registration_source_code%type,
52 registration_reason_code zx_registrations.registration_reason_code%type,
53 party_tax_profile_id zx_registrations.party_tax_profile_id%type,
54 tax zx_registrations.tax%type,
55 tax_regime_code zx_registrations.tax_regime_code%type,
56 inclusive_tax_flag zx_registrations.inclusive_tax_flag%type,
57 -- has_tax_exemptions_flag zx_registrations.has_tax_exemptions_flag%type,
58 effective_from date,
59 effective_to date,
60 rep_party_tax_name zx_registrations.rep_party_tax_name%type,
61 legal_registration_id zx_registrations.legal_registration_id%type,
62 default_registration_flag zx_registrations.default_registration_flag%type,
63 bank_id zx_registrations.bank_id%type,
64 bank_branch_id zx_registrations.bank_branch_id%type,
65 bank_account_num zx_registrations.bank_account_num%type,
66 legal_location_id zx_registrations.legal_location_id%type,
67 record_type_code zx_registrations.record_type_code%type,
68 request_id zx_registrations.request_id%type,
69 program_application_id zx_registrations.program_application_id%type,
70 program_id zx_registrations.program_id%type,
71 program_login_id zx_registrations.program_login_id%type,
72 account_id zx_registrations.account_id%type,
73 ACCOUNT_SITE_ID zx_registrations.ACCOUNT_SITE_ID%type,
74 -- site_use_id HZ_CUST_SITE_USES_ALL.site_use_id%type,
75 geo_type_classification_code HZ_CUST_SITE_USES_ALL.tax_classification%TYPE,
76 tax_classification_code zx_registrations.tax_classification_code%type,
77 attribute1 zx_registrations.attribute1%type,
78 attribute2 zx_registrations.attribute2%type,
79 attribute3 zx_registrations.attribute3%type,
80 attribute4 zx_registrations.attribute4%type,
81 attribute5 zx_registrations.attribute5%type,
82 attribute6 zx_registrations.attribute6%type,
83 attribute7 zx_registrations.attribute7%type,
84 attribute8 zx_registrations.attribute8%type,
85 attribute9 zx_registrations.attribute9%type,
86 attribute10 zx_registrations.attribute10%type,
87 attribute11 zx_registrations.attribute11%type,
88 attribute12 zx_registrations.attribute12%type,
89 attribute13 zx_registrations.attribute13%type,
90 attribute14 zx_registrations.attribute14%type,
91 attribute15 zx_registrations.attribute15%type,
92 attribute_category zx_registrations.attribute_category%type,
93 party_type_code zx_party_tax_profile.party_type_code%type,
94 supplier_flag zx_party_tax_profile.supplier_flag%type,
95 customer_flag zx_party_tax_profile.customer_flag%type,
96 site_flag zx_party_tax_profile.site_flag%type,
97 process_for_applicability_flag zx_party_tax_profile.process_for_applicability_flag%type,
98 rounding_level_code zx_party_tax_profile.rounding_level_code%type,
99 withholding_start_date zx_party_tax_profile.withholding_start_date%type,
100 allow_awt_flag zx_party_tax_profile.allow_awt_flag%type,
101 use_le_as_subscriber_flag zx_party_tax_profile.use_le_as_subscriber_flag%type,
102 legal_establishment_flag zx_party_tax_profile.legal_establishment_flag%type,
103 first_party_le_flag zx_party_tax_profile.first_party_le_flag%type,
104 reporting_authority_flag zx_party_tax_profile.reporting_authority_flag%type,
105 collecting_authority_flag zx_party_tax_profile.collecting_authority_flag%type,
106 provider_type_code zx_party_tax_profile.provider_type_code%type,
107 create_awt_dists_type_code zx_party_tax_profile.create_awt_dists_type_code%type,
108 create_awt_invoices_type_code zx_party_tax_profile.create_awt_invoices_type_code%type,
109 allow_offset_tax_flag zx_party_tax_profile.allow_offset_tax_flag%type,
110 effective_from_use_le zx_party_tax_profile.effective_from_use_le%type,
111 party_id zx_party_tax_profile.party_id%type,
112 rep_registration_number zx_party_tax_profile.rep_registration_number%type);
113
114 PROCEDURE GET_FISCAL_CLASSIFICATION(
115 p_fsc_rec IN OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_FISCAL_CLASS_INFO_REC,
116 p_return_status OUT NOCOPY VARCHAR2);
117
118 PROCEDURE GET_PROD_TRX_CATE_VALUE (
119 p_fsc_cat_rec IN OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_CATEGORY_CODE_INFO_REC,
120 p_return_status OUT NOCOPY VARCHAR2);
121
122 PROCEDURE GET_TAX_REGISTRATION(
123 p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
124 p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
125 p_account_type_code IN zx_registrations.account_type_code%TYPE,
126 p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
127 p_tax IN ZX_TAXES_B.TAX%TYPE,
128 p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
129 p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
130 p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
131 p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
132 p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
133 p_zx_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
134 p_ret_record_level OUT NOCOPY VARCHAR2,
135 p_return_status OUT NOCOPY VARCHAR2);
136
137 PROCEDURE INITIALIZE_LTE (p_return_status OUT NOCOPY VARCHAR2);
138
139 END ZX_TCM_CONTROL_PKG;