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_SIG_ACCT_EVAL_SUMM_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 21: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

17:
18: PROCEDURE get_kpi(
19: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
20: ,p_exp_source_sql out NOCOPY VARCHAR2
21: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
22: is
23: l_sqlstmt VARCHAR2(15000);
24: total_qry VARCHAR2(15000);
25: counter NUMBER := 0;

Line 29: l_bind_rec BIS_QUERY_ATTRIBUTES;

25: counter NUMBER := 0;
26: where_clause VARCHAR2(2000) := ' ';
27: v_total NUMBER;
28: v_period varchar2(10);
29: l_bind_rec BIS_QUERY_ATTRIBUTES;
30:
31: BEGIN
32:
33: counter := p_page_parameter_tbl.COUNT;

Line 137: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

133: )
134: ';
135:
136: p_exp_source_sql := l_sqlstmt;
137: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
138: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
139:
140: p_exp_source_output.EXTEND;
141: l_bind_rec.attribute_name := ':TIME';

Line 152: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

148:
149: PROCEDURE get_sig_acct_eval_details(
150: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
151: ,p_exp_source_sql out NOCOPY VARCHAR2
152: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
153: is
154: l_sqlstmt VARCHAR2(15000);
155: counter NUMBER := 0;
156: where_clause VARCHAR2(2000) := '';

Line 158: l_bind_rec BIS_QUERY_ATTRIBUTES;

154: l_sqlstmt VARCHAR2(15000);
155: counter NUMBER := 0;
156: where_clause VARCHAR2(2000) := '';
157: v_period varchar2(10);
158: l_bind_rec BIS_QUERY_ATTRIBUTES;
159: BEGIN
160: counter := p_page_parameter_tbl.COUNT;
161: FOR i IN 1..counter LOOP
162: IF p_page_parameter_tbl(i).parameter_id IS NOT NULL THEN

Line 258: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

254: and acv.certification_period_name = agpv.period_name
255: ';
256:
257: p_exp_source_sql := l_sqlstmt;
258: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
259: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
260:
261: p_exp_source_output.EXTEND;
262: l_bind_rec.attribute_name := ':TIME';

Line 304: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

300:
301: PROCEDURE get_org_details(
302: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
303: ,p_exp_source_sql out NOCOPY VARCHAR2
304: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
305: is
306: l_sqlstmt VARCHAR2(15000);
307: counter NUMBER := 0;
308: where_clause VARCHAR2(2000) := '';

Line 312: l_bind_rec BIS_QUERY_ATTRIBUTES;

308: where_clause VARCHAR2(2000) := '';
309: ---01.05.2006 npanandi: added l_act_sqlstmt below
310: l_act_sqlstmt VARCHAR2(15000);
311: v_period varchar2(10);
312: l_bind_rec BIS_QUERY_ATTRIBUTES;
313: BEGIN
314: counter := p_page_parameter_tbl.COUNT;
315: FOR i IN 1..counter LOOP
316: IF p_page_parameter_tbl(i).parameter_id IS NOT NULL THEN

Line 468: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

464: order by a.col_rank ';
465:
466:
467: p_exp_source_sql := l_act_sqlstmt;
468: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
469: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
470:
471: p_exp_source_output.EXTEND;
472: l_bind_rec.attribute_name := ':TIME';

Line 559: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

555:
556: PROCEDURE get_org_def_details(
557: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
558: ,p_exp_source_sql out NOCOPY VARCHAR2
559: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
560: is
561: l_sqlstmt VARCHAR2(15000);
562: counter NUMBER := 0;
563: where_clause VARCHAR2(2000) := '';

Line 565: l_bind_rec BIS_QUERY_ATTRIBUTES;

561: l_sqlstmt VARCHAR2(15000);
562: counter NUMBER := 0;
563: where_clause VARCHAR2(2000) := '';
564: v_period varchar2(10);
565: l_bind_rec BIS_QUERY_ATTRIBUTES;
566: BEGIN
567: counter := p_page_parameter_tbl.COUNT;
568: FOR i IN 1..counter LOOP
569: IF p_page_parameter_tbl(i).parameter_id IS NOT NULL THEN

Line 644: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

640: AND rocsf.ineffective_controls > 0
641: '||where_clause;
642:
643: p_exp_source_sql := l_sqlstmt;
644: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
645: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
646:
647: p_exp_source_output.EXTEND;
648: l_bind_rec.attribute_name := ':TIME';

Line 659: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

655:
656: PROCEDURE get_sig_acct_details(
657: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
658: ,p_exp_source_sql out NOCOPY VARCHAR2
659: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
660: is
661: l_sqlstmt VARCHAR2(15000);
662: counter NUMBER := 0;
663: where_clause VARCHAR2(2000) := '';

Line 665: l_bind_rec BIS_QUERY_ATTRIBUTES;

661: l_sqlstmt VARCHAR2(15000);
662: counter NUMBER := 0;
663: where_clause VARCHAR2(2000) := '';
664: v_period varchar2(10);
665: l_bind_rec BIS_QUERY_ATTRIBUTES;
666: BEGIN
667: counter := p_page_parameter_tbl.COUNT;
668: FOR i IN 1..counter LOOP
669: IF p_page_parameter_tbl(i).parameter_id IS NOT NULL THEN

Line 751: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

747: AND afka.natural_account_id = accteval.sig_acct_id
748: ' || where_clause;
749:
750: p_exp_source_sql := l_sqlstmt;
751: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
752: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
753:
754: p_exp_source_output.EXTEND;
755: l_bind_rec.attribute_name := ':TIME';

Line 766: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

762:
763: PROCEDURE get_sig_acct_eval_result(
764: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
765: ,p_exp_source_sql out NOCOPY VARCHAR2
766: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
767: is
768: l_sqlstmt VARCHAR2(15000);
769: l_act_sqlstmt VARCHAR2(15000);
770: counter NUMBER := 0;

Line 775: l_bind_rec BIS_QUERY_ATTRIBUTES;

771: where_clause VARCHAR2(2000) := ' ';
772: total_qry VARCHAR2(15000);
773: v_total number;
774: v_period varchar2(10);
775: l_bind_rec BIS_QUERY_ATTRIBUTES;
776: BEGIN
777: counter := p_page_parameter_tbl.COUNT;
778: FOR i IN 1..counter LOOP
779: IF p_page_parameter_tbl(i).parameter_id IS NOT NULL THEN

Line 914: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

910: ) t ) a
911: order by a.col_rank ';
912:
913: p_exp_source_sql := l_act_sqlstmt;
914: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
915: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
916:
917: p_exp_source_output.EXTEND;
918: l_bind_rec.attribute_name := ':TIME';

Line 929: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

925:
926: PROCEDURE get_sig_acct_eval_summ_result(
927: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
928: ,p_exp_source_sql out NOCOPY VARCHAR2
929: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
930: is
931: l_sqlstmt VARCHAR2(15000);
932: l_act_sqlstmt varchar2(15000);
933: counter NUMBER := 0;

Line 937: l_bind_rec BIS_QUERY_ATTRIBUTES;

933: counter NUMBER := 0;
934: where_clause VARCHAR2(2000) := ' ';
935: where_clause1 VARCHAR2(2000) := ' ';
936: v_period varchar2(10);
937: l_bind_rec BIS_QUERY_ATTRIBUTES;
938: BEGIN
939: counter := p_page_parameter_tbl.COUNT;
940: FOR i IN 1..counter LOOP
941: IF p_page_parameter_tbl(i).parameter_id IS NOT NULL THEN

Line 1133: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

1129: ) t ) a
1130: order by a.col_rank ';
1131:
1132: p_exp_source_sql := l_act_sqlstmt;
1133: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
1134: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1135:
1136: p_exp_source_output.EXTEND;
1137: l_bind_rec.attribute_name := ':TIME';