APPS.OPI_DBI_PRD_CST_MARGIN_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 107: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

103: p_use_grpid => 'N');
104:
105: -- prepare output for bind variables
106: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
107: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
108:
109: -- set the basic bind variables for the status SQL
110: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
111:

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

116:
117: IF (l_mv <> 'OPI_PGM_CAT_MV') THEN
118: l_custom_rec.attribute_name := ':OPI_PRDCAT_CUST_FLAG';
119: l_custom_rec.attribute_value := l_prd_cust_flag;
120: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
121: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
122: x_custom_output.extend;
123: x_custom_output(x_custom_output.count) := l_custom_rec;
124: END IF;

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

117: IF (l_mv <> 'OPI_PGM_CAT_MV') THEN
118: l_custom_rec.attribute_name := ':OPI_PRDCAT_CUST_FLAG';
119: l_custom_rec.attribute_value := l_prd_cust_flag;
120: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
121: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
122: x_custom_output.extend;
123: x_custom_output(x_custom_output.count) := l_custom_rec;
124: END IF;
125: x_custom_sql := l_query;

Line 431: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

427: p_use_grpid => 'N');
428:
429: -- Prepare PMV bind variables
430: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
431: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
432:
433: -- get all the basic binds used by POA queries
434: -- Do this before adding any of our binds, since the procedure
435: -- reinitializes the output table

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

441: No Bind Variables if the MV being used is at the Root Product Category level.
442: */
443: l_custom_rec.attribute_name := ':OPI_PRDCAT_CUST_FLAG';
444: l_custom_rec.attribute_value := l_prd_cust_flag;
445: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
446: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
447: x_custom_output.extend;
448: x_custom_output(x_custom_output.count) := l_custom_rec;
449:

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

442: */
443: l_custom_rec.attribute_name := ':OPI_PRDCAT_CUST_FLAG';
444: l_custom_rec.attribute_value := l_prd_cust_flag;
445: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
446: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
447: x_custom_output.extend;
448: x_custom_output(x_custom_output.count) := l_custom_rec;
449:
450: x_custom_sql := l_query;