eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.ZX_PARTY_TAX_PROFILE_PKG

Source


1 package ZX_PARTY_TAX_PROFILE_PKG as
2 /* $Header: zxcptytaxprfiles.pls 120.3 2005/11/11 23:45:35 dbetanco ship $ */
3 
4 procedure INSERT_ROW (
5   P_COLLECTING_AUTHORITY_FLAG in VARCHAR2,
6   P_PROVIDER_TYPE_CODE in VARCHAR2,
7   P_CREATE_AWT_DISTS_TYPE_CODE in VARCHAR2,
8   P_CREATE_AWT_INVOICES_TYPE_COD in VARCHAR2,
9   P_TAX_CLASSIFICATION_CODE in VARCHAR2,
10   P_SELF_ASSESS_FLAG in VARCHAR2,
11   P_ALLOW_OFFSET_TAX_FLAG in VARCHAR2,
12   P_REP_REGISTRATION_NUMBER in VARCHAR2,
13   P_EFFECTIVE_FROM_USE_LE in DATE,
14   P_RECORD_TYPE_CODE in VARCHAR2,
15   P_REQUEST_ID in NUMBER,
16   P_ATTRIBUTE1 in VARCHAR2,
17   P_ATTRIBUTE2 in VARCHAR2,
18   P_ATTRIBUTE3 in VARCHAR2,
19   P_ATTRIBUTE4 in VARCHAR2,
20   P_ATTRIBUTE5 in VARCHAR2,
21   P_ATTRIBUTE6 in VARCHAR2,
22   P_ATTRIBUTE7 in VARCHAR2,
23   P_ATTRIBUTE8 in VARCHAR2,
24   P_ATTRIBUTE9 in VARCHAR2,
25   P_ATTRIBUTE10 in VARCHAR2,
26   P_ATTRIBUTE11 in VARCHAR2,
27   P_ATTRIBUTE12 in VARCHAR2,
28   P_ATTRIBUTE13 in VARCHAR2,
29   P_ATTRIBUTE14 in VARCHAR2,
30   P_ATTRIBUTE15 in VARCHAR2,
31   P_ATTRIBUTE_CATEGORY in VARCHAR2,
32   P_PARTY_ID in NUMBER,
33   P_PROGRAM_LOGIN_ID in NUMBER,
34   P_PARTY_TYPE_CODE in VARCHAR2,
35   P_SUPPLIER_FLAG in VARCHAR2,
36   P_CUSTOMER_FLAG in VARCHAR2,
37   P_SITE_FLAG in VARCHAR2,
38   P_PROCESS_FOR_APPLICABILITY_FL in VARCHAR2,
39   P_ROUNDING_LEVEL_CODE in VARCHAR2,
40   P_ROUNDING_RULE_CODE in VARCHAR2,
41   P_WITHHOLDING_START_DATE in DATE,
42   P_INCLUSIVE_TAX_FLAG in VARCHAR2,
43   P_ALLOW_AWT_FLAG in VARCHAR2,
44   P_USE_LE_AS_SUBSCRIBER_FLAG in VARCHAR2,
45   P_LEGAL_ESTABLISHMENT_FLAG in VARCHAR2,
46   P_FIRST_PARTY_LE_FLAG in VARCHAR2,
47   P_REPORTING_AUTHORITY_FLAG in VARCHAR2,
48   X_RETURN_STATUS out NOCOPY VARCHAR2
49   );
50 
51 procedure INSERT_ROW (
52   P_COLLECTING_AUTHORITY_FLAG in VARCHAR2,
53   P_PROVIDER_TYPE_CODE in VARCHAR2,
54   P_CREATE_AWT_DISTS_TYPE_CODE in VARCHAR2,
55   P_CREATE_AWT_INVOICES_TYPE_COD in VARCHAR2,
56   P_TAX_CLASSIFICATION_CODE in VARCHAR2,
57   P_SELF_ASSESS_FLAG in VARCHAR2,
58   P_ALLOW_OFFSET_TAX_FLAG in VARCHAR2,
59   P_REP_REGISTRATION_NUMBER in VARCHAR2,
60   P_EFFECTIVE_FROM_USE_LE in DATE,
61   P_RECORD_TYPE_CODE in VARCHAR2,
62   P_REQUEST_ID in NUMBER,
63   P_ATTRIBUTE1 in VARCHAR2,
64   P_ATTRIBUTE2 in VARCHAR2,
65   P_ATTRIBUTE3 in VARCHAR2,
66   P_ATTRIBUTE4 in VARCHAR2,
67   P_ATTRIBUTE5 in VARCHAR2,
68   P_ATTRIBUTE6 in VARCHAR2,
69   P_ATTRIBUTE7 in VARCHAR2,
70   P_ATTRIBUTE8 in VARCHAR2,
71   P_ATTRIBUTE9 in VARCHAR2,
72   P_ATTRIBUTE10 in VARCHAR2,
73   P_ATTRIBUTE11 in VARCHAR2,
74   P_ATTRIBUTE12 in VARCHAR2,
75   P_ATTRIBUTE13 in VARCHAR2,
76   P_ATTRIBUTE14 in VARCHAR2,
77   P_ATTRIBUTE15 in VARCHAR2,
78   P_ATTRIBUTE_CATEGORY in VARCHAR2,
79   P_PARTY_ID in NUMBER,
80   P_PROGRAM_LOGIN_ID in NUMBER,
81   P_PARTY_TYPE_CODE in VARCHAR2,
82   P_SUPPLIER_FLAG in VARCHAR2,
83   P_CUSTOMER_FLAG in VARCHAR2,
84   P_SITE_FLAG in VARCHAR2,
85   P_PROCESS_FOR_APPLICABILITY_FL in VARCHAR2,
86   P_ROUNDING_LEVEL_CODE in VARCHAR2,
87   P_ROUNDING_RULE_CODE in VARCHAR2,
88   P_WITHHOLDING_START_DATE in DATE,
89   P_INCLUSIVE_TAX_FLAG in VARCHAR2,
90   P_ALLOW_AWT_FLAG in VARCHAR2,
91   P_USE_LE_AS_SUBSCRIBER_FLAG in VARCHAR2,
92   P_LEGAL_ESTABLISHMENT_FLAG in VARCHAR2,
93   P_FIRST_PARTY_LE_FLAG in VARCHAR2,
94   P_REPORTING_AUTHORITY_FLAG in VARCHAR2,
95   X_RETURN_STATUS out NOCOPY VARCHAR2,
96   P_REGISTRATION_TYPE_CODE in VARCHAR2,
97   P_COUNTRY_CODE in VARCHAR2
98   );
99 
100 
101 procedure UPDATE_ROW (
102   P_PARTY_TAX_PROFILE_ID in NUMBER,
103   P_COLLECTING_AUTHORITY_FLAG in VARCHAR2,
104   P_PROVIDER_TYPE_CODE in VARCHAR2,
105   P_CREATE_AWT_DISTS_TYPE_CODE in VARCHAR2,
106   P_CREATE_AWT_INVOICES_TYPE_COD in VARCHAR2,
107   P_TAX_CLASSIFICATION_CODE in VARCHAR2,
108   P_SELF_ASSESS_FLAG in VARCHAR2,
109   P_ALLOW_OFFSET_TAX_FLAG in VARCHAR2,
110   P_REP_REGISTRATION_NUMBER in VARCHAR2,
111   P_EFFECTIVE_FROM_USE_LE in DATE,
112   P_RECORD_TYPE_CODE in VARCHAR2,
113   P_REQUEST_ID in NUMBER,
114   P_ATTRIBUTE1 in VARCHAR2,
115   P_ATTRIBUTE2 in VARCHAR2,
116   P_ATTRIBUTE3 in VARCHAR2,
117   P_ATTRIBUTE4 in VARCHAR2,
118   P_ATTRIBUTE5 in VARCHAR2,
119   P_ATTRIBUTE6 in VARCHAR2,
120   P_ATTRIBUTE7 in VARCHAR2,
121   P_ATTRIBUTE8 in VARCHAR2,
122   P_ATTRIBUTE9 in VARCHAR2,
123   P_ATTRIBUTE10 in VARCHAR2,
124   P_ATTRIBUTE11 in VARCHAR2,
125   P_ATTRIBUTE12 in VARCHAR2,
126   P_ATTRIBUTE13 in VARCHAR2,
127   P_ATTRIBUTE14 in VARCHAR2,
128   P_ATTRIBUTE15 in VARCHAR2,
129   P_ATTRIBUTE_CATEGORY in VARCHAR2,
130   P_PARTY_ID in NUMBER,
131   P_PROGRAM_LOGIN_ID in NUMBER,
132   P_PARTY_TYPE_CODE in VARCHAR2,
133   P_SUPPLIER_FLAG in VARCHAR2,
134   P_CUSTOMER_FLAG in VARCHAR2,
135   P_SITE_FLAG in VARCHAR2,
136   P_PROCESS_FOR_APPLICABILITY_FL in VARCHAR2,
137   P_ROUNDING_LEVEL_CODE in VARCHAR2,
138   P_ROUNDING_RULE_CODE in VARCHAR2,
139   P_WITHHOLDING_START_DATE in DATE,
140   P_INCLUSIVE_TAX_FLAG in VARCHAR2,
141   P_ALLOW_AWT_FLAG in VARCHAR2,
142   P_USE_LE_AS_SUBSCRIBER_FLAG in VARCHAR2,
143   P_LEGAL_ESTABLISHMENT_FLAG in VARCHAR2,
144   P_FIRST_PARTY_LE_FLAG in VARCHAR2,
145   P_REPORTING_AUTHORITY_FLAG in VARCHAR2,
146   X_RETURN_STATUS out NOCOPY VARCHAR2
147 );
148 
149 procedure UPDATE_ROW (
150   P_PARTY_TAX_PROFILE_ID in NUMBER,
151   P_COLLECTING_AUTHORITY_FLAG in VARCHAR2,
152   P_PROVIDER_TYPE_CODE in VARCHAR2,
153   P_CREATE_AWT_DISTS_TYPE_CODE in VARCHAR2,
154   P_CREATE_AWT_INVOICES_TYPE_COD in VARCHAR2,
155   P_TAX_CLASSIFICATION_CODE in VARCHAR2,
156   P_SELF_ASSESS_FLAG in VARCHAR2,
157   P_ALLOW_OFFSET_TAX_FLAG in VARCHAR2,
158   P_REP_REGISTRATION_NUMBER in VARCHAR2,
159   P_EFFECTIVE_FROM_USE_LE in DATE,
160   P_RECORD_TYPE_CODE in VARCHAR2,
161   P_REQUEST_ID in NUMBER,
162   P_ATTRIBUTE1 in VARCHAR2,
163   P_ATTRIBUTE2 in VARCHAR2,
164   P_ATTRIBUTE3 in VARCHAR2,
165   P_ATTRIBUTE4 in VARCHAR2,
166   P_ATTRIBUTE5 in VARCHAR2,
167   P_ATTRIBUTE6 in VARCHAR2,
168   P_ATTRIBUTE7 in VARCHAR2,
169   P_ATTRIBUTE8 in VARCHAR2,
170   P_ATTRIBUTE9 in VARCHAR2,
171   P_ATTRIBUTE10 in VARCHAR2,
172   P_ATTRIBUTE11 in VARCHAR2,
173   P_ATTRIBUTE12 in VARCHAR2,
174   P_ATTRIBUTE13 in VARCHAR2,
175   P_ATTRIBUTE14 in VARCHAR2,
176   P_ATTRIBUTE15 in VARCHAR2,
177   P_ATTRIBUTE_CATEGORY in VARCHAR2,
178   P_PARTY_ID in NUMBER,
179   P_PROGRAM_LOGIN_ID in NUMBER,
180   P_PARTY_TYPE_CODE in VARCHAR2,
181   P_SUPPLIER_FLAG in VARCHAR2,
182   P_CUSTOMER_FLAG in VARCHAR2,
183   P_SITE_FLAG in VARCHAR2,
184   P_PROCESS_FOR_APPLICABILITY_FL in VARCHAR2,
185   P_ROUNDING_LEVEL_CODE in VARCHAR2,
186   P_ROUNDING_RULE_CODE in VARCHAR2,
187   P_WITHHOLDING_START_DATE in DATE,
188   P_INCLUSIVE_TAX_FLAG in VARCHAR2,
189   P_ALLOW_AWT_FLAG in VARCHAR2,
190   P_USE_LE_AS_SUBSCRIBER_FLAG in VARCHAR2,
191   P_LEGAL_ESTABLISHMENT_FLAG in VARCHAR2,
192   P_FIRST_PARTY_LE_FLAG in VARCHAR2,
193   P_REPORTING_AUTHORITY_FLAG in VARCHAR2,
194   X_RETURN_STATUS out NOCOPY VARCHAR2,
195   P_REGISTRATION_TYPE_CODE in VARCHAR2,
196   P_COUNTRY_CODE in VARCHAR2
197 );
198 
199 procedure DELETE_ROW (
200   P_PARTY_TAX_PROFILE_ID in NUMBER,
201   X_RETURN_STATUS out NOCOPY VARCHAR2
202   );
203 
204 end ZX_PARTY_TAX_PROFILE_PKG;