[Home] [Help]
PACKAGE: APPS.WSH_ORG_CARRIER_SITES_PKG
Source
1 PACKAGE WSH_ORG_CARRIER_SITES_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHOSTHS.pls 115.1 2002/11/13 20:11:37 nparikh noship $ */
3
4 TYPE OCSRecType IS RECORD (
5 Carrier_site_id NUMBER
6 , Organization_id NUMBER
7 , Enabled_Flag VARCHAR2(1)
8 , ATTRIBUTE_CATEGORY VARCHAR2(150)
9 , ATTRIBUTE1 VARCHAR2(150)
10 , ATTRIBUTE2 VARCHAR2(150)
11 , ATTRIBUTE3 VARCHAR2(150)
12 , ATTRIBUTE4 VARCHAR2(150)
13 , ATTRIBUTE5 VARCHAR2(150)
14 , ATTRIBUTE6 VARCHAR2(150)
15 , ATTRIBUTE7 VARCHAR2(150)
16 , ATTRIBUTE8 VARCHAR2(150)
17 , ATTRIBUTE9 VARCHAR2(150)
18 , ATTRIBUTE10 VARCHAR2(150)
19 , ATTRIBUTE11 VARCHAR2(150)
20 , ATTRIBUTE12 VARCHAR2(150)
21 , ATTRIBUTE13 VARCHAR2(150)
22 , ATTRIBUTE14 VARCHAR2(150)
23 , ATTRIBUTE15 VARCHAR2(150)
24 , Creation_Date DATE
25 , Created_By NUMBER
26 , Last_Update_Date DATE
27 , Last_Updated_By NUMBER
28 , Last_Update_Login NUMBER
29 , program_application_id NUMBER
30 , program_id NUMBER
31 , program_update_date DATE
32 , request_id NUMBER
33 );
34
35 PROCEDURE assign_org_carrier_site(
36 p_Org_Carrier_Site_info IN OCSRecType
37 , x_Rowid IN OUT NOCOPY VARCHAR2
38 , x_Org_Carrier_site_id IN OUT NOCOPY NUMBER
39 , x_Return_Status OUT NOCOPY VARCHAR2
40 , x_position OUT NOCOPY VARCHAR2
41 , x_procedure OUT NOCOPY VARCHAR2
42 , x_sqlerr OUT NOCOPY VARCHAR2
43 , x_sql_code OUT NOCOPY VARCHAR2
44 , x_exception_msg OUT NOCOPY VARCHAR2
45 );
46
47 PROCEDURE Lock_Org_Carrier_site (
48 p_rowid IN VARCHAR2
49 , p_Org_Carrier_site_info IN OCSRecType
50 , x_Return_Status OUT NOCOPY VARCHAR2
51 );
52
53 END WSH_ORG_CARRIER_SITES_PKG;