1 PACKAGE OE_SCHEDULE_GRP AUTHID CURRENT_USER AS
2 /* $Header: OEXGSCHS.pls 120.3.12020000.1 2012/06/26 08:41:41 appldev ship $ */
3
4 -- This new global is introduced as part of IR ISO CMS Project.
5 -- This global will indicate that the call is from Planning and
6 -- an internal sales order is updated from them. This global will
7 -- be read in Process Order API code while to trigger/not to
8 -- trigger scheduling (for Undemand/Unschedule/Unreserve) for
9 -- update of ordered quantity to 0, i.e. cancelling the internal
10 -- order line from Planning workbench or by DRP
11 --
12 -- For details on IR ISO CMS project, please refer to FOL >
13 -- OM Development > OM GM > 12.1.1 > TDD > IR_ISO_CMS_TDD.doc
14 -- or Refer to bug #7576948
15 --
16 G_ISO_Planning_Update BOOLEAN := FALSE;
17
18
19 TYPE sch_rec_type IS RECORD
20 (line_id Number, -- Line id from the line.
21 Org_id Number, -- Org Id the line belongs to
22 Header_id Number, -- Order Header information.
23 Inventory_item_id Number, -- Inventory Item Id ER 6110708
24 Ship_from_org_id Number, -- Warehouse
25 Schedule_ship_date Date, -- Ship date
26 Schedule_arrival_date Date, -- Arrival Date
27 Earliest_ship_date Date, -- Earliest available date
28 Delivery_lead_time Number, -- Lead time between ship and Arrival.
29 Shipping_Method_Code Varchar2(30), -- Method used to ship the line.
30 Ordered_Quantity Number, -- Is the quantity updated.
31 -- Ordered Qty is added as part of IR ISO CMS project. Refer Bug #7576948
32 Firm_Demand_Flag Varchar2(1), -- Is the line firmed or not.
33 Source_type_code Varchar2(30), -- Internal/External
34 Attribute_char1 Varchar2(30), -- New char attr
35 Attribute_num1 Number, -- New Number attr
36 Orig_Inventory_item_id Number, -- Original Inventory Item Id ER 6110708
37 Orig_Schedule_Ship_Date Date, -- Original Schedule Ship date on the SO
38 Orig_Schedule_Arrival_Date Date, -- Original Schedule Arr date on the SO
39 Orig_Ship_from_org_id Number, -- Original Waresouse on the SO
40 Orig_Shipping_Method_Code Varchar2(30), -- Origl Shipping Method on the SO
41 Orig_ordered_quantity Number, -- Original Ordered Qty on the SO
42 Orig_Earliest_Ship_date Date, -- Original ESD on the SO
43 x_override_atp_date_code Varchar2(1), -- Was it a overridden line.
44 x_line_number Varchar2(30), -- Line number
45 x_return_status Varchar2(1)); -- Return status of the line..
46
47 TYPE Sch_Tbl_Type IS TABLE OF Sch_rec_type
48 INDEX BY BINARY_INTEGER;
49
50 Procedure Update_Scheduling_Results
51 (p_x_sch_tbl IN OUT NOCOPY sch_tbl_type,
52 p_request_id IN Number,
53 x_return_status OUT NOCOPY Varchar2);
54
55 END OE_SCHEDULE_GRP;