APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_PICK_LIST

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

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

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

3538: wsh_debug_sv.log(l_module_name, 'Id Tab Count', l_id_tab.count);
3539: END IF;
3540:
3541: IF l_debug_on THEN
3542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.LAUNCH_PICK_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);
3543: END IF;
3544: --
3545:
3546: wsh_pick_list.launch_pick_release(

Line 3546: wsh_pick_list.launch_pick_release(

3542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.LAUNCH_PICK_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);
3543: END IF;
3544: --
3545:
3546: wsh_pick_list.launch_pick_release(
3547: p_trip_ids => l_dummy_ids,
3548: p_stop_ids => l_dummy_ids,
3549: p_delivery_ids => l_dummy_ids,
3550: p_detail_ids => l_id_tab,

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

3566: wsh_debug_sv.log(l_module_name, 'Id Tab Count', l_id_tab.count);
3567: END IF;
3568:
3569: IF l_debug_on THEN
3570: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.LAUNCH_PICK_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);
3571: END IF;
3572: --
3573: wsh_pick_list.launch_pick_release(
3574: p_trip_ids => l_dummy_ids,

Line 3573: wsh_pick_list.launch_pick_release(

3569: IF l_debug_on THEN
3570: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.LAUNCH_PICK_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);
3571: END IF;
3572: --
3573: wsh_pick_list.launch_pick_release(
3574: p_trip_ids => l_dummy_ids,
3575: p_stop_ids => l_dummy_ids,
3576: p_delivery_ids => l_dummy_ids,
3577: p_detail_ids => l_id_tab,

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

3593: wsh_debug_sv.log(l_module_name, 'Id Tab Count', l_id_tab.count);
3594: END IF;
3595:
3596: IF l_debug_on THEN
3597: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.LAUNCH_PICK_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);
3598: END IF;
3599: --
3600: wsh_pick_list.launch_pick_release(
3601: p_trip_ids => l_dummy_ids,

Line 3600: wsh_pick_list.launch_pick_release(

3596: IF l_debug_on THEN
3597: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.LAUNCH_PICK_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);
3598: END IF;
3599: --
3600: wsh_pick_list.launch_pick_release(
3601: p_trip_ids => l_dummy_ids,
3602: p_stop_ids => l_dummy_ids,
3603: p_delivery_ids => l_dummy_ids,
3604: p_detail_ids => l_id_tab,

Line 10891: l_group_match_seq_tbl WSH_PICK_LIST.group_match_seq_tab_type;

10887: l_debug_on Boolean;
10888:
10889: --bug 7171766
10890: l_match_found BOOLEAN;
10891: l_group_match_seq_tbl WSH_PICK_LIST.group_match_seq_tab_type;
10892: K NUMBER ;
10893:
10894: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_CARTON_GROUPING';
10895: