[Home] [Help]
PACKAGE: APPS.MTH_PROD_DATA_PROCESS_PKG
Source
1 Package MTH_PROD_DATA_PROCESS_PKG AUTHID CURRENT_USER AS
2 /*$Header: mthpdps.pls 120.1.12020000.2 2012/07/25 08:02:20 sasuren ship $ */
3
4
5
6 TYPE EPPLatestTimeLookupTableType IS TABLE OF DATE
7 INDEX BY BINARY_INTEGER;
8
9 /* ****************************************************************************
10 * Procedure :process_transactions *
11 * Description :... *
12 * File Name :MTHPDPB.PLS *
13 * Visibility :Public *
14 * Parameters : *
15 ******************************************************************************/
16
17 PROCEDURE process_epp( p_err_buff OUT NOCOPY VARCHAR2,
18 p_retcode OUT NOCOPY NUMBER,
19 p_mode IN VARCHAR2 --INIT, INCR
20 );
21
22
23 /* ****************************************************************************
24 * Procedure :populate_EPP_from_output *
25 * Description :Load data from equipment output into equipment production *
26 * performance table. *
27 **************************************************************************** */
28 PROCEDURE populate_EPP_from_output(p_run_mode IN VARCHAR2);
29
30 /* ****************************************************************************
31 * Procedure :populate_EPP_for_NonProd_Equip *
32 * Description :Load data for non-production equipments from equipment *
33 * status into equipment production performance table. *
34 **************************************************************************** */
35 PROCEDURE populate_EPP_for_NonProd_Equip(p_run_mode VARCHAR2);
36
37 /* ****************************************************************************
38 * Procedure :update_EPP_from_status *
39 * Description :Update run_hours,idle_hours,down_hours,off_hours *
40 * of EPP from status table. *
41 **************************************************************************** */
42 PROCEDURE update_EPP_from_status(p_run_mode VARCHAR2);
43
44 /* ****************************************************************************
45 * Procedure :populate_prod_perf_detail *
46 * Description : Populate data for equipments into prodcution performance *
47 * details table. *
48 * File Name :MTHPDPB.PLS *
49 * Visibility :Public *
50 * Parameters :None *
51 * Return Value :None *
52 **************************************************************************** */
53 PROCEDURE populate_prod_perf_detail(p_run_mode IN VARCHAR2);
54
55 /* ****************************************************************************
56 * Procedure :populate_prod_sust_detail *
57 * Description : Populate data for equipments into prodcution sustain fact *
58 * table. *
59 * File Name :MTHPDPB.PLS *
60 * Visibility :Public *
61 * Parameters :None *
62 * Return Value :None *
63 **************************************************************************** */
64 PROCEDURE populate_prod_sust_detail(p_run_mode IN VARCHAR2);
65
66 END MTH_PROD_DATA_PROCESS_PKG;