1 PACKAGE MSC_X_RECEIVE_CAPACITY_PKG AUTHID CURRENT_USER AS
2 /* $Header: MSCXRSCS.pls 115.15 2004/07/12 23:05:21 yptang ship $ */
3
4 G_MSC_CP_DEBUG VARCHAR2(10) := NVL(FND_PROFILE.VALUE('MSC_CP_DEBUG'), '0');
5 G_MSC_X_DEF_CALENDAR VARCHAR2(14):= fnd_profile.value('MSC_X_DEFAULT_CALENDAR');
6
7 SYS_YES CONSTANT NUMBER := 1;
8 SYS_NO CONSTANT NUMBER := 2;
9
10 SUPPLY_COMMIT CONSTANT Number := 3;
11
12 PROCEDURE receive_capacity(p_errbuf OUT NOCOPY VARCHAR2,
13 p_retcode OUT NOCOPY VARCHAR2,
14 p_horizon_start_date In VARCHAR2,
15 p_horizon_end_date In varchar2,
16 p_abc_class In Varchar2,
17 p_item_id In Number,
18 p_planner In Varchar2,
19 p_supplier_id IN number,
20 p_supplier_site_id In Number,
21 p_mps_designator_id IN Number,
22 p_overwrite IN Number default 1,
23 p_spread IN Number default 1
24 );
25
26 PROCEDURE Calculate_Capacity(p_sr_instance_id IN Number,
27 p_organization_id IN Number,
28 p_supplier_id IN Number,
29 p_supplier_site_id IN Number,
30 p_mps_designator_id IN Number,
31 p_item_id IN Number,
32 p_receipt_date IN date,
33 p_capacity IN Number,
34 p_bucket_type IN Number,
35 p_calendar_code IN varchar2,
36 p_refresh_number IN NUmber,
37 p_lv_start_date IN Date,
38 p_lv_end_date IN Date,
39 p_horizon_start_date In Date,
40 p_horizon_end_date In date,
41 p_overwrite IN Number,
42 p_abc_class in varchar2,
43 p_planner IN varchar2,
44 p_map_supplier_id IN number,
45 p_map_supplier_site_id IN number,
46 p_rounding_control IN number,
47 p_spread IN Number);
48
49 PROCEDURE Populate_Capacity(p_sr_instance_id IN Number,
50 p_organization_id IN Number,
51 p_supplier_id IN Number,
52 p_supplier_site_id IN Number,
53 p_item_id IN Number,
54 p_date IN Date,
55 p_capacity IN Number,
56 p_refresh_number IN Number,
57 p_lv_start_date IN Date,
58 p_lv_end_date IN Date,
59 p_horizon_start_date in Date,
60 p_horizon_end_date in Date,
61 p_overwrite In Number);
62
63 PROCEDURE Insert_Capacity(p_sr_instance_id IN Number,
64 p_organization_id IN Number,
65 p_supplier_id IN Number,
66 p_supplier_site_id IN Number,
67 p_item_id IN Number,
68 p_from_date IN Date,
69 p_to_date IN Date,
70 p_capacity IN Number,
71 p_refresh_number IN Number);
72
73 PROCEDURE Load_Supply_Schedule(p_sr_instance_id IN Number,
74 p_organization_id IN Number,
75 p_supplier_id IN Number,
76 p_supplier_site_id IN Number,
77 p_mod_org_id In Number,
78 p_mod_org_code IN Varchar2,
79 p_mps_designator_id IN Number,
80 p_item_id IN Number,
81 p_date IN Date,
82 p_capacity IN Number,
83 p_refresh_number IN Number);
84
85 PROCEDURE Insert_MPS_Designator(p_sr_instance_id IN Number,
86 p_organization_id IN Number,
87 p_supplier_id IN Number,
88 p_supplier_site_id IN Number,
89 p_mps_designator IN Varchar2,
90 p_refresh_number IN Number,
91 p_mps_designator_id OUT NOCOPY Number);
92
93 PROCEDURE Insert_Supply_Schedule(p_sr_instance_id IN Number,
94 p_organization_id IN Number,
95 p_supplier_id IN Number,
96 p_supplier_site_id IN Number,
97 p_mps_designator_id IN Number,
98 p_item_id IN Number,
99 p_date IN Date,
100 p_capacity IN Number,
101 p_refresh_number IN Number);
102
103 END MSC_X_RECEIVE_CAPACITY_PKG ;