DBA Data[Home] [Help]

APPS.BIX_PMV_EMC_AGTDET_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 40: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

36: --Initialize p_custom_output
37: --
38:
39: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
40: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
41:
42: -- Get the parameters
43:
44: BIX_PMV_DBI_UTL_PKG.get_emc_page_params( p_page_parameter_tbl,

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

276: -- Insert account Bind Variable
277:
278: l_custom_rec.attribute_name := ':l_application_id';
279: l_custom_rec.attribute_value:= l_application_id;
280: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
281: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
282:
283: p_custom_output.EXTEND;
284: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

Line 281: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

277:
278: l_custom_rec.attribute_name := ':l_application_id';
279: l_custom_rec.attribute_value:= l_application_id;
280: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
281: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
282:
283: p_custom_output.EXTEND;
284: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
285:

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

285:
286: IF ( l_account IS NOT NULL) THEN
287: l_custom_rec.attribute_name := ':l_account' ;
288: l_custom_rec.attribute_value:= l_account;
289: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
290: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
291:
292: p_custom_output.Extend();
293: p_custom_output(p_custom_output.count) := l_custom_rec;

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

286: IF ( l_account IS NOT NULL) THEN
287: l_custom_rec.attribute_name := ':l_account' ;
288: l_custom_rec.attribute_value:= l_account;
289: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
290: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
291:
292: p_custom_output.Extend();
293: p_custom_output(p_custom_output.count) := l_custom_rec;
294: END IF;

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

295:
296: IF ( l_classification IS NOT NULL) THEN
297: l_custom_rec.attribute_name := ':l_classification' ;
298: l_custom_rec.attribute_value:= l_classification;
299: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
300: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
301:
302: p_custom_output.Extend();
303: p_custom_output(p_custom_output.count) := l_custom_rec;

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

296: IF ( l_classification IS NOT NULL) THEN
297: l_custom_rec.attribute_name := ':l_classification' ;
298: l_custom_rec.attribute_value:= l_classification;
299: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
300: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
301:
302: p_custom_output.Extend();
303: p_custom_output(p_custom_output.count) := l_custom_rec;
304: END IF;

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

306:
307: IF ( l_agent_group IS NOT NULL) THEN
308: l_custom_rec.attribute_name := ':l_agent_group' ;
309: l_custom_rec.attribute_value:= l_agent_group;
310: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
311: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
312:
313: p_custom_output.Extend();
314: p_custom_output(p_custom_output.count) := l_custom_rec;

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

307: IF ( l_agent_group IS NOT NULL) THEN
308: l_custom_rec.attribute_name := ':l_agent_group' ;
309: l_custom_rec.attribute_value:= l_agent_group;
310: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
311: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
312:
313: p_custom_output.Extend();
314: p_custom_output(p_custom_output.count) := l_custom_rec;
315: END IF;

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

315: END IF;
316:
317: l_custom_rec.attribute_name := ':l_row_type' ;
318: l_custom_rec.attribute_value:= l_row_type;
319: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
320: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
321:
322: p_custom_output.Extend();
323: p_custom_output(p_custom_output.count) := l_custom_rec;

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

316:
317: l_custom_rec.attribute_name := ':l_row_type' ;
318: l_custom_rec.attribute_value:= l_row_type;
319: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
320: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
321:
322: p_custom_output.Extend();
323: p_custom_output(p_custom_output.count) := l_custom_rec;
324: