eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCI_PROC_CERT_SUMM_PKG dependencies on BIS_QUERY_ATTRIBUTES

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 40: l_bind_rec BIS_QUERY_ATTRIBUTES;

36: l_qry2 varchar2(2000);
37: l_qry3 varchar2(2000);
38: --dynamic bind parameters for period
39: v_period varchar2(10);
40: l_bind_rec BIS_QUERY_ATTRIBUTES;
41: BEGIN
42: counter := p_page_parameter_tbl.COUNT;
43: FOR i IN 1..counter LOOP
44: IF p_page_parameter_tbl(i).parameter_id IS NOT NULL THEN

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 136: l_bind_rec BIS_QUERY_ATTRIBUTES;

132: l_sqlstmt VARCHAR2(15000);
133: counter NUMBER := 0;
134: where_clause VARCHAR2(2000) := '';
135: v_period varchar2(10);
136: l_bind_rec BIS_QUERY_ATTRIBUTES;
137: BEGIN
138: counter := p_page_parameter_tbl.COUNT;
139: FOR i IN 1..counter LOOP
140: IF p_page_parameter_tbl(i).parameter_id IS NOT NULL THEN

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 247: l_bind_rec BIS_QUERY_ATTRIBUTES;

243: where_clause VARCHAR2(2000) := ' 1=1 ';
244: total_qry VARCHAR2(15000);
245: v_total number;
246: v_period varchar2(10);
247: l_bind_rec BIS_QUERY_ATTRIBUTES;
248: BEGIN
249:
250: counter := p_page_parameter_tbl.COUNT;
251: FOR i IN 1..counter LOOP

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 361: l_bind_rec BIS_QUERY_ATTRIBUTES;

357: l_rf_where varchar2(2000) := ' 1=1 ';
358:
359: v_yyyymm varchar2(6);
360: v_period varchar2(10);
361: l_bind_rec BIS_QUERY_ATTRIBUTES;
362: BEGIN
363: counter := p_page_parameter_tbl.COUNT;
364: FOR i IN 1..counter LOOP
365: IF p_page_parameter_tbl(i).parameter_id IS NOT NULL THEN

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