1 PACKAGE AR_GDF_VALIDATION AS
2 /* $Header: ARXGDVHS.pls 120.1.12010000.2 2008/11/20 07:25:17 npanchak ship $ */
3
4 /*-------------------------------------------------------------------------+
5 | PUBLIC FUNCTION |
6 | is_gdf_valid |
7 | |
8 | DESCRIPTION |
9 | This is a stub module for global descriptive flex field validation |
10 | during autoinvoice run. |
11 | |
12 | The actual module is installed only when JL is installed. |
13 | |
14 | ARGUMENTS |
15 | request_id request_id of the autoinvoice run |
16 | |
17 | RETURNS |
18 | 1 If validation is successful |
19 | 0 If error occured during validation |
20 | |
21 | NOTES |
22 | |
23 | EXAMPLE |
24 | ar_gdf_validation.is_gdf_valid(99999) |
25 | |
26 | MODIFICATION HISTORY |
27 | 28-Aug-97 Srinivasan Jandyala Created. |
28 | |
29 +-------------------------------------------------------------------------*/
30
31
32 FUNCTION is_gdf_valid(request_id IN NUMBER) RETURN NUMBER;
33
34 /*-------------------------------------------------------------------------+
35 | PUBLIC FUNCTION |
36 | is_gdf_postbatch_valid |
37 | |
38 | DESCRIPTION |
39 | This is a stub module for global descriptive flex field validation |
40 | during postbatch run. |
41 | |
42 | The actual module is installed only when JL is installed. |
43 | |
44 | ARGUMENTS |
45 | batch_id IN NUMBER |
46 | cash_receipt_id IN NUMBER |
47 | |
48 | RETURNS |
49 | 1 If validation is successful |
50 | 0 If error occured during validation |
51 | |
52 | NOTES |
53 | |
54 | EXAMPLE |
55 | |
56 | MODIFICATION HISTORY |
57 | 31-Aug-98 Nilesh Acharya Created. |
58 | |
59 +-------------------------------------------------------------------------*/
60
61
62 FUNCTION is_gdf_postbatch_valid(batch_id IN NUMBER,
63 cash_receipt_id IN NUMBER) RETURN NUMBER;
64
65
66 /*-------------------------------------------------------------------------+
67 | PUBLIC FUNCTION |
68 | is_gdf_taxid_valid |
69 | |
70 | DESCRIPTION |
71 | This is a stub module for taxid and global flexfields validation |
72 | for Globalizations. |
73 | |
74 | This package may exist as a stub, however for future implementation |
75 | this has been integrated as a hook. |
76 | |
77 | ARGUMENTS |
78 | request_id IN NUMBER |
79 | org_id IN NUMBER |
80 | sob IN NUMBER |
81 | user_id IN NUMBER |
82 | application_id IN NUMBER |
83 | language_id IN NUMBER |
84 | program_id IN NUMBER |
85 | prog_appl_id IN NUMBER |
86 | last_update_login IN NUMBER |
87 | |
88 | RETURNS |
89 | 1 If validation is successful |
90 | 0 If error occured during validation |
91 | |
92 | NOTES |
93 | |
94 | EXAMPLE |
95 | |
96 | MODIFICATION HISTORY |
97 | 09-Sep-98 Vikram Ahluwalia Created. |
98 | |
99 +-------------------------------------------------------------------------*/
100
101
102 FUNCTION is_gdf_taxid_valid(request_id IN NUMBER,
103 org_id IN NUMBER,
104 sob IN NUMBER,
105 user_id IN NUMBER,
106 application_id IN NUMBER,
107 language_id IN NUMBER,
108 program_id IN NUMBER,
109 prog_appl_id IN NUMBER,
110 last_update_login IN NUMBER) RETURN NUMBER;
111
112
113 /*-------------------------------------------------------------------------+
114 | PUBLIC FUNCTION |
115 | is_cust_imp_valid |
116 | |
117 | DESCRIPTION |
118 | This is a stub module for taxid and global flexfields validation |
119 | for Globalizations. |
120 | |
121 | ARGUMENTS |
122 | request_id IN NUMBER |
123 | org_id IN NUMBER |
124 | sob IN NUMBER |
125 | user_id IN NUMBER |
126 | application_id IN NUMBER |
127 | language_id IN NUMBER |
128 | program_id IN NUMBER |
129 | prog_appl_id IN NUMBER |
130 | last_update_login IN NUMBER |
131 | int_table_name IN VARCHAR2 |
132 | RETURNS |
133 | 1 If validation is successful |
134 | 0 If error occured during validation |
135 | |
136 | NOTES |
137 | |
138 | EXAMPLE |
139 | |
140 | MODIFICATION HISTORY |
141 | 10-MAR-00 Chirag Mehta Created. |
142 | |
143 +-------------------------------------------------------------------------*/
144
145
146 FUNCTION is_cust_imp_valid(request_id IN NUMBER,
147 org_id IN NUMBER,
148 sob IN NUMBER,
149 user_id IN NUMBER,
150 application_id IN NUMBER,
151 language_id IN NUMBER,
152 program_id IN NUMBER,
153 prog_appl_id IN NUMBER,
154 last_update_login IN NUMBER,
155 int_table_name IN VARCHAR2) RETURN NUMBER;
156
157
158 /*-------------------------------------------------------------------------+
159 | PUBLIC PROCEDURE |
160 | copy_gdf_attributes |
161 | |
162 | PUBLIC VARIABLES |
163 | |
164 | DESCRIPTION |
165 | This is a stub module for copying global descriptive flex fields to |
166 | to JG Tables from Autoinvoice and Copy Transactions. |
167 | |
168 | The global descriptive flex field copy package |
169 | JL_BR_SPED_PKG is installed only when JG is installed. |
170 | |
171 | ARGUMENTS |
172 | p_request_id Request Id of Autoinvoice/Copy Transactions. |
173 | p_called_from Module Name of Autoinvoice/Copy Transactions. |
174 | |
175 | RETURNS |
176 | None |
177 | |
178 | NOTES |
179 | |
180 | EXAMPLE |
181 | ar_gdf_validation.copy_gdf_attributes(99999,'RAXTRX') |
182 | |
183 | MODIFICATION HISTORY |
184 | 26-Aug-08 Vijay Pusuluri Created. |
185 +-------------------------------------------------------------------------*/
186
187 PROCEDURE copy_gdf_attributes(p_request_id IN NUMBER,
188 p_called_from IN VARCHAR2);
189
190 /*-------------------------------------------------------------------------+
191 | PUBLIC PROCEDURE |
192 | insert_global_table |
193 | |
194 | DESCRIPTION |
195 | This is module for insertion of address related |
196 | records in globalization tables |
197 | for Globalizations. |
198 | |
199 | ARGUMENTS |
200 | p_address_id IN NUMBER |
201 | p_contributor_class_code IN VARCHAR2 |
202 | |
203 | NOTES |
204 | |
205 | EXAMPLE |
206 | |
207 | MODIFICATION HISTORY |
208 | 11-JUNE-00 Chirag Mehta Created. |
209 | |
210 +-------------------------------------------------------------------------*/
211
212
213
214 PROCEDURE insert_global_table(p_address_id IN NUMBER,
215 p_contributor_class_code IN VARCHAR2);
216
217 FUNCTION is_jg_installed RETURN VARCHAR2;
218
219 END AR_GDF_VALIDATION;
220
|
|
|