[Home] [Help]
PACKAGE: APPS.MTH_EQUIPMENT_PKG
Source
1 PACKAGE MTH_EQUIPMENT_PKG AUTHID CURRENT_USER AS
2 /*$Header: mtheqips.pls 120.4.12020000.2 2012/11/06 13:33:48 sasuren noship $*/
3
4 /*******************************************************************************
5 * Procedure :MTH_LOAD_EQUIP_HIER_DENORM *
6 * Description :This procedure is used for populating equipment *
7 * denorm table *
8 * File Name :---- *
9 * Visibility :Public *
10 * Parameters : *
11 * *
12 * Modification log : *
13 * Author Date Change *
14 * Sanjeev Vellore Ramani 04-Apr-2012 Initial Creation*
15 *******************************************************************************/
16 PROCEDURE MTH_LOAD_EQUIP_HIER_DENORM;
17
18 /*******************************************************************************
19 * Fuction :VALIDATE_GROUP_ID *
20 * Description :This function is used for validating group ID *
21 * File Name :---- *
22 * Visibility :Public *
23 * Parameters : *
24 * *
25 * Modification log : *
26 * Author Date Change *
27 * Sanjeev Vellore Ramani 10-Mar-2012 Initial Creation*
28 *******************************************************************************/
29 FUNCTION VALIDATE_GROUP_ID RETURN VARCHAR2;
30
31 /*******************************************************************************
32 * Fuction :VALIDATE_CHILD_PARENT_REL *
33 * Description :This function is used for validating parent-child *
34 * relationship *
35 * File Name :---- *
36 * Visibility :Public *
37 * Parameters : *
38 * *
39 * Modification log : *
40 * Author Date Change *
41 * Sanjeev Vellore Ramani 17-Mar-2012 Initial Creation*
42 *******************************************************************************/
43 FUNCTION VALIDATE_CHILD_PARENT_REL RETURN VARCHAR2;
44
45 /*******************************************************************************
46 * Fuction :VALIDATE_PARENT_MOVE_DATE *
47 * Description :This function is used for validating the date on *
48 * which an entity is moved from one parent to *
49 * another where such a move is effective on a date *
50 * earlier than or equal to the effective date of one*
51 * or more of its children. *
52 * relationship *
53 * File Name :mtheqips.pls *
54 * Visibility :Public *
55 * Parameters :p_print_message varchar2 *
56 * *
57 * Modification log : *
58 * Author Date Change *
59 * Saurabh Surendra 05-Nov-2012 Initial Creation *
60 *******************************************************************************/
61
62 FUNCTION VALIDATE_PARENT_MOVE_DATE (p_print_message IN VARCHAR2 DEFAULT NULL)
63 RETURN VARCHAR2;
64
65 /*******************************************************************************
66 * Procedure :MTH_POPULATE_EQUIP_DENORM *
67 * Description :This procedure is used for populating equipment *
68 * denorm table *
69 * File Name :---- *
70 * Visibility :Public *
71 * Parameters : *
72 * *
73 * Modification log : *
74 * Author Date Change *
75 * Sanjeev Vellore Ramani 26-Mar-2012 Initial Creation*
76 *******************************************************************************/
77 PROCEDURE MTH_POPULATE_EQUIP_DENORM;
78
79 /*******************************************************************************
80 * Procedure :MTH_INSERT_EQUIP_DENORM *
81 * Description :This procedure is used for populating equipment *
82 * denorm table *
83 * File Name :---- *
84 * Visibility :Public *
85 * Parameters :p_level_fk_key *
86 * p_parent_fk_key *
87 * p_hierarchy_id *
88 * p_level_num *
89 * p_effective_date *
90 * p_level_name *
91 * *
92 * Modification log : *
93 * Author Date Change *
94 * Sanjeev Vellore Ramani 30-Mar-2012 Initial Creation*
95 *******************************************************************************/
96 PROCEDURE MTH_INSERT_EQUIP_DENORM(
97 p_level_fk_key IN NUMBER,
98 p_parent_fk_key IN NUMBER,
99 p_hierarchy_id IN NUMBER,
100 p_level_num IN NUMBER,
101 p_effective_date IN DATE,
102 p_level_name IN VARCHAR2);
103
104 /*******************************************************************************
105 * Procedure :MTH_NOVE_EQUIP_DENORM *
106 * Description :This procedure is used for populating equipment *
107 * denorm table *
108 * File Name :---- *
109 * Visibility :Public *
110 * Parameters :p_level_fk_key *
111 * p_parent_fk_key *
112 * p_hierarchy_id *
113 * p_level_num *
114 * p_effective_date *
115 * p_level_name *
116 * Modification log : *
117 * Author Date Change *
118 * Sanjeev Vellore Ramani 10-Apr-2012 Initial Creation*
119 *******************************************************************************/
120 PROCEDURE MTH_MOVE_EQUIP_DENORM(
121 p_level_fk_key IN NUMBER,
122 p_parent_fk_key IN NUMBER,
123 p_hierarchy_id IN NUMBER,
124 p_level_num IN NUMBER,
125 p_effective_date IN DATE,
126 p_level_name IN VARCHAR2);
127
128 /*******************************************************************************
129 * Procedure :MTH_SET_EXPIRATION_DATE *
130 * Description :This procedure is used for setting expiration date*
131 * in the equipment denorm table *
132 * File Name :---- *
133 * Visibility :Public *
134 * Parameters :p_dimension_key *
135 * p_level_num *
136 * p_effective_date *
137 * Modification log : *
138 * Author Date Change *
139 * Sanjeev Vellore Ramani 17-Apr-2012 Initial Creation*
140 *******************************************************************************/
141 PROCEDURE MTH_SET_EXPIRATION_DATE(
142 p_dimension_key IN NUMBER,
143 p_level_num IN NUMBER,
144 p_effective_date IN DATE);
145
146 /* *****************************************************************************
147 * Procedure :MTH_EQUIP_HRCHY_UA_MAP *
148 * Description : *
149 * File Name :MTHEQIPS.PLS *
150 * Visibility :Public *
151 * Parameters :fact table name *
152 * Modification log : *
153 * Author Date Change *
154 * Amrit Kaur 30-Mar-2012 Initial Creation *
155 ****************************************************************************** */
156 PROCEDURE MTH_EQUIP_HRCHY_UA_MAP;
157
158
159 END MTH_EQUIPMENT_PKG;