PACKAGE: APPS.WSH_ORG_CARRIER_SERVICES_PKG

Source

1 PACKAGE WSH_ORG_CARRIER_SERVICES_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHOCTHS.pls 115.4 2003/12/08 12:10:46 msutar ship $ */
3 
4 TYPE OCSRecType IS RECORD (
5   Carrier_service_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 , DISTRIBUTION_ACCOUNT           NUMBER        DEFAULT NULL -- BugFix#3296461
34 );
35 
36 TYPE CarRecType IS RECORD (
37   P_FREIGHT_CODE                 VARCHAR2(30)
38 , P_CARRIER_NAME                 VARCHAR2(80)
39 , ATTRIBUTE_CATEGORY             VARCHAR2(150)
40 , ATTRIBUTE1                     VARCHAR2(150)
41 , ATTRIBUTE2                     VARCHAR2(150)
42 , ATTRIBUTE3                     VARCHAR2(150)
43 , ATTRIBUTE4                     VARCHAR2(150)
44 , ATTRIBUTE5                     VARCHAR2(150)
45 , ATTRIBUTE6                     VARCHAR2(150)
46 , ATTRIBUTE7                     VARCHAR2(150)
47 , ATTRIBUTE8                     VARCHAR2(150)
48 , ATTRIBUTE9                     VARCHAR2(150)
49 , ATTRIBUTE10                    VARCHAR2(150)
50 , ATTRIBUTE11                    VARCHAR2(150)
51 , ATTRIBUTE12                    VARCHAR2(150)
52 , ATTRIBUTE13                    VARCHAR2(150)
53 , ATTRIBUTE14                    VARCHAR2(150)
54 , ATTRIBUTE15                    VARCHAR2(150)
55 , Creation_Date                  DATE
56 , Created_By                     NUMBER
57 , Last_Update_Date               DATE
58 , Last_Updated_By                NUMBER
59 , Last_Update_Login              NUMBER
60 );
61 
62 PROCEDURE assign_org_carrier_service(
63   p_Org_Carrier_Service_info       IN OCSRecType
64 , p_carrier_info                   IN CarRecType
65 , p_csm_info                       IN WSH_CARRIER_SHIP_METHODS_PKG.CSMRecType
66 , P_COMMIT                    IN  VARCHAR2 DEFAULT FND_API.G_FALSE
67 , x_Rowid            		     IN OUT NOCOPY  VARCHAR2
68 , x_Org_Carrier_Service_id         IN OUT NOCOPY  NUMBER
69 , x_Return_Status                     OUT NOCOPY  VARCHAR2
70 , x_position                          OUT NOCOPY  VARCHAR2
71 , x_procedure                         OUT NOCOPY  VARCHAR2
72 , x_sqlerr                            OUT NOCOPY  VARCHAR2
73 , x_sql_code                          OUT NOCOPY  VARCHAR2
74 , x_exception_msg                     OUT NOCOPY  VARCHAR2
75 );
76 
77 PROCEDURE Lock_Org_Carrier_Service (
78   p_rowid                          IN     VARCHAR2
79 , p_Org_Carrier_Service_info       IN     OCSRecType
80 , x_Return_Status                  OUT NOCOPY     VARCHAR2
81 );
82 
83 END WSH_ORG_CARRIER_SERVICES_PKG;