1 PACKAGE msc_exp_wf AUTHID CURRENT_USER AS
2 /*$Header: MSCEXWFS.pls 115.10 2004/04/27 06:23:20 pragarwa ship $ */
3
4 PROCEDURE launch_workflow(errbuf OUT NOCOPY VARCHAR2,
5 retcode OUT NOCOPY NUMBER,
6 p_plan_id IN NUMBER,
7 p_exception_id IN NUMBER DEFAULT NULL,
8 p_query_id IN NUMBER DEFAULT NULL);
9
10 PROCEDURE StartWFProcess ( item_type in varchar2 default null,
11 item_key in varchar2,
12 l_exception_id in number,
13 organization_id in number,
14 instance_id in number,
15 inventory_item_id in number,
16 exception_type in number,
17 organization_code in varchar2,
18 item_segments in varchar2,
19 item_description in varchar2,
20 exception_type_text in varchar2,
21 project_number in varchar2,
22 to_project_number in varchar2,
23 task_number in varchar2,
24 to_task_number in varchar2,
25 planning_group in varchar2,
26 due_date in date,
27 from_date in date,
28 p_to_date in date,
29 days_compressed in number,
30 quantity in varchar2,
31 lot_number in varchar2,
32 order_number in varchar2,
33 order_type_code in number,
34 supply_type in varchar2,
35 end_item_segments in varchar2,
36 end_item_description in varchar2,
37 end_order_number in varchar2,
38 department_line_code in varchar2,
39 resource_code in varchar2,
40 utilization_rate in number,
41 supplier_id in number,
42 supplier_name in varchar2,
43 supplier_site_id in number,
44 supplier_site_code in varchar2,
45 customer_id in number,
46 customer_name in varchar2,
47 workbench_function in varchar2,
48 workflow_process in varchar2 default null,
49 planner_code in varchar2,
50 p_plan_id in number,
51 db_link in varchar2,
52 l_a2m_db_link in varchar2,
53 transaction_id in number,
54 qty_related_values in number,
55 sup_project_id in number,
56 sup_task_id in number);
57
58 PROCEDURE SelectPlanner( itemtype in varchar2,
59 itemkey in varchar2,
60 actid in number,
61 funcmode in varchar2,
62 resultout out NOCOPY varchar2 );
63
64 FUNCTION GetPlannerMsgName(p_exception_type in number,
65 p_order_type in number,
66 p_stage in number,
67 p_result in varchar2)
68 RETURN varchar2;
69
70
71 PROCEDURE DetermineOrderType( itemtype in varchar2,
72 itemkey in varchar2,
73 actid in number,
74 funcmode in varchar2,
75 resultout out NOCOPY varchar2);
76
77 PROCEDURE Reschedule( itemtype in varchar2,
78 itemkey in varchar2,
79 actid in number,
80 funcmode in varchar2,
81 resultout out NOCOPY varchar2);
82
83 PROCEDURE Reschedule_program(
84 errbuf OUT NOCOPY VARCHAR2,
85 retcode OUT NOCOPY NUMBER,
86 l_plan_id in number,
87 l_transaction_id in number,
88 l_exception_type in number);
89
90 PROCEDURE DeleteActivities( arg_plan_id in number);
91
92 FUNCTION SupplierCapacity(arg_plan_id in number,
93 arg_exception_id in number)
94 return number;
95
96 PROCEDURE IsCallback(itemtype in varchar2,
97 itemkey in varchar2,
98 actid in number,
99 funcmode in varchar2,
100 resultout out NOCOPY varchar2);
101
102 PROCEDURE SelectSrUsers(itemtype in varchar2,
103 itemkey in varchar2,
104 actid in number,
105 funcmode in varchar2,
106 resultout out NOCOPY varchar2);
107
108 PROCEDURE CheckBuyer(itemtype in varchar2,
109 itemkey in varchar2,
110 actid in number,
111 funcmode in varchar2,
112 resultout out NOCOPY varchar2);
113
114 PROCEDURE StartSrWF(itemtype in varchar2,
115 itemkey in varchar2,
116 actid in number,
117 funcmode in varchar2,
118 resultout out NOCOPY varchar2);
119
120 TYPE number_arr IS TABLE OF number;
121 TYPE SupplierToleranceRecord is RECORD(
122 fence number_arr,
123 tolerance number_arr);
124
125 Procedure launch_background_program(p_planner in varchar2,
126 p_item_type in varchar2,
127 p_item_key in varchar2,
128 p_request_id out NOCOPY number);
129
130 Procedure start_deferred_activity(
131 errbuf OUT NOCOPY VARCHAR2,
132 retcode OUT NOCOPY NUMBER,
133 p_item_type varchar2,
134 p_item_key varchar2);
135
136 FUNCTION demand_order_type (p_plan_id number,
137 p_inst_id number,
138 p_demand_id NUMBER) return number;
139
140 FUNCTION demand_order_date (p_plan_id number,
141 p_inst_id number,
142 p_demand_id NUMBER) return date;
143
144 FUNCTION substitute_supply_date (p_plan_id number,
145 p_inst_id number,
146 p_demand_id NUMBER) return date;
147
148 END msc_exp_wf;