eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_DEPOT_COMPLETION_PKG dependencies on BIS_QUERY_ATTRIBUTES

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 31: l_custom_rec BIS_QUERY_ATTRIBUTES;

27: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
28: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
29: l_mv_set VARCHAR2(50);
30: l_aggregation_flag NUMBER;
31: l_custom_rec BIS_QUERY_ATTRIBUTES;
32: l_mv_type VARCHAR2(10);
33: l_err_stage VARCHAR2(32767);
34: l_debug_mode VARCHAR2(1);
35: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_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 345: l_custom_rec BIS_QUERY_ATTRIBUTES;

341: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
342: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
343: l_mv_set VARCHAR2(50);
344: l_aggregation_flag NUMBER;
345: l_custom_rec BIS_QUERY_ATTRIBUTES;
346: l_mv_type VARCHAR2(10);
347: l_err_stage VARCHAR2(32767);
348: l_debug_mode VARCHAR2(1);
349: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_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 519: l_custom_rec BIS_QUERY_ATTRIBUTES;

515: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
516: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
517: l_mv_set VARCHAR2(50);
518: l_aggregation_flag NUMBER;
519: l_custom_rec BIS_QUERY_ATTRIBUTES;
520: l_mv_type VARCHAR2(10);
521: l_err_stage VARCHAR2(32767);
522: l_debug_mode VARCHAR2(1);
523: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_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 649: l_custom_rec BIS_QUERY_ATTRIBUTES;

645: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
646: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
647: l_mv_set VARCHAR2(50);
648: l_aggregation_flag NUMBER;
649: l_custom_rec BIS_QUERY_ATTRIBUTES;
650: l_mv_type VARCHAR2(10);
651: l_err_stage VARCHAR2(32767);
652: l_debug_mode VARCHAR2(1);
653: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_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 781: l_custom_rec BIS_QUERY_ATTRIBUTES;

777: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
778: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
779: l_mv_set VARCHAR2(50);
780: l_aggregation_flag NUMBER;
781: l_custom_rec BIS_QUERY_ATTRIBUTES;
782: l_mv_type VARCHAR2(10);
783: l_err_stage VARCHAR2(32767);
784: l_function_name VARCHAR2(30);
785: l_debug_mode VARCHAR2(1);

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);