DBA Data[Home] [Help]

APPS.ENI_DBI_PCO_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 78: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

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

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

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;

Line 182: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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';

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

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;

Line 189: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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';

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

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

Line 196: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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;

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

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;

Line 204: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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';

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

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:

Line 211: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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;