1 PACKAGE MSD_SCE_PUBLISH_FORECAST_PKG AUTHID CURRENT_USER AS
2 /* $Header: msdxpcfs.pls 115.6 2004/07/15 19:40:12 esubrama ship $ */
3
4 /* PL/SQL table types */
5 TYPE companyNameList IS TABLE OF msc_companies.company_name%TYPE;
6 TYPE companySiteList IS TABLE OF msc_company_sites.company_site_name%TYPE;
7 TYPE itemNameList IS TABLE OF msc_system_items.item_name%TYPE;
8 TYPE itemDescList IS TABLE OF msc_system_items.description%TYPE;
9 TYPE itemUomList IS TABLE OF msc_system_items.uom_code%TYPE;
10 TYPE fndMeaningList IS TABLE OF fnd_lookup_values.meaning%TYPE;
11 TYPE plannerCodeList IS TABLE OF msc_system_items.planner_code%TYPE;
12 TYPE planningGroupList IS TABLE OF msc_demands.planning_group%TYPE;
13 TYPE shippingControlList IS TABLE OF msc_trading_partner_sites.shipping_control%TYPE;
14 TYPE numberList IS TABLE OF Number;
15 TYPE dateList IS TABLE OF Date;
16
17 PROCEDURE publish_customer_forecast (
18 p_errbuf out NOCOPY varchar2,
19 p_retcode out NOCOPY varchar2,
20 p_designator in varchar2,
21 p_order_type in number,
22 p_demand_plan_id in number,
23 p_scenario_id in number,
24 p_forecast_date in varchar2,
25 p_org_code in varchar2,
26 p_planner_code in varchar2,
27 -- p_abc_class in varchar2,
28 p_item_id in number,
29 p_customer_id in number,
30 p_customer_site_id in number,
31 p_horizon_start in varchar2,
32 p_horizon_days in number,
33 p_auto_version in number,
34 p_version in number
35 );
36
37
38 PROCEDURE explode_dates (
39 t_pub IN OUT NOCOPY companyNameList,
40 t_pub_id IN OUT NOCOPY numberList,
41 t_pub_site IN OUT NOCOPY companySiteList,
42 t_pub_site_id IN OUT NOCOPY numberList,
43 t_item_id IN OUT NOCOPY numberList,
44 t_qty IN OUT NOCOPY numberList,
45 t_pub_ot IN OUT NOCOPY numberList,
46 t_cust IN OUT NOCOPY companyNameList,
47 t_cust_id IN OUT NOCOPY numberList,
48 t_cust_site IN OUT NOCOPY companySiteList,
49 t_cust_site_id IN OUT NOCOPY numberList,
50 t_ship_from IN OUT NOCOPY companyNameList,
51 t_ship_from_id IN OUT NOCOPY numberList,
52 t_ship_from_site IN OUT NOCOPY companySiteList,
53 t_ship_from_site_id IN OUT NOCOPY numberList,
54 t_ship_to IN OUT NOCOPY companyNameList,
55 t_ship_to_id IN OUT NOCOPY numberList,
56 t_ship_to_site IN OUT NOCOPY companySiteList,
57 t_ship_to_site_id IN OUT NOCOPY numberList,
58 t_bkt_type IN OUT NOCOPY numberList,
59 t_posting_party_id IN OUT NOCOPY numberList,
60 t_item_name IN OUT NOCOPY itemNameList,
61 t_item_desc IN OUT NOCOPY itemDescList,
62 t_pub_ot_desc IN OUT NOCOPY fndMeaningList,
63 t_bkt_type_desc IN OUT NOCOPY fndMeaningList,
64 t_posting_party_name IN OUT NOCOPY companyNameList,
65 t_uom_code IN OUT NOCOPY itemUomList,
66 t_planner_code IN OUT NOCOPY plannerCodeList,
67 t_end_date IN OUT NOCOPY dateList,
68 t_ship_date IN OUT NOCOPY dateList,
69 t_tp_ship_date IN OUT NOCOPY dateList,
70 t_receipt_date IN OUT NOCOPY dateList,
71 t_tp_receipt_date IN OUT NOCOPY dateList,
72 t_master_item_name IN OUT NOCOPY itemNameList,
73 t_master_item_desc IN OUT NOCOPY itemDescList,
74 t_cust_item_name IN OUT NOCOPY itemNameList,
75 t_cust_item_desc IN OUT NOCOPY itemDescList,
76 t_tp_uom IN OUT NOCOPY itemUomList,
77 t_tp_qty IN OUT NOCOPY numberList
78 );
79
80 PROCEDURE get_optional_info(
81 t_item_id IN numberList,
82 t_pub_id IN numberList,
83 t_cust_id IN numberList,
84 t_cust_site_id IN numberList,
85 t_tp_cust_id IN numberList,
86 t_src_cust_site_id IN numberList,
87 t_src_org_id IN numberList,
88 t_src_instance_id IN numberList,
89 t_item_name IN itemNameList,
90 t_uom_code IN itemUomList,
91 t_qty IN numberList,
92 t_ship_date IN dateList,
93 t_receipt_date IN dateList,
94 t_tp_ship_date IN OUT NOCOPY dateList,
95 t_tp_receipt_date IN OUT NOCOPY dateList,
96 t_master_item_name IN OUT NOCOPY itemNameList,
97 t_master_item_desc IN OUT NOCOPY itemDescList,
98 t_cust_item_name IN OUT NOCOPY itemNameList,
99 t_cust_item_desc IN OUT NOCOPY itemDescList,
100 t_tp_uom IN OUT NOCOPY itemUomList,
101 t_tp_qty IN OUT NOCOPY numberList,
102 t_lead_time IN numberList,
103 p_forecast_date IN varchar2
104 );
105
106 PROCEDURE insert_into_sup_dem (
107 t_pub IN companyNameList,
108 t_pub_id IN numberList,
109 t_pub_site IN companySiteList,
110 t_pub_site_id IN numberList,
111 t_item_id IN numberList,
112 t_qty IN numberList,
113 t_pub_ot IN numberList,
114 t_cust IN companyNameList,
115 t_cust_id IN numberList,
116 t_cust_site IN companySiteList,
117 t_cust_site_id IN numberList,
118 t_ship_from IN companyNameList,
119 t_ship_from_id IN numberList,
120 t_ship_from_site IN companySiteList,
121 t_ship_from_site_id IN numberList,
122 t_ship_to IN companyNameList,
123 t_ship_to_id IN numberList,
124 t_ship_to_site IN companySiteList,
125 t_ship_to_site_id IN numberList,
126 t_bkt_type IN numberList,
127 t_posting_party_id IN numberList,
128 t_item_name IN itemNameList,
129 t_item_desc IN itemDescList,
130 t_master_item_name IN itemNameList,
131 t_master_item_desc IN itemDescList,
132 t_cust_item_name IN itemNameList,
133 t_cust_item_desc IN itemDescList,
134 t_pub_ot_desc IN fndMeaningList,
135 t_bkt_type_desc IN fndMeaningList,
136 t_posting_party_name IN companyNameList,
137 t_uom_code IN itemUomList,
138 t_planner_code IN plannerCodeList,
139 t_tp_ship_date IN dateList,
140 t_tp_receipt_date IN dateList,
141 t_tp_uom IN itemUomList,
142 t_tp_qty IN numberList,
143 p_version IN varchar2,
144 p_designator IN varchar2,
145 t_shipping_control IN shippingControlList
146 );
147
148 PROCEDURE delete_old_forecast(
149 p_org_id in number,
150 p_sr_instance_id in number,
151 p_planner_code in varchar2,
152 -- p_abc_class in varchar2,
153 p_item_id in number,
154 p_customer_id in number,
155 p_customer_site_id in number,
156 l_horizon_start in date,
157 p_horizon_end in date
158 );
159
160 END MSD_SCE_PUBLISH_FORECAST_PKG;