DBA Data[Home] [Help]

APPS.WSH_CARRIERS_PUB dependencies on WSH_CARRIERS_GRP

Line 68: x_car_out_rec_tab OUT NOCOPY wsh_carriers_grp.Org_Carrier_Ser_Out_Tab_Type,

64: p_freight_code IN VARCHAR2 DEFAULT NULL,
65: p_carrier_service_id IN NUMBER DEFAULT NULL,
66: p_ship_method_code IN VARCHAR2 DEFAULT NULL,
67: p_ship_method IN VARCHAR2 DEFAULT NULL,
68: x_car_out_rec_tab OUT NOCOPY wsh_carriers_grp.Org_Carrier_Ser_Out_Tab_Type,
69: x_return_status OUT NOCOPY VARCHAR2,
70: x_msg_count OUT NOCOPY NUMBER,
71: x_msg_data OUT NOCOPY VARCHAR2 )
72: IS

Line 83: l_shp_methods_dff WSH_CARRIERS_GRP.Ship_Method_Dff_Type;

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
86: l_car_ser_out_rec WSH_CARRIERS_GRP.Org_Carrier_Ser_Out_Rec_Type;
87: l_param_name VARCHAR2(100);

Line 84: l_rec_org_car_ser_tab WSH_CARRIERS_GRP.Org_Carrier_Service_Rec_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
86: l_car_ser_out_rec WSH_CARRIERS_GRP.Org_Carrier_Ser_Out_Rec_Type;
87: l_param_name VARCHAR2(100);
88: l_num_errors NUMBER ;

Line 85: l_rec_car_info_tab WSH_CARRIERS_GRP.Carrier_Info_Dff_Type; --Passed as null in grp API

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
86: l_car_ser_out_rec WSH_CARRIERS_GRP.Org_Carrier_Ser_Out_Rec_Type;
87: l_param_name VARCHAR2(100);
88: l_num_errors NUMBER ;
89: l_num_warnings NUMBER ;

Line 86: l_car_ser_out_rec WSH_CARRIERS_GRP.Org_Carrier_Ser_Out_Rec_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
86: l_car_ser_out_rec WSH_CARRIERS_GRP.Org_Carrier_Ser_Out_Rec_Type;
87: l_param_name VARCHAR2(100);
88: l_num_errors NUMBER ;
89: l_num_warnings NUMBER ;
90: l_return_status VARCHAR2(10);

Line 431: wsh_debug_sv.logmsg(l_module_name,'Calling WSH_CARRIERS_GRP.Assign_Org_Carrier_Service',WSH_DEBUG_SV.C_PROC_LEVEL);

427:
428: IF l_debug_on THEN
429: wsh_debug_sv.log(l_module_name,'Carrier_service_id',l_carrier_service_info_tab(l_index).carrier_service_id);
430: wsh_debug_sv.log(l_module_name,'Organization_id',l_rec_org_car_ser_tab.ORGANIZATION_ID);
431: wsh_debug_sv.logmsg(l_module_name,'Calling WSH_CARRIERS_GRP.Assign_Org_Carrier_Service',WSH_DEBUG_SV.C_PROC_LEVEL);
432: END IF;
433:
434: WSH_CARRIERS_GRP.Assign_Org_Carrier_Service(
435: p_api_version_number => p_api_version_number,

Line 434: WSH_CARRIERS_GRP.Assign_Org_Carrier_Service(

430: wsh_debug_sv.log(l_module_name,'Organization_id',l_rec_org_car_ser_tab.ORGANIZATION_ID);
431: wsh_debug_sv.logmsg(l_module_name,'Calling WSH_CARRIERS_GRP.Assign_Org_Carrier_Service',WSH_DEBUG_SV.C_PROC_LEVEL);
432: END IF;
433:
434: WSH_CARRIERS_GRP.Assign_Org_Carrier_Service(
435: p_api_version_number => p_api_version_number,
436: p_init_msg_list => p_init_msg_list,
437: p_commit => p_commit,
438: p_action_code => p_action_code,

Line 448: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_CARRIERS_GRP.Assign_Org_Carrier_Service',l_return_status);

444: x_msg_count => l_msg_count,
445: x_msg_data => l_msg_data );
446:
447: IF l_debug_on THEN
448: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_CARRIERS_GRP.Assign_Org_Carrier_Service',l_return_status);
449: END IF;
450:
451: WSH_UTIL_CORE.api_post_call(
452: p_return_status => l_return_status,