DBA Data[Home] [Help]

APPS.POA_DBI_UPR_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 24: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

20: FUNCTION get_age_filter_where(p_view_by IN VARCHAR2) return VARCHAR2;
21: FUNCTION get_sum_rpt_filter_where(p_view_by IN VARCHAR2) return VARCHAR2;
22: -- FUNCTION get_dtl_filter_where(p_view_by IN VARCHAR2) return VARCHAR2;
23:
24: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
25: x_custom_sql OUT NOCOPY VARCHAR2,
26: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
27: IS
28:

Line 255: PROCEDURE amt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

251:
252: END;
253:
254:
255: PROCEDURE amt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
256: x_custom_sql OUT NOCOPY VARCHAR2,
257: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
258: IS
259:

Line 582: PROCEDURE age_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

578: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
579:
580: END;
581:
582: PROCEDURE age_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
583: x_custom_sql OUT NOCOPY VARCHAR2,
584: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
585: IS
586:

Line 847: PROCEDURE sum_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

843: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
844:
845: END;
846:
847: PROCEDURE sum_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
848: x_custom_sql OUT NOCOPY VARCHAR2,
849: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
850: IS
851:

Line 1145: PROCEDURE dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

1141:
1142: END;
1143:
1144:
1145: PROCEDURE dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1146: x_custom_sql OUT NOCOPY VARCHAR2,
1147: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1148: IS
1149: l_query varchar2(10000);