APPS.ISC_DBI_RETURN_REASON_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 136: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

132: ELSE l_ret_reason_where := '
133: AND mv.return_reason IN (&ORDER_ITEM_RETURN_REASON+ORDER_ITEM_RETURN_REASON)';
134: END IF;
135:
136: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
137: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
138:
139: l_stmt := '
140: SELECT ret.value VIEWBY, -- return reason

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

181: x_custom_sql := l_stmt;
182:
183: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
184: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
185: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
186: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
187: x_custom_output.EXTEND;
188: x_custom_output(1) := l_custom_rec;
189:

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

182:
183: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
184: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
185: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
186: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
187: x_custom_output.EXTEND;
188: x_custom_output(1) := l_custom_rec;
189:
190: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';

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

188: x_custom_output(1) := l_custom_rec;
189:
190: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
191: l_custom_rec.attribute_value := to_char(l_cust_flag);
192: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
193: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
194: x_custom_output.EXTEND;
195: x_custom_output(2) := l_custom_rec;
196:

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

189:
190: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
191: l_custom_rec.attribute_value := to_char(l_cust_flag);
192: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
193: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
194: x_custom_output.EXTEND;
195: x_custom_output(2) := l_custom_rec;
196:
197: END get_sql;