DBA Data[Home] [Help]

APPS.WSH_ORG_CARRIER_SERVICES_PKG dependencies on WSH_CARRIER_SHIP_METHODS

Line 15: , p_csm_info IN WSH_CARRIER_SHIP_METHODS_PKG.CSMRecType

11: PROCEDURE Assign_Org_Carrier_Service
12: (
13: p_org_Carrier_Service_Info IN OCSRecType
14: , p_carrier_info IN CarRecType
15: , p_csm_info IN WSH_CARRIER_SHIP_METHODS_PKG.CSMRecType
16: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
17: , x_Rowid IN OUT NOCOPY VARCHAR2
18: , x_Org_Carrier_Service_id IN OUT NOCOPY NUMBER
19: , x_Return_Status OUT NOCOPY VARCHAR2

Line 76: l_csm_info WSH_CARRIER_SHIP_METHODS_PKG.CSMRecType;

72: l_csm_rowid VARCHAR2(40);
73: l_procedure VARCHAR2(500);
74: l_position NUMBER;
75: l_carrier_ship_method_id NUMBER;
76: l_csm_info WSH_CARRIER_SHIP_METHODS_PKG.CSMRecType;
77:
78: --Variable added for bug 6126916
79: l_org_freight_tl_info c_get_org_freight_tl%rowtype;
80:

Line 281: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CARRIER_SHIP_METHODS_PKG.Create_Carrier_Ship_Method',WSH_DEBUG_SV.C_PROC_LEVEL);

277: l_procedure := 'Calling Create_Carrier_Ship_Method';
278:
279: --
280: IF l_debug_on THEN
281: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CARRIER_SHIP_METHODS_PKG.Create_Carrier_Ship_Method',WSH_DEBUG_SV.C_PROC_LEVEL);
282: END IF;
283: --
284:
285: WSH_CARRIER_SHIP_METHODS_PKG.Create_Carrier_Ship_Method

Line 285: WSH_CARRIER_SHIP_METHODS_PKG.Create_Carrier_Ship_Method

281: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CARRIER_SHIP_METHODS_PKG.Create_Carrier_Ship_Method',WSH_DEBUG_SV.C_PROC_LEVEL);
282: END IF;
283: --
284:
285: WSH_CARRIER_SHIP_METHODS_PKG.Create_Carrier_Ship_Method
286: (
287: p_carrier_ship_method_info => p_CSM_info,
288: x_rowid => l_csm_rowid,
289: x_carrier_ship_method_id => l_carrier_ship_method_id,

Line 343: L_PROCEDURE := 'Updating WSH_CARRIER_SHIP_METHODS';

339: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
340: END IF;
341:
342: L_POSITION := 30;
343: L_PROCEDURE := 'Updating WSH_CARRIER_SHIP_METHODS';
344:
345: UPDATE WSH_CARRIER_SHIP_METHODS
346: SET ENABLED_FLAG = p_org_Carrier_Service_Info.Enabled_Flag,
347: WEB_ENABLED = p_csm_info.web_enabled

Line 345: UPDATE WSH_CARRIER_SHIP_METHODS

341:
342: L_POSITION := 30;
343: L_PROCEDURE := 'Updating WSH_CARRIER_SHIP_METHODS';
344:
345: UPDATE WSH_CARRIER_SHIP_METHODS
346: SET ENABLED_FLAG = p_org_Carrier_Service_Info.Enabled_Flag,
347: WEB_ENABLED = p_csm_info.web_enabled
348: WHERE ORGANIZATION_ID = p_csm_info.organization_id
349: AND SHIP_METHOD_CODE = p_csm_info.ship_method_code;