APPS.HRI_OLTP_PMV_ABS_DTL dependencies on BIS_QUERY_ATTRIBUTES

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 33: l_custom_rec BIS_QUERY_ATTRIBUTES;

29: l_params_header VARCHAR2(10000);
30: l_lnk_profile_chk VARCHAR2(4000);
31:
32: /* Table of custom parameters */
33: l_custom_rec BIS_QUERY_ATTRIBUTES;
34:
35: /* Security clause */
36: l_security_clause VARCHAR2(1000);
37:

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 186: l_custom_rec BIS_QUERY_ATTRIBUTES;

182: l_params_header VARCHAR2(10000);
183: l_lnk_profile_chk VARCHAR2(4000);
184:
185: /* Table of custom parameters */
186: l_custom_rec BIS_QUERY_ATTRIBUTES;
187:
188: /* Security clause */
189: l_security_clause VARCHAR2(1000);
190:

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;