1 PACKAGE MSC_ATP_DRP AUTHID CURRENT_USER AS
2 /* $Header: MSCATDRS.pls 120.0 2005/05/25 20:15:08 appldev noship $ */
3
4 -- Procedure that nets supplies and demands for DRP plan.
5 PROCEDURE Get_Mat_Avail_Drp (
6 p_item_id IN NUMBER,
7 p_org_id IN NUMBER,
8 p_instance_id IN NUMBER,
9 p_plan_id IN NUMBER,
10 p_itf IN DATE,
11 x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
12 x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
13 );
14
15 -- Procedure that nets supplies and demand details for DRP plan.
16 PROCEDURE Get_Mat_Avail_Drp_dtls (
17 p_item_id IN NUMBER,
18 p_request_item_id IN NUMBER,
19 p_org_id IN NUMBER,
20 p_instance_id IN NUMBER,
21 p_plan_id IN NUMBER,
22 p_itf IN DATE,
23 p_level IN NUMBER,
24 p_scenario_id IN NUMBER,
25 p_identifier IN NUMBER
26 );
27
28 -- procedure for full summation of
29 -- supply/demand for DRP plans.
30
31 PROCEDURE LOAD_SD_FULL_DRP(p_plan_id IN NUMBER,
32 p_sys_date IN DATE);
33
34 -- summary enhancement : procedure for net summation of supply/demand
35 -- for DRP cases.
36
37 PROCEDURE LOAD_SD_NET_DRP (p_plan_id IN NUMBER,
38 p_last_refresh_number IN NUMBER,
39 p_new_refresh_number IN NUMBER,
40 p_sys_date IN DATE);
41
42 -- Procedure that nets supplies and demands for DRP plan when summary is enabled.
43 PROCEDURE get_mat_avail_drp_summ (
44 p_item_id IN NUMBER,
45 p_org_id IN NUMBER,
46 p_instance_id IN NUMBER,
47 p_plan_id IN NUMBER,
48 p_itf IN DATE,
49 p_refresh_number IN NUMBER, -- For summary enhancement
50 x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
51 x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr);
52
53 END MSC_ATP_DRP;