APPS.RCI_PROC_CERT_SUMM_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 27: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

23:
24: PROCEDURE get_kpi(
25: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
26: ,p_exp_source_sql out NOCOPY VARCHAR2
27: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
28: is
29: l_sqlstmt VARCHAR2(15000);
30: total_qry VARCHAR2(15000);
31: counter NUMBER := 0;

Line 115: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

111: )
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';

Line 130: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

126:
127: PROCEDURE get_proc_cert_details(
128: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
129: ,p_exp_source_sql out NOCOPY VARCHAR2
130: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
131: is
132: l_sqlstmt VARCHAR2(15000);
133: counter NUMBER := 0;
134: where_clause VARCHAR2(2000) := '';

Line 223: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

219: ' || where_clause ;
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';

Line 238: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

234:
235: PROCEDURE get_proc_cert_result(
236: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
237: ,p_exp_source_sql out NOCOPY VARCHAR2
238: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
239: is
240: l_sqlstmt VARCHAR2(15000);
241: l_act_sqlstmt VARCHAR2(15000);
242: counter NUMBER := 0;

Line 332: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

328: ) t ) a
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';

Line 347: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

343:
344: PROCEDURE get_proc_cert_summary(
345: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
346: ,p_exp_source_sql out NOCOPY VARCHAR2
347: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
348: is
349: l_sqlstmt VARCHAR2(15000);
350: l_act_sqlstmt varchar2(15000);
351: counter NUMBER := 0;

Line 573: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

569: ) t ) a
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';