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_TBL

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