1 PACKAGE MSC_X_CVMI_REPLENISH AS
2 /* $Header: MSCXCFVS.pls 120.1 2005/12/12 02:49:12 shwmathu noship $ */
3
4 -- constants used for SCE order type code
5 REPLENISHMENT CONSTANT NUMBER := 19;
6 REQUISITION CONSTANT NUMBER := 20;
7 SUPPLY_SCHEDULE CONSTANT NUMBER := 2;
8 ALLOCATED_ONHAND CONSTANT NUMBER := 9;
9 UNALLOCATED_ONHAND CONSTANT NUMBER := 10;
10 ASN CONSTANT NUMBER := 15;
11 SHIPMENT_RECEIPT CONSTANT NUMBER := 16;
12 PURCHASE_ORDER CONSTANT NUMBER := 13;
13 CONSUMPTION_ADVICE CONSTANT NUMBER := 28;
14
15 CP_PLAN_ID CONSTANT NUMBER := -1;
16 INTERNAL_REQ CONSTANT NUMBER := 30;
17 INTERNAL_SALES_ORDER CONSTANT NUMBER := 29;
18 SALES_ORDER CONSTANT NUMBER := 14;
19 SYS_YES CONSTANT NUMBER := 1;
20 SYS_NO CONSTANT NUMBER := 2;
21 FUTURE_DATE CONSTANT NUMBER := 30000;
22 VMI_PLANNING_METHOD CONSTANT NUMBER := 7;
23 NOT_EXISTS NUMBER := -1;
24 REFRESHED NUMBER := 1;
25 NOT_REFRESHED NUMBER := 0;
26
27 UNRELEASED CONSTANT NUMBER := 0;
28 RELEASED CONSTANT NUMBER := 1;
29 REJECTED CONSTANT NUMBER := 2;
30
31 VMI_PLAN_ID CONSTANT NUMBER := -1;
32 REORDER_POINT_CODE CONSTANT NUMBER := 1;
33 MIN_MAX_CODE CONSTANT NUMBER := 2;
34 AUTO_RELEASE_YES CONSTANT NUMBER := 1;
35
36 CUSTOMER_OF CONSTANT NUMBER := 1;
37 COMPANY_MAPPING CONSTANT NUMBER := 1;
38 ORGANIZATION_MAPPING CONSTANT NUMBER := 2;
39 SITE_MAPPING CONSTANT NUMBER := 3;
40
41 OEM_COMPANY_ID CONSTANT NUMBER := 1;
42 UNCONSIGNED CONSTANT NUMBER := 2;
43 CONSIGNED CONSTANT NUMBER := 1;
44
45 TYPE number_arr IS TABLE of NUMBER;
46 TYPE date_arr IS TABLE of DATE;
47
48 TYPE ordernumList IS TABLE OF msc_sup_dem_entries.order_number%TYPE;
49 TYPE releasenumList IS TABLE OF msc_sup_dem_entries.release_number%TYPE;
50 TYPE linenumList IS TABLE OF msc_sup_dem_entries.line_number%TYPE;
51 TYPE companynameList IS TABLE of msc_companies.company_name%TYPE;
52 TYPE companysitenameList is TABLE of msc_company_sites.company_site_name%TYPE;
53 TYPE itemnameList is TABLE of msc_items.item_name%TYPE;
54 TYPE uomcodeList is TABLE of msc_system_items.uom_code%TYPE;
55 TYPE itemdescriptionList is TABLE of msc_system_items.description%TYPE;
56 -- TYPE suppliercontactList is TABLE of msc_planners.user_name%TYPE;
57 TYPE plannerCodeList is TABLE of msc_system_items.planner_code%TYPE;
58 -- TYPE customercontactList is TABLE of msc_partner_contacts.name%TYPE;
59
60 -- This procedure will be called by Concurrent Program to perform
61 -- SCE VMI replenishment
62 PROCEDURE vmi_replenish_concurrent
63 (
64 p_replenish_time_fence IN NUMBER DEFAULT 1
65 );
66
67 -- This procedure is associated with the 'Create Replenishment' Workflow
68 -- activity and will create a VMI replenishment if there is a shortage
69 -- of supply
70 PROCEDURE vmi_replenish(l_last_max_refresh_number IN NUMBER,
71 l_repl_time_fence IN NUMBER);
72
73
74 -- This procesure prints out message to user
75 PROCEDURE vmi_reject
76 ( itemtype in varchar2
77 , itemkey in varchar2
78 , actid in number
79 , funcmode in varchar2
80 , resultout out nocopy varchar2
81 );
82
83 PROCEDURE is_auto_release
84 (
85 itemtype in varchar2
86 , itemkey in varchar2
87 , actid in number
88 , funcmode in varchar2
89 , resultout out nocopy varchar2
90 );
91
92 PROCEDURE Is_Supplier_Approval
93 (
94 itemtype in varchar2
95 , itemkey in varchar2
96 , actid in number
97 , funcmode in varchar2
98 , resultout out nocopy varchar2
99 );
100
101 PROCEDURE vmi_release_api
102 ( p_inventory_item_id IN NUMBER
103 , p_sr_instance_id IN NUMBER
104 , p_supplier_id IN NUMBER
105 , p_supplier_site_id IN NUMBER
106 , p_customer_id IN NUMBER
107 , p_customer_site_id IN NUMBER
108 , p_release_quantity IN NUMBER
109 , p_uom IN VARCHAR2
110 , p_sr_inventory_item_id IN NUMBER
111 , p_customer_model_org_id IN NUMBER
112 , p_source_org_id IN NUMBER
113 , p_request_date IN DATE
114 , p_consigned_flag IN NUMBER
115 , p_vmi_release_type IN NUMBER
116 , p_item_name VARCHAR2
117 , p_item_describtion VARCHAR2
118 , p_customer_name VARCHAR2
119 , p_customer_site_name VARCHAR2
120 , p_uom_code VARCHAR2
121 , p_vmi_minimum_units IN OUT NOCOPY NUMBER
122 , p_vmi_maximum_units IN OUT NOCOPY NUMBER
123 , p_vmi_minimum_days NUMBER
124 , p_vmi_maximum_days NUMBER
125 , p_average_daily_demand NUMBER
126 , p_ORDER_NUMBER IN VARCHAR2 --Consigned CVMI Enh
127 , p_RELEASE_NUMBER IN VARCHAR2
128 , p_LINE_NUMBER IN VARCHAR2
129 , p_END_ORDER_NUMBER IN VARCHAR2
130 , p_END_ORDER_REL_NUMBER IN VARCHAR2
131 , p_END_ORDER_LINE_NUMBER IN VARCHAR2
132 , p_source_org_name IN VARCHAR2
133 , p_order_type IN VARCHAR2
134 );
135
136 PROCEDURE vmi_release_api_ui
137 ( p_rep_transaction_id IN NUMBER
138 , p_release_quantity IN NUMBER
139 );
140
141 PROCEDURE vmi_release_api_load
142 ( p_header_id IN NUMBER
143 );
144
145 PROCEDURE vmi_replenish_wf
146 (
147 p_rep_transaction_id IN NUMBER
148 , p_inventory_item_id IN NUMBER
149 , p_supplier_id IN NUMBER
150 , p_supplier_site_id IN NUMBER
151 , p_sr_instance_id IN NUMBER
152 , p_customer_id IN NUMBER
153 , p_customer_site_id IN NUMBER
154 , p_vmi_minimum_units IN NUMBER
155 , p_vmi_maximum_units IN NUMBER
156 , p_vmi_minimum_days IN NUMBER
157 , p_vmi_maximum_days IN NUMBER
158 , p_so_authorization_flag IN NUMBER
159 , p_consigned_flag IN NUMBER
160 , p_planner_code IN VARCHAR2 -- , p_supplier_contact IN VARCHAR2
161 -- , p_customer_contact IN VARCHAR2
162 , p_supplier_item_name IN VARCHAR2
163 , p_supplier_item_desc IN VARCHAR2
164 , p_customer_item_name IN VARCHAR2
165 , p_customer_item_desc IN VARCHAR2
166 , p_supplier_name IN VARCHAR2
167 , p_supplier_site_name IN VARCHAR2
168 , p_customer_name IN VARCHAR2
169 , p_customer_site_name IN VARCHAR2
170 , p_order_quantity IN VARCHAR2
171 , p_onhand_quantity IN VARCHAR2
172 , p_time_fence_multiplier IN NUMBER
173 , p_time_fence_end_date IN VARCHAR2
174 , p_uom IN VARCHAR2
175 , p_source_so_org_id IN NUMBER
176 , p_modeled_customer_org_id IN NUMBER
177 , p_vmi_release_type IN NUMBER
178 , p_sr_inventory_item_id IN NUMBER
179 );
180
181 PROCEDURE print_user_info(
182 p_user_info IN VARCHAR2
183 );
184
185 PROCEDURE print_debug_info(
186 p_debug_info IN VARCHAR2
187 );
188
189 PROCEDURE reset_vmi_refresh_flag;
190
191 END MSC_X_CVMI_REPLENISH;