1 PACKAGE MSC_WF_ALLOC_ATP AUTHID CURRENT_USER AS -- specification
2 /* $Header: MSCWFATS.pls 120.1 2005/08/25 05:16:41 anbansal noship $ */
3
4
5 -- ================= Procedures ====================
6
7 --ATP Debug Workflow
8 PROCEDURE DEBUG_WF(
9 p_session_id IN NUMBER,
10 p_login_user IN VARCHAR2,
11 p_session_loc_des IN VARCHAR2,
12 p_trace_loc_des IN VARCHAR2,
13 p_spid_des IN NUMBER);
14
15 PROCEDURE start_mscalloc_wf(
16 p_itemkey IN VARCHAR2,
17 p_inventory_item_id IN NUMBER,
18 p_inventory_item_name IN VARCHAR2,
19 p_plan_id IN NUMBER,
20 p_organization_id IN NUMBER,
21 p_organization_code IN VARCHAR2,
22 p_instance_id IN NUMBER,
23 p_demand_class IN VARCHAR2,
24 p_requested_qty IN NUMBER,
25 p_request_date IN DATE,
26 p_request_date_qty IN NUMBER,
27 p_available_qty IN NUMBER,
28 p_available_date IN DATE,
29 p_stolen_qty IN NUMBER,
30 p_customer_id IN NUMBER,
31 p_customer_site_id IN NUMBER,
32 p_order_number IN NUMBER);
33
34 PROCEDURE Within_Allocation(
35 itemtype in varchar2,
36 itemkey in varchar2,
37 actid in number,
38 funcmode in varchar2,
39 resultout out NoCopy varchar2);
40
41 PROCEDURE Qty_Stolen(
42 itemtype in varchar2,
43 itemkey in varchar2,
44 actid in number,
45 funcmode in varchar2,
46 resultout out NoCopy varchar2);
47
48 PROCEDURE ATP_Satisfy(
49 itemtype in varchar2,
50 itemkey in varchar2,
51 actid in number,
52 funcmode in varchar2,
53 resultout out NoCopy varchar2);
54
55
56 PROCEDURE start_mscatp_wf(
57 p_itemkey IN VARCHAR2,
58 p_inventory_item_id IN NUMBER,
59 p_inventory_item_name IN VARCHAR2,
60 p_plan_id IN NUMBER,
61 p_organization_id IN NUMBER,
62 p_organization_code IN VARCHAR2,
63 p_instance_id IN NUMBER,
64 p_demand_class IN VARCHAR2,
65 p_requested_qty IN NUMBER,
66 p_request_date IN DATE,
67 p_request_date_qty IN NUMBER,
68 p_available_qty IN NUMBER,
69 p_available_date IN DATE,
70 p_customer_id IN NUMBER,
71 p_customer_site_id IN NUMBER,
72 p_order_number IN NUMBER,
73 p_line_number IN NUMBER);
74
75
76 END MSC_WF_ALLOC_ATP;