[Home] [Help]
PACKAGE: APPS.ZX_ACCT_TAX_CLS_DEFS_PKG
Source
1 PACKAGE zx_acct_tax_cls_defs_pkg AS
2 /* $Header: zxgltcds.pls 120.1 2005/07/06 12:03:27 mparihar noship $ */
3 --
4 -- Package
5 -- zx_account_tax_rates_pkg
6 -- Purpose
7 -- To implement various data checking needed for the
8 -- gl_tax_options table
9 -- History
10 -- 24-NOV-04 Tai-Hyun Won Created
11 --
12
13 --
14 -- Procedure
15 -- select_columns
16 -- Purpose
17 -- Gets the values of some columns from zx_acct_tx_cls_defs_all associated
18 -- with the given ledger and organization.
19 -- History
20 --
21 -- Arguments
22 -- x_ledger_id ID of the current ledger
23 -- x_org_id ID of the current organization
24
25 PROCEDURE select_columns(
26 x_ledger_id NUMBER,
27 x_org_id NUMBER,
28 x_tax_class IN OUT NOCOPY VARCHAR2,
29 x_tax_classification_code IN OUT NOCOPY VARCHAR2);
30
31
32 --
33 -- Procedure
34 -- duplicate_tax_class_code
35 --
36 -- Purpose
37 -- Check if another record for the same ledger id and org id exists
38 --
39 -- History
40 --
41 --
42 -- Arguments
43 -- x_ledger_id ID of the current ledger
44 -- x_org_id ID of the current organization
45 -- x_rowid Row ID
46 --
47 PROCEDURE duplicate_tax_class_code(
48 x_ledger_id NUMBER,
49 x_org_id NUMBER,
50 x_rowid VARCHAR2);
51
52
53 --
54 -- Procedure
55 -- org_name
56 --
57 -- Purpose
58 -- Gets the name of the current organization
59 --
60 -- History
61 --
62 --
63 -- Arguments
64 -- x_org_id ID of the current organization
65 -- x_org_name Name of the current organization
66 --
67 PROCEDURE org_name(
68 x_org_id NUMBER,
69 x_org_name IN OUT NOCOPY VARCHAR2);
70
71
72 --
73 -- Procedure
74 -- insert_row
75 -- Purpose
76 --
77 -- History
78 -- 24-Nov-04 Tai-Hyun Won Created
79 --
80 PROCEDURE insert_row(
81 X_LEDGER_ID NUMBER,
82 X_ORG_ID NUMBER,
83 X_ACCOUNT_SEGMENT_VALUE VARCHAR2,
84 X_TAX_CLASS VARCHAR2,
85 X_TAX_CLASSIFICATION_CODE VARCHAR2,
86 X_ALLOW_TAX_CODE_OVERRIDE_FLAG VARCHAR2,
87 X_RECORD_TYPE_CODE VARCHAR2,
88 X_CREATION_DATE DATE,
89 X_CREATED_BY NUMBER,
90 X_LAST_UPDATED_BY NUMBER,
91 X_LAST_UPDATE_DATE DATE,
92 X_LAST_UPDATE_LOGIN NUMBER,
93 X_ATTRIBUTE_CATEGORY VARCHAR2,
94 X_ATTRIBUTE1 VARCHAR2,
95 X_ATTRIBUTE2 VARCHAR2,
96 X_ATTRIBUTE3 VARCHAR2,
97 X_ATTRIBUTE4 VARCHAR2,
98 X_ATTRIBUTE5 VARCHAR2,
99 X_ATTRIBUTE6 VARCHAR2,
100 X_ATTRIBUTE7 VARCHAR2,
101 X_ATTRIBUTE8 VARCHAR2,
102 X_ATTRIBUTE9 VARCHAR2,
103 X_ATTRIBUTE10 VARCHAR2,
104 X_ATTRIBUTE11 VARCHAR2,
105 X_ATTRIBUTE12 VARCHAR2,
106 X_ATTRIBUTE13 VARCHAR2,
107 X_ATTRIBUTE14 VARCHAR2,
108 X_ATTRIBUTE15 VARCHAR2);
109
110 --
111 -- Procedure
112 -- update_row
113 -- Purpose
114 --
115 -- History
116 -- 24-Nov-04 Tai-Hyun Won Created
117 --
118 PROCEDURE update_row(
119 X_LEDGER_ID NUMBER,
120 X_ORG_ID NUMBER,
121 X_ACCOUNT_SEGMENT_VALUE VARCHAR2,
122 X_TAX_CLASS VARCHAR2,
123 X_TAX_CLASSIFICATION_CODE VARCHAR2,
124 X_ALLOW_TAX_CODE_OVERRIDE_FLAG VARCHAR2,
125 X_RECORD_TYPE_CODE VARCHAR2,
126 X_CREATION_DATE DATE,
127 X_CREATED_BY NUMBER,
128 X_LAST_UPDATED_BY NUMBER,
129 X_LAST_UPDATE_DATE DATE,
130 X_LAST_UPDATE_LOGIN NUMBER,
131 X_ATTRIBUTE_CATEGORY VARCHAR2,
132 X_ATTRIBUTE1 VARCHAR2,
133 X_ATTRIBUTE2 VARCHAR2,
134 X_ATTRIBUTE3 VARCHAR2,
135 X_ATTRIBUTE4 VARCHAR2,
136 X_ATTRIBUTE5 VARCHAR2,
137 X_ATTRIBUTE6 VARCHAR2,
138 X_ATTRIBUTE7 VARCHAR2,
139 X_ATTRIBUTE8 VARCHAR2,
140 X_ATTRIBUTE9 VARCHAR2,
141 X_ATTRIBUTE10 VARCHAR2,
142 X_ATTRIBUTE11 VARCHAR2,
143 X_ATTRIBUTE12 VARCHAR2,
144 X_ATTRIBUTE13 VARCHAR2,
145 X_ATTRIBUTE14 VARCHAR2,
146 X_ATTRIBUTE15 VARCHAR2,
147 X_ACCOUNT_SEGMENT_VALUE_ORIG VARCHAR2,
148 X_TAX_CLASS_ORIG VARCHAR2);
149
150 --
151 -- Procedure
152 -- lock_row
153 -- Purpose
154 --
155 -- History
156 -- 24-Nov-04 Tai-Hyun Won Created
157 --
158 PROCEDURE lock_row(
159 X_LEDGER_ID NUMBER,
160 X_ORG_ID NUMBER,
161 X_ACCOUNT_SEGMENT_VALUE VARCHAR2,
162 X_TAX_CLASS VARCHAR2,
163 X_TAX_CLASSIFICATION_CODE VARCHAR2,
164 X_ALLOW_TAX_CODE_OVERRIDE_FLAG VARCHAR2,
165 X_RECORD_TYPE_CODE VARCHAR2,
166 X_CREATION_DATE DATE,
167 X_CREATED_BY NUMBER,
168 X_LAST_UPDATED_BY NUMBER,
169 X_LAST_UPDATE_DATE DATE,
170 X_LAST_UPDATE_LOGIN NUMBER,
171 X_ATTRIBUTE_CATEGORY VARCHAR2,
172 X_ATTRIBUTE1 VARCHAR2,
173 X_ATTRIBUTE2 VARCHAR2,
174 X_ATTRIBUTE3 VARCHAR2,
175 X_ATTRIBUTE4 VARCHAR2,
176 X_ATTRIBUTE5 VARCHAR2,
177 X_ATTRIBUTE6 VARCHAR2,
178 X_ATTRIBUTE7 VARCHAR2,
179 X_ATTRIBUTE8 VARCHAR2,
180 X_ATTRIBUTE9 VARCHAR2,
181 X_ATTRIBUTE10 VARCHAR2,
182 X_ATTRIBUTE11 VARCHAR2,
183 X_ATTRIBUTE12 VARCHAR2,
184 X_ATTRIBUTE13 VARCHAR2,
185 X_ATTRIBUTE14 VARCHAR2,
186 X_ATTRIBUTE15 VARCHAR2);
187
188 END zx_acct_tax_cls_defs_pkg;