APPS.HRI_OLTP_EMB_EQTY_ANAL dependencies on HRI_OLTP_EMB_EQTY_ANAL

Line 1: PACKAGE BODY HRI_OLTP_EMB_EQTY_ANAL AS

1: PACKAGE BODY HRI_OLTP_EMB_EQTY_ANAL AS
2: /* $Header: hrioembeanl.pkb 120.3.12000000.2 2007/04/16 06:27:48 vjaganat noship $ */
3:
4:
5: g_schema VARCHAR2(50) := 'APPS';

Line 128: p_parameter_rec IN HRI_OLTP_EMB_EQTY_ANAL.HRI_EMB_PARAM_REC_TYPE

124: ** Hardcoded to a new MV in first version
125: **
126: */
127: PROCEDURE get_wrkfc_fact_table(
128: p_parameter_rec IN HRI_OLTP_EMB_EQTY_ANAL.HRI_EMB_PARAM_REC_TYPE
129: ,o_sql_string OUT NOCOPY VARCHAR2
130: ,o_return_status OUT NOCOPY VARCHAR2)
131: IS
132:

Line 143: FUNCTION get_wrkfc_fact_table(p_parameter_rec IN HRI_OLTP_EMB_EQTY_ANAL.HRI_EMB_PARAM_REC_TYPE)

139: o_return_status := 'EXCEPTION: ' || SUBSTRB(SQLERRM,50);
140: END get_wrkfc_fact_table; -- procedure
141:
142: /* function call to get_wrkfc_fact_table procedure */
143: FUNCTION get_wrkfc_fact_table(p_parameter_rec IN HRI_OLTP_EMB_EQTY_ANAL.HRI_EMB_PARAM_REC_TYPE)
144: RETURN VARCHAR2
145: IS
146:
147: l_return_status VARCHAR2(1000);

Line 170: p_parameter_rec IN HRI_OLTP_EMB_EQTY_ANAL.HRI_EMB_PARAM_REC_TYPE

166:
167:
168:
169: PROCEDURE get_wrkfc_fact_sql(
170: p_parameter_rec IN HRI_OLTP_EMB_EQTY_ANAL.HRI_EMB_PARAM_REC_TYPE
171: ,o_sql_string OUT NOCOPY VARCHAR2
172: ,o_return_status OUT NOCOPY VARCHAR2)
173: IS
174:

Line 260: p_parameter_rec IN HRI_OLTP_EMB_EQTY_ANAL.HRI_EMB_PARAM_REC_TYPE

256: ** may be enhanced in a future version to use a 'CEO' level MV.
257: **
258: **/
259: PROCEDURE get_wrkfc_fact_ceo_sql(
260: p_parameter_rec IN HRI_OLTP_EMB_EQTY_ANAL.HRI_EMB_PARAM_REC_TYPE
261: ,o_sql_string OUT NOCOPY VARCHAR2
262: ,o_return_status OUT NOCOPY VARCHAR2)
263: IS
264:

Line 266: l_parameter_rec HRI_OLTP_EMB_EQTY_ANAL.HRI_EMB_PARAM_REC_TYPE;

262: ,o_return_status OUT NOCOPY VARCHAR2)
263: IS
264:
265: l_sql_statement VARCHAR2(32000);
266: l_parameter_rec HRI_OLTP_EMB_EQTY_ANAL.HRI_EMB_PARAM_REC_TYPE;
267:
268: BEGIN
269:
270: l_parameter_rec := p_parameter_rec;

Line 293: p_parameter_rec IN HRI_OLTP_EMB_EQTY_ANAL.HRI_EMB_PARAM_REC_TYPE

289: /*
290: ** Formats the report U.I. outer columns
291: **/
292: PROCEDURE get_outer_columns(
293: p_parameter_rec IN HRI_OLTP_EMB_EQTY_ANAL.HRI_EMB_PARAM_REC_TYPE
294: ,o_sql_string OUT NOCOPY VARCHAR2
295: ,o_return_status OUT NOCOPY VARCHAR2)
296: IS
297:

Line 371: l_parameter_rec HRI_OLTP_EMB_EQTY_ANAL.HRI_EMB_PARAM_REC_TYPE;

367: l_eqty_outer_columns1 VARCHAR2(1000);
368: l_eqty_outer_columns2 VARCHAR2(1000);
369:
370: -- parameter structure
371: l_parameter_rec HRI_OLTP_EMB_EQTY_ANAL.HRI_EMB_PARAM_REC_TYPE;
372:
373: -- fixed GSCC hardcoded schema issue
374: l_dummy1 VARCHAR2(2000);
375: l_dummy2 VARCHAR2(2000);

Line 495: END HRI_OLTP_EMB_EQTY_ANAL;

491:
492: END get_sql;
493:
494:
495: END HRI_OLTP_EMB_EQTY_ANAL;