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 RCI_SIG_ACCT_EVAL_SUMM_PKG

Line 1: PACKAGE BODY RCI_SIG_ACCT_EVAL_SUMM_PKG AS

1: PACKAGE BODY RCI_SIG_ACCT_EVAL_SUMM_PKG AS
2: /*$Header: rcisgacb.pls 120.26.12000000.1 2007/01/16 20:46:46 appldev ship $*/
3:
4: --
5: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE

Line 373: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_risk_count(aauv.organization_id) RCI_PROC_CERT_MEASURE4

369: aauv.organization_id RCI_DRILLDOWN_PARAM1
370: ,aauv.NAME RCI_PROC_CERT_MEASURE1
371: ,aauv.company RCI_PROC_CERT_MEASURE2
372: ,aauv.lob_description RCI_PROC_CERT_MEASURE3
373: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_risk_count(aauv.organization_id) RCI_PROC_CERT_MEASURE4
374: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_control_count(aauv.organization_id) RCI_PROC_CERT_MEASURE5
375: ,'' '' RCI_PROC_CERT_MEASURE6
376: ,acv.certification_name RCI_PROC_CERT_MEASURE7
377: ,certres.value RCI_PROC_CERT_MEASURE8

Line 374: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_control_count(aauv.organization_id) RCI_PROC_CERT_MEASURE5

370: ,aauv.NAME RCI_PROC_CERT_MEASURE1
371: ,aauv.company RCI_PROC_CERT_MEASURE2
372: ,aauv.lob_description RCI_PROC_CERT_MEASURE3
373: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_risk_count(aauv.organization_id) RCI_PROC_CERT_MEASURE4
374: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_control_count(aauv.organization_id) RCI_PROC_CERT_MEASURE5
375: ,'' '' RCI_PROC_CERT_MEASURE6
376: ,acv.certification_name RCI_PROC_CERT_MEASURE7
377: ,certres.value RCI_PROC_CERT_MEASURE8
378: ,trunc(rocsf.ORG_CERTIFIED_ON) RCI_PROC_CERT_MEASURE9

Line 379: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_latest_engagement(aauv.organization_id) RCI_PROC_CERT_MEASURE10

375: ,'' '' RCI_PROC_CERT_MEASURE6
376: ,acv.certification_name RCI_PROC_CERT_MEASURE7
377: ,certres.value RCI_PROC_CERT_MEASURE8
378: ,trunc(rocsf.ORG_CERTIFIED_ON) RCI_PROC_CERT_MEASURE9
379: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_latest_engagement(aauv.organization_id) RCI_PROC_CERT_MEASURE10
380: ,evalopinion.eval_result RCI_PROC_CERT_MEASURE11
381: ,trunc(evalopinion.eval_date)RCI_PROC_CERT_MEASURE12
382: ,evalopinion.eval_by RCI_PROC_CERT_MEASURE13
383: FROM

Line 416: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_risk_count(aauv.organization_id) RCI_PROC_CERT_MEASURE4

412: l_sqlstmt := 'SELECT DISTINCT aauv.organization_id RCI_DRILLDOWN_PARAM1
413: ,aauv.NAME RCI_PROC_CERT_MEASURE1
414: ,aauv.company RCI_PROC_CERT_MEASURE2
415: ,aauv.lob_description RCI_PROC_CERT_MEASURE3
416: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_risk_count(aauv.organization_id) RCI_PROC_CERT_MEASURE4
417: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_control_count(aauv.organization_id) RCI_PROC_CERT_MEASURE5
418: ,'' '' RCI_PROC_CERT_MEASURE6
419: ,acv.certification_name RCI_PROC_CERT_MEASURE7
420: ,certres.value RCI_PROC_CERT_MEASURE8

Line 417: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_control_count(aauv.organization_id) RCI_PROC_CERT_MEASURE5

413: ,aauv.NAME RCI_PROC_CERT_MEASURE1
414: ,aauv.company RCI_PROC_CERT_MEASURE2
415: ,aauv.lob_description RCI_PROC_CERT_MEASURE3
416: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_risk_count(aauv.organization_id) RCI_PROC_CERT_MEASURE4
417: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_control_count(aauv.organization_id) RCI_PROC_CERT_MEASURE5
418: ,'' '' RCI_PROC_CERT_MEASURE6
419: ,acv.certification_name RCI_PROC_CERT_MEASURE7
420: ,certres.value RCI_PROC_CERT_MEASURE8
421: ,trunc(rocsf.ORG_CERTIFIED_ON) RCI_PROC_CERT_MEASURE9

Line 422: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_latest_engagement(aauv.organization_id) RCI_PROC_CERT_MEASURE10

418: ,'' '' RCI_PROC_CERT_MEASURE6
419: ,acv.certification_name RCI_PROC_CERT_MEASURE7
420: ,certres.value RCI_PROC_CERT_MEASURE8
421: ,trunc(rocsf.ORG_CERTIFIED_ON) RCI_PROC_CERT_MEASURE9
422: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_latest_engagement(aauv.organization_id) RCI_PROC_CERT_MEASURE10
423: ,evalopinion.eval_result RCI_PROC_CERT_MEASURE11
424: ,evalopinion.eval_by RCI_PROC_CERT_MEASURE12
425: ,trunc(evalopinion.eval_date) RCI_PROC_CERT_MEASURE13
426: FROM amw_audit_units_v aauv

Line 610: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_unmiti_risks(acv.certification_id,aauv.organization_id) RCI_PROC_CERT_MEASURE4

606: DISTINCT aauv.organization_id RCI_DRILLDOWN_PARAM1
607: ,aauv.NAME RCI_PROC_CERT_MEASURE1
608: ,aauv.company RCI_PROC_CERT_MEASURE2
609: ,aauv.lob_description RCI_PROC_CERT_MEASURE3
610: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_unmiti_risks(acv.certification_id,aauv.organization_id) RCI_PROC_CERT_MEASURE4
611: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_ineff_ctrls(acv.certification_id,aauv.organization_id) RCI_PROC_CERT_MEASURE5
612: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_ineff_procs(acv.certification_id,aauv.organization_id) RCI_PROC_CERT_MEASURE6
613: ,'' '' RCI_PROC_CERT_MEASURE7
614: ,acv.certification_name RCI_PROC_CERT_MEASURE8

Line 611: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_ineff_ctrls(acv.certification_id,aauv.organization_id) RCI_PROC_CERT_MEASURE5

607: ,aauv.NAME RCI_PROC_CERT_MEASURE1
608: ,aauv.company RCI_PROC_CERT_MEASURE2
609: ,aauv.lob_description RCI_PROC_CERT_MEASURE3
610: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_unmiti_risks(acv.certification_id,aauv.organization_id) RCI_PROC_CERT_MEASURE4
611: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_ineff_ctrls(acv.certification_id,aauv.organization_id) RCI_PROC_CERT_MEASURE5
612: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_ineff_procs(acv.certification_id,aauv.organization_id) RCI_PROC_CERT_MEASURE6
613: ,'' '' RCI_PROC_CERT_MEASURE7
614: ,acv.certification_name RCI_PROC_CERT_MEASURE8
615: ,certres.value RCI_PROC_CERT_MEASURE9

Line 612: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_ineff_procs(acv.certification_id,aauv.organization_id) RCI_PROC_CERT_MEASURE6

608: ,aauv.company RCI_PROC_CERT_MEASURE2
609: ,aauv.lob_description RCI_PROC_CERT_MEASURE3
610: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_unmiti_risks(acv.certification_id,aauv.organization_id) RCI_PROC_CERT_MEASURE4
611: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_ineff_ctrls(acv.certification_id,aauv.organization_id) RCI_PROC_CERT_MEASURE5
612: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_ineff_procs(acv.certification_id,aauv.organization_id) RCI_PROC_CERT_MEASURE6
613: ,'' '' RCI_PROC_CERT_MEASURE7
614: ,acv.certification_name RCI_PROC_CERT_MEASURE8
615: ,certres.value RCI_PROC_CERT_MEASURE9
616: ,trunc(rocsf.ORG_CERTIFIED_ON) RCI_PROC_CERT_MEASURE10

Line 617: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_latest_engagement(aauv.organization_id) RCI_PROC_CERT_MEASURE11

613: ,'' '' RCI_PROC_CERT_MEASURE7
614: ,acv.certification_name RCI_PROC_CERT_MEASURE8
615: ,certres.value RCI_PROC_CERT_MEASURE9
616: ,trunc(rocsf.ORG_CERTIFIED_ON) RCI_PROC_CERT_MEASURE10
617: ,RCI_SIG_ACCT_EVAL_SUMM_PKG.get_latest_engagement(aauv.organization_id) RCI_PROC_CERT_MEASURE11
618: ,evalopinion.eval_result RCI_PROC_CERT_MEASURE12
619: ,evalopinion.eval_by RCI_PROC_CERT_MEASURE13
620: ,trunc(evalopinion.eval_date) RCI_PROC_CERT_MEASURE14
621: FROM amw_audit_units_v aauv

Line 1418: END RCI_SIG_ACCT_EVAL_SUMM_PKG;

1414: ,l_request_id );
1415:
1416: EXECUTE IMMEDIATE ('COMMIT');
1417: END sig_acct_initial_load;
1418: END RCI_SIG_ACCT_EVAL_SUMM_PKG;