74: , l_type
75: , l_manager
76: , l_lob
77: );
78: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
79: x_custom_output := bis_query_attributes_tbl();
80: l_org_temp := l_org;
81:
82: Begin
177:
178: x_custom_output.extend;
179: l_custom_rec.attribute_name := ':PCO_LIST_DRILL';
180: l_custom_rec.attribute_value := l_drill_down_part_count;
181: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
182: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
183: x_custom_output(1) := l_custom_rec;
184:
185: x_custom_output.extend;
178: x_custom_output.extend;
179: l_custom_rec.attribute_name := ':PCO_LIST_DRILL';
180: l_custom_rec.attribute_value := l_drill_down_part_count;
181: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
182: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
183: x_custom_output(1) := l_custom_rec;
184:
185: x_custom_output.extend;
186: l_custom_rec.attribute_name := ':PCO_COMP_DRILL';
184:
185: x_custom_output.extend;
186: l_custom_rec.attribute_name := ':PCO_COMP_DRILL';
187: l_custom_rec.attribute_value := l_component_cat_cond;
188: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
189: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
190: x_custom_output(2) := l_custom_rec;
191:
192: x_custom_output.extend;
185: x_custom_output.extend;
186: l_custom_rec.attribute_name := ':PCO_COMP_DRILL';
187: l_custom_rec.attribute_value := l_component_cat_cond;
188: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
189: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
190: x_custom_output(2) := l_custom_rec;
191:
192: x_custom_output.extend;
193: l_custom_rec.attribute_name := ':PCO_CAT_DRILL';
191:
192: x_custom_output.extend;
193: l_custom_rec.attribute_name := ':PCO_CAT_DRILL';
194: l_custom_rec.attribute_value := l_cat_cond;
195: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
196: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
197: x_custom_output(3) := l_custom_rec;
198:
199: --Bug#5083708
192: x_custom_output.extend;
193: l_custom_rec.attribute_name := ':PCO_CAT_DRILL';
194: l_custom_rec.attribute_value := l_cat_cond;
195: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
196: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
197: x_custom_output(3) := l_custom_rec;
198:
199: --Bug#5083708
200: x_custom_output.extend;
199: --Bug#5083708
200: x_custom_output.extend;
201: l_custom_rec.attribute_name := ':ORGANIZATION_ID';
202: l_custom_rec.attribute_value := replace(l_org,'''');
203: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
204: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
205: x_custom_output(4) := l_custom_rec;
206:
207: x_custom_output.extend;
200: x_custom_output.extend;
201: l_custom_rec.attribute_name := ':ORGANIZATION_ID';
202: l_custom_rec.attribute_value := replace(l_org,'''');
203: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
204: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
205: x_custom_output(4) := l_custom_rec;
206:
207: x_custom_output.extend;
208: l_custom_rec.attribute_name := ':ASSEMBLY_ITEM_ID';
206:
207: x_custom_output.extend;
208: l_custom_rec.attribute_name := ':ASSEMBLY_ITEM_ID';
209: l_custom_rec.attribute_value := replace(l_item,'''');
210: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
211: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
212: x_custom_output(5) := l_custom_rec;
213: --Bug#5083708
214:
207: x_custom_output.extend;
208: l_custom_rec.attribute_name := ':ASSEMBLY_ITEM_ID';
209: l_custom_rec.attribute_value := replace(l_item,'''');
210: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
211: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
212: x_custom_output(5) := l_custom_rec;
213: --Bug#5083708
214:
215: END GET_SQL;