[Home] [Help]
PACKAGE: APPS.JL_ZZ_AR_TX_CATEG_PKG
Source
1 PACKAGE JL_ZZ_AR_TX_CATEG_PKG AS
2 /* $Header: jlzztcts.pls 120.3 2003/09/02 21:58:46 opedrega ship $ */
3
4 PROCEDURE Insert_Row
5 (X_rowid IN OUT NOCOPY VARCHAR2,
6 X_tax_category_id NUMBER,
7 X_tax_category VARCHAR2,
8 X_end_date_active DATE,
9 X_last_updated_by NUMBER,
10 X_last_update_date DATE,
11 X_created_by NUMBER,
12 X_creation_date DATE,
13 X_last_update_login NUMBER,
14 X_threshold_check_level VARCHAR2,
15 X_threshold_check_grp_by VARCHAR2,
16 --X_description VARCHAR2 DEFAULT NULL,
17 X_min_amount NUMBER DEFAULT NULL,
18 X_min_taxable_basis NUMBER DEFAULT NULL,
19 X_min_percentage NUMBER DEFAULT NULL,
20 X_tax_inclusive VARCHAR2 DEFAULT NULL,
21 X_org_tax_attribute VARCHAR2 DEFAULT NULL,
22 X_cus_tax_attribute VARCHAR2 DEFAULT NULL,
23 X_txn_tax_attribute VARCHAR2 DEFAULT NULL,
24 X_tributary_substitution VARCHAR2 DEFAULT NULL,
25 X_used_to_reduce VARCHAR2 DEFAULT NULL,
26 X_tax_categ_to_reduce_id NUMBER DEFAULT NULL,
27 X_tax_code VARCHAR2 DEFAULT NULL,
28 X_tax_authority_code VARCHAR2 DEFAULT NULL,
29 X_mandatory_in_class VARCHAR2 DEFAULT NULL,
30 X_print_flag VARCHAR2 DEFAULT NULL,
31 X_tax_rule_set VARCHAR2 DEFAULT NULL,
32 X_start_date_active DATE DEFAULT NULL,
33 X_tax_regime VARCHAR2 DEFAULT NULL,
34 X_org_id NUMBER DEFAULT NULL,
35 X_attribute_category VARCHAR2 DEFAULT NULL,
36 X_attribute1 VARCHAR2 DEFAULT NULL,
37 X_attribute2 VARCHAR2 DEFAULT NULL,
38 X_attribute3 VARCHAR2 DEFAULT NULL,
39 X_attribute4 VARCHAR2 DEFAULT NULL,
40 X_attribute5 VARCHAR2 DEFAULT NULL,
41 X_attribute6 VARCHAR2 DEFAULT NULL,
42 X_attribute7 VARCHAR2 DEFAULT NULL,
43 X_attribute8 VARCHAR2 DEFAULT NULL,
44 X_attribute9 VARCHAR2 DEFAULT NULL,
45 X_attribute10 VARCHAR2 DEFAULT NULL,
46 X_attribute11 VARCHAR2 DEFAULT NULL,
47 X_attribute12 VARCHAR2 DEFAULT NULL,
48 X_attribute13 VARCHAR2 DEFAULT NULL,
49 X_attribute14 VARCHAR2 DEFAULT NULL,
50 X_attribute15 VARCHAR2 DEFAULT NULL,
51 X_calling_sequence IN VARCHAR2);
52
53 PROCEDURE Lock_Row
54 (X_rowid VARCHAR2,
55 X_tax_category_id NUMBER,
56 X_tax_category VARCHAR2,
57 X_end_date_active DATE,
58 X_last_updated_by NUMBER,
59 X_last_update_date DATE,
60 X_created_by NUMBER,
61 X_creation_date DATE,
62 X_last_update_login NUMBER,
63 X_threshold_check_level VARCHAR2,
64 X_threshold_check_grp_by VARCHAR2,
65 --X_description VARCHAR2 DEFAULT NULL,
66 X_min_amount NUMBER DEFAULT NULL,
67 X_min_taxable_basis NUMBER DEFAULT NULL,
68 X_min_percentage NUMBER DEFAULT NULL,
69 X_tax_inclusive VARCHAR2 DEFAULT NULL,
70 X_org_tax_attribute VARCHAR2 DEFAULT NULL,
71 X_cus_tax_attribute VARCHAR2 DEFAULT NULL,
72 X_txn_tax_attribute VARCHAR2 DEFAULT NULL,
73 X_tributary_substitution VARCHAR2 DEFAULT NULL,
74 X_used_to_reduce VARCHAR2 DEFAULT NULL,
75 X_tax_categ_to_reduce_id NUMBER DEFAULT NULL,
76 X_tax_code VARCHAR2 DEFAULT NULL,
77 X_tax_authority_code VARCHAR2 DEFAULT NULL,
78 X_mandatory_in_class VARCHAR2 DEFAULT NULL,
79 X_print_flag VARCHAR2 DEFAULT NULL,
80 X_tax_rule_set VARCHAR2 DEFAULT NULL,
81 X_start_date_active DATE DEFAULT NULL,
82 X_tax_regime VARCHAR2 DEFAULT NULL,
83 X_org_id IN NUMBER DEFAULT NULL,
84 X_attribute_category VARCHAR2 DEFAULT NULL,
85 X_attribute1 VARCHAR2 DEFAULT NULL,
86 X_attribute2 VARCHAR2 DEFAULT NULL,
87 X_attribute3 VARCHAR2 DEFAULT NULL,
88 X_attribute4 VARCHAR2 DEFAULT NULL,
89 X_attribute5 VARCHAR2 DEFAULT NULL,
90 X_attribute6 VARCHAR2 DEFAULT NULL,
91 X_attribute7 VARCHAR2 DEFAULT NULL,
92 X_attribute8 VARCHAR2 DEFAULT NULL,
93 X_attribute9 VARCHAR2 DEFAULT NULL,
94 X_attribute10 VARCHAR2 DEFAULT NULL,
95 X_attribute11 VARCHAR2 DEFAULT NULL,
96 X_attribute12 VARCHAR2 DEFAULT NULL,
97 X_attribute13 VARCHAR2 DEFAULT NULL,
98 X_attribute14 VARCHAR2 DEFAULT NULL,
99 X_attribute15 VARCHAR2 DEFAULT NULL,
100 X_calling_sequence IN VARCHAR2);
101
102
103 PROCEDURE UpDate_Row
104 (X_rowid VARCHAR2,
105 X_tax_category_id NUMBER,
106 X_tax_category VARCHAR2,
107 X_end_date_active DATE,
108 X_last_updated_by NUMBER,
109 X_last_update_date DATE,
110 X_created_by NUMBER,
111 X_creation_date DATE,
112 X_last_update_login NUMBER,
113 X_threshold_check_level VARCHAR2,
114 X_threshold_check_grp_by VARCHAR2,
115 --X_description VARCHAR2 DEFAULT NULL,
116 X_min_amount NUMBER DEFAULT NULL,
117 X_min_taxable_basis NUMBER DEFAULT NULL,
118 X_min_percentage NUMBER DEFAULT NULL,
119 X_tax_inclusive VARCHAR2 DEFAULT NULL,
120 X_org_tax_attribute VARCHAR2 DEFAULT NULL,
121 X_cus_tax_attribute VARCHAR2 DEFAULT NULL,
122 X_txn_tax_attribute VARCHAR2 DEFAULT NULL,
123 X_tributary_substitution VARCHAR2 DEFAULT NULL,
124 X_used_to_reduce VARCHAR2 DEFAULT NULL,
125 X_tax_categ_to_reduce_id NUMBER DEFAULT NULL,
126 X_tax_code VARCHAR2 DEFAULT NULL,
127 X_tax_authority_code VARCHAR2 DEFAULT NULL,
128 X_mandatory_in_class VARCHAR2 DEFAULT NULL,
129 X_print_flag VARCHAR2 DEFAULT NULL,
130 X_tax_rule_set VARCHAR2 DEFAULT NULL,
131 X_start_date_active DATE DEFAULT NULL,
132 X_tax_regime VARCHAR2 DEFAULT NULL,
133 X_org_id IN NUMBER DEFAULT NULL,
134 X_attribute_category VARCHAR2 DEFAULT NULL,
135 X_attribute1 VARCHAR2 DEFAULT NULL,
136 X_attribute2 VARCHAR2 DEFAULT NULL,
137 X_attribute3 VARCHAR2 DEFAULT NULL,
138 X_attribute4 VARCHAR2 DEFAULT NULL,
139 X_attribute5 VARCHAR2 DEFAULT NULL,
140 X_attribute6 VARCHAR2 DEFAULT NULL,
141 X_attribute7 VARCHAR2 DEFAULT NULL,
142 X_attribute8 VARCHAR2 DEFAULT NULL,
143 X_attribute9 VARCHAR2 DEFAULT NULL,
144 X_attribute10 VARCHAR2 DEFAULT NULL,
145 X_attribute11 VARCHAR2 DEFAULT NULL,
146 X_attribute12 VARCHAR2 DEFAULT NULL,
147 X_attribute13 VARCHAR2 DEFAULT NULL,
148 X_attribute14 VARCHAR2 DEFAULT NULL,
149 X_attribute15 VARCHAR2 DEFAULT NULL,
150 X_calling_sequence IN VARCHAR2) ;
151
152
153 PROCEDURE Delete_Row
154 (X_rowid VARCHAR2,
155 X_tax_category_id NUMBER,
156 X_end_date_active DATE,
157 X_calling_sequence IN VARCHAR2);
158
159 PROCEDURE Check_Unique
160 (X_rowid VARCHAR2,
161 X_tax_category_id NUMBER,
162 X_end_Date_active DATE,
163 X_calling_sequence IN VARCHAR2);
164
165 PROCEDURE Check_Overlapped_Dates
166 (X_rowid VARCHAR2,
167 X_tax_category_id NUMBER,
168 X_end_date_active DATE,
169 X_start_date_active DATE,
170 X_org_id NUMBER,
171 X_calling_sequence IN VARCHAR2);
172
173
174 PROCEDURE Check_Gaps
175 (X_rowid VARCHAR2,
176 X_tax_category_id NUMBER,
177 X_end_date_active DATE,
178 X_start_date_active DATE,
179 X_calling_sequence IN VARCHAR2);
180
181 END JL_ZZ_AR_TX_CATEG_PKG;