1 PACKAGE RRS_SITES_PKG AS
2 /* $Header: RRSSTPKS.pls 120.2 2005/11/21 05:39:09 pfarkade noship $ */
3
4 PROCEDURE CREATE_PROPERTY_LOCATIONS
5 (errbuf OUT NOCOPY VARCHAR2
6 ,retcode OUT NOCOPY VARCHAR2
7 ,p_batch_name IN VARCHAR2
8 ,p_org_id IN NUMBER
9 ) ;
10
11 PROCEDURE CREATE_PROPERTY_LOCATIONS_WRP
12 (p_batch_name IN VARCHAR2
13 ,p_org_id IN NUMBER
14 ,x_request_id OUT NOCOPY NUMBER
15 ,x_return_status OUT NOCOPY VARCHAR2
16 ,x_msg_count OUT NOCOPY NUMBER
17 ,x_msg_data OUT NOCOPY VARCHAR2
18 ) ;
19
20 PROCEDURE CREATE_PROPERTY_LOCATIONS_CONC
21 (p_batch_name IN VARCHAR2
22 ,p_org_id IN NUMBER
23 ,x_request_id OUT NOCOPY NUMBER
24 ,x_return_status OUT NOCOPY VARCHAR2
25 ,x_msg_count OUT NOCOPY NUMBER
26 ,x_msg_data OUT NOCOPY VARCHAR2
27 ) ;
28
29 PROCEDURE DELETE_TEMPLATE
30 (
31 p_site_id IN NUMBER
32 );
33
34 --Bug 4742710
35 PROCEDURE GET_COUNTRYCODE
36 (
37 p_location_id IN NUMBER
38 ,x_country_code OUT NOCOPY VARCHAR2
39 ,x_country_name OUT NOCOPY VARCHAR2
40 );
41
42 END RRS_SITES_PKG;
43