1 package ZX_REGISTRATIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: zxcregs.pls 120.5 2005/05/25 11:32:09 scsharma ship $ */
3
4 procedure INSERT_ROW (
5 P_REQUEST_ID in NUMBER,
6 P_ATTRIBUTE1 in VARCHAR2,
7 P_ATTRIBUTE2 in VARCHAR2,
8 P_ATTRIBUTE3 in VARCHAR2,
9 P_ATTRIBUTE4 in VARCHAR2,
10 P_ATTRIBUTE5 in VARCHAR2,
11 P_ATTRIBUTE6 in VARCHAR2,
12 P_VALIDATION_RULE in VARCHAR2,
13 P_ROUNDING_RULE_CODE in VARCHAR2,
14 P_TAX_JURISDICTION_CODE in VARCHAR2,
15 P_SELF_ASSESS_FLAG in VARCHAR2,
16 P_REGISTRATION_STATUS_CODE in VARCHAR2,
17 P_REGISTRATION_SOURCE_CODE in VARCHAR2,
18 P_REGISTRATION_REASON_CODE in VARCHAR2,
19 P_TAX in VARCHAR2,
20 P_TAX_REGIME_CODE in VARCHAR2,
21 P_INCLUSIVE_TAX_FLAG in VARCHAR2,
22 P_EFFECTIVE_FROM in DATE,
23 P_EFFECTIVE_TO in DATE,
24 P_REP_PARTY_TAX_NAME in VARCHAR2,
25 P_DEFAULT_REGISTRATION_FLAG in VARCHAR2,
26 P_BANK_ACCOUNT_NUM in VARCHAR2,
27 P_RECORD_TYPE_CODE in VARCHAR2,
28 P_LEGAL_LOCATION_ID in NUMBER,
29 P_TAX_AUTHORITY_ID in NUMBER,
30 P_REP_TAX_AUTHORITY_ID in NUMBER,
31 P_COLL_TAX_AUTHORITY_ID in NUMBER,
32 P_REGISTRATION_TYPE_CODE in VARCHAR2,
33 P_REGISTRATION_NUMBER in VARCHAR2,
34 P_PARTY_TAX_PROFILE_ID in NUMBER,
35 P_LEGAL_REGISTRATION_ID in NUMBER,
36 P_BANK_ID in NUMBER,
37 P_BANK_BRANCH_ID in NUMBER,
38 P_ACCOUNT_SITE_ID in NUMBER,
39 P_ATTRIBUTE14 in VARCHAR2,
40 P_ATTRIBUTE15 in VARCHAR2,
41 P_ATTRIBUTE_CATEGORY in VARCHAR2,
42 P_PROGRAM_LOGIN_ID in NUMBER,
43 P_ACCOUNT_ID in NUMBER,
44 P_TAX_CLASSIFICATION_CODE in VARCHAR2,
45 P_ATTRIBUTE7 in VARCHAR2,
46 P_ATTRIBUTE8 in VARCHAR2,
47 P_ATTRIBUTE9 in VARCHAR2,
48 P_ATTRIBUTE10 in VARCHAR2,
49 P_ATTRIBUTE11 in VARCHAR2,
50 P_ATTRIBUTE12 in VARCHAR2,
51 P_ATTRIBUTE13 in VARCHAR2,
52 X_RETURN_STATUS out NOCOPY VARCHAR2
53 );
54
55 procedure UPDATE_ROW (
56 P_REGISTRATION_ID in NUMBER,
57 P_REQUEST_ID in NUMBER,
58 P_ATTRIBUTE1 in VARCHAR2,
59 P_ATTRIBUTE2 in VARCHAR2,
60 P_ATTRIBUTE3 in VARCHAR2,
61 P_ATTRIBUTE4 in VARCHAR2,
62 P_ATTRIBUTE5 in VARCHAR2,
63 P_ATTRIBUTE6 in VARCHAR2,
64 P_VALIDATION_RULE in VARCHAR2,
65 P_ROUNDING_RULE_CODE in VARCHAR2,
66 P_TAX_JURISDICTION_CODE in VARCHAR2,
67 P_SELF_ASSESS_FLAG in VARCHAR2,
68 P_REGISTRATION_STATUS_CODE in VARCHAR2,
69 P_REGISTRATION_SOURCE_CODE in VARCHAR2,
70 P_REGISTRATION_REASON_CODE in VARCHAR2,
71 P_TAX in VARCHAR2,
72 P_TAX_REGIME_CODE in VARCHAR2,
73 P_INCLUSIVE_TAX_FLAG in VARCHAR2,
74 P_EFFECTIVE_FROM in DATE,
75 P_EFFECTIVE_TO in DATE,
76 P_REP_PARTY_TAX_NAME in VARCHAR2,
77 P_DEFAULT_REGISTRATION_FLAG in VARCHAR2,
78 P_BANK_ACCOUNT_NUM in VARCHAR2,
79 P_RECORD_TYPE_CODE in VARCHAR2,
80 P_LEGAL_LOCATION_ID in NUMBER,
81 P_TAX_AUTHORITY_ID in NUMBER,
82 P_REP_TAX_AUTHORITY_ID in NUMBER,
83 P_COLL_TAX_AUTHORITY_ID in NUMBER,
84 P_REGISTRATION_TYPE_CODE in VARCHAR2,
85 P_REGISTRATION_NUMBER in VARCHAR2,
86 P_PARTY_TAX_PROFILE_ID in NUMBER,
87 P_LEGAL_REGISTRATION_ID in NUMBER,
88 P_BANK_ID in NUMBER,
89 P_BANK_BRANCH_ID in NUMBER,
90 P_ACCOUNT_SITE_ID in NUMBER,
91 P_ATTRIBUTE14 in VARCHAR2,
92 P_ATTRIBUTE15 in VARCHAR2,
93 P_ATTRIBUTE_CATEGORY in VARCHAR2,
94 P_PROGRAM_LOGIN_ID in NUMBER,
95 P_ACCOUNT_ID in NUMBER,
96 P_TAX_CLASSIFICATION_CODE in VARCHAR2,
97 P_ATTRIBUTE7 in VARCHAR2,
98 P_ATTRIBUTE8 in VARCHAR2,
99 P_ATTRIBUTE9 in VARCHAR2,
100 P_ATTRIBUTE10 in VARCHAR2,
101 P_ATTRIBUTE11 in VARCHAR2,
102 P_ATTRIBUTE12 in VARCHAR2,
103 P_ATTRIBUTE13 in VARCHAR2,
104 X_RETURN_STATUS out NOCOPY VARCHAR2
105 );
106 procedure DELETE_ROW (
107 P_REGISTRATION_ID in NUMBER,
108 X_RETURN_STATUS out NOCOPY VARCHAR2
109 );
110
111 end ZX_REGISTRATIONS_PKG;