APPS.HRI_OLTP_PMV_WMV_SUP dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 7: PROCEDURE get_sql2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

3:
4: g_rtn VARCHAR2(5) := '
5: ';
6:
7: PROCEDURE get_sql2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
8: x_custom_sql OUT NOCOPY VARCHAR2,
9: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
10:
11: l_sqltext VARCHAR2(32767);

Line 313: PROCEDURE get_wmv_low_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

309: -- 3. Average Length of Service
310: -- 4. Previous Average Length of Service
311: -- ----------------------------------------------------------------------
312: --
313: PROCEDURE get_wmv_low_kpi(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: -- The security clause

Line 395: PROCEDURE get_wmv_c_low_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

391: END get_wmv_low_kpi;
392:
393:
394: /* CWK KPIs */
395: PROCEDURE get_wmv_c_low_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
396: x_custom_sql OUT NOCOPY VARCHAR2,
397: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
398:
399: l_sqltext VARCHAR2(32767);

Line 413: l_page_parameter_tbl BIS_PMV_PAGE_PARAMETER_TBL;

409: l_wrkfc_fact_sql VARCHAR2(10000);
410: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
411: l_wcnt_chg_fact_sql VARCHAR2(10000);
412:
413: l_page_parameter_tbl BIS_PMV_PAGE_PARAMETER_TBL;
414:
415: BEGIN
416:
417: /* Initialize out parameters */

Line 481: PROCEDURE get_wmv_c_atvty_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

477: x_custom_output(1) := l_custom_rec;
478:
479: END get_wmv_c_low_kpi;
480:
481: PROCEDURE get_wmv_c_atvty_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
482: x_custom_sql OUT NOCOPY VARCHAR2,
483: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
484:
485: l_sqltext VARCHAR2(32767);

Line 499: l_page_parameter_tbl BIS_PMV_PAGE_PARAMETER_TBL;

495: l_wrkfc_fact_sql VARCHAR2(10000);
496: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
497: l_wcnt_chg_fact_sql VARCHAR2(10000);
498:
499: l_page_parameter_tbl BIS_PMV_PAGE_PARAMETER_TBL;
500:
501: BEGIN
502:
503: /* Initialize out parameters */