APPS.RCI_ORG_CERT_SUMM_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 5: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

1: PACKAGE BODY RCI_ORG_CERT_SUMM_PKG AS
2: --$Header: rciocsb.pls 120.39.12000000.6 2007/04/09 19:57:49 ddesjard ship $
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);

Line 145: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

141:
142: ---------------------------------------------------------------------------------
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;

Line 505: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

501:
502: -- the get_org_cert_prcnt procedure is called by
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;

Line 673: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

669:
670: -- the get_unmitigated_risks procedure is called by
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);

Line 880: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

876:
877: -- the get_control_list procedure is called by
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);

Line 1079: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

1075:
1076: -- the get_issue_detail procedure is called by
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);

Line 1275: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

1271:
1272: -- the get_deficient_processes procedure is called by
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);

Line 1477: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

1473:
1474: -- the get_org_certification_detail procedure is called by
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);

Line 1660: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

1656:
1657: -- the get_process_detail procedure is called by
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);