APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_PICK_LIST

Line 454: IF l_adjust_planned_del_tab.count > 0 and WSH_PICK_LIST.G_BATCH_ID is NULL THEN

450: x_num_errors => l_number_of_errors);
451: /* Patchset I : Harmonization Project End */
452: END IF;
453: -- deliveryMerge
454: IF l_adjust_planned_del_tab.count > 0 and WSH_PICK_LIST.G_BATCH_ID is NULL THEN
455: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(
456: p_delivery_ids => l_adjust_planned_del_tab,
457: p_caller => 'WSH_DLMG',
458: p_force_appending_limit => 'N',

Line 3535: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.LAUNCH_PICK_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);

3531: wsh_debug_sv.log(l_module_name, 'Id Tab Count', l_id_tab.count);
3532: END IF;
3533:
3534: IF l_debug_on THEN
3535: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.LAUNCH_PICK_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);
3536: END IF;
3537: --
3538:
3539: wsh_pick_list.launch_pick_release(

Line 3539: wsh_pick_list.launch_pick_release(

3535: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.LAUNCH_PICK_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);
3536: END IF;
3537: --
3538:
3539: wsh_pick_list.launch_pick_release(
3540: p_trip_ids => l_dummy_ids,
3541: p_stop_ids => l_dummy_ids,
3542: p_delivery_ids => l_dummy_ids,
3543: p_detail_ids => l_id_tab,

Line 3563: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.LAUNCH_PICK_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);

3559: wsh_debug_sv.log(l_module_name, 'Id Tab Count', l_id_tab.count);
3560: END IF;
3561:
3562: IF l_debug_on THEN
3563: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.LAUNCH_PICK_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);
3564: END IF;
3565: --
3566: wsh_pick_list.launch_pick_release(
3567: p_trip_ids => l_dummy_ids,

Line 3566: wsh_pick_list.launch_pick_release(

3562: IF l_debug_on THEN
3563: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.LAUNCH_PICK_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);
3564: END IF;
3565: --
3566: wsh_pick_list.launch_pick_release(
3567: p_trip_ids => l_dummy_ids,
3568: p_stop_ids => l_dummy_ids,
3569: p_delivery_ids => l_dummy_ids,
3570: p_detail_ids => l_id_tab,

Line 3590: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.LAUNCH_PICK_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);

3586: wsh_debug_sv.log(l_module_name, 'Id Tab Count', l_id_tab.count);
3587: END IF;
3588:
3589: IF l_debug_on THEN
3590: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.LAUNCH_PICK_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);
3591: END IF;
3592: --
3593: wsh_pick_list.launch_pick_release(
3594: p_trip_ids => l_dummy_ids,

Line 3593: wsh_pick_list.launch_pick_release(

3589: IF l_debug_on THEN
3590: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.LAUNCH_PICK_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);
3591: END IF;
3592: --
3593: wsh_pick_list.launch_pick_release(
3594: p_trip_ids => l_dummy_ids,
3595: p_stop_ids => l_dummy_ids,
3596: p_delivery_ids => l_dummy_ids,
3597: p_detail_ids => l_id_tab,

Line 10771: l_group_match_seq_tbl WSH_PICK_LIST.group_match_seq_tab_type;

10767: l_debug_on Boolean;
10768:
10769: --bug 7171766
10770: l_match_found BOOLEAN;
10771: l_group_match_seq_tbl WSH_PICK_LIST.group_match_seq_tab_type;
10772: K NUMBER ;
10773:
10774: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_CARTON_GROUPING';
10775: