DBA Data[Home] [Help]

APPS.POA_DBI_UPR_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 26: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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:
29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
30: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 257: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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:
260: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
261: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 584: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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:
587: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
588: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 849: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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:
852: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
853: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 1147: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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);
1150: l_cur_suffix varchar2(2);
1151: l_where_clause varchar2(2000);