DBA Data[Home] [Help]

APPS.ISC_DBI_RETURN_DETAIL_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 125: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

121: ELSE l_ret_reason_where := '
122: AND mv.return_reason IN (&ORDER_ITEM_RETURN_REASON+ORDER_ITEM_RETURN_REASON)';
123: END IF;
124:
125: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
126: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
127:
128: l_stmt := '
129: SELECT ISC_ATTRIBUTE_7,ISC_ATTRIBUTE_3, ISC_ATTRIBUTE_4,

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

165: x_custom_sql := l_stmt;
166:
167: l_custom_rec.attribute_name := ':ISC_LANG';
168: l_custom_rec.attribute_value := l_lang;
169: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
170: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
171: x_custom_output.EXTEND;
172: x_custom_output(1) := l_custom_rec;
173:

Line 170: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

166:
167: l_custom_rec.attribute_name := ':ISC_LANG';
168: l_custom_rec.attribute_value := l_lang;
169: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
170: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
171: x_custom_output.EXTEND;
172: x_custom_output(1) := l_custom_rec;
173:
174: END get_sql;