APPS.HRI_OLTP_PMV_WMV_TRN_SUP dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 10: PROCEDURE get_sql2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

6:
7: /******************************************************************************/
8: /* Annualized Turnover Portlet */
9: /******************************************************************************/
10: PROCEDURE get_sql2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
11: x_custom_sql OUT NOCOPY VARCHAR2,
12: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
13:
14: /* Variables for SQL returned */

Line 310: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

306: /******************************************************************************/
307: /* Annualized Turnover Status Portlet */
308: /******************************************************************************/
309: PROCEDURE get_actual_detail_sql2
310: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
311: x_custom_sql OUT NOCOPY VARCHAR2,
312: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
313:
314: /* Variables for SQL returned */

Line 595: PROCEDURE GET_SQL_TRN_PVT(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

591: x_custom_output(3) := l_custom_rec;
592:
593: END get_actual_detail_sql2;
594:
595: PROCEDURE GET_SQL_TRN_PVT(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
596: x_custom_sql OUT NOCOPY VARCHAR2,
597: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
598:
599: l_SQLText VARCHAR2(32767) ;

Line 885: PROCEDURE get_trn_los_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

881: -- 3. Current average length of service
882: -- 4. Previous average length of service
883: -- -----------------------------------------------------------------------
884: --
885: PROCEDURE get_trn_los_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
886: x_custom_sql OUT NOCOPY VARCHAR2,
887: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
888: --
889: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 981: PROCEDURE get_wmv_trn_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

977: -- 2. Voluntary Terminations
978: -- 3. Involuntary terminations
979: -- -----------------------------------------------------------------------
980: --
981: PROCEDURE get_wmv_trn_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
982: x_custom_sql OUT NOCOPY VARCHAR2,
983: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
984: --
985: l_custom_rec BIS_QUERY_ATTRIBUTES;