DBA Data[Home] [Help]

APPS.RCI_PROC_CERT_SUMM_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 116: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

112: ';**/
113:
114: p_exp_source_sql := l_sqlstmt;
115: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
116: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
117:
118: p_exp_source_output.EXTEND;
119: l_bind_rec.attribute_name := ':TIME';
120: l_bind_rec.attribute_value := v_period;

Line 121: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

117:
118: p_exp_source_output.EXTEND;
119: l_bind_rec.attribute_name := ':TIME';
120: l_bind_rec.attribute_value := v_period;
121: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
122: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
123: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
124:
125: END get_kpi;

Line 122: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

118: p_exp_source_output.EXTEND;
119: l_bind_rec.attribute_name := ':TIME';
120: l_bind_rec.attribute_value := v_period;
121: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
122: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
123: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
124:
125: END get_kpi;
126:

Line 224: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

220:
221: p_exp_source_sql := l_sqlstmt;
222:
223: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
224: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
225:
226: p_exp_source_output.EXTEND;
227: l_bind_rec.attribute_name := ':TIME';
228: l_bind_rec.attribute_value := v_period;

Line 229: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

225:
226: p_exp_source_output.EXTEND;
227: l_bind_rec.attribute_name := ':TIME';
228: l_bind_rec.attribute_value := v_period;
229: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
230: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
231: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
232:
233: END get_proc_cert_details;

Line 230: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

226: p_exp_source_output.EXTEND;
227: l_bind_rec.attribute_name := ':TIME';
228: l_bind_rec.attribute_value := v_period;
229: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
230: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
231: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
232:
233: END get_proc_cert_details;
234:

Line 333: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

329: order by a.col_rank ';
330:
331: p_exp_source_sql := l_act_sqlstmt;
332: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
333: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
334:
335: p_exp_source_output.EXTEND;
336: l_bind_rec.attribute_name := ':TIME';
337: l_bind_rec.attribute_value := v_period;

Line 338: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

334:
335: p_exp_source_output.EXTEND;
336: l_bind_rec.attribute_name := ':TIME';
337: l_bind_rec.attribute_value := v_period;
338: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
339: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
340: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
341:
342: END get_proc_cert_result;

Line 339: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

335: p_exp_source_output.EXTEND;
336: l_bind_rec.attribute_name := ':TIME';
337: l_bind_rec.attribute_value := v_period;
338: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
339: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
340: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
341:
342: END get_proc_cert_result;
343:

Line 574: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

570: order by a.col_rank ';
571:
572: p_exp_source_sql := l_act_sqlstmt;
573: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
574: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
575:
576: p_exp_source_output.EXTEND;
577: l_bind_rec.attribute_name := ':TIME';
578: l_bind_rec.attribute_value := v_period;

Line 579: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

575:
576: p_exp_source_output.EXTEND;
577: l_bind_rec.attribute_name := ':TIME';
578: l_bind_rec.attribute_value := v_period;
579: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
580: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
581: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
582:
583: END get_proc_cert_summary;

Line 580: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

576: p_exp_source_output.EXTEND;
577: l_bind_rec.attribute_name := ':TIME';
578: l_bind_rec.attribute_value := v_period;
579: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
580: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
581: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
582:
583: END get_proc_cert_summary;
584: