eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_CARRIERS_PUB dependencies on WSH_CARRIERS

Line 1: PACKAGE BODY WSH_CARRIERS_PUB AS

1: PACKAGE BODY WSH_CARRIERS_PUB AS
2: /* $Header: WSHCAPBB.pls 120.0.12010000.2 2010/06/14 12:43:57 gbhargav noship $ */
3:
4: --===================
5: -- CONSTANTS

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_CARRIERS_PUB';

3:
4: --===================
5: -- CONSTANTS
6: --===================
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_CARRIERS_PUB';
8:
9: --===================
10: -- PROCEDURES
11: --===================

Line 62: p_org_info_tab IN WSH_CARRIERS_PUB.Org_Info_Tab_Type,

58: ( p_api_version_number IN NUMBER,
59: p_init_msg_list IN VARCHAR2,
60: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
61: p_action_code IN VARCHAR2,
62: p_org_info_tab IN WSH_CARRIERS_PUB.Org_Info_Tab_Type,
63: p_carrier_id IN NUMBER DEFAULT NULL,
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,

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 76: l_freight_code WSH_CARRIERS.Freight_code%TYPE ;

72: IS
73: l_api_version_number CONSTANT NUMBER :=1.0 ;
74: l_api_name CONSTANT VARCHAR2(30):= 'Assign_Org_Carrier_Service';
75: l_carrier_id NUMBER ;
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 ;

Line 77: l_org_info_tab WSH_CARRIERS_PUB.Org_Info_Tab_Type;

73: l_api_version_number CONSTANT NUMBER :=1.0 ;
74: l_api_name CONSTANT VARCHAR2(30):= 'Assign_Org_Carrier_Service';
75: l_carrier_id NUMBER ;
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 ;

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,

Line 581: END WSH_CARRIERS_PUB;

577: --}
578:
579: END Assign_Org_Carrier_Service;
580:
581: END WSH_CARRIERS_PUB;