1 PACKAGE AHL_LTP_ASCP_ORDERS_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLSCMRS.pls 115.2 2004/01/29 00:05:41 ssurapan noship $*/
3 --
4 --
5 TYPE Sched_Orders_Rec IS RECORD
6 (Order_line_id Number, -- Line id (Schedule Mat Id)
7 Org_id Number, -- Org Id the line belongs to
8 Header_id Number, -- Order Header (Visit Task Id)
9 Schedule_ship_date Date, -- Ship date (Dmd_Satisfied_date)
10 Schedule_arrival_date Date, -- Arrival Date
11 Earliest_ship_date Date, -- Earliest available date
12 Quantity_By_Due_Date Number);
13
14 TYPE Sched_Orders_Tbl IS TABLE OF Sched_Orders_Rec
15 INDEX BY BINARY_INTEGER;
16
17 -- Start of Comments --
18 -- Procedure name : Update_Sheduling_Results
19 -- Type : Public
20 -- Function : This procedure Updates Scheduled Materials table with scheduled date
21 -- Quantity from APS
22 -- Pre-reqs :
23 -- Parameters :
24 --
25 -- Standard IN Parameters :
26 -- p_api_version IN NUMBER Required
27 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
28 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
29 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
30 -- Standard out Parameters :
31 -- x_return_status OUT VARCHAR2 Required
32 --
33 -- Update_Scheduling_Results :
34 --
35 --
36 --
37 PROCEDURE Update_Scheduling_Results (
38 p_api_version IN NUMBER := 1.0,
39 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
40 p_commit IN VARCHAR2 := FND_API.g_false,
41 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
42 p_sched_Orders_Tbl IN Sched_Orders_Tbl,
43 x_return_status OUT NOCOPY VARCHAR2);
44
45
46 END AHL_LTP_ASCP_ORDERS_PVT;