[Home] [Help]
PACKAGE: APPS.MTH_PROCESS_UDA_PKG
Source
1 PACKAGE MTH_PROCESS_UDA_PKG AUTHID CURRENT_USER AS
2 /*$Header: mthudaps.pls 120.2.12020000.1 2012/07/24 16:14:20 sasuren noship $*/
3
4 /*******************************************************************************
5 * Procedure :MAIN *
6 * Description :This procedure is the main procedure for output *
7 * File Name :MTHUDAPB.PLS *
8 * Visibility :Public *
9 * Parameters : p_mode : INIT,INCR,RECALC *
10 * p_recal_from_date : Recalculation from date *
11 * p_recal_to_date : Recalculation to date *
12 * p_equipment_pk_key : Equipment to recalculate *
13 * p_plant_fk_key : Plant *
14 * p_err_buff : Error message *
15 * p_retcode : Error Code *
16 * Modification log : *
17 * Author Date Change *
18 * Srikanth Lakshmanan 17-Oct-2011 Initial Creation *
19 *******************************************************************************/
20
21
22 PROCEDURE PROCESS_UDA( p_mode IN VARCHAR2, --INIT, INCR, RECALC
23 p_recal_from_date IN DATE DEFAULT NULL, --Recalculation from date
24 p_recal_to_date IN DATE DEFAULT NULL, --Recalculation to date
25 p_equipment_pk_key IN NUMBER DEFAULT NULL, --Equipment to recalculate
26 p_plant_fk_key IN NUMBER DEFAULT NULL, --Equipment to recalculate
27 p_retcode OUT NOCOPY NUMBER
28 );
29
30 /*******************************************************************************
31 * Procedure :VALIDATE *
32 * Description :This procedure is the validate procedure *
33 * File Name :MTHUDAPB.PLS *
34 * Visibility :Public *
35 * Parameters : p_mode : INIT,INCR,RECALC *
36 * p_recal_from_date : Recalculation from date *
37 * p_recal_to_date : Recalculation to date *
38 * p_err_buff : Error message *
39 * p_retcode : Error Code *
40 * Modification log : *
41 * Author Date Change *
42 * Srikanth Lakshmanan 31-Oct-2011 Initial Creation *
43 *******************************************************************************/
44
45 PROCEDURE VALIDATE( p_mode IN VARCHAR2, --INIT, INCR, RECALC
46 p_recal_from_date IN DATE DEFAULT NULL, --Recalculation from date
47 p_recal_to_date IN DATE DEFAULT NULL, --Recalculation to date
48 p_retcode OUT NOCOPY NUMBER,
49 p_err_buff OUT NOCOPY VARCHAR2
50 );
51
52 /*******************************************************************************
53 * Procedure :PROCESS_EQUIPUDA_IN_INCR_MODE *
54 * Description :This procedure is the main procedure for output *
55 * File Name :MTHUDAPB.PLS *
56 * Visibility :Public *
57 * Parameters : *
58 * Modification log : *
59 * Author Date Change *
60 * Srikanth Lakshmanan 17-Oct-2011 Initial Creation *
61 *******************************************************************************/
62
63 PROCEDURE PROCESS_EQUIPUDA_IN_INCR_MODE(
64 p_retcode OUT NOCOPY NUMBER,
65 p_err_buff OUT NOCOPY VARCHAR2
66 );
67
68 /*******************************************************************************
69 * Procedure :REPROCES_EQUIPMENTS_UDA *
70 * Description :This procedure is the main procedure for output *
71 * File Name :MTHUDAPB.PLS *
72 * Visibility :Public *
73 * Parameters : p_recal_from_date : Recalculation from date *
74 * p_recal_to_date : Recalculation to date *
75 * p_equipment_pk_key : Equipment to recalculate *
76 * p_plant_fk_key : Plant to recalculate *
77 * p_err_buff : Error message *
78 * p_retcode : Error Code *
79 * Modification log : *
80 * Author Date Change *
81 * Srikanth Lakshmanan 17-Oct-2011 Initial Creation *
82 *******************************************************************************/
83
84 PROCEDURE REPROCES_EQUIPMENTS_UDA( p_mode IN VARCHAR2, --INIT, INCR, RECALC
85 p_recal_from_date IN DATE DEFAULT NULL, --Recalculation from date
86 p_recal_to_date IN DATE DEFAULT NULL, --Recalculation to date
87 p_equipment_pk_key IN NUMBER DEFAULT NULL, --Equipment to recalculate
88 p_plant IN NUMBER DEFAULT NULL, --Equipment to recalculate
89 p_retcode OUT NOCOPY NUMBER,
90 p_err_buff OUT NOCOPY VARCHAR2
91 );
92
93 /*******************************************************************************
94 * Procedure :PROCESS_INTERFACE_TO_STAGING *
95 * Description :This procedure is the main procedure for output *
96 * File Name :MTHUDAPB.PLS *
97 * Visibility :Public *
98 * Parameters : p_entity *
99 * *
100 * Modification log : *
101 * Author Date Change *
102 * Akanksha verma 30-March-2012 Initial Creation *
103 *******************************************************************************/
104
105 PROCEDURE PROCESS_INTERFACE_TO_STAGING (P_ENTITY IN VARCHAR2
106 );
107
108 /*******************************************************************************
109 * Procedure :PROCESS_UDA_STATIC_DATA *
110 * Description :This procedure is the main procedure for output *
111 * File Name :MTHUDAPB.PLS *
112 * Visibility :Public *
113 * Parameters : p_entity *
114 * *
115 * Modification log : *
116 * Author Date Change *
117 * Akanksha verma 3-April-2012 Initial Creation *
118 *******************************************************************************/
119
120 Procedure PROCESS_UDA_STATIC_DATA (p_err_buff OUT NOCOPY VARCHAR2,
121 p_retcode OUT NOCOPY NUMBER,
122 p_entity IN VARCHAR2
123 );
124
125 END MTH_PROCESS_UDA_PKG;