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_ORG_CERT_SUMM_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 7: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

3:
4: PROCEDURE get_org_kpi(
5: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
6: ,p_exp_source_sql out NOCOPY VARCHAR2
7: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
8: is
9: l_sqlstmt VARCHAR2(15000);
10: v_dummy number := 99;
11:

Line 130: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

126: p_exp_source_sql := l_sqlstmt || l_qry1 || l_qry2 || l_qry3;
127: /***12.12.2005 npanandi: bug 4880422 fix ends ***/
128:
129: /**04.27.2006 npanandi: adding code for dynamic binding of time period dimensions**/
130: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
131: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
132:
133: p_exp_source_output.EXTEND;
134: l_bind_rec.attribute_name := ':TIME1';

Line 147: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

143: -- the get_org_certification_result procedure is called by Organization Certification Summary report.
144: PROCEDURE get_org_certification_result(
145: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
146: ,p_exp_source_sql out NOCOPY VARCHAR2
147: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
148: is
149: l_multi_factor NUMBER;
150: l_sqlstmt VARCHAR2(15000);
151: l_act_sqlstmt varchar2(15000);

Line 448: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

444:
445: p_exp_source_sql := l_act_sqlstmt;
446:
447: /**04.27.2006 npanandi: adding code for dynamic binding of time period dimensions**/
448: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
449: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
450:
451: p_exp_source_output.EXTEND;
452: l_bind_rec.attribute_name := ':TIME1';

Line 507: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

503: -- Organization Certification Result report.
504: PROCEDURE get_org_cert_prcnt(
505: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
506: ,p_exp_source_sql out NOCOPY VARCHAR2
507: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
508: is
509: l_multi_factor NUMBER;
510: l_sqlstmt VARCHAR2(15000);
511: l_act_sqlstmt varchar2(15000);

Line 658: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

654: /**p_exp_source_sql := l_sqlstmt || l_from_clause || l_grp_by;**/
655: p_exp_source_sql := l_act_sqlstmt;
656:
657: /**04.27.2006 npanandi: adding code for dynamic binding of time period dimensions**/
658: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
659: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
660:
661: p_exp_source_output.EXTEND;
662: l_bind_rec.attribute_name := ':TIME1';

Line 675: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

671: -- Organization Certification Unmitigated Risks List report.
672: PROCEDURE get_unmitigated_risks(
673: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
674: ,p_exp_source_sql out NOCOPY VARCHAR2
675: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
676: is
677: l_sqlstmt VARCHAR2(15000);
678: ---12.22.2005 npanandi: added l_act_sqlstmt below
679: l_act_sqlstmt VARCHAR2(15000);

Line 864: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

860:
861: p_exp_source_sql := l_act_sqlstmt;
862:
863: /**04.27.2006 npanandi: adding code for dynamic binding of time period dimensions**/
864: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
865: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
866:
867: p_exp_source_output.EXTEND;
868: l_bind_rec.attribute_name := ':TIME1';

Line 882: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

878: -- Organization Certification Control Detail List report.
879: PROCEDURE get_control_list(
880: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
881: ,p_exp_source_sql out NOCOPY VARCHAR2
882: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
883: is
884: l_sqlstmt VARCHAR2(15000);
885: ---12.22.2005 npanandi: added l_act_sqlstmt below
886: l_act_sqlstmt VARCHAR2(15000);

Line 1062: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

1058:
1059: p_exp_source_sql := l_act_sqlstmt;
1060:
1061: /**04.28.2006 npanandi: adding code for dynamic binding of time period dimensions**/
1062: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
1063: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1064:
1065: p_exp_source_output.EXTEND;
1066: l_bind_rec.attribute_name := ':TIME1';

Line 1081: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1077: -- Issue Detail List report.
1078: PROCEDURE get_issue_detail(
1079: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1080: ,p_exp_source_sql out NOCOPY VARCHAR2
1081: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1082: is
1083: l_sqlstmt VARCHAR2(15000);
1084: l_act_sqlstmt varchar2(15000);
1085: l_from_clause varchar2(15000);

Line 1277: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1273: -- Process Deficiency Detail report.
1274: PROCEDURE get_deficient_processes(
1275: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1276: ,p_exp_source_sql out NOCOPY VARCHAR2
1277: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1278: is
1279: l_sqlstmt VARCHAR2(15000);
1280: ---12.22.2005 npanandi: added l_act_sqlstmt below
1281: l_act_sqlstmt VARCHAR2(15000);

Line 1462: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

1458:
1459: p_exp_source_sql := l_act_sqlstmt;
1460:
1461: /**04.28.2006 npanandi: adding code for dynamic binding of time period dimensions**/
1462: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
1463: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1464:
1465: p_exp_source_output.EXTEND;
1466: l_bind_rec.attribute_name := ':TIME1';

Line 1479: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1475: -- Organization Certification Detail report.
1476: PROCEDURE get_org_certification_detail(
1477: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1478: ,p_exp_source_sql out NOCOPY VARCHAR2
1479: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1480: is
1481: l_sqlstmt VARCHAR2(15000);
1482: ---12.22.2005 npanandi: added l_act_sqlstmt below
1483: l_act_sqlstmt VARCHAR2(15000);

Line 1644: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

1640: p_exp_source_sql := l_act_sqlstmt;
1641: ----p_exp_source_sql := l_sqlstmt || l_from_clause || l_group_by;
1642:
1643: /**04.28.2006 npanandi: adding code for dynamic binding of time period dimensions**/
1644: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
1645: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1646:
1647: p_exp_source_output.EXTEND;
1648: l_bind_rec.attribute_name := ':TIME1';

Line 1662: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1658: -- Organization Certification Detail + Significant Account Evaluation Summary report.
1659: PROCEDURE get_process_detail(
1660: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1661: ,p_exp_source_sql out NOCOPY VARCHAR2
1662: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1663: is
1664: l_sqlstmt VARCHAR2(15000);
1665: ---12.22.2005 npanandi: added l_act_sqlstmt below
1666: l_act_sqlstmt VARCHAR2(15000);

Line 1840: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

1836:
1837: p_exp_source_sql := l_act_sqlstmt;
1838:
1839: /**04.28.2006 npanandi: adding code for dynamic binding of time period dimensions**/
1840: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
1841: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1842:
1843: p_exp_source_output.EXTEND;
1844: l_bind_rec.attribute_name := ':TIME1';