1 PACKAGE msc_sce_pub_supply_commit_pkg AUTHID CURRENT_USER AS
2 /* $Header: MSCXPSCS.pls 115.15 2004/08/13 18:36:28 yptang 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_supply_commits (
18 p_errbuf out nocopy varchar2,
19 p_retcode out nocopy varchar2,
20 p_plan_id in number,
21 p_org_code in varchar2 default null,
22 p_planner_code in varchar2 default null,
23 p_abc_class in varchar2 default null,
24 p_item_id in number default null,
25 p_planning_gp in varchar2 default null,
26 p_project_id in number default null,
27 p_task_id in number default null,
28 p_source_customer_id in number default null,
29 p_source_customer_site_id in number default null,
30 p_horizon_start in varchar2,
31 p_horizon_end in varchar2,
32 p_auto_version in number default 1,
33 p_version in number default null,
34 p_include_so_flag in number default 2,
35 p_overwrite in number default 1
36 );
37
38 /*
39 PROCEDURE get_optional_info(
40 t_item_id IN numberList,
41 t_pub_id IN numberList,
42 t_cust_id IN numberList,
43 t_cust_site_id IN numberList,
44 t_src_cust_id IN numberList,
45 t_src_cust_site_id IN numberList,
46 t_src_org_id IN numberList,
47 t_src_instance_id IN numberList,
48 t_item_name IN itemNameList,
49 t_uom_code IN itemUomList,
50 t_qty IN numberList,
51 t_receipt_date IN dateList,
52 t_tp_receipt_date IN OUT NOCOPY dateList,
53 t_tp_item_name IN OUT NOCOPY itemNameList,
54 t_tp_uom IN OUT NOCOPY itemUomList,
55 t_tp_qty IN OUT NOCOPY numberList
56 ) ;
57 */
58
59 PROCEDURE get_optional_info(
60 t_item_id IN numberList,
61 t_pub_id IN numberList,
62 t_cust_id IN numberList,
63 t_cust_site_id IN numberList,
64 t_src_cust_id IN numberList,
65 t_src_cust_site_id IN numberList,
66 t_src_org_id IN numberList,
67 t_src_instance_id IN numberList,
68 t_item_name IN OUT NOCOPY itemNameList,
69 t_uom_code IN itemUomList,
70 t_qty IN numberList,
71 t_receipt_date IN dateList,
72 t_tp_receipt_date IN OUT NOCOPY dateList,
73 --t_tp_item_name IN OUT NOCOPY itemNameList,
74 t_master_item_name IN OUT NOCOPY itemNameList,
75 t_master_item_desc IN OUT NOCOPY itemDescList,
76 t_cust_item_name IN OUT NOCOPY itemNameList,
77 t_cust_item_desc IN OUT NOCOPY itemDescList,
78 t_tp_uom IN OUT NOCOPY itemUomList,
79 t_tp_qty IN OUT NOCOPY numberList,
80 t_item_desc IN OUT NOCOPY itemDescList
81 );
82 /*
83 PROCEDURE insert_into_sup_dem (
84 t_pub IN companyNameList,
85 t_pub_id IN numberList,
86 t_pub_site IN companySiteList,
87 t_pub_site_id IN numberList,
88 t_item_id IN numberList,
89 t_qty IN numberList,
90 t_pub_ot IN numberList,
91 t_cust IN companyNameList,
92 t_cust_id IN numberList,
93 t_cust_site IN companySiteList,
94 t_cust_site_id IN numberList,
95 t_ship_from IN companyNameList,
96 t_ship_from_id IN numberList,
97 t_ship_from_site IN companySiteList,
98 t_ship_from_site_id IN numberList,
99 t_ship_to IN companyNameList,
100 t_ship_to_id IN numberList,
101 t_ship_to_site IN companySiteList,
102 t_ship_to_site_id IN numberList,
103 t_bkt_type IN numberList,
104 t_posting_party_id IN numberList,
105 t_item_name IN itemNameList,
106 t_item_desc IN itemDescList,
107 t_pub_ot_desc IN fndMeaningList,
108 t_proj_number IN numberList,
109 t_task_number IN numberList,
110 t_planning_gp IN planningGroupList,
111 t_bkt_type_desc IN fndMeaningList,
112 t_posting_party_name IN companyNameList,
113 t_uom_code IN itemUomList,
114 t_planner_code IN plannerCodeList,
115 t_ship_date IN dateList,
116 t_tp_receipt_date IN dateList,
117 t_tp_item_name IN itemNameList,
118 t_tp_uom IN itemUomList,
119 t_tp_qty IN numberList,
120 p_version IN varchar2,
121 p_designator IN varchar2
122 );
123 */
124
125 PROCEDURE insert_into_sup_dem (
126 t_pub IN companyNameList,
127 t_pub_id IN numberList,
128 t_pub_site IN companySiteList,
129 t_pub_site_id IN numberList,
130 t_item_id IN numberList,
131 t_qty IN numberList,
132 t_pub_ot IN numberList,
133 t_cust IN companyNameList,
134 t_cust_id IN numberList,
135 t_cust_site IN companySiteList,
136 t_cust_site_id IN numberList,
137 t_ship_from IN companyNameList,
138 t_ship_from_id IN numberList,
139 t_ship_from_site IN companySiteList,
140 t_ship_from_site_id IN numberList,
141 t_ship_to IN companyNameList,
142 t_ship_to_id IN numberList,
143 t_ship_to_site IN companySiteList,
144 t_ship_to_site_id IN numberList,
145 t_bkt_type IN numberList,
146 t_posting_party_id IN numberList,
147 t_item_name IN itemNameList,
148 t_item_desc IN itemDescList,
149 t_master_item_name IN itemNameList,
150 t_master_item_desc IN itemDescList,
151 t_cust_item_name IN itemNameList,
152 t_cust_item_desc IN itemDescList,
153 t_pub_ot_desc IN fndMeaningList,
154 t_proj_number IN numberList,
155 t_task_number IN numberList,
156 t_planning_gp IN planningGroupList,
157 t_bkt_type_desc IN fndMeaningList,
158 t_posting_party_name IN companyNameList,
159 t_uom_code IN itemUomList,
160 t_planner_code IN plannerCodeList,
161 t_ship_date IN dateList,
162 t_receipt_date IN dateList,
163 t_tp_item_name IN itemNameList,
164 t_tp_uom IN itemUomList,
165 t_tp_qty IN numberList,
166 p_version IN varchar2,
167 p_designator IN VARCHAR2,
168 p_user_id IN number,
169 t_shipping_control IN shippingControlList,
170 t_key_date IN dateList
171 );
172
173 PROCEDURE delete_old_forecast(
174 p_plan_id in number,
175 p_org_id in number,
176 p_sr_instance_id in number,
177 p_planner_code in varchar2,
178 p_abc_class in varchar2,
179 p_item_id in number,
180 p_planning_gp in varchar2,
181 p_project_id in number,
182 p_task_id in number,
183 p_source_customer_id in number,
184 p_source_customer_site_id in number,
185 p_horizon_start in date,
186 p_horizon_end in date,
187 p_overwrite in number
188 );
189
190 PROCEDURE log_message(
191 p_string IN VARCHAR2
192 );
193
194 FUNCTION get_message (
195 p_app IN VARCHAR2,
196 p_name IN VARCHAR2,
197 p_lang IN VARCHAR2
198 ) RETURN VARCHAR2;
199
200 -- This procesure prints out debug information
201 PROCEDURE print_debug_info(
202 p_debug_info IN VARCHAR2
203 );
204
205 -- This procesure prints out message to user
206 PROCEDURE print_user_info(
207 p_user_info IN VARCHAR2
208 );
209
210 END msc_sce_pub_supply_commit_pkg;