APPS.HRI_OLTP_PMV_LBRCST_ORGMGR dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 12: PROCEDURE GET_ORG_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

8: -- ----------------------------------------------------
9: -- This procedure frames the Query for the Report Labor Cost Distribution By Organization.
10: -- ----------------------------------------------------
11:
12: PROCEDURE GET_ORG_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
13: x_custom_sql OUT NOCOPY VARCHAR2,
14: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
15:
16: l_sqltext VARCHAR2(32767);

Line 208: PROCEDURE GET_KPI_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

204: -- ----------------------------------------------------
205: -- This procedure frames the Query for Labor Cost KPI.
206: -- ----------------------------------------------------
207:
208: PROCEDURE GET_KPI_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
209: x_custom_sql OUT NOCOPY VARCHAR2,
210: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
211:
212: l_sqltext VARCHAR2(32767);

Line 669: PROCEDURE GET_POS_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

665: -- ----------------------------------------------------
666: -- This procedure frames the Query for the Report Labor Cost Distribution By Position.
667: -- ----------------------------------------------------
668:
669: PROCEDURE GET_POS_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
670: x_custom_sql OUT NOCOPY VARCHAR2,
671: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
672:
673: l_sqltext VARCHAR2(32767);

Line 805: PROCEDURE GET_POS_DTL_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

801: -- ----------------------------------------------------
802: -- This procedure frames the Query for the Report Position Occupancy Report.
803: -- ----------------------------------------------------
804:
805: PROCEDURE GET_POS_DTL_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
806: x_custom_sql OUT NOCOPY VARCHAR2,
807: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
808:
809: l_lnk_profile_chk NUMBER;

Line 981: PROCEDURE GET_ELE_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

977: -- ----------------------------------------------------
978: -- This procedure frames the Query for the Report Labor Cost Distribution By Element.
979: -- ----------------------------------------------------
980:
981: PROCEDURE GET_ELE_SQL(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_sqltext VARCHAR2(32767);

Line 1175: PROCEDURE GET_FSC_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

1171: -- ----------------------------------------------------
1172: -- This procedure frames the Query for the Report Labor Cost Distribution By Funding Source.
1173: -- ----------------------------------------------------
1174:
1175: PROCEDURE GET_FSC_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1176: x_custom_sql OUT NOCOPY VARCHAR2,
1177: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
1178:
1179: l_sqltext VARCHAR2(32767);