APPS.ISC_DBI_BK_DETAIL_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 110: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

106: l_prod_where := '
107: AND star.master_id IN (&ITEM+ENI_ITEM)';
108: END IF;
109:
110: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
111: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
112:
113: l_stmt := '
114: SELECT ISC_ATTRIBUTE_1, -- Order Number

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

183: x_custom_sql := l_stmt;
184:
185: l_custom_rec.attribute_name := ':ISC_SG';
186: l_custom_rec.attribute_value := to_char(l_sg_sg);
187: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
188: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
189: x_custom_output.extend;
190: x_custom_output(1) := l_custom_rec;
191:

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

184:
185: l_custom_rec.attribute_name := ':ISC_SG';
186: l_custom_rec.attribute_value := to_char(l_sg_sg);
187: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
188: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
189: x_custom_output.extend;
190: x_custom_output(1) := l_custom_rec;
191:
192: l_custom_rec.attribute_name := ':ISC_RES';

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

190: x_custom_output(1) := l_custom_rec;
191:
192: l_custom_rec.attribute_name := ':ISC_RES';
193: l_custom_rec.attribute_value := to_char(l_sg_res);
194: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
195: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
196: x_custom_output.extend;
197: x_custom_output(2) := l_custom_rec;
198:

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

191:
192: l_custom_rec.attribute_name := ':ISC_RES';
193: l_custom_rec.attribute_value := to_char(l_sg_res);
194: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
195: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
196: x_custom_output.extend;
197: x_custom_output(2) := l_custom_rec;
198:
199: END get_sql;