[Home] [Help]
PACKAGE: APPS.WSH_CREATE_CARRIERS_PKG
Source
1 PACKAGE WSH_CREATE_CARRIERS_PKG as
2 /* $Header: WSHCATHS.pls 120.0.12010000.1 2008/07/29 05:58:46 appldev ship $ */
3
4 -- Pack J Enhancement
5 TYPE CARecType IS RECORD(
6 CARRIER_ID WSH_CARRIERS.CARRIER_ID%TYPE
7 , SCAC_CODE WSH_CARRIERS.SCAC_CODE%TYPE
8 , FREIGHT_CODE WSH_CARRIERS.FREIGHT_CODE%TYPE
9 , MANIFESTING_ENABLED WSH_CARRIERS.MANIFESTING_ENABLED_FLAG%TYPE
10 , CURRENCY_CODE WSH_CARRIERS.CURRENCY_CODE%TYPE
11 , CARRIER_NAME HZ_PARTIES.PARTY_NAME%TYPE
12 , STATUS HZ_PARTIES.STATUS%TYPE
13 --
14 , ATTRIBUTE_CATEGORY WSH_CARRIERS.ATTRIBUTE_CATEGORY%TYPE
15 , ATTRIBUTE1 WSH_CARRIERS.ATTRIBUTE1%TYPE
16 , ATTRIBUTE2 WSH_CARRIERS.ATTRIBUTE2%TYPE
17 , ATTRIBUTE3 WSH_CARRIERS.ATTRIBUTE3%TYPE
18 , ATTRIBUTE4 WSH_CARRIERS.ATTRIBUTE4%TYPE
19 , ATTRIBUTE5 WSH_CARRIERS.ATTRIBUTE5%TYPE
20 , ATTRIBUTE6 WSH_CARRIERS.ATTRIBUTE6%TYPE
21 , ATTRIBUTE7 WSH_CARRIERS.ATTRIBUTE7%TYPE
22 , ATTRIBUTE8 WSH_CARRIERS.ATTRIBUTE8%TYPE
23 , ATTRIBUTE9 WSH_CARRIERS.ATTRIBUTE9%TYPE
24 , ATTRIBUTE10 WSH_CARRIERS.ATTRIBUTE10%TYPE
25 , ATTRIBUTE11 WSH_CARRIERS.ATTRIBUTE11%TYPE
26 , ATTRIBUTE12 WSH_CARRIERS.ATTRIBUTE12%TYPE
27 , ATTRIBUTE13 WSH_CARRIERS.ATTRIBUTE13%TYPE
28 , ATTRIBUTE14 WSH_CARRIERS.ATTRIBUTE14%TYPE
29 , ATTRIBUTE15 WSH_CARRIERS.ATTRIBUTE15%TYPE
30 --
31 , MAX_NUM_STOPS_PERMITTED WSH_CARRIERS.MAX_NUM_STOPS_PERMITTED%TYPE
32 , MAX_TOTAL_DISTANCE WSH_CARRIERS.MAX_TOTAL_DISTANCE%TYPE
33 , MAX_TOTAL_TIME WSH_CARRIERS.MAX_TOTAL_TIME%TYPE
34 , ALLOW_INTERSPERSE_LOAD WSH_CARRIERS.ALLOW_INTERSPERSE_LOAD%TYPE
35 , MAX_LAYOVER_TIME WSH_CARRIERS.MAX_LAYOVER_TIME%TYPE
36 , MIN_LAYOVER_TIME WSH_CARRIERS.MIN_LAYOVER_TIME%TYPE
37 , MAX_TOTAL_DISTANCE_IN_24HR WSH_CARRIERS.MAX_TOTAL_DISTANCE_IN_24HR%TYPE
38 , MAX_DRIVING_TIME_IN_24HR WSH_CARRIERS.MAX_DRIVING_TIME_IN_24HR%TYPE
39 , MAX_DUTY_TIME_IN_24HR WSH_CARRIERS.MAX_DUTY_TIME_IN_24HR%TYPE
40 , ALLOW_CONTINUOUS_MOVE WSH_CARRIERS.ALLOW_CONTINUOUS_MOVE%TYPE
41 , MAX_CM_DISTANCE WSH_CARRIERS.MAX_CM_DISTANCE%TYPE
42 , MAX_CM_TIME WSH_CARRIERS.MAX_CM_TIME%TYPE
43 , MAX_CM_DH_DISTANCE WSH_CARRIERS.MAX_CM_DH_DISTANCE%TYPE
44 , MAX_CM_DH_TIME WSH_CARRIERS.MAX_CM_DH_TIME%TYPE
45 , MAX_SIZE_WIDTH WSH_CARRIERS.MAX_SIZE_WIDTH%TYPE
46 , MAX_SIZE_HEIGHT WSH_CARRIERS.MAX_SIZE_HEIGHT%TYPE
47 , MAX_SIZE_LENGTH WSH_CARRIERS.MAX_SIZE_LENGTH%TYPE
48 , MIN_SIZE_WIDTH WSH_CARRIERS.MAX_SIZE_WIDTH%TYPE
49 , MIN_SIZE_HEIGHT WSH_CARRIERS.MAX_SIZE_HEIGHT%TYPE
50 , MIN_SIZE_LENGTH WSH_CARRIERS.MIN_SIZE_LENGTH%TYPE
51 , TIME_UOM WSH_CARRIERS.TIME_UOM%TYPE
52 , DIMENSION_UOM WSH_CARRIERS.DIMENSION_UOM%TYPE
53 , DISTANCE_UOM WSH_CARRIERS.DISTANCE_UOM%TYPE
54 , MAX_OUT_OF_ROUTE WSH_CARRIERS.MAX_OUT_OF_ROUTE%TYPE
55 , CM_FREE_DH_MILEAGE WSH_CARRIERS.CM_FREE_DH_MILEAGE%TYPE
56 , MIN_CM_DISTANCE WSH_CARRIERS.MIN_CM_DISTANCE%TYPE
57 , CM_FIRST_LOAD_DISCOUNT WSH_CARRIERS.CM_FIRST_LOAD_DISCOUNT%TYPE
58 , MIN_CM_TIME WSH_CARRIERS.MIN_CM_TIME%TYPE
59 , UNIT_RATE_BASIS WSH_CARRIERS.UNIT_RATE_BASIS%TYPE
60 , WEIGHT_UOM WSH_CARRIERS.WEIGHT_UOM%TYPE
61 , VOLUME_UOM WSH_CARRIERS.VOLUME_UOM%TYPE
62 , GENERIC_FLAG WSH_CARRIERS.GENERIC_FLAG%TYPE
63 , FREIGHT_BILL_AUTO_APPROVAL WSH_CARRIERS.FREIGHT_BILL_AUTO_APPROVAL%TYPE
64 , FREIGHT_AUDIT_LINE_LEVEL WSH_CARRIERS.FREIGHT_AUDIT_LINE_LEVEL%TYPE
65 , SUPPLIER_ID WSH_CARRIERS.SUPPLIER_ID%TYPE
66 , SUPPLIER_SITE_ID WSH_CARRIERS.SUPPLIER_SITE_ID%TYPE
67 , CM_RATE_VARIANT WSH_CARRIERS.CM_RATE_VARIANT%TYPE
68 , DISTANCE_CALCULATION_METHOD WSH_CARRIERS.DISTANCE_CALCULATION_METHOD%TYPE
69 , ORIGIN_DSTN_SURCHARGE_LEVEL WSH_CARRIERS.ORIGIN_DSTN_SURCHARGE_LEVEL%TYPE
70 -- R12 Code Changes
71 , DIM_DIMENSIONAL_FACTOR WSH_CARRIERS.DIM_DIMENSIONAL_FACTOR%TYPE
72 , DIM_WEIGHT_UOM WSH_CARRIERS.DIM_WEIGHT_UOM%TYPE
73 , DIM_VOLUME_UOM WSH_CARRIERS.DIM_VOLUME_UOM%TYPE
74 , DIM_DIMENSION_UOM WSH_CARRIERS.DIM_DIMENSION_UOM%TYPE
75 , DIM_MIN_PACK_VOL WSH_CARRIERS.DIM_MIN_PACK_VOL%TYPE
76 -- R12 Code Changes
77 );
78
79 TYPE Site_Rec_Type IS RECORD(
80 CARRIER_ID WSH_CARRIER_SITES.CARRIER_ID%TYPE,
81 CARRIER_SITE_ID WSH_CARRIER_SITES.CARRIER_SITE_ID%TYPE,
82 EMAIL_ADDRESS WSH_CARRIER_SITES.EMAIL_ADDRESS%TYPE,
83 AUTO_ACCEPT_LOAD_TENDER WSH_CARRIER_SITES.AUTO_ACCEPT_LOAD_TENDER%TYPE,
84 TENDER_WAIT_TIME WSH_CARRIER_SITES.TENDER_WAIT_TIME%TYPE,
85 WAIT_TIME_UOM WSH_CARRIER_SITES.WAIT_TIME_UOM%TYPE,
86 WEIGHT_THRESHOLD_UPPER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_UPPER%TYPE,
87 WEIGHT_THRESHOLD_LOWER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_LOWER%TYPE,
88 VOLUME_THRESHOLD_UPPER WSH_CARRIER_SITES.VOLUME_THRESHOLD_UPPER%TYPE,
89 VOLUME_THRESHOLD_LOWER WSH_CARRIER_SITES.VOLUME_THRESHOLD_LOWER%TYPE,
90 -- R12 Code Changes
91 ENABLE_AUTO_TENDER WSH_CARRIER_SITES.ENABLE_AUTO_TENDER%TYPE,
92 TENDER_TRANSMISSION_METHOD WSH_CARRIER_SITES.TENDER_TRANSMISSION_METHOD%TYPE
93 -- R12 Code Changes
94 );
95
96
97 PROCEDURE CREATE_CARRIERINFO (
98 P_Carrier_info IN CARecType,
99 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
100 X_ROWID OUT NOCOPY VARCHAR2,
101 X_CARRIER_PARTY_ID OUT NOCOPY NUMBER,
102 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
103 X_EXCEPTION_MSG OUT NOCOPY VARCHAR2,
104 X_POSITION OUT NOCOPY NUMBER,
105 X_PROCEDURE OUT NOCOPY VARCHAR2,
106 X_SQLERR OUT NOCOPY VARCHAR2,
107 X_SQL_CODE OUT NOCOPY VARCHAR2 );
108
109
110 PROCEDURE UPDATE_CARRIERINFO(
111 P_Carrier_info IN CARecType,
112 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
113 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
114 X_EXCEPTION_MSG OUT NOCOPY VARCHAR2,
115 X_PROCEDURE OUT NOCOPY VARCHAR2,
116 X_POSITION OUT NOCOPY NUMBER,
117 X_SQLERR OUT NOCOPY VARCHAR2,
118 X_SQL_CODE OUT NOCOPY VARCHAR2 );
119
120 PROCEDURE Lock_Carriers (
121 P_Carrier_info IN CARecType,
122 P_ROWID IN VARCHAR2,
123 X_RETURN_STATUS OUT NOCOPY VARCHAR2 );
124
125 PROCEDURE Create_Code_Assgn(
126 P_CARRIER_ID IN NUMBER,
127 P_CLASS_CODE IN VARCHAR2,
128 P_ENABLED IN VARCHAR2,
129 X_CODE_ASSIGNMENT_ID OUT NOCOPY NUMBER,
130 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
131 X_POSITION OUT NOCOPY NUMBER,
132 X_PROCEDURE OUT NOCOPY VARCHAR2,
133 X_EXCEPTION_MSG OUT NOCOPY VARCHAR2,
134 X_SQL_CODE OUT NOCOPY NUMBER,
135 X_SQLERR OUT NOCOPY VARCHAR2 );
136
137 PROCEDURE Update_Code_Assgn(
138 P_CLASS_CODE IN VARCHAR2,
139 P_ENABLED IN VARCHAR2,
140 P_CODE_ASSIGNMENT_ID IN NUMBER,
141 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
142 X_POSITION OUT NOCOPY NUMBER,
143 X_PROCEDURE OUT NOCOPY VARCHAR2,
144 X_EXCEPTION_MSG OUT NOCOPY VARCHAR2,
145 X_SQL_CODE OUT NOCOPY NUMBER,
146 X_SQLERR OUT NOCOPY VARCHAR2 );
147
148 PROCEDURE Get_Site_Trans_Details(
149 p_carrier_id IN NUMBER
150 , p_organization_id IN NUMBER
151 , x_site_trans_rec OUT NOCOPY Site_Rec_Type
152 , x_return_status OUT NOCOPY VARCHAR2 );
153
154 PROCEDURE Carrier_Deactivate(
155 p_carrier_id IN NUMBER
156 ,x_return_status OUT NOCOPY VARCHAR2
157 ,x_position OUT NOCOPY NUMBER
158 ,x_exception_msg OUT NOCOPY VARCHAR2
159 ,x_procedure OUT NOCOPY VARCHAR2
160 ,x_sqlerr OUT NOCOPY VARCHAR2
161 ,x_sql_code OUT NOCOPY VARCHAR2
162 );
163
164 END WSH_CREATE_CARRIERS_PKG;