PACKAGE: APPS.WSH_CARRIER_VEHICLE_TYPES_PKG

Source

1 PACKAGE WSH_CARRIER_VEHICLE_TYPES_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHVTTHS.pls 115.0 2003/06/26 10:58:19 msutar noship $ */
3 
4 TYPE CVTRecType IS RECORD(
5 CARRIER_ID 		NUMBER,
6 VEHICLE_TYPE_ID 	NUMBER,
7 ASSIGNED_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 );
30 
31 PROCEDURE Create_Carrier_Vehicle_Type (
32    P_Carrier_Vehicle_Info      IN  CVTRecType,
33    X_ROWID                     OUT NOCOPY  VARCHAR2,
34    X_RETURN_STATUS             OUT NOCOPY  VARCHAR2,
35    X_EXCEPTION_MSG             OUT NOCOPY  VARCHAR2,
36    X_POSITION                  OUT NOCOPY  NUMBER,
37    X_PROCEDURE                 OUT NOCOPY  VARCHAR2,
38    X_SQLERR                    OUT NOCOPY  VARCHAR2,
39    X_SQL_CODE                  OUT NOCOPY  VARCHAR2 );
40 
41 
42 PROCEDURE Update_Carrier_Vehicle_Type(
43    P_Carrier_Vehicle_Info          IN  CVTRecType,
44    P_ROWID                         IN  VARCHAR2,
45    X_RETURN_STATUS                 OUT NOCOPY  VARCHAR2,
46    X_EXCEPTION_MSG                 OUT NOCOPY  VARCHAR2,
47    X_PROCEDURE                     OUT NOCOPY  VARCHAR2,
48    X_POSITION                      OUT NOCOPY  NUMBER,
49    X_SQLERR                        OUT NOCOPY  VARCHAR2,
50    X_SQL_CODE                      OUT NOCOPY  VARCHAR2 );
51 
52 PROCEDURE Lock_Carrier_Vehicle_Type (
53    P_Carrier_Vehicle_Info IN  CVTRecType,
54    P_ROWID                IN  VARCHAR2,
55    X_RETURN_STATUS        OUT NOCOPY  VARCHAR2 );
56 
57 END WSH_CARRIER_VEHICLE_TYPES_PKG;