APPS.HRI_OLTP_PMV_OPEN_ENRT_STAT dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 13: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

9: -- variables required for the execution of queries returned by GET_???_SQL
10: -- procedures.
11: --
12: procedure SET_BIND_PARAMETERS(
13: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
14: x_custom_output IN OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,
15: p_selection OUT NOCOPY NUMBER)
16: IS
17: --

Line 254: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl )

250: -- parameters passed by parameter portlet, call this procedure from CHECK_???_SQL procedures
251: -- Remember to uncomment call to this procedure, since it enables a trace
252: --
253: PROCEDURE PRINT_TABLE_PARAMETERS (
254: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl )
255: IS
256: --
257: --
258: BEGIN

Line 289: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

285: --
286: -- The function will return the paramter value for the passed parameter name
287: --
288: FUNCTION GET_PARAMETER_VALUE (
289: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
290: p_parameter_name IN VARCHAR2
291: )
292: RETURN VARCHAR2
293: IS

Line 327: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

323: --
324: -- The function will return the paramter ID for the passed parameter name
325: --
326: FUNCTION GET_PARAMETER_ID (
327: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
328: p_parameter_name IN VARCHAR2
329: )
330: RETURN varchar2
331: IS

Line 367: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

363: -- Participation By Plan
364: -- AK_REGION = HRI_P_ELIGENRL_PRTT_PLIP
365: --
366: PROCEDURE GET_ELIGENRL_PLIP_SQL (
367: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
368: x_custom_sql OUT NOCOPY VARCHAR2,
369: x_custom_output OUT NOCOPY bis_query_attributes_tbl
370: )
371: IS

Line 472: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

468: -- Participation By Option In Plan
469: -- AK_REGION = HRI_P_ELIGENRL_PRTT_OIPL
470: --
471: PROCEDURE GET_ELIGENRL_OIPL_SQL (
472: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
473: x_custom_sql OUT NOCOPY VARCHAR2,
474: x_custom_output OUT NOCOPY bis_query_attributes_tbl
475: )
476: IS

Line 557: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

553: -- Open Action Items
554: -- AK_REGION : HRI_P_ENRLACTN_OPN_ITEMS
555: --
556: PROCEDURE GET_ENRLACTN_SQL (
557: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
558: x_custom_sql OUT NOCOPY VARCHAR2,
559: x_custom_output OUT NOCOPY bis_query_attributes_tbl
560: )
561: IS

Line 634: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

630: -- Open Action Item Details
631: -- AK_REGION : HRI_P_ENRLACTN_OPN_ITEM_DTL
632: --
633: PROCEDURE GET_ENRLACTN_DET_SQL (
634: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
635: x_custom_sql OUT NOCOPY VARCHAR2,
636: x_custom_output OUT NOCOPY bis_query_attributes_tbl
637: )
638: IS

Line 788: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

784: -- Event Status
785: -- AK_REGION : HRI_P_ELCTN_EVNT_STATUS
786: --
787: PROCEDURE GET_ELCTN_EVNT_SQL (
788: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
789: x_custom_sql OUT NOCOPY VARCHAR2,
790: x_custom_output OUT NOCOPY bis_query_attributes_tbl
791: )
792: IS

Line 858: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

854: -- Open Enrollment KPIs
855: -- AK_REGION : HRI_P_ELCTN_ENRT_GRAPH
856: --
857: PROCEDURE GET_ENRT_KPI_GRAPH_SQL (
858: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
859: x_custom_sql OUT NOCOPY VARCHAR2,
860: x_custom_output OUT NOCOPY bis_query_attributes_tbl
861: )
862: IS

Line 928: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

924: -- Open Enrollment Status
925: -- AK_REGION : HRI_K_ELCTN_ENRT
926: --
927: PROCEDURE GET_ENRT_KPI_SQL (
928: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
929: x_custom_sql OUT NOCOPY VARCHAR2,
930: x_custom_output OUT NOCOPY bis_query_attributes_tbl
931: )
932: IS

Line 994: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

990: -- Participation By Plan Type
991: -- AK_REGION : HRI_P_ELIGENRL_PRTT_PTIP
992: --
993: PROCEDURE GET_ELIGENRL_PTIP_SQL (
994: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
995: x_custom_sql OUT NOCOPY VARCHAR2,
996: x_custom_output OUT NOCOPY bis_query_attributes_tbl
997: )
998: IS