APPS.HRI_OLTP_PMV_DTL_SALARY dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 14: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

10: /******************************************************************************/
11: /* Salary detail for Staff = Directs */
12: /******************************************************************************/
13: PROCEDURE get_salary_detail_directs
14: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
15: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
16: p_lnk_emp_name IN VARCHAR2,
17: p_lnk_mgr_name IN VARCHAR2,
18: x_custom_sql OUT NOCOPY VARCHAR2,

Line 15: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

11: /* Salary detail for Staff = Directs */
12: /******************************************************************************/
13: PROCEDURE get_salary_detail_directs
14: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
15: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
16: p_lnk_emp_name IN VARCHAR2,
17: p_lnk_mgr_name IN VARCHAR2,
18: x_custom_sql OUT NOCOPY VARCHAR2,
19: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

Line 232: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

228: /******************************************************************************/
229: /* Salary detail for Staff = All */
230: /******************************************************************************/
231: PROCEDURE get_salary_detail_all
232: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
233: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
234: p_lnk_emp_name IN VARCHAR2,
235: p_lnk_mgr_name IN VARCHAR2,
236: x_custom_sql OUT NOCOPY VARCHAR2,

Line 233: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

229: /* Salary detail for Staff = All */
230: /******************************************************************************/
231: PROCEDURE get_salary_detail_all
232: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
233: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
234: p_lnk_emp_name IN VARCHAR2,
235: p_lnk_mgr_name IN VARCHAR2,
236: x_custom_sql OUT NOCOPY VARCHAR2,
237: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

Line 422: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

418: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
419:
420:
421: /* Parameter values */
422: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
423: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
424:
425: /* Variables for dynamic part of SQL query */
426: l_lnk_profile_chk VARCHAR2(4000);

Line 423: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

419:
420:
421: /* Parameter values */
422: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
423: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
424:
425: /* Variables for dynamic part of SQL query */
426: l_lnk_profile_chk VARCHAR2(4000);
427: l_lnk_emp_name VARCHAR2(4000);

Line 433: hri_oltp_pmv_util_param.get_parameters_from_table

429:
430: BEGIN
431:
432: /* Get common parameter values */
433: hri_oltp_pmv_util_param.get_parameters_from_table
434: (p_page_parameter_tbl => p_page_parameter_tbl,
435: p_parameter_rec => l_parameter_rec,
436: p_bind_tab => l_bind_tab);
437:

Line 493: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

489: /* Table of custom parameters */
490: l_custom_rec BIS_QUERY_ATTRIBUTES;
491:
492: /* Parameter values */
493: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
494: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
495:
496: /* Security clause */
497: l_security_clause VARCHAR2(1000);

Line 494: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

490: l_custom_rec BIS_QUERY_ATTRIBUTES;
491:
492: /* Parameter values */
493: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
494: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
495:
496: /* Security clause */
497: l_security_clause VARCHAR2(1000);
498:

Line 513: hri_oltp_pmv_util_param.get_parameters_from_table

509: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
510: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
511:
512: /* Get common parameter values */
513: hri_oltp_pmv_util_param.get_parameters_from_table
514: (p_page_parameter_tbl => p_page_parameter_tbl,
515: p_parameter_rec => l_parameter_rec,
516: p_bind_tab => l_bind_tab);
517: