APPS.HRI_OLTP_PMV_ABS_DTL dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 25: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

21: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
22: p_lnk_emp_name IN VARCHAR2,
23: p_lnk_mgr_name IN VARCHAR2,
24: x_custom_sql OUT NOCOPY VARCHAR2,
25: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
26:
27: /* Variable to return SQL query for report */
28: l_sqltext VARCHAR2(32000);
29: l_params_header VARCHAR2(10000);

Line 51: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

47: BEGIN
48:
49: /* Initialize table/record variables */
50: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
51: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
52:
53: /* Set security clause */
54: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
55:

Line 178: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

174: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
175: p_lnk_emp_name IN VARCHAR2,
176: p_lnk_mgr_name IN VARCHAR2,
177: x_custom_sql OUT NOCOPY VARCHAR2,
178: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
179:
180: /* Variable to return SQL query for report */
181: l_sqltext VARCHAR2(32000);
182: l_params_header VARCHAR2(10000);

Line 203: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

199: BEGIN
200:
201: /* Initialize table/record variables */
202: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
203: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
204:
205: /* Set security clause */
206: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
207:

Line 315: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

311: /* Absence Detail report */
312: /******************************************************************************/
313: PROCEDURE GET_ABS_DETAIL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
314: x_custom_sql OUT NOCOPY VARCHAR2,
315: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
316:
317: /* Parameter values */
318: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
319: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;