[Home] [Help]
PACKAGE: APPS.MTH_PROCESS_STATUS_PKG
Source
1 PACKAGE MTH_PROCESS_STATUS_PKG AUTHID CURRENT_USER AS
2 /*$Header: mtheqsts.pls 120.0.12020000.1 2012/07/24 16:10:47 sasuren noship $*/
3
4 /*******************************************************************************
5 * Procedure :VALIDATE *
6 * Description :This procedure is the validate procedure *
7 * File Name :MTHEQOPB.PLS *
8 * Visibility :Public *
9 * Parameters : p_err_buff : Error message *
10 * p_retcode : Error Code *
11 * Modification log : *
12 * Author Date Change *
13 * Mandar Gijare 13-Sep-2011 Initial Creation *
14 *******************************************************************************/
15 PROCEDURE VALIDATE(
16 p_mode IN VARCHAR2,
17 p_source IN VARCHAR2,
18 p_retcode OUT NOCOPY NUMBER,
19 p_err_buff OUT NOCOPY VARCHAR2
20 );
21
22 /*******************************************************************************
23 * Procedure :PROCESS_STATUS *
24 * Description :This procedure is the main procedure for status *
25 * File Name :MTHEQSTS.PLS *
26 * Visibility :Public *
27 * Parameters : p_mode : INIT,INCR,RECAL *
28 * p_source : TAG,CSV *
29 * p_recal_from_date : Recalculation from date *
30 * p_recal_to_date : Recalculation to date *
31 * p_equipment_pk_key : Equipment to recalculate *
32 * Modification log : *
33 * Author Date Change *
34 * Mandar Gijare 02-Sep-2011 Initial Creation *
35 *******************************************************************************/
36
37 PROCEDURE PROCESS_STATUS( p_mode IN VARCHAR2, --INIT, INCR, RECAL
38 p_source IN VARCHAR2, --TAG, CSV
39 p_recal_from_date IN DATE DEFAULT NULL, --Recalculation from date
40 p_recal_to_date IN DATE DEFAULT NULL, --Recalculation to date
41 p_equipment_pk_key IN NUMBER DEFAULT NULL, --Equipment to recalculate
42 p_plant_pk_key IN NUMBER DEFAULT NULL, --Site for which recalcution to be done
43 p_ret_code OUT NOCOPY NUMBER
44 );
45
46 /*******************************************************************************
47 * Procedure :PROCESS_STATUS_SUMMARY *
48 * Description :This procedure is the main procedure for status *
49 * summary
50 * File Name :MTHEQSTS.PLS *
51 * Visibility :Public *
52 * Parameters : p_fact_name : name of the fact table *
53 * p_from_date : from_date for the run *
54 * p_to_date : to_date for the run *
55 * Modification log : *
56 * Author Date Change *
57 * Mandar Gijare 02-Sep-2011 Initial Creation *
58 *******************************************************************************/
59 PROCEDURE PROCESS_STATUS_SUMMARY(p_mode IN VARCHAR2, --INIT,INCR,RECAL
60 p_recal_from_date IN TIMESTAMP , --Recalculation from date
61 p_recal_to_date IN TIMESTAMP DEFAULT NULL, --Recalculation to date
62 p_equipment_pk_key IN NUMBER DEFAULT NULL, --Equipment to recalculate
63 p_plant_pk_key IN NUMBER DEFAULT NULL, --Plant to recalculate
64 p_ret_code OUT NOCOPY NUMBER
65 );
66
67
68 END MTH_PROCESS_STATUS_PKG;