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.XLE_BUSINESSINFO_GRP

Source


4 
1 PACKAGE XLE_BUSINESSINFO_GRP AUTHID CURRENT_USER AS
2 /* $Header: xlegbuis.pls 120.22 2005/10/21 15:31:58 spasupun ship $*/
3 
5 TYPE BG_LE_Rec IS RECORD (
6  Business_group_id  	HR_OPERATING_UNITS.business_group_id%TYPE,
7  LEGAL_ENTITY_ID  	XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
8  PARTY_ID    		XLE_ENTITY_PROFILES.party_id%TYPE
9 );
10 
11 
12 TYPE BG_LE_Tbl_Type IS TABLE OF BG_LE_Rec INDEX BY BINARY_INTEGER;
13 
14 
15 PROCEDURE Get_BusinessGroup_Info(
16     	x_return_status      OUT NOCOPY  VARCHAR2,
20         P_party_id   	     IN  XLE_ENTITY_PROFILES.party_id%TYPE,
17     	x_msg_count          OUT NOCOPY NUMBER,
18     	x_msg_data    	     OUT NOCOPY VARCHAR2,
19     	P_LegalEntity_ID     IN  XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
21         p_businessgroup_id   IN   hr_operating_units.business_group_id%type,
22         x_businessgroup_info OUT NOCOPY BG_LE_Tbl_Type
23     );
24 
25 
26 
27 TYPE LE_Ledger_Rec IS RECORD (
28    Ledger_ID               gl_ledgers.ledger_id%TYPE,
29    bal_seg_value           gl_ledger_norm_seg_vals.segment_value%type,
30    LEGAL_ENTITY_ID         XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
31    NAME                    XLE_ENTITY_PROFILES.NAME%TYPE,
32    PARTY_ID                XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
33    LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
34    TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
35    ACTIVITY_CODE           XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
36    sub_activity_code       XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
37    type_of_company         XLE_ENTITY_PROFILES.type_of_company%TYPE,
38    LE_EFFECTIVE_FROM       XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
39    LE_EFFECTIVE_TO         XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
40    REGISTRATION_NUMBER     XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
41    LEGISLATIVE_CATEGORY    XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
42    EFFECTIVE_FROM          XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
43    EFFECTIVE_TO            XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
44    ADDRESS_LINE_1          HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
45    ADDRESS_LINE_2          HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
46    ADDRESS_LINE_3          HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
47    TOWN_OR_CITY            HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
48    REGION_1 		   HR_LOCATIONS_ALL.REGION_1%TYPE,
49    REGION_2 		   HR_LOCATIONS_ALL.REGION_2%TYPE,
50    REGION_3 		   HR_LOCATIONS_ALL.REGION_3%TYPE,
51    POSTAL_CODE 	 	   HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
52    COUNTRY 		   HR_LOCATIONS_ALL.COUNTRY%TYPE
53 
54 );
55 
56 TYPE LE_Ledger_Rec_Type IS TABLE OF LE_Ledger_Rec INDEX BY BINARY_INTEGER;
57 
58 TYPE inv_org_Rec IS RECORD (
59    Inv_org_id                 org_organization_definitions.organization_id%type,
60    LEGAL_ENTITY_ID  		XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
61    NAME 			XLE_ENTITY_PROFILES.NAME%TYPE,
62    PARTY_ID 			XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
63    LEGAL_ENTITY_IDENTIFIER    XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
64    TRANSACTING_ENTITY_FLAG    XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
65    ACTIVITY_CODE 		XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
66    sub_activity_code 		XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
67    type_of_company 		XLE_ENTITY_PROFILES.type_of_company%TYPE,
68    LE_EFFECTIVE_FROM 		XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
69    LE_EFFECTIVE_TO 		XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
70    REGISTRATION_NUMBER 		XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
71    LEGISLATIVE_CATEGORY 	XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
72    EFFECTIVE_FROM 		XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
73    EFFECTIVE_TO 		XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
74    ADDRESS_LINE_1 		HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
75    ADDRESS_LINE_2 		HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
76    ADDRESS_LINE_3 		HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
77    TOWN_OR_CITY 		HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
78    REGION_1 			HR_LOCATIONS_ALL.REGION_1%TYPE,
79    REGION_2 			HR_LOCATIONS_ALL.REGION_2%TYPE,
80    REGION_3 			HR_LOCATIONS_ALL.REGION_3%TYPE,
81    POSTAL_CODE 			HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
82    COUNTRY 			HR_LOCATIONS_ALL.COUNTRY%TYPE
83 
84 );
85 
86 TYPE inv_org_Rec_Type IS TABLE OF inv_org_Rec INDEX BY BINARY_INTEGER;
87 
88 
89 TYPE OU_LE_Rec IS RECORD (
90    Operating_Unit_ID  		NUMBER,
91    LEGAL_ENTITY_ID  		XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
92    NAME 			XLE_ENTITY_PROFILES.NAME%TYPE,
93    PARTY_ID 			XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
94    LEGAL_ENTITY_IDENTIFIER     XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
95    TRANSACTING_ENTITY_FLAG     XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
96    ACTIVITY_CODE 		XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
97    sub_activity_code 		XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
98    type_of_company 		XLE_ENTITY_PROFILES.type_of_company%TYPE,
99    LE_EFFECTIVE_FROM 		XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
100    LE_EFFECTIVE_TO 		XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
101    REGISTRATION_NUMBER 		XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
102    LEGISLATIVE_CATEGORY 	XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
103    EFFECTIVE_FROM 		XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
104    EFFECTIVE_TO 		XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
105    ADDRESS_LINE_1 		HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
106    ADDRESS_LINE_2 		HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
107    ADDRESS_LINE_3 		HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
108    TOWN_OR_CITY		 	HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
109    REGION_1 			HR_LOCATIONS_ALL.REGION_1%TYPE,
110    REGION_2 			HR_LOCATIONS_ALL.REGION_2%TYPE,
111    REGION_3 			HR_LOCATIONS_ALL.REGION_3%TYPE,
112    POSTAL_CODE 			HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
113    COUNTRY 			HR_LOCATIONS_ALL.COUNTRY%TYPE
114 );
115 
116 TYPE OU_LE_Tbl_Type IS TABLE OF OU_LE_Rec INDEX BY BINARY_INTEGER;
117 
118 
119 PROCEDURE Get_Ledger_Info(
120                       x_return_status   OUT  NOCOPY VARCHAR2,
121                       x_msg_data    	OUT  NOCOPY VARCHAR2,
122                       P_Ledger_ID    	IN   NUMBER,
123                       x_Ledger_info 	OUT  NOCOPY LE_Ledger_Rec_Type
124     );
125 
126 PROCEDURE Get_Ledger_Info(
127                       x_return_status   OUT NOCOPY VARCHAR2,
128                       x_msg_data    	OUT NOCOPY VARCHAR2,
132     );
129                       P_Ledger_ID    	IN  NUMBER,
130                       P_BSV    		IN  Varchar2,
131                       x_Ledger_info 	OUT NOCOPY LE_Ledger_Rec_Type
133 /*
134 PROCEDURE Get_Ledger_Info(
135                       x_return_status         OUT VARCHAR2,
136                       x_msg_data    OUT  VARCHAR2,
140     );
137                       p_party_id    IN NUMBER,
138                       p_LegalEntity_ID IN Number,
139                       x_Ledger_info OUT LE_Ledger_Rec_Type
141 
142    */
143 
144 PROCEDURE Get_OperatingUnit_Info(
145                       x_return_status         OUT NOCOPY VARCHAR2,
146                       x_msg_data    OUT  NOCOPY VARCHAR2,
147                       p_operating_unit    IN NUMBER,
148                       p_legal_entity_id   IN NUMBER,
149                       p_party_id   IN NUMBER,
150                       x_ou_le_info OUT NOCOPY OU_LE_Tbl_Type
151     );
152 
153 
154 PROCEDURE Get_InvOrg_Info(
155                       x_return_status  OUT NOCOPY VARCHAR2,
156                       x_msg_data       OUT  NOCOPY VARCHAR2,
157                       P_InvOrg_ID      IN NUMBER,
158 		      P_Le_ID          IN NUMBER,
159 		      P_Party_ID       IN NUMBER,
163 
160                       x_Inv_Le_info OUT NOCOPY inv_org_Rec_Type
161     );
162 
164 FUNCTION Get_Le_Id_Mfg(p_operating_unit   IN NUMBER,
165                        p_transaction_type IN NUMBER,
166                        p_customer_account IN NUMBER)
167 RETURN NUMBER;
168 
169 TYPE ccid_le_Rec IS RECORD (
170    Ledger_ID  			gl_ledgers.ledger_id%TYPE,
171    ccid 			gl_code_combinations.code_combination_id%type,
172    LEGAL_ENTITY_ID  		XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
173    NAME 			XLE_ENTITY_PROFILES.NAME%TYPE,
174    PARTY_ID 			XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
175    LEGAL_ENTITY_IDENTIFIER    XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
176    TRANSACTING_ENTITY_FLAG    XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
177    ACTIVITY_CODE 		XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
178    sub_activity_code 		XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
179    type_of_company 		XLE_ENTITY_PROFILES.type_of_company%TYPE,
180    LE_EFFECTIVE_FROM 		XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
181    LE_EFFECTIVE_TO	 	XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
182    REGISTRATION_NUMBER 		XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
183    LEGISLATIVE_CATEGORY 	XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
184    EFFECTIVE_FROM 		XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
185    EFFECTIVE_TO 		XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
186    ADDRESS_STYLE 		HR_LOCATIONS_ALL.STYLE%TYPE,
187    ADDRESS_LINE_1 		HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
188    ADDRESS_LINE_2	 	HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
189    ADDRESS_LINE_3 		HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
190    TOWN_OR_CITY 		HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
191    REGION_1 			HR_LOCATIONS_ALL.REGION_1%TYPE,
192    REGION_2 			HR_LOCATIONS_ALL.REGION_2%TYPE,
193    REGION_3 			HR_LOCATIONS_ALL.REGION_3%TYPE,
194    POSTAL_CODE 			HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
195    COUNTRY 			HR_LOCATIONS_ALL.COUNTRY%TYPE,
196    ATTRIBUTE1 			HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
197    ATTRIBUTE2 			HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
198    ATTRIBUTE3 			HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
199    ATTRIBUTE4 			HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
200    ATTRIBUTE5 			HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
201    ATTRIBUTE6 			HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
202    ATTRIBUTE7 			HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
203    ATTRIBUTE8 			HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
204    ATTRIBUTE9 			HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
205    ATTRIBUTE10 			HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
206    ATTRIBUTE11 			HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
207    ATTRIBUTE12 			HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
208    ATTRIBUTE13 			HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
209    ATTRIBUTE14 			HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
210    ATTRIBUTE15 			HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
211    ATTRIBUTE16 			HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
212    ATTRIBUTE17 			HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
213    ATTRIBUTE18 			HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,
214    ATTRIBUTE19 			HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,
215    ATTRIBUTE20 			HR_LOCATIONS_ALL.ATTRIBUTE20%TYPE
216 );
217 
218 TYPE ccid_le_Rec_Type IS TABLE OF ccid_le_Rec INDEX BY BINARY_INTEGER;
219 
220 PROCEDURE Get_CCID_Info(
221                 x_return_status         OUT NOCOPY VARCHAR2,
222                 x_msg_data    OUT NOCOPY VARCHAR2,
223                 P_operating_unit_ID    IN NUMBER,
224                 P_code_combination_id    IN Number,
225                 x_ccid_le_info OUT NOCOPY XLE_BUSINESSINFO_GRP.ccid_le_Rec_Type
226     ) ;
227 
228 TYPE ptop_le_Rec IS RECORD (
229    LEGAL_ENTITY_ID  	   XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
230    NAME                    XLE_ENTITY_PROFILES.NAME%TYPE,
231    PARTY_ID                XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
232    LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
233    TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
234    ACTIVITY_CODE           XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
235    sub_activity_code       XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
236    type_of_company         XLE_ENTITY_PROFILES.type_of_company%TYPE,
237    LE_EFFECTIVE_FROM       XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
238    LE_EFFECTIVE_TO         XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
239    REGISTRATION_NUMBER     XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
240    LEGISLATIVE_CATEGORY    XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
241    EFFECTIVE_FROM          XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
242    EFFECTIVE_TO            XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
243    ADDRESS_LINE_1          HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
244    ADDRESS_LINE_2          HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
245    ADDRESS_LINE_3 	   HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
246    TOWN_OR_CITY            HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
247    REGION_1                HR_LOCATIONS_ALL.REGION_1%TYPE,
248    REGION_2 		   HR_LOCATIONS_ALL.REGION_2%TYPE,
249    REGION_3 		   HR_LOCATIONS_ALL.REGION_3%TYPE,
250    POSTAL_CODE   	   HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
251    COUNTRY    		   HR_LOCATIONS_ALL.COUNTRY%TYPE
252 );
253 
254 PROCEDURE Get_PurchasetoPay_Info(
255                   x_return_status  	OUT NOCOPY VARCHAR2,
256                   x_msg_data       	OUT  NOCOPY VARCHAR2,
257                   P_registration_code   IN VARCHAR2 DEFAULT NULL,
258                   P_registration_number IN VARCHAR2 DEFAULT NULL,
259                   P_location_id 	IN NUMBER DEFAULT NULL,
260                   P_code_combination_id IN NUMBER DEFAULT NULL,
261                   P_operating_unit_id 	IN NUMBER,
262                   x_ptop_Le_info OUT NOCOPY XLE_BUSINESSINFO_GRP.ptop_le_rec);
263 
267    PARTY_ID 			XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
264 TYPE otoc_le_rec IS RECORD (
265    LEGAL_ENTITY_ID  		XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
266    NAME 			XLE_ENTITY_PROFILES.NAME%TYPE,
271    sub_activity_code 		XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
268    LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
269    TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
270    ACTIVITY_CODE 		XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
272    type_of_company 		XLE_ENTITY_PROFILES.type_of_company%TYPE,
273    LE_EFFECTIVE_FROM 		XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
274    LE_EFFECTIVE_TO 		XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
275    REGISTRATION_NUMBER 		XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
276    LEGISLATIVE_CATEGORY 	XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
277    EFFECTIVE_FROM 		XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
278    EFFECTIVE_TO 		XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
279    ADDRESS_STYLE 		HR_LOCATIONS_ALL.STYLE%TYPE,
280    ADDRESS_LINE_1 		HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
281    ADDRESS_LINE_2 		HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
282    ADDRESS_LINE_3 		HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
283    TOWN_OR_CITY 		HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
284    REGION_1 			HR_LOCATIONS_ALL.REGION_1%TYPE,
285    REGION_2 			HR_LOCATIONS_ALL.REGION_2%TYPE,
286    REGION_3 			HR_LOCATIONS_ALL.REGION_3%TYPE,
287    POSTAL_CODE 			HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
288    COUNTRY 			HR_LOCATIONS_ALL.COUNTRY%TYPE,
289    ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
290    ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
291    ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
292    ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
293    ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
294    ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
295    ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
296    ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
297    ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
298    ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
299    ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
300    ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
301    ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
302    ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
303    ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
304    ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
305    ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
306    ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,
307    ATTRIBUTE19 HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,
308    ATTRIBUTE20 HR_LOCATIONS_ALL.ATTRIBUTE20%TYPE
309 );
310 
311 PROCEDURE Get_OrdertoCash_Info(
312              x_return_status       OUT NOCOPY VARCHAR2,
313              x_msg_data            OUT  NOCOPY VARCHAR2,
314              P_customer_type       IN VARCHAR2 DEFAULT NULL,
315              P_customer_id         IN NUMBER DEFAULT NULL,
316              P_transaction_type_id IN NUMBER DEFAULT NULL,
317              P_batch_source_id     IN  NUMBER DEFAULT NULL,
318              P_operating_unit_id   IN NUMBER ,
319              x_otoc_Le_info        OUT NOCOPY XLE_BUSINESSINFO_GRP.otoc_le_rec);
320 
321 FUNCTION Get_OrdertoCash_Info(
322                       P_customer_type 		IN VARCHAR2 DEFAULT NULL,
323                       P_customer_id 		IN NUMBER DEFAULT NULL,
324                       P_transaction_type_id     IN NUMBER DEFAULT NULL,
325                       P_batch_source_id 	IN  NUMBER DEFAULT NULL,
326                       P_operating_unit_id 	IN NUMBER
327                       )
328 RETURN NUMBER;
329 
330 FUNCTION Get_OrdertoCash_Info(
331                       x_return_status  OUT NOCOPY VARCHAR2,
332                       x_msg_data       OUT  NOCOPY VARCHAR2,
333                       P_customer_type IN VARCHAR2 DEFAULT NULL,
334                       P_customer_id IN NUMBER DEFAULT NULL,
335                       P_transaction_type_id     IN NUMBER DEFAULT NULL,
336                       P_batch_source_id IN  NUMBER DEFAULT NULL,
337                       P_operating_unit_id IN NUMBER
338                       )
339 RETURN NUMBER;
340 
341 END;