DBA Data[Home] [Help]

PACKAGE: APPS.ZX_VALIDATE_API_PKG

Source


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;