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_COMPL_ENV_CHG_SUMM_PKG dependencies on RCI_COMPL_ENV_CHG_SUMM_F

Line 115: select * from rci_compl_env_chg_summ_f;

111: ,retcode IN OUT NOCOPY NUMBER) is
112:
113: /*02.02.2006 npanandi: changed below cursor for performance reasons
114: cursor cur_f is
115: select * from rci_compl_env_chg_summ_f;
116: */
117: cursor cur_f is
118: select distinct fin_certification_id,organization_id,process_id
119: from rci_compl_env_chg_summ_f

Line 119: from rci_compl_env_chg_summ_f

115: select * from rci_compl_env_chg_summ_f;
116: */
117: cursor cur_f is
118: select distinct fin_certification_id,organization_id,process_id
119: from rci_compl_env_chg_summ_f
120: where organization_id is not null
121: and process_id is not null;
122:
123: cur_rec cur_f%rowtype;

Line 161: DELETE FROM rci_dr_inc where fact_name = 'RCI_COMPL_ENV_CHG_SUMM_F';

157: x_global_start_date => g_global_start_date
158: ,x_rci_schema => g_rci_schema);
159:
160: l_stmnt_id := 10;
161: DELETE FROM rci_dr_inc where fact_name = 'RCI_COMPL_ENV_CHG_SUMM_F';
162:
163:
164: -- change the following line to have schema.tablename
165: l_stmnt_id := 20;

Line 166: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_COMPL_ENV_CHG_SUMM_F');

162:
163:
164: -- change the following line to have schema.tablename
165: l_stmnt_id := 20;
166: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_COMPL_ENV_CHG_SUMM_F');
167:
168: l_stmnt_id := 25;
169: l_run_date := sysdate - 5/(24*60);
170:

Line 173: insert into rci_compl_env_chg_summ_f(

169: l_run_date := sysdate - 5/(24*60);
170:
171:
172: l_stmnt_id := 30;
173: insert into rci_compl_env_chg_summ_f(
174: fin_certification_id,
175: cert_status,
176: cert_type,
177: cert_period_name,

Line 286: update rci_compl_env_chg_summ_f

282: AND ACA.CONTROL_ID = ACAV.CONTROL_ID
283: AND ACAV.CURR_APPROVED_FLAG = 'Y'
284: AND NVL(ACAV.KEY_MITIGATING,'N') = 'Y';
285:
286: update rci_compl_env_chg_summ_f
287: set LATEST_APPR_REVISION_NUMBER = l_curr_rev_num,
288: /**01.25.2006 npanandi: changed below math, since it results in
289: negative values at times***/
290: /***NEW_REVISIONS_SINCE = latest_appr_revision_number - revision_number,***/

Line 324: 'RCI_COMPL_ENV_CHG_SUMM_F'

320: ,program_id
321: ,program_login_id
322: ,program_application_id
323: ,request_id ) VALUES (
324: 'RCI_COMPL_ENV_CHG_SUMM_F'
325: ,l_run_date
326: ,l_user_id
327: ,sysdate
328: ,sysdate

Line 351: select * from rci_compl_env_chg_summ_f;

347: ,retcode IN OUT NOCOPY NUMBER)
348: is
349: /*02.02.2006 npanandi: changed below cursor for performance reasons
350: cursor cur_f is
351: select * from rci_compl_env_chg_summ_f;
352: */
353: cursor cur_f is
354: select distinct fin_certification_id,organization_id,process_id
355: from rci_compl_env_chg_summ_f

Line 355: from rci_compl_env_chg_summ_f

351: select * from rci_compl_env_chg_summ_f;
352: */
353: cursor cur_f is
354: select distinct fin_certification_id,organization_id,process_id
355: from rci_compl_env_chg_summ_f
356: where organization_id is not null
357: and process_id is not null;
358:
359: cur_rec cur_f%rowtype;

Line 397: l_last_run_date := get_last_run_date('RCI_COMPL_ENV_CHG_SUMM_F');

393: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
394:
395: l_stmnt_id := 10;
396: l_proc_name := 'run_incr_load_drm';
397: l_last_run_date := get_last_run_date('RCI_COMPL_ENV_CHG_SUMM_F');
398:
399: IF l_last_run_date IS NULL THEN
400: l_message := 'Please launch the Initial Load Request Set for the Compliance Environment Change Summary page.';
401: RAISE INITIALIZATION_ERROR;

Line 412: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_COMPL_ENV_CHG_SUMM_F');

408: /** 01.16.06 npanandi: added below procedure cal as RSG errors otherwise **/
409: check_initial_load_setup(
410: x_global_start_date => g_global_start_date
411: ,x_rci_schema => g_rci_schema);
412: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_COMPL_ENV_CHG_SUMM_F');
413:
414:
415: /*** initial load query comes here ***/
416: l_stmnt_id := 30;

Line 417: insert into rci_compl_env_chg_summ_f(

413:
414:
415: /*** initial load query comes here ***/
416: l_stmnt_id := 30;
417: insert into rci_compl_env_chg_summ_f(
418: fin_certification_id,
419: cert_status,
420: cert_type,
421: cert_period_name,

Line 530: update rci_compl_env_chg_summ_f

526: AND ACA.CONTROL_ID = ACAV.CONTROL_ID
527: AND ACAV.CURR_APPROVED_FLAG = 'Y'
528: AND NVL(ACAV.KEY_MITIGATING,'N') = 'Y';
529:
530: update rci_compl_env_chg_summ_f
531: set LATEST_APPR_REVISION_NUMBER = l_curr_rev_num,
532: /**01.25.2006 npanandi: changed below math, since it results in
533: negative values at times***/
534: /***NEW_REVISIONS_SINCE = latest_appr_revision_number - revision_number,***/

Line 567: WHERE fact_name = 'RCI_COMPL_ENV_CHG_SUMM_F' ;

563: ,program_id = l_program_id
564: ,program_login_id = l_program_login_id
565: ,program_application_id = l_program_application_id
566: ,request_id = l_request_id
567: WHERE fact_name = 'RCI_COMPL_ENV_CHG_SUMM_F' ;
568:
569: commit;
570: retcode := C_OK;
571: EXCEPTION

Line 712: from rci_compl_env_chg_summ_f f, fii_time_day ftd

708: decode(sum(Total_Risks), 0, null, sum(Num_Changed_Risks)/sum(Total_Risks)*100) RCI_COMP_ENV_MEASURE6,
709: sum(Total_Controls) RCI_COMP_ENV_ATT2,
710: sum(Num_Changed_Controls) RCI_COMP_ENV_MEASURE7,
711: decode(sum(Total_Controls), 0, null, sum(Num_Changed_Controls)/sum(Total_Controls)*100) RCI_COMP_ENV_MEASURE8
712: from rci_compl_env_chg_summ_f f, fii_time_day ftd
713: where f.organization_id is not null
714: and f.report_date_julian = ftd.report_date_julian';
715:
716: l_query2 := ' group by f.organization_id ';

Line 737: from rci_compl_env_chg_summ_f f, fii_time_day ftd

733: decode(sum(Total_Risks), 0, null, sum(Num_Changed_Risks)/sum(Total_Risks)*100) RCI_COMP_ENV_MEASURE6,
734: sum(Total_Controls) RCI_COMP_ENV_ATT2,
735: sum(Num_Changed_Controls) RCI_COMP_ENV_MEASURE7,
736: decode(sum(Total_Controls), 0, null, sum(Num_Changed_Controls)/sum(Total_Controls)*100) RCI_COMP_ENV_MEASURE8
737: from rci_compl_env_chg_summ_f f, fii_time_day ftd
738: where f.process_id is not null
739: and f.report_date_julian = ftd.report_date_julian';
740:
741: l_query2 := ' group by f.process_id ';

Line 762: from rci_compl_env_chg_summ_f f, fii_time_day ftd

758: decode(sum(Total_Risks), 0, null, sum(Num_Changed_Risks)/sum(Total_Risks)*100) RCI_COMP_ENV_MEASURE6,
759: sum(Total_Controls) RCI_COMP_ENV_ATT2,
760: sum(Num_Changed_Controls) RCI_COMP_ENV_MEASURE7,
761: decode(sum(Total_Controls), 0, null, sum(Num_Changed_Controls)/sum(Total_Controls)*100) RCI_COMP_ENV_MEASURE8
762: from rci_compl_env_chg_summ_f f, fii_time_day ftd
763: where f.fin_certification_id is not null
764: and f.report_date_julian = ftd.report_date_julian';
765:
766: l_query2 := ' group by f.fin_certification_id';

Line 790: from rci_compl_env_chg_summ_f f, fii_time_day ftd, RCI_SIGNIFICANT_ACCT_V rsav

786: decode(sum(Total_Risks), 0, null, sum(Num_Changed_Risks)/sum(Total_Risks)*100) RCI_COMP_ENV_MEASURE6,
787: sum(Total_Controls) RCI_COMP_ENV_ATT2,
788: sum(Num_Changed_Controls) RCI_COMP_ENV_MEASURE7,
789: decode(sum(Total_Controls), 0, null, sum(Num_Changed_Controls)/sum(Total_Controls)*100) RCI_COMP_ENV_MEASURE8
790: from rci_compl_env_chg_summ_f f, fii_time_day ftd, RCI_SIGNIFICANT_ACCT_V rsav
791: where f.account_group_id is not null
792: and f.natural_account_id is not null
793: and f.natural_account_id = rsav.id
794: and f.report_date_julian = ftd.report_date_julian';