APPS.ENI_DBI_RVR_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 112: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

108: ELSE l_ret_reason_where := '
109: AND mv.return_reason IN (&ORDER_ITEM_RETURN_REASON+ORDER_ITEM_RETURN_REASON)';
110: END IF;
111:
112: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
113: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
114:
115: x_custom_sql := '
116: SELECT ret.value VIEWBY -- return reason

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

160: -- &ORDER_BY_CLAUSE NULLS LAST -- '||l_curr;
161:
162: l_custom_rec.attribute_name := ':ENI_ITEM_CAT_FLAG';
163: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
164: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
165: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
166: x_custom_output.EXTEND;
167: x_custom_output(1) := l_custom_rec;
168:

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

161:
162: l_custom_rec.attribute_name := ':ENI_ITEM_CAT_FLAG';
163: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
164: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
165: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
166: x_custom_output.EXTEND;
167: x_custom_output(1) := l_custom_rec;
168:
169: l_custom_rec.attribute_name := ':ENI_CUST_FLAG';

Line 171: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

167: x_custom_output(1) := l_custom_rec;
168:
169: l_custom_rec.attribute_name := ':ENI_CUST_FLAG';
170: l_custom_rec.attribute_value := to_char(l_cust_flag);
171: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
172: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
173: x_custom_output.EXTEND;
174: x_custom_output(2) := l_custom_rec;
175:

Line 172: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

168:
169: l_custom_rec.attribute_name := ':ENI_CUST_FLAG';
170: l_custom_rec.attribute_value := to_char(l_cust_flag);
171: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
172: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
173: x_custom_output.EXTEND;
174: x_custom_output(2) := l_custom_rec;
175:
176: END get_sql;