[Home] [Help]
PACKAGE: APPS.JL_ZZ_AR_TX_CUS_CLS_PKG
Source
1 PACKAGE JL_ZZ_AR_TX_CUS_CLS_PKG as
2 /* $Header: jlzztacs.pls 120.2 2003/03/03 19:32:17 opedrega ship $ */
3
4 PROCEDURE Populate_Cus_Cls_Rows
5 (X_address_id NUMBER,
6 X_class_code VARCHAR2,
7 X_org_id NUMBER);
8
9 PROCEDURE Insert_Row
10 (X_rowid IN OUT NOCOPY VARCHAR2,
11 X_cus_class_id NUMBER,
12 X_address_id NUMBER,
13 X_tax_attr_class_code VARCHAR2,
14 X_tax_category_id NUMBER,
15 X_tax_attribute_name VARCHAR2,
16 X_tax_attribute_value VARCHAR2,
17 X_enabled_flag VARCHAR2,
18 X_org_id NUMBER,
19 X_last_updated_by NUMBER,
20 X_last_update_date DATE,
21 X_last_update_login NUMBER,
22 X_creation_date DATE,
23 X_created_by NUMBER,
24 X_calling_sequence IN VARCHAR2);
25
26 PROCEDURE Update_Row
27 (X_rowid VARCHAR2,
28 X_cus_class_id NUMBER,
29 X_address_id NUMBER,
30 X_tax_attr_class_code VARCHAR2,
31 X_tax_category_id NUMBER,
32 X_tax_attribute_name VARCHAR2,
33 X_tax_attribute_value VARCHAR2,
34 X_enabled_flag VARCHAR2,
35 X_org_id NUMBER,
36 X_last_updated_by NUMBER,
37 X_last_update_date DATE,
38 X_last_update_login NUMBER,
39 X_creation_date DATE,
40 X_created_by NUMBER,
41 X_calling_sequence IN VARCHAR2);
42
43 PROCEDURE Delete_Row
44 (X_rowid VARCHAR2);
45
46 PROCEDURE Lock_Row
47 (X_rowid VARCHAR2,
48 X_cus_class_id NUMBER,
49 X_address_id NUMBER,
50 X_tax_attr_class_code VARCHAR2,
51 X_tax_category_id NUMBER,
52 X_tax_attribute_name VARCHAR2,
53 X_tax_attribute_value VARCHAR2,
54 X_enabled_flag VARCHAR2,
55 X_org_id NUMBER,
56 X_last_updated_by NUMBER,
57 X_last_update_date DATE,
58 X_last_update_login NUMBER,
59 X_creation_date DATE,
60 X_created_by NUMBER,
61 X_calling_sequence IN VARCHAR2);
62
63 PROCEDURE Check_Unique
64 (X_rowid VARCHAR2,
65 X_address_id NUMBER,
66 X_tax_attr_class_code VARCHAR2,
67 X_tax_category_id NUMBER,
68 X_tax_attribute_name VARCHAR2,
69 X_org_id NUMBER,
70 X_calling_sequence IN VARCHAR2);
71
72 END JL_ZZ_AR_TX_CUS_CLS_PKG;