DBA Data[Home] [Help]

APPS.OPI_DBI_INV_CURR_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 132: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

128: -- {
129: -- initialization block
130: x_custom_sql := NULL;
131: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();
132: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
133: l_query := NULL;
134: l_view_by := NULL;
135: l_view_by_col := NULL;
136: l_xtd := NULL;

Line 234: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

230:
231: -- Subinventory aggregation level flag.
232: l_custom_rec.attribute_name := ':OPI_CURR_INV_EXP_AGG_FLAG';
233: l_custom_rec.attribute_value := l_aggr_level_flag;
234: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
235: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
236: x_custom_output.extend;
237: x_custom_output(x_custom_output.count) := l_custom_rec;
238:

Line 235: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

231: -- Subinventory aggregation level flag.
232: l_custom_rec.attribute_name := ':OPI_CURR_INV_EXP_AGG_FLAG';
233: l_custom_rec.attribute_value := l_aggr_level_flag;
234: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
235: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
236: x_custom_output.extend;
237: x_custom_output(x_custom_output.count) := l_custom_rec;
238:
239: x_custom_sql := l_query;

Line 503: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

499: -- {
500: -- initialization block
501: x_custom_sql := NULL;
502: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();
503: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
504: l_query := NULL;
505: l_view_by := NULL;
506: l_view_by_col := NULL;
507: l_xtd := NULL;

Line 701: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

697:
698: -- Aggregation level flags
699: l_custom_rec.attribute_name := ':OPI_AGGREGATION_LEVEL_FLAG';
700: l_custom_rec.attribute_value := l_onh_aggr_level_flag;
701: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
702: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
703: x_custom_output.extend;
704: x_custom_output(x_custom_output.count) := l_custom_rec;
705:

Line 702: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

698: -- Aggregation level flags
699: l_custom_rec.attribute_name := ':OPI_AGGREGATION_LEVEL_FLAG';
700: l_custom_rec.attribute_value := l_onh_aggr_level_flag;
701: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
702: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
703: x_custom_output.extend;
704: x_custom_output(x_custom_output.count) := l_custom_rec;
705:
706: l_custom_rec.attribute_name := ':OPI_PROD_CONS_AGG_FLAG';

Line 708: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

704: x_custom_output(x_custom_output.count) := l_custom_rec;
705:
706: l_custom_rec.attribute_name := ':OPI_PROD_CONS_AGG_FLAG';
707: l_custom_rec.attribute_value := l_prod_aggr_level_flag;
708: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
709: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
710: x_custom_output.extend;
711: x_custom_output(x_custom_output.count) := l_custom_rec;
712:

Line 709: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

705:
706: l_custom_rec.attribute_name := ':OPI_PROD_CONS_AGG_FLAG';
707: l_custom_rec.attribute_value := l_prod_aggr_level_flag;
708: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
709: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
710: x_custom_output.extend;
711: x_custom_output(x_custom_output.count) := l_custom_rec;
712:
713: l_custom_rec.attribute_name := ':OPI_COGS_SHIP_AGG_FLAG';

Line 715: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

711: x_custom_output(x_custom_output.count) := l_custom_rec;
712:
713: l_custom_rec.attribute_name := ':OPI_COGS_SHIP_AGG_FLAG';
714: l_custom_rec.attribute_value := l_ship_aggr_level_flag;
715: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
716: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
717: x_custom_output.extend;
718: x_custom_output(x_custom_output.count) := l_custom_rec;
719:

Line 716: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

712:
713: l_custom_rec.attribute_name := ':OPI_COGS_SHIP_AGG_FLAG';
714: l_custom_rec.attribute_value := l_ship_aggr_level_flag;
715: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
716: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
717: x_custom_output.extend;
718: x_custom_output(x_custom_output.count) := l_custom_rec;
719:
720: l_custom_rec.attribute_name := ':OPI_INV_DOH_PER_LEN';

Line 722: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

718: x_custom_output(x_custom_output.count) := l_custom_rec;
719:
720: l_custom_rec.attribute_name := ':OPI_INV_DOH_PER_LEN';
721: l_custom_rec.attribute_value := l_per_length;
722: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
723: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
724: x_custom_output.extend;
725: x_custom_output(x_custom_output.count) := l_custom_rec;
726:

Line 723: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

719:
720: l_custom_rec.attribute_name := ':OPI_INV_DOH_PER_LEN';
721: l_custom_rec.attribute_value := l_per_length;
722: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
723: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
724: x_custom_output.extend;
725: x_custom_output(x_custom_output.count) := l_custom_rec;
726:
727: x_custom_sql := l_query;

Line 1173: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1169: -- {
1170: -- initialization block
1171: x_custom_sql := NULL;
1172: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();
1173: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1174: l_query := NULL;
1175: l_view_by := NULL;
1176: l_view_by_col := NULL;
1177: l_xtd := NULL;