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_DFCY_ETL_PKG dependencies on RCI_ORG_PROC_DFCY_F

Line 154: from rci_org_proc_dfcy_f;

150: cursor c_load_cols is
151: select certification_id
152: ,organization_id
153: ,process_id
154: from rci_org_proc_dfcy_f;
155:
156: l_stmnt_id NUMBER := 0;
157: l_run_date DATE;
158: l_proc_name VARCHAR2(30);

Line 193: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_PROC_DFCY_F';

189: x_global_start_date => g_global_start_date
190: ,x_rci_schema => g_rci_schema);
191:
192: l_stmnt_id := 10;
193: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_PROC_DFCY_F';
194:
195: ----dbms_output.put_line( '2 **************' );
196:
197: l_stmnt_id := 20;

Line 198: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_PROC_DFCY_F');

194:
195: ----dbms_output.put_line( '2 **************' );
196:
197: l_stmnt_id := 20;
198: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_PROC_DFCY_F');
199:
200: ----dbms_output.put_line( '3 **************' );
201: l_stmnt_id := 30;
202: l_run_date := sysdate - 5/(24*60);

Line 204: INSERT INTO RCI_ORG_PROC_DFCY_F(

200: ----dbms_output.put_line( '3 **************' );
201: l_stmnt_id := 30;
202: l_run_date := sysdate - 5/(24*60);
203:
204: INSERT INTO RCI_ORG_PROC_DFCY_F(
205: project_id
206: ,fin_certification_id
207: ,certification_id
208: ,certification_status

Line 434: update RCI_ORG_PROC_DFCY_F

430: and nvl(acb.key_mitigating,'N') = 'Y';
431: /** 12.12.2005 npanandi: ends bug 4862301 fix **/
432: end if;
433:
434: update RCI_ORG_PROC_DFCY_F
435: set unmitigated_risks = l_unmitigated_risks
436: ,ineffective_controls = l_ineffective_controls
437: /** 12.12.2005 npanandi: bug 4862301 fix for keyControl **/
438: ,key_control = l_key_control

Line 463: 'RCI_ORG_PROC_DFCY_F'

459: ,program_id
460: ,program_login_id
461: ,program_application_id
462: ,request_id ) VALUES (
463: 'RCI_ORG_PROC_DFCY_F'
464: ,l_run_date
465: ,l_user_id
466: ,sysdate
467: ,sysdate

Line 497: from rci_org_proc_dfcy_f;

493: cursor c_load_cols is
494: select certification_id
495: ,organization_id
496: ,process_id
497: from rci_org_proc_dfcy_f;
498:
499: l_stmnt_id NUMBER := 0;
500: l_run_date DATE;
501: l_proc_name VARCHAR2(30);

Line 536: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_PROC_DFCY_F';

532: x_global_start_date => g_global_start_date
533: ,x_rci_schema => g_rci_schema);
534:
535: l_stmnt_id := 10;
536: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_PROC_DFCY_F';
537:
538: ----dbms_output.put_line( '2 **************' );
539:
540: l_stmnt_id := 20;

Line 541: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_PROC_DFCY_F');

537:
538: ----dbms_output.put_line( '2 **************' );
539:
540: l_stmnt_id := 20;
541: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_PROC_DFCY_F');
542:
543: ----dbms_output.put_line( '3 **************' );
544: l_stmnt_id := 30;
545: l_run_date := sysdate - 5/(24*60);

Line 547: INSERT INTO RCI_ORG_PROC_DFCY_F(

543: ----dbms_output.put_line( '3 **************' );
544: l_stmnt_id := 30;
545: l_run_date := sysdate - 5/(24*60);
546:
547: INSERT INTO RCI_ORG_PROC_DFCY_F(
548: project_id
549: ,fin_certification_id
550: ,certification_id
551: ,certification_status

Line 696: update RCI_ORG_PROC_DFCY_F

692: and nvl(acb.key_mitigating,'N') = 'Y';
693: /** 12.12.2005 npanandi: ends bug 4862301 fix **/
694: end if;
695:
696: update RCI_ORG_PROC_DFCY_F
697: set unmitigated_risks = l_unmitigated_risks
698: ,ineffective_controls = l_ineffective_controls
699: /** 12.12.2005 npanandi: bug 4862301 fix for keyControl **/
700: ,key_control = l_key_control

Line 725: 'RCI_ORG_PROC_DFCY_F'

721: ,program_id
722: ,program_login_id
723: ,program_application_id
724: ,request_id ) VALUES (
725: 'RCI_ORG_PROC_DFCY_F'
726: ,l_run_date
727: ,l_user_id
728: ,sysdate
729: ,sysdate

Line 767: from rci_org_proc_dfcy_f;

763: cursor c_load_cols is
764: select certification_id
765: ,organization_id
766: ,process_id
767: from rci_org_proc_dfcy_f;
768:
769: l_stmnt_id NUMBER := 0;
770: l_run_date DATE;
771: l_last_run_date DATE;

Line 799: l_last_run_date := get_last_run_date('RCI_ORG_PROC_DFCY_F');

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

Line 815: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_PROC_DFCY_F');

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

Line 819: INSERT INTO RCI_ORG_PROC_DFCY_F(

815: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_PROC_DFCY_F');
816:
817: l_stmnt_id := 40;
818:
819: INSERT INTO RCI_ORG_PROC_DFCY_F(
820: project_id
821: ,fin_certification_id
822: ,certification_id
823: ,certification_status

Line 981: update RCI_ORG_PROC_DFCY_F

977: and nvl(acb.key_mitigating,'N') = 'Y';
978: /** 12.12.2005 npanandi: ends bug 4862301 fix **/
979: end if;
980:
981: update RCI_ORG_PROC_DFCY_F
982: set unmitigated_risks = l_unmitigated_risks
983: ,ineffective_controls = l_ineffective_controls
984: /** 12.12.2005 npanandi: bug 4862301 fix for keyControl **/
985: ,key_control = l_key_control

Line 1002: WHERE fact_name = 'RCI_ORG_PROC_DFCY_F' ;

998: ,program_id = l_program_id
999: ,program_login_id = l_program_login_id
1000: ,program_application_id = l_program_application_id
1001: ,request_id = l_request_id
1002: WHERE fact_name = 'RCI_ORG_PROC_DFCY_F' ;
1003:
1004:
1005: commit;
1006: retcode := C_OK;

Line 1023: from rci_org_proc_dfcy_f;

1019: cursor c_load_cols is
1020: select certification_id
1021: ,organization_id
1022: ,process_id
1023: from rci_org_proc_dfcy_f;
1024:
1025: l_stmnt_id NUMBER := 0;
1026: l_run_date DATE;
1027: l_last_run_date DATE;

Line 1055: l_last_run_date := get_last_run_date('RCI_ORG_PROC_DFCY_F');

1051: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1052:
1053: l_stmnt_id := 10;
1054: l_proc_name := 'run_incr_load_drm';
1055: l_last_run_date := get_last_run_date('RCI_ORG_PROC_DFCY_F');
1056:
1057: IF l_last_run_date IS NULL THEN
1058: l_message := 'Please launch the Initial Load Request Set for the Organization Certification Summary page.';
1059: RAISE INITIALIZATION_ERROR;

Line 1067: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_PROC_DFCY_F');

1063: l_run_date := sysdate - 5/(24*60);
1064: ---l_master_org := get_master_organization_id;
1065:
1066: l_stmnt_id := 30;
1067: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_PROC_DFCY_F');
1068:
1069: l_stmnt_id := 40;
1070:
1071: INSERT INTO RCI_ORG_PROC_DFCY_F(

Line 1071: INSERT INTO RCI_ORG_PROC_DFCY_F(

1067: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_PROC_DFCY_F');
1068:
1069: l_stmnt_id := 40;
1070:
1071: INSERT INTO RCI_ORG_PROC_DFCY_F(
1072: project_id
1073: ,fin_certification_id
1074: ,certification_id
1075: ,certification_status

Line 1220: update RCI_ORG_PROC_DFCY_F

1216: and nvl(acb.key_mitigating,'N') = 'Y';
1217: /** 12.12.2005 npanandi: ends bug 4862301 fix **/
1218: end if;
1219:
1220: update RCI_ORG_PROC_DFCY_F
1221: set unmitigated_risks = l_unmitigated_risks
1222: ,ineffective_controls = l_ineffective_controls
1223: /** 12.12.2005 npanandi: bug 4862301 fix for keyControl **/
1224: ,key_control = l_key_control

Line 1241: WHERE fact_name = 'RCI_ORG_PROC_DFCY_F' ;

1237: ,program_id = l_program_id
1238: ,program_login_id = l_program_login_id
1239: ,program_application_id = l_program_application_id
1240: ,request_id = l_request_id
1241: WHERE fact_name = 'RCI_ORG_PROC_DFCY_F' ;
1242:
1243:
1244: commit;
1245: retcode := C_OK;