DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_LBRCST_ORGMGR dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 6: PROCEDURE GET_ORG_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

2: /* $Header: hrirplom.pkh 120.1 2005/08/24 07:19:17 rlpatil noship $ */
3:
4:
5:
6: PROCEDURE GET_ORG_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
7: x_custom_sql OUT NOCOPY VARCHAR2,
8: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
9:
10: PROCEDURE GET_KPI_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

Line 10: PROCEDURE GET_KPI_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

6: PROCEDURE GET_ORG_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
7: x_custom_sql OUT NOCOPY VARCHAR2,
8: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
9:
10: PROCEDURE GET_KPI_SQL(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);
13:
14: FUNCTION CALC_PREV_VALUE_ORG(p_ORGMGR_ID NUMBER,

Line 27: PROCEDURE GET_POS_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

23: p_effective_start_date DATE,
24: p_effective_end_date DATE,
25: p_position_id NUMBER )
26: RETURN NUMBER ;
27: PROCEDURE GET_POS_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
28: x_custom_sql OUT NOCOPY VARCHAR2,
29: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
30:
31: PROCEDURE GET_POS_DTL_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

Line 31: PROCEDURE GET_POS_DTL_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

27: PROCEDURE GET_POS_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
28: x_custom_sql OUT NOCOPY VARCHAR2,
29: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
30:
31: PROCEDURE GET_POS_DTL_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
32: x_custom_sql OUT NOCOPY VARCHAR2,
33: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
34:
35: FUNCTION CALC_PREV_VALUE_ELE(p_ORGMGR_ID NUMBER,

Line 43: PROCEDURE GET_ELE_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

39: p_effective_end_date DATE,
40: p_element_type_id NUMBER)
41: RETURN NUMBER ;
42:
43: PROCEDURE GET_ELE_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
44: x_custom_sql OUT NOCOPY VARCHAR2,
45: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
46:
47: FUNCTION CALC_PREV_VALUE_FSC(p_ORGMGR_ID NUMBER,

Line 55: PROCEDURE GET_FSC_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

51: p_effective_end_date DATE,
52: p_element_type_id NUMBER,
53: p_cost_allocation_keyflex_id NUMBER)
54: RETURN NUMBER ;
55: PROCEDURE GET_FSC_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
56: x_custom_sql OUT NOCOPY VARCHAR2,
57: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
58:
59: FUNCTION GET_KPI_TOTALS(p_ORGMGR_ID NUMBER,