[Home] [Help]
PACKAGE: APPS.JL_ZZ_AR_TX_ATT_CLS_PKG
Source
1 PACKAGE JL_ZZ_AR_TX_ATT_CLS_PKG as
2 /* $Header: jlzztcls.pls 120.2 2003/03/03 19:33:49 opedrega ship $ */
3
4 PROCEDURE Populate_All_Rows
5 (X_class_type VARCHAR2,
6 X_class_code VARCHAR2,
7 X_enabled_flag VARCHAR2,
8 X_org_id NUMBER);
9
10 PROCEDURE Populate_Mandatory_Rows
11 (X_class_type VARCHAR2,
12 X_class_code VARCHAR2,
13 X_enabled_flag VARCHAR2,
14 X_org_id NUMBER);
15
16 PROCEDURE Insert_Row
17 (X_rowid IN OUT NOCOPY VARCHAR2,
18 X_attribute_class_id NUMBER,
19 X_tax_attr_class_type VARCHAR2,
20 X_tax_attr_class_code VARCHAR2,
21 X_tax_category_id NUMBER,
22 X_tax_attribute_type VARCHAR2,
23 X_tax_attribute_name VARCHAR2,
24 X_tax_attribute_value VARCHAR2,
25 X_enabled_flag VARCHAR2,
26 X_org_id NUMBER,
27 X_last_updated_by NUMBER,
28 X_last_update_date DATE,
29 X_last_update_login NUMBER,
30 X_creation_date DATE,
31 X_created_by NUMBER,
32 X_attribute_category VARCHAR2,
33 X_attribute1 VARCHAR2,
34 X_attribute2 VARCHAR2,
35 X_attribute3 VARCHAR2,
36 X_attribute4 VARCHAR2,
37 X_attribute5 VARCHAR2,
38 X_attribute6 VARCHAR2,
39 X_attribute7 VARCHAR2,
40 X_attribute8 VARCHAR2,
41 X_attribute9 VARCHAR2,
42 X_attribute10 VARCHAR2,
43 X_attribute11 VARCHAR2,
44 X_attribute12 VARCHAR2,
45 X_attribute13 VARCHAR2,
46 X_attribute14 VARCHAR2,
47 X_attribute15 VARCHAR2,
48 X_calling_sequence IN VARCHAR2);
49
50 PROCEDURE Update_Row
51 (X_rowid VARCHAR2,
52 X_tax_attr_class_type VARCHAR2,
53 X_tax_attr_class_code VARCHAR2,
54 X_tax_category_id NUMBER,
55 X_tax_attribute_type VARCHAR2,
56 X_tax_attribute_name VARCHAR2,
57 X_tax_attribute_value VARCHAR2,
58 X_enabled_flag VARCHAR2,
59 X_org_id NUMBER,
60 X_last_updated_by NUMBER,
61 X_last_update_date DATE,
62 X_last_update_login NUMBER,
63 X_creation_date DATE,
64 X_created_by NUMBER,
65 X_attribute_category VARCHAR2,
66 X_attribute1 VARCHAR2,
67 X_attribute2 VARCHAR2,
68 X_attribute3 VARCHAR2,
69 X_attribute4 VARCHAR2,
70 X_attribute5 VARCHAR2,
71 X_attribute6 VARCHAR2,
72 X_attribute7 VARCHAR2,
73 X_attribute8 VARCHAR2,
74 X_attribute9 VARCHAR2,
75 X_attribute10 VARCHAR2,
76 X_attribute11 VARCHAR2,
77 X_attribute12 VARCHAR2,
78 X_attribute13 VARCHAR2,
79 X_attribute14 VARCHAR2,
80 X_attribute15 VARCHAR2,
81 X_calling_sequence IN VARCHAR2);
82
83 PROCEDURE Delete_Row
84 (X_rowid VARCHAR2);
85
86 PROCEDURE Lock_Row
87 (X_rowid VARCHAR2,
88 X_tax_attr_class_type VARCHAR2,
89 X_tax_attr_class_code VARCHAR2,
90 X_tax_category_id NUMBER,
91 X_tax_attribute_type VARCHAR2,
92 X_tax_attribute_name VARCHAR2,
93 X_tax_attribute_value VARCHAR2,
94 X_enabled_flag VARCHAR2,
95 X_org_id NUMBER,
96 X_last_updated_by NUMBER,
97 X_last_update_date DATE,
98 X_last_update_login NUMBER,
99 X_creation_date DATE,
100 X_created_by NUMBER,
101 X_attribute_category VARCHAR2,
102 X_attribute1 VARCHAR2,
103 X_attribute2 VARCHAR2,
104 X_attribute3 VARCHAR2,
105 X_attribute4 VARCHAR2,
106 X_attribute5 VARCHAR2,
107 X_attribute6 VARCHAR2,
108 X_attribute7 VARCHAR2,
109 X_attribute8 VARCHAR2,
110 X_attribute9 VARCHAR2,
111 X_attribute10 VARCHAR2,
112 X_attribute11 VARCHAR2,
113 X_attribute12 VARCHAR2,
114 X_attribute13 VARCHAR2,
115 X_attribute14 VARCHAR2,
116 X_attribute15 VARCHAR2,
117 X_calling_sequence IN VARCHAR2);
118
119 PROCEDURE Check_Unique
120 (X_rowid VARCHAR2,
121 X_tax_attr_class_type VARCHAR2,
122 X_tax_attr_class_code VARCHAR2,
123 X_tax_category_id NUMBER,
124 X_tax_attribute_type VARCHAR2,
125 X_tax_attribute_name VARCHAR2,
126 X_org_id NUMBER,
127 X_calling_sequence IN VARCHAR2);
128
129 FUNCTION Check_Unique_Detail
130 (X_lookup_type VARCHAR2,
131 X_lookup_code VARCHAR2,
132 X_lookup_code_out OUT NOCOPY VARCHAR2,
133 X_org_id NUMBER,
134 X_calling_sequence IN VARCHAR2) RETURN NUMBER;
135
136 END JL_ZZ_AR_TX_ATT_CLS_PKG;