DBA Data[Home] [Help]

APPS.WSH_DELIVERY_AUTOCREATE dependencies on WSH_SHIPPING_PARAMS_PVT

Line 31: l_shipping_params WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

27:
28: l_autocreate_del_orders_flag varchar2(1);
29: l_error_code number := NULL;
30: l_error_text varchar2(2000) := NULL;
31: l_shipping_params WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
32:
33: --
34: l_debug_on BOOLEAN;
35: --

Line 98: WSH_SHIPPING_PARAMS_PVT.Get(p_organization_id => p_organization_id,

94: END IF;
95: RETURN;
96: END IF;
97:
98: WSH_SHIPPING_PARAMS_PVT.Get(p_organization_id => p_organization_id,
99: x_param_info => l_shipping_params,
100: x_return_status => x_return_status);
101:
102:

Line 1834: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

1830: l_check_fte_inst VARCHAR2(1) := 'N'; -- used to check is FTE is installed or not
1831:
1832: -- bug 2691385
1833: l_detail_is_empty_cont VARCHAR2(1) := 'N';
1834: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
1835:
1836: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
1837: l_action_rec wsh_delivery_autocreate.action_rec_type;
1838: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

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

2245: -- following code is common for parallel and non-parallel cases
2246: -- of creating a new delivery, up to the label SKIP_ITM_EXISTING_DEL.
2247:
2248: IF l_debug_on THEN
2249: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
2250: END IF;
2251:
2252: WSH_SHIPPING_PARAMS_PVT.Get(
2253: p_organization_id => l_delivery_info.organization_id,

Line 2252: WSH_SHIPPING_PARAMS_PVT.Get(

2248: IF l_debug_on THEN
2249: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
2250: END IF;
2251:
2252: WSH_SHIPPING_PARAMS_PVT.Get(
2253: p_organization_id => l_delivery_info.organization_id,
2254: x_param_info => l_param_info,
2255: x_return_status => l_return_status
2256: );

Line 2777: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

2773: TYPE line_org_type IS TABLE OF line_org_rec_type INDEX BY BINARY_INTEGER;
2774: l_line_warehouse_ids line_org_type;
2775: t_line_warehouse_id line_org_rec_type;
2776:
2777: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
2778:
2779: temp_ids wsh_util_core.id_tab_type;
2780: curr_warehouse_id NUMBER;
2781:

Line 2872: WSH_SHIPPING_PARAMS_PVT.Get(

2868: -- Call autocreate_deliveries to create delivery.
2869: curr_warehouse_id := l_line_warehouse_ids(1).warehouse_id;
2870: FOR i in 1..l_line_warehouse_ids.count LOOP
2871: IF ( curr_warehouse_id <> l_line_warehouse_ids(i).warehouse_id ) THEN
2872: WSH_SHIPPING_PARAMS_PVT.Get(
2873: p_organization_id => curr_warehouse_id,
2874: x_param_info => l_param_info,
2875: x_return_status => x_return_status
2876: );

Line 2961: WSH_SHIPPING_PARAMS_PVT.Get(

2957: temp_ids(temp_ids.count + 1) := l_line_warehouse_ids(i).line_id;
2958: END LOOP;
2959: -- Handling the case when it is the last warehouse group or the only warehouse group in the table
2960: IF temp_ids.count > 0 THEN
2961: WSH_SHIPPING_PARAMS_PVT.Get(
2962: p_organization_id => curr_warehouse_id,
2963: x_param_info => l_param_info,
2964: x_return_status => l_return_status
2965: );