DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERIES_PVT dependencies on STANDARD

Line 317: ,nvl(p_delivery_info.delivery_type,'STANDARD')

313: x_delivery_id
314: ,x_name
315: ,nvl(p_delivery_info.planned_flag,'N')
316: ,nvl(p_delivery_info.status_code,'OP')
317: ,nvl(p_delivery_info.delivery_type,'STANDARD')
318: ,p_delivery_info.loading_sequence
319: ,p_delivery_info.loading_order_flag
320: ,p_delivery_info.initial_pickup_date
321: ,p_delivery_info.initial_pickup_location_id

Line 1145: -- Do the Proration only for the 'Standard' Deliveries.

1141: END IF;
1142: --
1143:
1144: -- "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
1145: -- Do the Proration only for the 'Standard' Deliveries.
1146:
1147: IF NVL(p_delivery_info.delivery_type, 'STANDARD')='STANDARD' AND NVL(p_delivery_info.PRORATE_WT_FLAG,'N')='Y'
1148: AND (nvl(l_diff_gross_wt,0) <> 0 OR nvl(l_diff_net_wt,0) <> 0) THEN --{
1149: --

Line 1147: IF NVL(p_delivery_info.delivery_type, 'STANDARD')='STANDARD' AND NVL(p_delivery_info.PRORATE_WT_FLAG,'N')='Y'

1143:
1144: -- "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
1145: -- Do the Proration only for the 'Standard' Deliveries.
1146:
1147: IF NVL(p_delivery_info.delivery_type, 'STANDARD')='STANDARD' AND NVL(p_delivery_info.PRORATE_WT_FLAG,'N')='Y'
1148: AND (nvl(l_diff_gross_wt,0) <> 0 OR nvl(l_diff_net_wt,0) <> 0) THEN --{
1149: --
1150: IF l_debug_on THEN
1151: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.prorate_weight',WSH_DEBUG_SV.C_PROC_LEVEL);