[Home] [Help]
PACKAGE: APPS.MTH_PROCESS_OUTPUT_PKG
Source
1 PACKAGE MTH_PROCESS_OUTPUT_PKG AUTHID CURRENT_USER AS
2 /*$Header: mtheqops.pls 120.0.12020000.1 2012/07/24 16:10:25 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( p_mode IN VARCHAR2,
16 p_source IN VARCHAR2,
17 p_retcode OUT NOCOPY NUMBER,
18 p_err_buff OUT NOCOPY VARCHAR2
19 );
20
21 /*******************************************************************************
22 * Procedure :PROCESS_OUTPUT *
23 * Description :This procedure is the main procedure for output *
24 * File Name :MTHEQOPS.PLS *
25 * Visibility :Public *
26 * Parameters : p_mode : INIT,INCR,RECAL *
27 * p_source : TAG,CSV *
28 * p_recal_from_date : Recalculation from date *
29 * p_recal_to_date : Recalculation to date *
30 * p_equipment_pk_key : Equipment to recalculate *
31 * p_plant_pk_key : Plant for recalculation *
32 * Modification log : *
33 * Author Date Change *
34 * Mandar Gijare 02-Sep-2011 Initial Creation *
35 *******************************************************************************/
36 PROCEDURE PROCESS_OUTPUT( p_mode IN VARCHAR2, --INIT, INCR, RECAL
37 p_source IN VARCHAR2, --TAG, CSV
38 p_recal_from_date IN DATE DEFAULT NULL, --Recalculation from date
39 p_recal_to_date IN DATE DEFAULT NULL, --Recalculation to date
40 p_equipment_pk_key IN NUMBER DEFAULT NULL , --Equipment to recalculate
41 p_plant_pk_key IN NUMBER DEFAULT NULL, --Plant for recalcution
42 p_ret_code OUT NOCOPY NUMBER
43 );
44
45 /*******************************************************************************
46 * Procedure :PROCESS_OUTPUT_SUMMARY *
47 * Description :This procedure is the main procedure for output *
48 * summary
49 * File Name :MTHEQOPS.PLS *
50 * Visibility :Public *
51 * Parameters : p_fact_name : name of the fact table *
52 * p_from_date : from_date for the run *
53 * p_to_date : to_date for the run *
54 * Modification log : *
55 * Author Date Change *
56 * Mandar Gijare 02-Sep-2011 Initial Creation *
57 *******************************************************************************/
58 PROCEDURE PROCESS_OUTPUT_SUMMARY(p_mode IN VARCHAR2, --INIT,INCR,RECAL
59 p_recal_from_date IN TIMESTAMP , --Recalculation from date
60 p_recal_to_date IN TIMESTAMP DEFAULT NULL, --Recalculation to date
61 p_equipment_pk_key IN NUMBER DEFAULT NULL, --Equipment to recalculate
62 p_plant_pk_key IN NUMBER DEFAULT NULL,
63 p_ret_code OUT NOCOPY NUMBER
64 );
65
66
67 END MTH_PROCESS_OUTPUT_PKG;