DBA Data[Home] [Help]

APPS.WSH_USA_CATEGORIES_PVT dependencies on INV_MOVE_ORDER_PUB

Line 2252: l_mo_line_rec INV_Move_Order_PUB.Trolin_Rec_Type;

2248:
2249: --Bug 9226187 : Added local variables
2250: l_status VARCHAR2(1);
2251: l_mo_line_id NUMBER;
2252: l_mo_line_rec INV_Move_Order_PUB.Trolin_Rec_Type;
2253: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2254: l_trolin_old_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2255: l_trolin_out_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2256: l_msg_count NUMBER;

Line 2253: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

2249: --Bug 9226187 : Added local variables
2250: l_status VARCHAR2(1);
2251: l_mo_line_id NUMBER;
2252: l_mo_line_rec INV_Move_Order_PUB.Trolin_Rec_Type;
2253: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2254: l_trolin_old_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2255: l_trolin_out_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2256: l_msg_count NUMBER;
2257: l_msg_data VARCHAR2(3000);

Line 2254: l_trolin_old_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

2250: l_status VARCHAR2(1);
2251: l_mo_line_id NUMBER;
2252: l_mo_line_rec INV_Move_Order_PUB.Trolin_Rec_Type;
2253: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2254: l_trolin_old_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2255: l_trolin_out_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2256: l_msg_count NUMBER;
2257: l_msg_data VARCHAR2(3000);
2258:

Line 2255: l_trolin_out_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

2251: l_mo_line_id NUMBER;
2252: l_mo_line_rec INV_Move_Order_PUB.Trolin_Rec_Type;
2253: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2254: l_trolin_old_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2255: l_trolin_out_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2256: l_msg_count NUMBER;
2257: l_msg_data VARCHAR2(3000);
2258:
2259:

Line 2292: --Bug 9226187: Introduced call to the API INV_MOVE_ORDER_PUB.Process_Move_Order_Line

2288: WSH_DEBUG_SV.log(l_module_name,'P_WMS_FLAG',P_WMS_FLAG);
2289: WSH_DEBUG_SV.log(l_module_name,'X_UPDATE_ALLOWED',X_UPDATE_ALLOWED);
2290: END IF;
2291: --
2292: --Bug 9226187: Introduced call to the API INV_MOVE_ORDER_PUB.Process_Move_Order_Line
2293: -- in order to change the Date_Required on MO Line,whenever there is a
2294: -- change in the Dat_Scheduled on SO Line.
2295: -- The call should be made only if the delivery detail is 'Released to Warehouse'
2296: -- and a Move Order line exists.

Line 2322: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);

2318: l_trolin_tbl(1).OPERATION := INV_GLOBALS.G_OPR_UPDATE;
2319: l_trolin_tbl(1).date_required := p_attributes_rec.date_scheduled;
2320:
2321: IF l_debug_on THEN
2322: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
2323: END IF;
2324:
2325: INV_MOVE_ORDER_PUB.Process_Move_Order_Line(
2326: p_api_version_number => 1.0,

Line 2325: INV_MOVE_ORDER_PUB.Process_Move_Order_Line(

2321: IF l_debug_on THEN
2322: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
2323: END IF;
2324:
2325: INV_MOVE_ORDER_PUB.Process_Move_Order_Line(
2326: p_api_version_number => 1.0,
2327: p_commit => FND_API.G_FALSE,
2328: x_return_status => x_return_status,
2329: x_msg_count => l_msg_count,

Line 2462: l_mo_line_rec INV_Move_Order_PUB.Trolin_Rec_Type;

2458: l_status_count NUMBER;
2459: l_mo_line_id NUMBER;
2460: l_ship_set NUMBER;
2461: --l_param_info WSH_SHIPPING_PARAMETERS.Parameter_Rec_Type;
2462: l_mo_line_rec INV_Move_Order_PUB.Trolin_Rec_Type;
2463: -- HW OPMCONV. Removed OPM variables
2464:
2465: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2466: l_trolin_old_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

Line 2465: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

2461: --l_param_info WSH_SHIPPING_PARAMETERS.Parameter_Rec_Type;
2462: l_mo_line_rec INV_Move_Order_PUB.Trolin_Rec_Type;
2463: -- HW OPMCONV. Removed OPM variables
2464:
2465: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2466: l_trolin_old_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2467: l_trolin_out_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2468: l_msg_count NUMBER;
2469: l_msg_data VARCHAR2(3000);

Line 2466: l_trolin_old_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

2462: l_mo_line_rec INV_Move_Order_PUB.Trolin_Rec_Type;
2463: -- HW OPMCONV. Removed OPM variables
2464:
2465: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2466: l_trolin_old_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2467: l_trolin_out_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2468: l_msg_count NUMBER;
2469: l_msg_data VARCHAR2(3000);
2470: update_not_allowed EXCEPTION;

Line 2467: l_trolin_out_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

2463: -- HW OPMCONV. Removed OPM variables
2464:
2465: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2466: l_trolin_old_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2467: l_trolin_out_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2468: l_msg_count NUMBER;
2469: l_msg_data VARCHAR2(3000);
2470: update_not_allowed EXCEPTION;
2471:

Line 2582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);

2578: l_trolin_tbl(1).OPERATION := INV_GLOBALS.G_OPR_UPDATE;
2579: l_trolin_tbl(1).ship_set_id := p_attributes_rec.ship_set_id;
2580:
2581: IF l_debug_on THEN
2582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
2583: END IF;
2584:
2585: INV_MOVE_ORDER_PUB.Process_Move_Order_Line(
2586: p_api_version_number => 1.0,

Line 2585: INV_MOVE_ORDER_PUB.Process_Move_Order_Line(

2581: IF l_debug_on THEN
2582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
2583: END IF;
2584:
2585: INV_MOVE_ORDER_PUB.Process_Move_Order_Line(
2586: p_api_version_number => 1.0,
2587: p_commit => FND_API.G_FALSE,
2588: x_return_status => x_return_status,
2589: x_msg_count => l_msg_count,