APPS.ISC_DBI_BKLG_DETAIL_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 112: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

108: l_prod_where := '
109: AND star.master_id IN (&ITEM+ENI_ITEM)';
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: l_stmt := '
116: SELECT ISC_ATTRIBUTE_1, -- Order Number

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

247: x_custom_sql := l_stmt;
248:
249: l_custom_rec.attribute_name := ':ISC_SG';
250: l_custom_rec.attribute_value := to_char(l_sg_sg);
251: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
252: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
253: x_custom_output.extend;
254: x_custom_output(1) := l_custom_rec;
255:

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

248:
249: l_custom_rec.attribute_name := ':ISC_SG';
250: l_custom_rec.attribute_value := to_char(l_sg_sg);
251: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
252: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
253: x_custom_output.extend;
254: x_custom_output(1) := l_custom_rec;
255:
256: l_custom_rec.attribute_name := ':ISC_RES';

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

254: x_custom_output(1) := l_custom_rec;
255:
256: l_custom_rec.attribute_name := ':ISC_RES';
257: l_custom_rec.attribute_value := to_char(l_sg_res);
258: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
259: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
260: x_custom_output.extend;
261: x_custom_output(2) := l_custom_rec;
262:

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

255:
256: l_custom_rec.attribute_name := ':ISC_RES';
257: l_custom_rec.attribute_value := to_char(l_sg_res);
258: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
259: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
260: x_custom_output.extend;
261: x_custom_output(2) := l_custom_rec;
262:
263: END get_sql;