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_ETL_PKG dependencies on RCI_ORG_CERT_SUMM_F

Line 217: from rci_org_cert_summ_f;

213: cursor c_load_cols is
214: select distinct fin_certification_id
215: ,organization_id
216: ,process_id
217: from rci_org_cert_summ_f;
218:
219:
220: l_proc_w_ineff_ctrls number := 0;
221: l_ineffective_ctrls number := 0;

Line 259: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_SUMM_F';

255: x_global_start_date => g_global_start_date
256: ,x_rci_schema => g_rci_schema);
257:
258: l_stmnt_id := 10;
259: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_SUMM_F';
260:
261: ----dbms_output.put_line( '2 **************' );
262:
263: l_stmnt_id := 20;

Line 264: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_SUMM_F');

260:
261: ----dbms_output.put_line( '2 **************' );
262:
263: l_stmnt_id := 20;
264: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_SUMM_F');
265:
266: ----dbms_output.put_line( '3 **************' );
267: l_stmnt_id := 30;
268: l_run_date := sysdate - 5/(24*60);

Line 270: INSERT INTO RCI_ORG_CERT_SUMM_F(

266: ----dbms_output.put_line( '3 **************' );
267: l_stmnt_id := 30;
268: l_run_date := sysdate - 5/(24*60);
269:
270: INSERT INTO RCI_ORG_CERT_SUMM_F(
271: fin_certification_id
272: ,natural_account_id
273: ,certification_id
274: ,certification_type

Line 419: update rci_org_cert_summ_f

415: ---- FETCH c_open_org_issues INTO l_open_issues;
416: ----CLOSE c_open_org_issues;
417:
418: /****
419: update rci_org_cert_summ_f
420: set proc_w_ineff_ctrls = l_proc_w_ineff_ctrls
421: where fin_certification_id = r_load_cols.fin_certification_id
422: and organization_id = r_load_cols.organization_id;
423: ***/

Line 425: update rci_org_cert_summ_f

421: where fin_certification_id = r_load_cols.fin_certification_id
422: and organization_id = r_load_cols.organization_id;
423: ***/
424:
425: update rci_org_cert_summ_f
426: set proc_w_ineff_ctrls = l_proc_w_ineff_ctrls
427: ,proc_certified_with_issues = l_processes_certified_w_issues
428: ,proc_certified = l_processes_certified
429: ,proc_not_certified = l_processes_not_certified

Line 452: 'RCI_ORG_CERT_SUMM_F'

448: ,program_id
449: ,program_login_id
450: ,program_application_id
451: ,request_id ) VALUES (
452: 'RCI_ORG_CERT_SUMM_F'
453: ,l_run_date
454: ,l_user_id
455: ,sysdate
456: ,sysdate

Line 488: from rci_org_cert_summ_f;

484: ,open_issues
485: ,certification_id
486: ,organization_id
487: ,process_id
488: from rci_org_cert_summ_f;
489:
490: l_proc_w_ineff_ctrls number := 0;
491: l_ineffective_ctrls number := 0;
492: l_unmitigated_risks number := 0;

Line 526: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_SUMM_F';

522: x_global_start_date => g_global_start_date
523: ,x_rci_schema => g_rci_schema);
524:
525: l_stmnt_id := 10;
526: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_SUMM_F';
527:
528: ----dbms_output.put_line( '2 **************' );
529:
530: l_stmnt_id := 20;

Line 531: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_SUMM_F');

527:
528: ----dbms_output.put_line( '2 **************' );
529:
530: l_stmnt_id := 20;
531: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_SUMM_F');
532:
533: ----dbms_output.put_line( '3 **************' );
534: l_stmnt_id := 30;
535: l_run_date := sysdate - 5/(24*60);

Line 537: INSERT INTO RCI_ORG_CERT_SUMM_F(

533: ----dbms_output.put_line( '3 **************' );
534: l_stmnt_id := 30;
535: l_run_date := sysdate - 5/(24*60);
536:
537: INSERT INTO RCI_ORG_CERT_SUMM_F(
538: fin_certification_id
539: ,natural_account_id
540: ,certification_id
541: ,certification_type

Line 694: update rci_org_cert_summ_f

690: ,r_load_cols.organization_id);
691: FETCH c_open_org_issues INTO l_open_issues;
692: CLOSE c_open_org_issues;
693:
694: update rci_org_cert_summ_f
695: set proc_w_ineff_ctrls = nvl(l_proc_w_ineff_ctrls,0)
696: ,unmitigated_risks = nvl(l_unmitigated_risks,0)
697: ,ineffective_controls = nvl(l_ineffective_ctrls,0)
698: ,open_issues = nvl(l_open_issues,0)

Line 718: 'RCI_ORG_CERT_SUMM_F'

714: ,program_id
715: ,program_login_id
716: ,program_application_id
717: ,request_id ) VALUES (
718: 'RCI_ORG_CERT_SUMM_F'
719: ,l_run_date
720: ,l_user_id
721: ,sysdate
722: ,sysdate

Line 763: from rci_org_cert_summ_f;

759: cursor c_load_cols is
760: select distinct fin_certification_id
761: ,organization_id
762: ,process_id
763: from rci_org_cert_summ_f;
764:
765: l_stmnt_id NUMBER := 0;
766: l_run_date DATE;
767: l_last_run_date DATE;

Line 798: l_last_run_date := get_last_run_date('RCI_ORG_CERT_SUMM_F');

794: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
795:
796: l_stmnt_id := 10;
797: l_proc_name := 'run_incr_load_drm';
798: l_last_run_date := get_last_run_date('RCI_ORG_CERT_SUMM_F');
799:
800: IF l_last_run_date IS NULL THEN
801: l_message := 'Please launch the Initial Load Request Set for the Organization Certification Summary page.';
802: RAISE INITIALIZATION_ERROR;

Line 814: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_SUMM_F');

810: /** 01.16.06 npanandi: added below procedure cal as RSG errors otherwise **/
811: check_initial_load_setup(
812: x_global_start_date => g_global_start_date
813: ,x_rci_schema => g_rci_schema);
814: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_SUMM_F');
815:
816: INSERT INTO RCI_ORG_CERT_SUMM_F(
817: fin_certification_id
818: ,natural_account_id

Line 816: INSERT INTO RCI_ORG_CERT_SUMM_F(

812: x_global_start_date => g_global_start_date
813: ,x_rci_schema => g_rci_schema);
814: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_SUMM_F');
815:
816: INSERT INTO RCI_ORG_CERT_SUMM_F(
817: fin_certification_id
818: ,natural_account_id
819: ,certification_id
820: ,certification_type

Line 965: update rci_org_cert_summ_f

961: ---- FETCH c_open_org_issues INTO l_open_issues;
962: ----CLOSE c_open_org_issues;
963:
964: /****
965: update rci_org_cert_summ_f
966: set proc_w_ineff_ctrls = l_proc_w_ineff_ctrls
967: where fin_certification_id = r_load_cols.fin_certification_id
968: and organization_id = r_load_cols.organization_id;
969: ***/

Line 971: update rci_org_cert_summ_f

967: where fin_certification_id = r_load_cols.fin_certification_id
968: and organization_id = r_load_cols.organization_id;
969: ***/
970:
971: update rci_org_cert_summ_f
972: set proc_w_ineff_ctrls = l_proc_w_ineff_ctrls
973: ,proc_certified_with_issues = l_processes_certified_w_issues
974: ,proc_certified = l_processes_certified
975: ,proc_not_certified = l_processes_not_certified

Line 1008: from rci_org_cert_summ_f;

1004: ,open_issues
1005: ,certification_id
1006: ,organization_id
1007: ,process_id
1008: from rci_org_cert_summ_f;
1009:
1010: l_stmnt_id NUMBER := 0;
1011: l_run_date DATE;
1012: l_last_run_date DATE;

Line 1040: l_last_run_date := get_last_run_date('RCI_ORG_CERT_SUMM_F');

1036: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1037:
1038: l_stmnt_id := 10;
1039: l_proc_name := 'run_incr_load_drm';
1040: l_last_run_date := get_last_run_date('RCI_ORG_CERT_SUMM_F');
1041:
1042: IF l_last_run_date IS NULL THEN
1043: l_message := 'Please launch the Initial Load Request Set for the Organization Certification Summary page.';
1044: RAISE INITIALIZATION_ERROR;

Line 1052: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_SUMM_F');

1048: l_run_date := sysdate - 5/(24*60);
1049: ---l_master_org := get_master_organization_id;
1050:
1051: l_stmnt_id := 20;
1052: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_SUMM_F');
1053:
1054: INSERT INTO RCI_ORG_CERT_SUMM_F(
1055: fin_certification_id
1056: ,natural_account_id

Line 1054: INSERT INTO RCI_ORG_CERT_SUMM_F(

1050:
1051: l_stmnt_id := 20;
1052: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_SUMM_F');
1053:
1054: INSERT INTO RCI_ORG_CERT_SUMM_F(
1055: fin_certification_id
1056: ,natural_account_id
1057: ,certification_id
1058: ,certification_type

Line 1210: update rci_org_cert_summ_f

1206: ,r_load_cols.organization_id);
1207: FETCH c_open_org_issues INTO l_open_issues;
1208: CLOSE c_open_org_issues;
1209:
1210: update rci_org_cert_summ_f
1211: set proc_w_ineff_ctrls = l_proc_w_ineff_ctrls
1212: ,unmitigated_risks = l_unmitigated_risks
1213: ,ineffective_controls = l_ineffective_ctrls
1214: ,open_issues = l_open_issues

Line 1233: WHERE fact_name = 'RCI_ORG_CERT_SUMM_F' ;

1229: ,program_id = l_program_id
1230: ,program_login_id = l_program_login_id
1231: ,program_application_id = l_program_application_id
1232: ,request_id = l_request_id
1233: WHERE fact_name = 'RCI_ORG_CERT_SUMM_F' ;
1234:
1235:
1236: commit;
1237: retcode := C_OK;