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_BACKLOG_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 21: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

17: RETURN VARCHAR2;
18:
19: PROCEDURE GET_BACKLOG_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
20: x_custom_sql OUT NOCOPY VARCHAR2,
21: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
22: IS
23: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
24: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
25: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

Line 35: l_custom_rec BIS_QUERY_ATTRIBUTES;

31: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
32: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
33: l_mv_set VARCHAR2(50);
34: l_aggregation_flag NUMBER;
35: l_custom_rec BIS_QUERY_ATTRIBUTES;
36: l_mv_type VARCHAR2(10);
37: l_err_stage VARCHAR2(32767);
38: l_debug_mode VARCHAR2(1);
39: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;

Line 110: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

106: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
107: END IF;
108:
109: -- prepare output for bind variables
110: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
111: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
112:
113: -- set the basic bind variables for the status SQL
114: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

Line 309: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

305: END GET_BACKLOG_TBL_SEL_CLAUSE;
306:
307: PROCEDURE GET_BACKLOG_TRD_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
308: x_custom_sql OUT NOCOPY VARCHAR2,
309: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
310: IS
311:
312: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
313: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

Line 324: l_custom_rec BIS_QUERY_ATTRIBUTES;

320: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
321: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
322: l_mv_set VARCHAR2(50);
323: l_aggregation_flag NUMBER;
324: l_custom_rec BIS_QUERY_ATTRIBUTES;
325: l_mv_type VARCHAR2(10);
326: l_err_stage VARCHAR2(32767);
327: l_debug_mode VARCHAR2(1);
328: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;

Line 392: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

388: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
389: END IF;
390:
391: -- prepare output for bind variables
392: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
393: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
394:
395: -- set the basic bind variables for the status SQL
396: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,

Line 476: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

472: END GET_BACKLOG_TRD_SEL_CLAUSE;
473:
474: PROCEDURE GET_BACKLOG_DTL_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
475: x_custom_sql OUT NOCOPY VARCHAR2,
476: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
477: IS
478:
479: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
480: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

Line 491: l_custom_rec BIS_QUERY_ATTRIBUTES;

487: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
488: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
489: l_mv_set VARCHAR2(50);
490: l_aggregation_flag NUMBER;
491: l_custom_rec BIS_QUERY_ATTRIBUTES;
492: l_mv_type VARCHAR2(10);
493: l_err_stage VARCHAR2(32767);
494: l_debug_mode VARCHAR2(1);
495: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;

Line 608: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

604: END get_backlog_dtl_tbl_sql;
605:
606: PROCEDURE GET_PAST_DUE_AGNG_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
607: x_custom_sql OUT NOCOPY VARCHAR2,
608: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
609: IS
610:
611: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
612: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

Line 623: l_custom_rec BIS_QUERY_ATTRIBUTES;

619: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
620: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
621: l_mv_set VARCHAR2(50);
622: l_aggregation_flag NUMBER;
623: l_custom_rec BIS_QUERY_ATTRIBUTES;
624: l_mv_type VARCHAR2(10);
625: l_err_stage VARCHAR2(32767);
626: l_debug_mode VARCHAR2(1);
627: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;

Line 736: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

732: l_err_stage:='The query is : ' || l_query;
733: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
734: END IF;
735: -- prepare output for bind variables
736: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
737: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
738:
739: -- set the basic bind variables for the status SQL
740: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

Line 764: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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

Line 779: l_custom_rec BIS_QUERY_ATTRIBUTES;

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

Line 901: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

897: END GET_PAST_DUE_DTL_TBL_SQL;
898:
899: PROCEDURE GET_DAYS_UNTIL_PROM_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
900: x_custom_sql OUT NOCOPY VARCHAR2,
901: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
902: IS
903: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
904: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
905: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

Line 914: l_custom_rec BIS_QUERY_ATTRIBUTES;

910: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
911: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
912: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
913: l_mv_set VARCHAR2(50);
914: l_custom_rec BIS_QUERY_ATTRIBUTES;
915: l_mv_type VARCHAR2(10);
916: l_err_stage VARCHAR2(32767);
917: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
918: l_agg_flag_1 NUMBER; -- for isc_dr_curr_02_mv

Line 1120: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1116: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
1117: END IF;
1118:
1119: -- prepare output for bind variables
1120: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1121: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1122:
1123: -- set the basic bind variables for the status SQL
1124: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);