APPS.WSH_CARRIERS_PUB dependencies on WSH_CARRIER_SERVICES

Line 80: l_ship_method_code WSH_CARRIER_SERVICES.Ship_Method_Code%TYPE ;

76: l_freight_code WSH_CARRIERS.Freight_code%TYPE ;
77: l_org_info_tab WSH_CARRIERS_PUB.Org_Info_Tab_Type;
78: l_carrier_service_id NUMBER ;
79: l_carrier_service_info_tab Carrier_Ser_DFF_Tab_Type;
80: l_ship_method_code WSH_CARRIER_SERVICES.Ship_Method_Code%TYPE ;
81: l_ship_method WSH_CARRIER_SERVICES.Ship_Method_Meaning%TYPE ;
82: l_carrier_service_exists VARCHAR2(1);
83: l_shp_methods_dff WSH_CARRIERS_GRP.Ship_Method_Dff_Type;
84: l_rec_org_car_ser_tab WSH_CARRIERS_GRP.Org_Carrier_Service_Rec_Type;

Line 81: l_ship_method WSH_CARRIER_SERVICES.Ship_Method_Meaning%TYPE ;

77: l_org_info_tab WSH_CARRIERS_PUB.Org_Info_Tab_Type;
78: l_carrier_service_id NUMBER ;
79: l_carrier_service_info_tab Carrier_Ser_DFF_Tab_Type;
80: l_ship_method_code WSH_CARRIER_SERVICES.Ship_Method_Code%TYPE ;
81: l_ship_method WSH_CARRIER_SERVICES.Ship_Method_Meaning%TYPE ;
82: l_carrier_service_exists VARCHAR2(1);
83: l_shp_methods_dff WSH_CARRIERS_GRP.Ship_Method_Dff_Type;
84: l_rec_org_car_ser_tab WSH_CARRIERS_GRP.Org_Carrier_Service_Rec_Type;
85: l_rec_car_info_tab WSH_CARRIERS_GRP.Carrier_Info_Dff_Type; --Passed as null in grp API

Line 115: FROM WSH_CARRIER_SERVICES

111: ATTRIBUTE12,
112: ATTRIBUTE13,
113: ATTRIBUTE14,
114: ATTRIBUTE15
115: FROM WSH_CARRIER_SERVICES
116: WHERE carrier_service_id = l_carrier_service_id
117: AND enabled_flag = 'Y';
118:
119: --Cursor to fetch carrier_service_id and DFF.

Line 138: FROM WSH_CARRIER_SERVICES

134: ATTRIBUTE12,
135: ATTRIBUTE13,
136: ATTRIBUTE14,
137: ATTRIBUTE15
138: FROM WSH_CARRIER_SERVICES
139: WHERE ship_method_code = l_ship_method_code
140: AND enabled_flag = 'Y';
141:
142: --Cursor to fetch carrier service details

Line 161: FROM WSH_CARRIER_SERVICES

157: ATTRIBUTE12,
158: ATTRIBUTE13,
159: ATTRIBUTE14,
160: ATTRIBUTE15
161: FROM WSH_CARRIER_SERVICES
162: WHERE carrier_id = l_carrier_id
163: AND enabled_flag = 'Y';
164:
165: --

Line 307: wsh_debug_sv.log(l_module_name,'Fetching wsh_carrier_services data for Carrier Service Id',l_carrier_service_id);

303: --Carrier service validation
304: IF (l_carrier_service_id IS NOT NULL ) THEN
305: --{
306: IF l_debug_on THEN
307: wsh_debug_sv.log(l_module_name,'Fetching wsh_carrier_services data for Carrier Service Id',l_carrier_service_id);
308: END IF;
309: OPEN c_check_carrier_ser_exists(l_carrier_service_id);
310: FETCH c_check_carrier_ser_exists INTO l_carrier_service_info_tab(1);
311:

Line 348: wsh_debug_sv.log(l_module_name,'Fetching wsh_carrier_services data for ship method code',l_ship_method_code);

344: x_num_warnings => l_num_warnings,
345: x_num_errors => l_num_errors);
346:
347: IF l_debug_on THEN
348: wsh_debug_sv.log(l_module_name,'Fetching wsh_carrier_services data for ship method code',l_ship_method_code);
349: END IF;
350:
351: --Fetch carrier_serivce_id and corresponding DFF.
352: OPEN c_check_carrier_sm_exists (l_ship_method_code);