1 PACKAGE EAM_Downtime_PUB AUTHID CURRENT_USER as
2 /* $Header: EAMPEQDS.pls 115.3 2002/12/06 00:33:01 dizhao noship $ */
3
4
5 /* ========================================================================== */
6 -- PROCEDURE
7 -- Process_Production_Downtime
8 --
9 -- Description
10 -- This procedure is called by the concurrent program Load Production
11 -- Maintenance Downtime. The following parameters are passed by the
12 -- concurrent program:
13 -- . p_org_id
14 -- production organization to load maintenance downtime
15 -- . p_simulation_set
16 -- simulation set to load capacity reduction caused by downtime
17 -- . p_run_option
18 -- 1 = load downtime
19 -- 2 = purge all capacity change entries loaded by this process
20 -- . p_include_unreleased
21 -- 1 (yes) = consider both released and unreleased work orders
22 -- 2 (no) = consider only released work orders
23 -- . p_firm_order_only
24 -- 1 = consider only firm work orders
25 -- 2 = consider both firm and non-firm work orders
26 -- . p_department_id
27 -- Compute downtime only for equipment instances associated to
28 -- resources owned by the specified department.
29 -- . p_resource_id
30 -- Compute downtime only for equipment instances associated to
31 -- the specified resource.
32
33 /* ========================================================================== */
34
35 PROCEDURE Process_Production_Downtime(
36 errbuf OUT NOCOPY VARCHAR2,
37 retcode OUT NOCOPY NUMBER,
38 p_org_id IN NUMBER,
39 p_simulation_set IN VARCHAR2,
40 p_run_option IN NUMBER,
41 p_include_unreleased IN NUMBER,
42 p_firm_order_only IN NUMBER,
43 p_department_id IN NUMBER DEFAULT NULL,
44 p_resource_id IN NUMBER DEFAULT NULL
45 );
46 END EAM_Downtime_PUB;