[Home] [Help]
PACKAGE: APPS.WSH_CARRIER_SERVICES_PKG
Source
1 PACKAGE WSH_CARRIER_SERVICES_PKG as
2 /* $Header: WSHCVTHS.pls 120.1 2006/05/05 15:05:01 wrudge noship $ */
3
4 TYPE CSRecType IS RECORD (
5 Carrier_Service_id WSH_CARRIER_SERVICES.CARRIER_SERVICE_ID%TYPE
6 , Carrier_Id WSH_CARRIER_SERVICES.CARRIER_ID%TYPE
7 , mode_of_transport WSH_CARRIER_SERVICES.MODE_OF_TRANSPORT%TYPE
8 , Enabled_Flag WSH_CARRIER_SERVICES.ENABLED_FLAG%TYPE
9 , Web_Enabled WSH_CARRIER_SERVICES.WEB_ENABLED%TYPE
10 , service_level WSH_CARRIER_SERVICES.SERVICE_LEVEL%TYPE
11 , min_sl_time WSH_CARRIER_SERVICES.MIN_SL_TIME%TYPE
12 , max_sl_time WSH_CARRIER_SERVICES.MAX_SL_TIME%TYPE
13 , sl_time_uom WSH_CARRIER_SERVICES.SL_TIME_UOM%TYPE
14 , ship_method_code WSH_CARRIER_SERVICES.SHIP_METHOD_CODE%TYPE
15 , ship_method_meaning WSH_CARRIER_SERVICES.SHIP_METHOD_MEANING%TYPE
16 , ATTRIBUTE_CATEGORY WSH_CARRIER_SERVICES.ATTRIBUTE_CATEGORY%TYPE
17 , ATTRIBUTE1 WSH_CARRIER_SERVICES.ATTRIBUTE1%TYPE
18 , ATTRIBUTE2 WSH_CARRIER_SERVICES.ATTRIBUTE2%TYPE
19 , ATTRIBUTE3 WSH_CARRIER_SERVICES.ATTRIBUTE3%TYPE
20 , ATTRIBUTE4 WSH_CARRIER_SERVICES.ATTRIBUTE4%TYPE
21 , ATTRIBUTE5 WSH_CARRIER_SERVICES.ATTRIBUTE5%TYPE
22 , ATTRIBUTE6 WSH_CARRIER_SERVICES.ATTRIBUTE6%TYPE
23 , ATTRIBUTE7 WSH_CARRIER_SERVICES.ATTRIBUTE7%TYPE
24 , ATTRIBUTE8 WSH_CARRIER_SERVICES.ATTRIBUTE8%TYPE
25 , ATTRIBUTE9 WSH_CARRIER_SERVICES.ATTRIBUTE9%TYPE
26 , ATTRIBUTE10 WSH_CARRIER_SERVICES.ATTRIBUTE10%TYPE
27 , ATTRIBUTE11 WSH_CARRIER_SERVICES.ATTRIBUTE11%TYPE
28 , ATTRIBUTE12 WSH_CARRIER_SERVICES.ATTRIBUTE12%TYPE
29 , ATTRIBUTE13 WSH_CARRIER_SERVICES.ATTRIBUTE13%TYPE
30 , ATTRIBUTE14 WSH_CARRIER_SERVICES.ATTRIBUTE14%TYPE
31 , ATTRIBUTE15 WSH_CARRIER_SERVICES.ATTRIBUTE15%TYPE
32 , Creation_Date WSH_CARRIER_SERVICES.CREATION_DATE%TYPE
33 , Created_By WSH_CARRIER_SERVICES.CREATED_BY%TYPE
34 , Last_Update_Date WSH_CARRIER_SERVICES.LAST_UPDATE_DATE%TYPE
35 , Last_Updated_By WSH_CARRIER_SERVICES.LAST_UPDATED_BY%TYPE
36 , Last_Update_Login WSH_CARRIER_SERVICES.LAST_UPDATE_LOGIN%TYPE
37 , program_application_id WSH_CARRIER_SERVICES.PROGRAM_APPLICATION_ID%TYPE
38 , program_id WSH_CARRIER_SERVICES.PROGRAM_ID%TYPE
39 , program_update_date WSH_CARRIER_SERVICES.PROGRAM_UPDATE_DATE%TYPE
40 , request_id WSH_CARRIER_SERVICES.REQUEST_ID%TYPE
41 -- Pack J Enhancement
42 , MAX_NUM_STOPS_PERMITTED WSH_CARRIER_SERVICES.MAX_NUM_STOPS_PERMITTED%TYPE
43 , MAX_TOTAL_DISTANCE WSH_CARRIER_SERVICES.MAX_TOTAL_DISTANCE%TYPE
44 , MAX_TOTAL_TIME WSH_CARRIER_SERVICES.MAX_TOTAL_TIME%TYPE
45 , ALLOW_INTERSPERSE_LOAD WSH_CARRIER_SERVICES.ALLOW_INTERSPERSE_LOAD%TYPE
46 , MAX_LAYOVER_TIME WSH_CARRIER_SERVICES.MAX_LAYOVER_TIME%TYPE
47 , MIN_LAYOVER_TIME WSH_CARRIER_SERVICES.MIN_LAYOVER_TIME%TYPE
48 , MAX_TOTAL_DISTANCE_IN_24HR WSH_CARRIER_SERVICES.MAX_TOTAL_DISTANCE_IN_24HR%TYPE
49 , MAX_DRIVING_TIME_IN_24HR WSH_CARRIER_SERVICES.MAX_DRIVING_TIME_IN_24HR%TYPE
50 , MAX_DUTY_TIME_IN_24HR WSH_CARRIER_SERVICES.MAX_DUTY_TIME_IN_24HR%TYPE
51 , ALLOW_CONTINUOUS_MOVE WSH_CARRIER_SERVICES.ALLOW_CONTINUOUS_MOVE%TYPE
52 , MAX_CM_DISTANCE WSH_CARRIER_SERVICES.MAX_CM_DISTANCE%TYPE
53 , MAX_CM_TIME WSH_CARRIER_SERVICES.MAX_CM_TIME%TYPE
54 , MAX_CM_DH_DISTANCE WSH_CARRIER_SERVICES.MAX_CM_DH_DISTANCE%TYPE
55 , MAX_CM_DH_TIME WSH_CARRIER_SERVICES.MAX_CM_DH_TIME%TYPE
56 , MAX_SIZE_WIDTH WSH_CARRIER_SERVICES.MAX_SIZE_WIDTH%TYPE
57 , MAX_SIZE_HEIGHT WSH_CARRIER_SERVICES.MAX_SIZE_HEIGHT%TYPE
58 , MAX_SIZE_LENGTH WSH_CARRIER_SERVICES.MAX_SIZE_LENGTH%TYPE
59 , MIN_SIZE_WIDTH WSH_CARRIER_SERVICES.MIN_SIZE_WIDTH%TYPE
60 , MIN_SIZE_HEIGHT WSH_CARRIER_SERVICES.MIN_SIZE_HEIGHT%TYPE
61 , MIN_SIZE_LENGTH WSH_CARRIER_SERVICES.MIN_SIZE_LENGTH%TYPE
62 , MAX_OUT_OF_ROUTE WSH_CARRIER_SERVICES.MAX_OUT_OF_ROUTE%TYPE
63 , CM_FREE_DH_MILEAGE WSH_CARRIER_SERVICES.CM_FREE_DH_MILEAGE%TYPE
64 , MIN_CM_DISTANCE WSH_CARRIER_SERVICES.MIN_CM_DISTANCE%TYPE
65 , CM_FIRST_LOAD_DISCOUNT WSH_CARRIER_SERVICES.CM_FIRST_LOAD_DISCOUNT%TYPE
66 , MIN_CM_TIME WSH_CARRIER_SERVICES.MIN_CM_TIME%TYPE
67 , UNIT_RATE_BASIS WSH_CARRIER_SERVICES.UNIT_RATE_BASIS%TYPE
68 , CM_RATE_VARIANT WSH_CARRIER_SERVICES.CM_RATE_VARIANT%TYPE
69 , DISTANCE_CALCULATION_METHOD WSH_CARRIER_SERVICES.DISTANCE_CALCULATION_METHOD%TYPE
70 , ORIGIN_DSTN_SURCHARGE_LEVEL WSH_CARRIER_SERVICES.ORIGIN_DSTN_SURCHARGE_LEVEL%TYPE
71 -- R12 Code Changes
72 ,DIM_DIMENSIONAL_FACTOR WSH_CARRIER_SERVICES.DIM_DIMENSIONAL_FACTOR%TYPE
73 ,DIM_WEIGHT_UOM WSH_CARRIER_SERVICES.DIM_WEIGHT_UOM%TYPE
74 ,DIM_VOLUME_UOM WSH_CARRIER_SERVICES.DIM_VOLUME_UOM%TYPE
75 ,DIM_DIMENSION_UOM WSH_CARRIER_SERVICES.DIM_DIMENSION_UOM%TYPE
76 ,DIM_MIN_PACK_VOL WSH_CARRIER_SERVICES.DIM_MIN_PACK_VOL%TYPE
77 ,DEFAULT_VEHICLE_TYPE_ID WSH_CARRIER_SERVICES.DEFAULT_VEHICLE_TYPE_ID%TYPE
78 -- R12 Code Changes
79 -- ECO 5069719
80 ,UPDATE_MOT_SL WSH_CARRIER_SERVICES.UPDATE_MOT_SL%TYPE
81 );
82
83 PROCEDURE Create_Carrier_Service(
84 p_Carrier_Service_Info IN CSRecType DEFAULT NULL
85 , P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE
86 , x_Rowid OUT NOCOPY VARCHAR2
87 , x_Carrier_Service_id OUT NOCOPY NUMBER
88 , x_Return_Status OUT NOCOPY VARCHAR2
89 , x_position OUT NOCOPY NUMBER
90 , x_procedure OUT NOCOPY VARCHAR2
91 , x_sqlerr OUT NOCOPY VARCHAR2
92 , x_sql_code OUT NOCOPY VARCHAR2
93 );
94
95 PROCEDURE Lock_Carrier_Service (
96 p_rowid IN VARCHAR2
97 , p_Carrier_Service_Info IN CSRecType default null
98 , x_Return_Status OUT NOCOPY VARCHAR2
99 );
100
101 PROCEDURE Update_Carrier_Service(
102 p_rowid IN VARCHAR2
103 , p_Carrier_Service_Info IN CSRecType default null
104 , P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE
105 , x_Return_Status OUT NOCOPY VARCHAR2
106 , x_position OUT NOCOPY NUMBER
107 , x_procedure OUT NOCOPY VARCHAR2
108 , x_sqlerr OUT NOCOPY VARCHAR2
109 , x_sql_code OUT NOCOPY VARCHAR2
110 , x_exception_msg OUT NOCOPY VARCHAR2
111 );
112
113 PROCEDURE Car_Ser_Unassign_AllOrg(
114 p_carrier_service_id IN NUMBER
115 , p_ship_method_code IN VARCHAR2
116 , p_freight_code IN VARCHAR2
117 , x_return_status OUT NOCOPY VARCHAR2
118 , x_exception_msg OUT NOCOPY VARCHAR2
119 , x_position OUT NOCOPY NUMBER
120 , x_procedure OUT NOCOPY VARCHAR2
121 , x_sqlerr OUT NOCOPY VARCHAR2
122 , x_sql_code OUT NOCOPY VARCHAR2
123 );
124
125 END WSH_CARRIER_SERVICES_PKG;