APPS.ISC_DEPOT_COMPLETION_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 17: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

13: RETURN VARCHAR2;
14:
15: PROCEDURE GET_COMPLETION_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
16: x_custom_sql OUT NOCOPY VARCHAR2,
17: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
18: IS
19: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
20: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
21: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

Line 118: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

114: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
115: END IF;
116:
117: -- prepare output for bind variables
118: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
119: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
120:
121: -- set the basic bind variables for the status SQL
122: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

Line 330: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

326: END GET_COMPLETION_TBL_SEL_CLAUSE;
327:
328: PROCEDURE GET_COMPLETION_TRD_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
329: x_custom_sql OUT NOCOPY VARCHAR2,
330: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
331: IS
332:
333: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
334: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

Line 420: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

416: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
417: END IF;
418:
419: -- prepare output for bind variables
420: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
421: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
422:
423: -- set the basic bind variables for the status SQL
424: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,

Line 504: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

500:
501:
502: PROCEDURE GET_COMPLETION_DTL_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
503: x_custom_sql OUT NOCOPY VARCHAR2,
504: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
505: IS
506:
507: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
508: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

Line 634: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

630: END GET_COMPLETION_DTL_TBL_SQL;
631:
632: PROCEDURE GET_LAT_COMP_DTL_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
633: x_custom_sql OUT NOCOPY VARCHAR2,
634: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
635: IS
636:
637: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
638: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

Line 766: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

762: END GET_LAT_COMP_DTL_TBL_SQL;
763:
764: PROCEDURE GET_LAT_COMP_AGNG_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
765: x_custom_sql OUT NOCOPY VARCHAR2,
766: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
767: IS
768:
769: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
770: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

Line 920: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

916: l_where_clause || fnd_global.newline ||
917: ' group by range_name, buckets.bucket_number order by buckets.bucket_number)';
918:
919: -- prepare output for bind variables
920: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
921: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
922:
923: -- set the basic bind variables for the status SQL
924: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);