PACKAGE: APPS.WSH_CARRIER_SHIP_METHODS_PKG

Source

1 PACKAGE WSH_CARRIER_SHIP_METHODS_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHCSTHS.pls 115.11 2002/11/18 20:12:36 nparikh ship $ */
3 
4 TYPE CSMRecType IS RECORD (
5   Carrier_Ship_Method_id         NUMBER
6 , Carrier_Id                     NUMBER
7 , ship_method_code               VARCHAR2(30)
8 , freight_code                   VARCHAR2(30)
9 , service_level			   VARCHAR2(30)
10 , carrier_site_id                NUMBER
11 , organization_id                NUMBER
12 , Enabled_Flag                   VARCHAR2(1)
13 , ATTRIBUTE_CATEGORY             VARCHAR2(150)
14 , ATTRIBUTE1                     VARCHAR2(150)
15 , ATTRIBUTE2                     VARCHAR2(150)
16 , ATTRIBUTE3                     VARCHAR2(150)
17 , ATTRIBUTE4                     VARCHAR2(150)
18 , ATTRIBUTE5                     VARCHAR2(150)
19 , ATTRIBUTE6                     VARCHAR2(150)
20 , ATTRIBUTE7                     VARCHAR2(150)
21 , ATTRIBUTE8                     VARCHAR2(150)
22 , ATTRIBUTE9                     VARCHAR2(150)
23 , ATTRIBUTE10                    VARCHAR2(150)
24 , ATTRIBUTE11                    VARCHAR2(150)
25 , ATTRIBUTE12                    VARCHAR2(150)
26 , ATTRIBUTE13                    VARCHAR2(150)
27 , ATTRIBUTE14                    VARCHAR2(150)
28 , ATTRIBUTE15                    VARCHAR2(150)
29 , Creation_Date                  DATE
30 , Created_By                     NUMBER
31 , Last_Update_Date               DATE
32 , Last_Updated_By                NUMBER
33 , Last_Update_Login              NUMBER
34 , Web_Enabled			 VARCHAR2(1)
35 );
36 
37 PROCEDURE Create_Carrier_Ship_Method(
38   p_Carrier_Ship_Method_Info       IN     CSMRecType
39 , x_Rowid            					  OUT NOCOPY  VARCHAR2
40 , x_Carrier_Ship_Method_id            OUT NOCOPY  NUMBER
41 , x_Return_Status                     OUT NOCOPY  VARCHAR2
42 );
43 
44 PROCEDURE Lock_Carrier_Ship_Method (
45   p_rowid                          IN     VARCHAR2
46 , p_Carrier_Ship_Method_Info       IN     CSMRecType
47 , x_Return_Status                     OUT NOCOPY  VARCHAR2
48 );
49 
50 PROCEDURE Update_Carrier_Ship_Method(
51   p_rowid                          IN     VARCHAR2
52 , p_Carrier_Ship_Method_Info       IN     CSMRecType
53 , x_Return_Status                     OUT NOCOPY  VARCHAR2
54 );
55 
56 PROCEDURE Delete_Carrier_Ship_Method(
57   p_rowid                          IN     VARCHAR2 := NULL
58 , p_carrier_ship_method_id         IN     NUMBER
59 , x_Return_Status                     OUT NOCOPY  VARCHAR2
60 );
61 
62 END WSH_CARRIER_SHIP_METHODS_PKG;