1 PACKAGE MSC_ATP_EXCEPTIONS AS
2 /* $Header: MSCATPXS.pls 120.1 2007/12/12 10:23:18 sbnaik ship $ */
3
4 ------------ Record Type Definitions--------------
5
6 TYPE ATP_Exception_Rec_Typ is RECORD (
7 exception_type number, -- Exception type.
8 -- 15 for unconstrained plans
9 -- 24 for constrained plans
10 exception_group number, -- Exception group, always 5
11 plan_id number, -- Plan ID
12 organization_id number, -- Organization ID
13 inventory_item_id number, -- Inventory Item ID
14 sr_instance_id number, -- Instance ID
15 demand_id number, -- Demand ID
16 quantity number, -- Quantity requested
17 order_number varchar2(240), -- Order number
18 customer_id number, -- Customer ID
19 customer_site_id number, -- Customer Site ID
20 demand_satisfy_date date, -- Date the demand is satisfied
21 quantity_satisfied number -- Quantity satisfied on demand date
22 );
23
24
25 -----------Procedure Declarations----------------
26
27 /*
28 bug 2795053 (ssurendr) - This procedure is not required any more.
29 PROCEDURE Get_Plan_Constraints (
30 p_plan_id IN NUMBER,
31 x_plan_type OUT NOCOPY NUMBER
32 );
33 */
34
35 PROCEDURE Add_ATP_Exception (
36 p_session_id IN NUMBER,
37 p_exception_rec IN OUT NOCOPY MSC_ATP_EXCEPTIONS.ATP_Exception_Rec_Typ,
38 x_return_status OUT NOCOPY VARCHAR2
39 );
40
41 ----------ATP Global Variables------------------
42
43 -- Origination Field value for ATP generated SO exceptions
44 g_atp_exception_origin_code CONSTANT INTEGER := 2;
45
46 END MSC_ATP_EXCEPTIONS;