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:
56: /* Loop through parameters that have been set */
57: l_parameter_name := p_bind_tab.FIRST;
58:
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:
208: /* Loop through parameters that have been set */
209: l_parameter_name := p_bind_tab.FIRST;
210:
331: p_parameter_rec => l_parameter_rec,
332: p_bind_tab => l_bind_tab);
333:
334: /* Activite Drill URL for Link to HR Employee Directory */
335: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk
336: (p_parameter_rec => l_parameter_rec
337: ,p_bind_tab => l_bind_tab);
338:
339: IF (l_lnk_profile_chk = 1 AND