APPS.WSH_PICK_LIST dependencies on WSH_SHIPPING_PARAMS_PVT

Line 235: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

231: WHERE ORGANIZATION_ID = c_org_id;
232:
233: l_default_pickconfirm VARCHAR2(1);
234: l_init_rules VARCHAR2(1) := FND_API.G_FALSE;
235: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
236: l_express_pick_profile VARCHAR2(1);
237:
238: l_debug_on BOOLEAN;
239: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_ORG_PARAMS';

Line 253: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);

249:
250: IF l_debug_on THEN
251: WSH_DEBUG_SV.push(l_module_name);
252: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID ',P_ORGANIZATION_ID);
253: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
254: END IF;
255:
256: -- 10. Getting Organization Parameters
257: WSH_SHIPPING_PARAMS_PVT.Get(

Line 257: WSH_SHIPPING_PARAMS_PVT.Get(

253: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
254: END IF;
255:
256: -- 10. Getting Organization Parameters
257: WSH_SHIPPING_PARAMS_PVT.Get(
258: p_organization_id => p_organization_id,
259: x_param_info => l_param_info,
260: x_return_status => x_return_status);
261:

Line 263: WSH_DEBUG_SV.log(l_module_name,'Return Status After Calling WSH_SHIPPING_PARAMS_PVT.Get',x_return_status);

259: x_param_info => l_param_info,
260: x_return_status => x_return_status);
261:
262: IF l_debug_on THEN
263: WSH_DEBUG_SV.log(l_module_name,'Return Status After Calling WSH_SHIPPING_PARAMS_PVT.Get',x_return_status);
264: END IF;
265:
266: -- 20. Using NVL function for possible null values
267: l_param_info.PRINT_PICK_SLIP_MODE := NVL(l_param_info.PRINT_PICK_SLIP_MODE, 'E');

Line 7271: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

7267: l_autocreate_del_flag VARCHAR2(1);
7268: l_pickconfirm_required NUMBER;
7269: l_del_org NUMBER;
7270: l_det_org NUMBER;
7271: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
7272: l_return_status VARCHAR2(1);
7273: l_task_planning_flag VARCHAR2(1) := NULL;
7274: l_non_picking_flag VARCHAR2(1) := NULL;
7275: l_warn_org NUMBER;

Line 7491: WSH_SHIPPING_PARAMS_PVT.Get(p_organization_id => l_del_org,

7487: j := l_del_org_params_cache_tab.count + 1;
7488:
7489: l_del_org_params_cache_tab(j).organization_id := l_del_org;
7490:
7491: WSH_SHIPPING_PARAMS_PVT.Get(p_organization_id => l_del_org,
7492: x_param_info => l_param_info,
7493: x_return_status => l_return_status);
7494: l_task_planning_flag := l_param_info.task_planning_flag;
7495: l_del_org_params_cache_tab(j).task_planning_flag := l_task_planning_flag;