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_DBI_PAST_DUE_TREND_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 100: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

96: ELSE l_item_cat_flag := 0; -- item
97: END IF;
98: END IF;
99:
100: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
101: x_custom_output := bis_query_attributes_tbl();
102:
103: l_sql_stmt := '
104: SELECT fii.name VIEWBY,

Line 173: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;

169: ORDER BY fii.start_date';
170:
171: x_custom_sql := l_sql_stmt;
172:
173: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
174: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
175: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
176: x_custom_output.extend;
177: x_custom_output(1) := l_custom_rec;

Line 175: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;

171: x_custom_sql := l_sql_stmt;
172:
173: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
174: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
175: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
176: x_custom_output.extend;
177: x_custom_output(1) := l_custom_rec;
178:
179: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';

Line 181: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;

177: x_custom_output(1) := l_custom_rec;
178:
179: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
180: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
181: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
182: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
183: x_custom_output.extend;
184: x_custom_output(2) := l_custom_rec;
185:

Line 182: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;

178:
179: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
180: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
181: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
182: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
183: x_custom_output.extend;
184: x_custom_output(2) := l_custom_rec;
185:
186: l_custom_rec.attribute_name := ':ISC_CUSTOMER_FLAG';

Line 188: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

184: x_custom_output(2) := l_custom_rec;
185:
186: l_custom_rec.attribute_name := ':ISC_CUSTOMER_FLAG';
187: l_custom_rec.attribute_value := to_char(l_customer_flag);
188: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
189: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
190: x_custom_output.extend;
191: x_custom_output(3) := l_custom_rec;
192:

Line 189: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

185:
186: l_custom_rec.attribute_name := ':ISC_CUSTOMER_FLAG';
187: l_custom_rec.attribute_value := to_char(l_customer_flag);
188: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
189: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
190: x_custom_output.extend;
191: x_custom_output(3) := l_custom_rec;
192:
193: END Get_Sql;