1 package Zx_Validate_Api_Pkg AUTHID CURRENT_USER as
2 /* $Header: zxapdefvalpkgs.pls 120.9 2006/03/29 06:42:59 agurram ship $ */
3
4
5 TYPE trx_line_id_tbl IS TABLE OF
6 ZX_TRANSACTION_LINES_GT.trx_line_id%TYPE
7 INDEX BY BINARY_INTEGER;
8
9 TYPE trx_level_type_tbl IS TABLE OF
10 ZX_TRANSACTION_LINES_GT.trx_level_type%TYPE
11 INDEX BY BINARY_INTEGER;
12
13 TYPE ship_from_party_id_tbl IS TABLE OF
14 ZX_TRANSACTION_LINES_GT.ship_from_party_id%TYPE
15 INDEX BY BINARY_INTEGER;
16
17 TYPE ship_from_party_site_id_tbl IS TABLE OF
18 ZX_TRANSACTION_LINES_GT.ship_from_party_site_id%TYPE
19 INDEX BY BINARY_INTEGER;
20
21 TYPE account_ccid_tbl IS TABLE OF
22 ZX_TRANSACTION_LINES_GT.account_ccid%TYPE
23 INDEX BY BINARY_INTEGER;
24
25 TYPE account_string_tbl IS TABLE OF
26 ZX_TRANSACTION_LINES_GT.account_string%TYPE
27 INDEX BY BINARY_INTEGER;
28
29 TYPE ship_to_location_id_tbl IS TABLE OF
30 ZX_TRANSACTION_LINES_GT.ship_to_location_id%TYPE
31 INDEX BY BINARY_INTEGER;
32
33 TYPE product_id_tbl IS TABLE OF
34 ZX_TRANSACTION_LINES_GT.product_id%TYPE
35 INDEX BY BINARY_INTEGER;
36
37 TYPE product_type_tbl IS TABLE OF
38 ZX_TRANSACTION_LINES_GT.product_type%TYPE
39 INDEX BY BINARY_INTEGER;
40
41 TYPE product_org_id_tbl IS TABLE OF
42 ZX_TRANSACTION_LINES_GT.product_org_id%TYPE
43 INDEX BY BINARY_INTEGER;
44
45 TYPE event_class_code_tbl IS TABLE OF
46 ZX_TRX_HEADERS_GT.event_class_code%TYPE
47 INDEX BY BINARY_INTEGER;
48
49 TYPE entity_code_tbl IS TABLE OF
50 ZX_TRX_HEADERS_GT.entity_code%TYPE
51 INDEX BY BINARY_INTEGER;
52
53 TYPE shipto_cust_acct_siteuseid_tbl IS TABLE OF
54 ZX_TRX_HEADERS_GT.ship_to_cust_acct_site_use_id%TYPE
55 INDEX BY BINARY_INTEGER;
56
57 TYPE billto_cust_acct_siteuseid_tbl IS TABLE OF
58 ZX_TRX_HEADERS_GT.bill_to_cust_acct_site_use_id%TYPE
59 INDEX BY BINARY_INTEGER;
60
61 TYPE internal_organization_id_tbl IS TABLE OF
62 ZX_TRX_HEADERS_GT.internal_organization_id%TYPE
63 INDEX BY BINARY_INTEGER;
64
65 TYPE ledger_id_tbl IS TABLE OF
66 ZX_TRX_HEADERS_GT.ledger_id%TYPE
67 INDEX BY BINARY_INTEGER;
68
69 TYPE trx_date_tbl IS TABLE OF
70 ZX_TRX_HEADERS_GT.trx_date%TYPE
71 INDEX BY BINARY_INTEGER;
72
73 TYPE receivables_trx_type_id_tbl IS TABLE OF
74 ZX_TRX_HEADERS_GT.receivables_trx_type_id%TYPE
75 INDEX BY BINARY_INTEGER;
76
77 TYPE trx_id_tbl IS TABLE OF
78 ZX_TRX_HEADERS_GT.trx_id%TYPE
79 INDEX BY BINARY_INTEGER;
80
81 TYPE application_id_tbl IS TABLE OF
82 ZX_TRX_HEADERS_GT.application_id%TYPE
83 INDEX BY BINARY_INTEGER;
84
85 TYPE legal_entity_id_tbl IS TABLE OF
86 ZX_TRX_HEADERS_GT.legal_entity_id%TYPE
87 INDEX BY BINARY_INTEGER;
88
89 TYPE ship_third_pty_acct_id_tbl IS TABLE OF
90 ZX_TRX_HEADERS_GT.ship_third_pty_acct_id%TYPE
91 INDEX BY BINARY_INTEGER;
92
93 TYPE bill_third_pty_acct_id_tbl IS TABLE OF
94 ZX_TRX_HEADERS_GT.bill_third_pty_acct_id%TYPE
95 INDEX BY BINARY_INTEGER;
96
97 TYPE defaulting_attribute1_tbl IS TABLE OF
98 ZX_TRANSACTION_LINES_GT.defaulting_attribute1%TYPE
99 INDEX BY BINARY_INTEGER;
100
101 TYPE defaulting_attribute2_tbl IS TABLE OF
102 ZX_TRANSACTION_LINES_GT.defaulting_attribute2%TYPE
103 INDEX BY BINARY_INTEGER;
104
105 TYPE defaulting_attribute3_tbl IS TABLE OF
106 ZX_TRANSACTION_LINES_GT.defaulting_attribute3%TYPE
107 INDEX BY BINARY_INTEGER;
108
109 TYPE defaulting_attribute4_tbl IS TABLE OF
110 ZX_TRANSACTION_LINES_GT.defaulting_attribute4%TYPE
111 INDEX BY BINARY_INTEGER;
112
113 TYPE defaulting_attribute5_tbl IS TABLE OF
114 ZX_TRANSACTION_LINES_GT.defaulting_attribute5%TYPE
115 INDEX BY BINARY_INTEGER;
116
117 TYPE defaulting_attribute6_tbl IS TABLE OF
118 ZX_TRANSACTION_LINES_GT.defaulting_attribute6%TYPE
119 INDEX BY BINARY_INTEGER;
120
121 TYPE defaulting_attribute7_tbl IS TABLE OF
122 ZX_TRANSACTION_LINES_GT.defaulting_attribute7%TYPE
123 INDEX BY BINARY_INTEGER;
124
125 TYPE defaulting_attribute8_tbl IS TABLE OF
126 ZX_TRANSACTION_LINES_GT.defaulting_attribute8%TYPE
127 INDEX BY BINARY_INTEGER;
128
129 TYPE defaulting_attribute9_tbl IS TABLE OF
130 ZX_TRANSACTION_LINES_GT.defaulting_attribute9%TYPE
131 INDEX BY BINARY_INTEGER;
132
133 TYPE defaulting_attribute10_tbl IS TABLE OF
134 ZX_TRANSACTION_LINES_GT.defaulting_attribute10%TYPE
135 INDEX BY BINARY_INTEGER;
136
137 TYPE input_tax_classif_code_tbl IS TABLE OF
138 ZX_TRANSACTION_LINES_GT.INPUT_TAX_CLASSIFICATION_CODE%TYPE
139 INDEX BY BINARY_INTEGER;
140
141 TYPE output_tax_classif_code_tbl IS TABLE OF
142 ZX_TRANSACTION_LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE%TYPE
143 INDEX BY BINARY_INTEGER;
144
145 TYPE ref_doc_application_id_tbl IS TABLE OF
146 ZX_TRANSACTION_LINES_GT.REF_DOC_APPLICATION_ID%TYPE
147 INDEX BY BINARY_INTEGER;
148
149 TYPE ref_doc_entity_code_tbl IS TABLE OF
150 ZX_TRANSACTION_LINES_GT.REF_DOC_ENTITY_CODE%TYPE
151 INDEX BY BINARY_INTEGER;
152
153 TYPE ref_doc_event_class_code_tbl IS TABLE OF
154 ZX_TRANSACTION_LINES_GT.REF_DOC_EVENT_CLASS_CODE%TYPE
155 INDEX BY BINARY_INTEGER;
156
157 TYPE ref_doc_trx_id_tbl IS TABLE OF
158 ZX_TRANSACTION_LINES_GT.REF_DOC_TRX_ID%TYPE
159 INDEX BY BINARY_INTEGER;
160
161 TYPE ref_doc_line_id_tbl IS TABLE OF
162 ZX_TRANSACTION_LINES_GT.REF_DOC_LINE_ID%TYPE
163 INDEX BY BINARY_INTEGER;
164
165 TYPE ref_doc_trx_level_type_tbl IS TABLE OF
166 ZX_TRANSACTION_LINES_GT.REF_DOC_TRX_LEVEL_TYPE%TYPE
167 INDEX BY BINARY_INTEGER;
168
169 TYPE summary_tax_line_number_tbl IS TABLE OF
170 ZX_IMPORT_TAX_LINES_GT.summary_tax_line_number%TYPE
171 INDEX BY BINARY_INTEGER;
172
173 ------------ Main Procedure(Called from AP) ---------------------------
174
175 PROCEDURE Default_And_Validate_Tax_Attr(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2,
178 p_commit IN VARCHAR2,
179 p_validation_level IN VARCHAR2,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2);
183
184 ------------------ Procedure For Defaulting -----------------------
185
186 PROCEDURE Default_Tax_Attr(x_return_status OUT NOCOPY VARCHAR2);
187
188 ------------------ Procedure For Validating -----------------------
189
190 PROCEDURE Validate_Tax_Attr(x_return_status OUT NOCOPY VARCHAR2);
191
192 PROCEDURE pop_def_tax_classif_code(
193 x_return_status OUT NOCOPY VARCHAR2);
194
195
196 END Zx_Validate_Api_Pkg;