DBA Data[Home] [Help]

APPS.ISC_DBI_PAST_DUE_SUM_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 229: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

225: END;
226:
227: l_lang := USERENV('LANG');
228:
229: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
230: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
231:
232: -- SQL statement generation: SELECT
233:

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

417: x_custom_sql := l_sql_stmt;
418:
419: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
420: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
421: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
422: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
423: x_custom_output.extend;
424: x_custom_output(1) := l_custom_rec;
425:

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

418:
419: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
420: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
421: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
422: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
423: x_custom_output.extend;
424: x_custom_output(1) := l_custom_rec;
425:
426: l_custom_rec.attribute_name := ':ISC_CUSTOMER_FLAG';

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

424: x_custom_output(1) := l_custom_rec;
425:
426: l_custom_rec.attribute_name := ':ISC_CUSTOMER_FLAG';
427: l_custom_rec.attribute_value := to_char(l_customer_flag);
428: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
429: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
430: x_custom_output.extend;
431: x_custom_output(2) := l_custom_rec;
432:

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

425:
426: l_custom_rec.attribute_name := ':ISC_CUSTOMER_FLAG';
427: l_custom_rec.attribute_value := to_char(l_customer_flag);
428: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
429: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
430: x_custom_output.extend;
431: x_custom_output(2) := l_custom_rec;
432:
433: l_custom_rec.attribute_name := ':ISC_LANG';

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

431: x_custom_output(2) := l_custom_rec;
432:
433: l_custom_rec.attribute_name := ':ISC_LANG';
434: l_custom_rec.attribute_value := l_lang;
435: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
436: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
437: x_custom_output.extend;
438: x_custom_output(3) := l_custom_rec;
439:

Line 436: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

432:
433: l_custom_rec.attribute_name := ':ISC_LANG';
434: l_custom_rec.attribute_value := l_lang;
435: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
436: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
437: x_custom_output.extend;
438: x_custom_output(3) := l_custom_rec;
439:
440: END Get_Sql;