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.

[Home] [Help]

APPS.RCI_CTRL_DETAIL_ETL_PKG dependencies on RCI_ORG_CERT_CTRLS_F

Line 183: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_CTRLS_F';

179: x_global_start_date => g_global_start_date
180: ,x_rci_schema => g_rci_schema);
181:
182: l_stmnt_id := 10;
183: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_CTRLS_F';
184:
185:
186: l_stmnt_id := 20;
187: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_CTRLS_F');

Line 187: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_CTRLS_F');

183: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_CTRLS_F';
184:
185:
186: l_stmnt_id := 20;
187: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_CTRLS_F');
188:
189: l_stmnt_id := 30;
190: l_run_date := sysdate - 5/(24*60);
191:

Line 192: INSERT INTO RCI_ORG_CERT_CTRLS_F(

188:
189: l_stmnt_id := 30;
190: l_run_date := sysdate - 5/(24*60);
191:
192: INSERT INTO RCI_ORG_CERT_CTRLS_F(
193: fin_certification_id
194: ,certification_id
195: ,certification_status
196: ,certification_type

Line 310: 'RCI_ORG_CERT_CTRLS_F'

306: ,program_id
307: ,program_login_id
308: ,program_application_id
309: ,request_id ) VALUES (
310: 'RCI_ORG_CERT_CTRLS_F'
311: ,l_run_date
312: ,l_user_id
313: ,sysdate
314: ,sysdate

Line 372: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_CTRLS_F';

368: x_global_start_date => g_global_start_date
369: ,x_rci_schema => g_rci_schema);
370:
371: l_stmnt_id := 10;
372: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_CTRLS_F';
373:
374:
375: l_stmnt_id := 20;
376: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_CTRLS_F');

Line 376: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_CTRLS_F');

372: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_CTRLS_F';
373:
374:
375: l_stmnt_id := 20;
376: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_CTRLS_F');
377:
378: l_stmnt_id := 30;
379: l_run_date := sysdate - 5/(24*60);
380:

Line 381: INSERT INTO RCI_ORG_CERT_CTRLS_F(

377:
378: l_stmnt_id := 30;
379: l_run_date := sysdate - 5/(24*60);
380:
381: INSERT INTO RCI_ORG_CERT_CTRLS_F(
382: fin_certification_id
383: ,certification_id
384: ,certification_status
385: ,certification_type

Line 519: 'RCI_ORG_CERT_CTRLS_F'

515: ,program_id
516: ,program_login_id
517: ,program_application_id
518: ,request_id ) VALUES (
519: 'RCI_ORG_CERT_CTRLS_F'
520: ,l_run_date
521: ,l_user_id
522: ,sysdate
523: ,sysdate

Line 581: l_last_run_date := get_last_run_date('RCI_ORG_CERT_CTRLS_F');

577: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
578:
579: l_stmnt_id := 10;
580: l_proc_name := 'run_incr_load_drm';
581: l_last_run_date := get_last_run_date('RCI_ORG_CERT_CTRLS_F');
582:
583: IF l_last_run_date IS NULL THEN
584: l_message := 'Please launch the Initial Load Request Set for the Organization Certification Summary page.';
585: RAISE INITIALIZATION_ERROR;

Line 597: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_CTRLS_F');

593: /** 01.16.06 npanandi: added below procedure cal as RSG errors otherwise **/
594: check_initial_load_setup(
595: x_global_start_date => g_global_start_date
596: ,x_rci_schema => g_rci_schema);
597: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_CTRLS_F');
598:
599: l_stmnt_id := 40;
600:
601: INSERT INTO RCI_ORG_CERT_CTRLS_F(

Line 601: INSERT INTO RCI_ORG_CERT_CTRLS_F(

597: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_CTRLS_F');
598:
599: l_stmnt_id := 40;
600:
601: INSERT INTO RCI_ORG_CERT_CTRLS_F(
602: fin_certification_id
603: ,certification_id
604: ,certification_status
605: ,certification_type

Line 716: WHERE fact_name = 'RCI_ORG_CERT_CTRLS_F' ;

712: ,program_id = l_program_id
713: ,program_login_id = l_program_login_id
714: ,program_application_id = l_program_application_id
715: ,request_id = l_request_id
716: WHERE fact_name = 'RCI_ORG_CERT_CTRLS_F' ;
717:
718:
719: commit;
720: retcode := C_OK;

Line 758: l_last_run_date := get_last_run_date('RCI_ORG_CERT_CTRLS_F');

754: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
755:
756: l_stmnt_id := 10;
757: l_proc_name := 'run_incr_load_drm';
758: l_last_run_date := get_last_run_date('RCI_ORG_CERT_CTRLS_F');
759:
760: IF l_last_run_date IS NULL THEN
761: l_message := 'Please launch the Initial Load Request Set for the Organization Certification Summary page.';
762: RAISE INITIALIZATION_ERROR;

Line 770: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_CTRLS_F');

766: l_run_date := sysdate - 5/(24*60);
767: ---l_master_org := get_master_organization_id;
768:
769: l_stmnt_id := 30;
770: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_CTRLS_F');
771:
772: l_stmnt_id := 40;
773:
774: INSERT INTO RCI_ORG_CERT_CTRLS_F(

Line 774: INSERT INTO RCI_ORG_CERT_CTRLS_F(

770: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_CTRLS_F');
771:
772: l_stmnt_id := 40;
773:
774: INSERT INTO RCI_ORG_CERT_CTRLS_F(
775: fin_certification_id
776: ,certification_id
777: ,certification_status
778: ,certification_type

Line 910: WHERE fact_name = 'RCI_ORG_CERT_CTRLS_F' ;

906: ,program_id = l_program_id
907: ,program_login_id = l_program_login_id
908: ,program_application_id = l_program_application_id
909: ,request_id = l_request_id
910: WHERE fact_name = 'RCI_ORG_CERT_CTRLS_F' ;
911:
912:
913: commit;
914: retcode := C_OK;