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_F

Line 68: rci_sig_acct_eval_f accteval,fii_time_day ftd

64: ,orgs_with_ineff_ctrls
65: ,unmiti_risks
66: ,ineff_ctrls
67: from
68: rci_sig_acct_eval_f accteval,fii_time_day ftd
69: where
70: accteval.report_date_julian = ftd.report_date_julian
71: '|| where_clause || '
72: group by

Line 115: rci_sig_acct_eval_f accteval,fii_time_day ftd

111: ,orgs_with_ineff_ctrls
112: ,unmiti_risks
113: ,ineff_ctrls
114: from
115: rci_sig_acct_eval_f accteval,fii_time_day ftd
116: where
117: accteval.report_date_julian = ftd.report_date_julian
118: '|| where_clause || '
119: group by

Line 219: rci_sig_acct_eval_f accteval

215: ,/*o.audit_result*/rfaev.value RCI_PROC_CERT_MEASURE11
216: ,o.author RCI_PROC_CERT_MEASURE12
217: ,trunc(o.authored_date) RCI_PROC_CERT_MEASURE13
218: FROM
219: rci_sig_acct_eval_f accteval
220: ,fii_time_day ftd
221: ,amw_fin_cert_eval_sum afces
222: ,amw_opinions_v o
223: ,amw_certification_vl acv

Line 720: rci_sig_acct_eval_f accteval

716: ,rfaev.value RCI_PROC_CERT_MEASURE7
717: ,o.author RCI_PROC_CERT_MEASURE8
718: ,trunc(o.authored_date) RCI_PROC_CERT_MEASURE9
719: FROM
720: rci_sig_acct_eval_f accteval
721: ,fii_time_day ftd
722: ,amw_fin_cert_eval_sum afces
723: ,amw_fin_key_accounts_vl afka
724: ,(select distinct authored_date,pk1_value,pk2_value,author

Line 827: rci_sig_acct_eval_f accteval

823: ,orgs_with_ineff_ctrls
824: ,unmiti_risks
825: ,ineff_ctrls
826: from
827: rci_sig_acct_eval_f accteval
828: ,fii_time_day ftd
829: where
830: accteval.report_date_julian = ftd.report_date_julian
831: '|| where_clause || '

Line 879: rci_sig_acct_eval_f accteval

875: ,orgs_with_ineff_ctrls
876: ,unmiti_risks
877: ,ineff_ctrls
878: from
879: rci_sig_acct_eval_f accteval
880: ,fii_time_day ftd
881: where
882: accteval.report_date_julian = ftd.report_date_julian
883: '|| where_clause || '

Line 1030: rci_sig_acct_eval_f accteval

1026: ,acct_eval_ie
1027: ,acct_eval_e
1028: ,acct_eval_ne
1029: from
1030: rci_sig_acct_eval_f accteval
1031: ,fii_time_day ftd
1032: where
1033: accteval.report_date_julian = ftd.report_date_julian
1034: ' || where_clause || '

Line 1152: EXECUTE IMMEDIATE ('TRUNCATE TABLE amw.rci_sig_acct_eval_f');

1148: errbuf IN OUT NOCOPY VARCHAR2
1149: ,retcode IN OUT NOCOPY NUMBER)
1150: IS
1151: BEGIN
1152: EXECUTE IMMEDIATE ('TRUNCATE TABLE amw.rci_sig_acct_eval_f');
1153: sig_acct_initial_load(
1154: errbuf => errbuf
1155: ,retcode => retcode);
1156: EXECUTE IMMEDIATE ('COMMIT');

Line 1182: FROM rci_sig_acct_eval_f;

1178: AND object_name = 'AMW_ORG_PROCESS';
1179:
1180: CURSOR c_stmt_grp is
1181: SELECT DISTINCT STATEMENT_GROUP_ID, FINANCIAL_STATEMENT_ID, FINANCIAL_ITEM_ID
1182: FROM rci_sig_acct_eval_f;
1183:
1184: v_certification_result amw_opinion_values_b.opinion_value_code%type;
1185: v_cert_with_issues rci_sig_acct_eval_f.proc_cert_result_cwi%type := 0;
1186: v_certified rci_sig_acct_eval_f.proc_cert_result_c%type := 0;

Line 1185: v_cert_with_issues rci_sig_acct_eval_f.proc_cert_result_cwi%type := 0;

1181: SELECT DISTINCT STATEMENT_GROUP_ID, FINANCIAL_STATEMENT_ID, FINANCIAL_ITEM_ID
1182: FROM rci_sig_acct_eval_f;
1183:
1184: v_certification_result amw_opinion_values_b.opinion_value_code%type;
1185: v_cert_with_issues rci_sig_acct_eval_f.proc_cert_result_cwi%type := 0;
1186: v_certified rci_sig_acct_eval_f.proc_cert_result_c%type := 0;
1187: v_not_certified rci_sig_acct_eval_f.proc_cert_result_nc%type := 0;
1188:
1189: v_evaluation_result amw_opinion_values_b.opinion_value_code%type;

Line 1186: v_certified rci_sig_acct_eval_f.proc_cert_result_c%type := 0;

1182: FROM rci_sig_acct_eval_f;
1183:
1184: v_certification_result amw_opinion_values_b.opinion_value_code%type;
1185: v_cert_with_issues rci_sig_acct_eval_f.proc_cert_result_cwi%type := 0;
1186: v_certified rci_sig_acct_eval_f.proc_cert_result_c%type := 0;
1187: v_not_certified rci_sig_acct_eval_f.proc_cert_result_nc%type := 0;
1188:
1189: v_evaluation_result amw_opinion_values_b.opinion_value_code%type;
1190: v_ineffective rci_sig_acct_eval_f.acct_eval_ie%type := 0;

Line 1187: v_not_certified rci_sig_acct_eval_f.proc_cert_result_nc%type := 0;

1183:
1184: v_certification_result amw_opinion_values_b.opinion_value_code%type;
1185: v_cert_with_issues rci_sig_acct_eval_f.proc_cert_result_cwi%type := 0;
1186: v_certified rci_sig_acct_eval_f.proc_cert_result_c%type := 0;
1187: v_not_certified rci_sig_acct_eval_f.proc_cert_result_nc%type := 0;
1188:
1189: v_evaluation_result amw_opinion_values_b.opinion_value_code%type;
1190: v_ineffective rci_sig_acct_eval_f.acct_eval_ie%type := 0;
1191: v_effective rci_sig_acct_eval_f.acct_eval_e%type := 0;

Line 1190: v_ineffective rci_sig_acct_eval_f.acct_eval_ie%type := 0;

1186: v_certified rci_sig_acct_eval_f.proc_cert_result_c%type := 0;
1187: v_not_certified rci_sig_acct_eval_f.proc_cert_result_nc%type := 0;
1188:
1189: v_evaluation_result amw_opinion_values_b.opinion_value_code%type;
1190: v_ineffective rci_sig_acct_eval_f.acct_eval_ie%type := 0;
1191: v_effective rci_sig_acct_eval_f.acct_eval_e%type := 0;
1192: v_not_evaluated rci_sig_acct_eval_f.acct_eval_ne%type := 0;
1193:
1194: p_statement_group_id rci_sig_acct_eval_f.statement_group_id%type := 0;

Line 1191: v_effective rci_sig_acct_eval_f.acct_eval_e%type := 0;

1187: v_not_certified rci_sig_acct_eval_f.proc_cert_result_nc%type := 0;
1188:
1189: v_evaluation_result amw_opinion_values_b.opinion_value_code%type;
1190: v_ineffective rci_sig_acct_eval_f.acct_eval_ie%type := 0;
1191: v_effective rci_sig_acct_eval_f.acct_eval_e%type := 0;
1192: v_not_evaluated rci_sig_acct_eval_f.acct_eval_ne%type := 0;
1193:
1194: p_statement_group_id rci_sig_acct_eval_f.statement_group_id%type := 0;
1195: p_financial_statement_id rci_sig_acct_eval_f.financial_statement_id%type := 0;

Line 1192: v_not_evaluated rci_sig_acct_eval_f.acct_eval_ne%type := 0;

1188:
1189: v_evaluation_result amw_opinion_values_b.opinion_value_code%type;
1190: v_ineffective rci_sig_acct_eval_f.acct_eval_ie%type := 0;
1191: v_effective rci_sig_acct_eval_f.acct_eval_e%type := 0;
1192: v_not_evaluated rci_sig_acct_eval_f.acct_eval_ne%type := 0;
1193:
1194: p_statement_group_id rci_sig_acct_eval_f.statement_group_id%type := 0;
1195: p_financial_statement_id rci_sig_acct_eval_f.financial_statement_id%type := 0;
1196: p_financial_item_id rci_sig_acct_eval_f.financial_item_id%type := 0;

Line 1194: p_statement_group_id rci_sig_acct_eval_f.statement_group_id%type := 0;

1190: v_ineffective rci_sig_acct_eval_f.acct_eval_ie%type := 0;
1191: v_effective rci_sig_acct_eval_f.acct_eval_e%type := 0;
1192: v_not_evaluated rci_sig_acct_eval_f.acct_eval_ne%type := 0;
1193:
1194: p_statement_group_id rci_sig_acct_eval_f.statement_group_id%type := 0;
1195: p_financial_statement_id rci_sig_acct_eval_f.financial_statement_id%type := 0;
1196: p_financial_item_id rci_sig_acct_eval_f.financial_item_id%type := 0;
1197:
1198: v_orgs_with_ineff_ctrls rci_sig_acct_eval_f.orgs_with_ineff_ctrls%type := 0;

Line 1195: p_financial_statement_id rci_sig_acct_eval_f.financial_statement_id%type := 0;

1191: v_effective rci_sig_acct_eval_f.acct_eval_e%type := 0;
1192: v_not_evaluated rci_sig_acct_eval_f.acct_eval_ne%type := 0;
1193:
1194: p_statement_group_id rci_sig_acct_eval_f.statement_group_id%type := 0;
1195: p_financial_statement_id rci_sig_acct_eval_f.financial_statement_id%type := 0;
1196: p_financial_item_id rci_sig_acct_eval_f.financial_item_id%type := 0;
1197:
1198: v_orgs_with_ineff_ctrls rci_sig_acct_eval_f.orgs_with_ineff_ctrls%type := 0;
1199: v_unmiti_risks rci_sig_acct_eval_f.unmiti_risks%type := 0;

Line 1196: p_financial_item_id rci_sig_acct_eval_f.financial_item_id%type := 0;

1192: v_not_evaluated rci_sig_acct_eval_f.acct_eval_ne%type := 0;
1193:
1194: p_statement_group_id rci_sig_acct_eval_f.statement_group_id%type := 0;
1195: p_financial_statement_id rci_sig_acct_eval_f.financial_statement_id%type := 0;
1196: p_financial_item_id rci_sig_acct_eval_f.financial_item_id%type := 0;
1197:
1198: v_orgs_with_ineff_ctrls rci_sig_acct_eval_f.orgs_with_ineff_ctrls%type := 0;
1199: v_unmiti_risks rci_sig_acct_eval_f.unmiti_risks%type := 0;
1200: v_ineff_ctrls rci_sig_acct_eval_f.ineff_ctrls%type := 0;

Line 1198: v_orgs_with_ineff_ctrls rci_sig_acct_eval_f.orgs_with_ineff_ctrls%type := 0;

1194: p_statement_group_id rci_sig_acct_eval_f.statement_group_id%type := 0;
1195: p_financial_statement_id rci_sig_acct_eval_f.financial_statement_id%type := 0;
1196: p_financial_item_id rci_sig_acct_eval_f.financial_item_id%type := 0;
1197:
1198: v_orgs_with_ineff_ctrls rci_sig_acct_eval_f.orgs_with_ineff_ctrls%type := 0;
1199: v_unmiti_risks rci_sig_acct_eval_f.unmiti_risks%type := 0;
1200: v_ineff_ctrls rci_sig_acct_eval_f.ineff_ctrls%type := 0;
1201: */
1202: l_user_id NUMBER ;

Line 1199: v_unmiti_risks rci_sig_acct_eval_f.unmiti_risks%type := 0;

1195: p_financial_statement_id rci_sig_acct_eval_f.financial_statement_id%type := 0;
1196: p_financial_item_id rci_sig_acct_eval_f.financial_item_id%type := 0;
1197:
1198: v_orgs_with_ineff_ctrls rci_sig_acct_eval_f.orgs_with_ineff_ctrls%type := 0;
1199: v_unmiti_risks rci_sig_acct_eval_f.unmiti_risks%type := 0;
1200: v_ineff_ctrls rci_sig_acct_eval_f.ineff_ctrls%type := 0;
1201: */
1202: l_user_id NUMBER ;
1203: l_login_id NUMBER ;

Line 1200: v_ineff_ctrls rci_sig_acct_eval_f.ineff_ctrls%type := 0;

1196: p_financial_item_id rci_sig_acct_eval_f.financial_item_id%type := 0;
1197:
1198: v_orgs_with_ineff_ctrls rci_sig_acct_eval_f.orgs_with_ineff_ctrls%type := 0;
1199: v_unmiti_risks rci_sig_acct_eval_f.unmiti_risks%type := 0;
1200: v_ineff_ctrls rci_sig_acct_eval_f.ineff_ctrls%type := 0;
1201: */
1202: l_user_id NUMBER ;
1203: l_login_id NUMBER ;
1204: l_program_id NUMBER ;

Line 1211: EXECUTE IMMEDIATE ('TRUNCATE TABLE amw.rci_sig_acct_eval_f');

1207: l_request_id NUMBER ;
1208: l_run_date DATE;
1209: --upd_flag BOOLEAN;
1210: BEGIN
1211: EXECUTE IMMEDIATE ('TRUNCATE TABLE amw.rci_sig_acct_eval_f');
1212:
1213: INSERT INTO RCI_SIG_ACCT_EVAL_F(
1214: STATEMENT_GROUP_ID
1215: ,FINANCIAL_STATEMENT_ID

Line 1213: INSERT INTO RCI_SIG_ACCT_EVAL_F(

1209: --upd_flag BOOLEAN;
1210: BEGIN
1211: EXECUTE IMMEDIATE ('TRUNCATE TABLE amw.rci_sig_acct_eval_f');
1212:
1213: INSERT INTO RCI_SIG_ACCT_EVAL_F(
1214: STATEMENT_GROUP_ID
1215: ,FINANCIAL_STATEMENT_ID
1216: ,FINANCIAL_ITEM_ID
1217: ,ACCOUNT_GROUP_ID

Line 1313: UPDATE rci_sig_acct_eval_f

1309: upd_flag := true;
1310: v_ineffective := 1;
1311: END IF;
1312: IF upd_flag THEN
1313: UPDATE rci_sig_acct_eval_f
1314: SET
1315: ACCT_EVAL_RESULT_CODE = v_evaluation_result,
1316: ACCT_EVAL_IE = v_ineffective,
1317: ACCT_EVAL_E = v_effective,

Line 1342: UPDATE rci_sig_acct_eval_f

1338: v_certified := 1;
1339: END IF;
1340:
1341: IF upd_flag THEN
1342: UPDATE rci_sig_acct_eval_f
1343: SET
1344: PROC_CERT_RESULT_CWI = v_cert_with_issues,
1345: PROC_CERT_RESULT_C = v_certified,
1346: PROC_CERT_RESULT_NC = v_not_certified,

Line 1369: UPDATE rci_sig_acct_eval_f

1365: p_financial_statement_id, p_financial_item_id , v_unmiti_risks );
1366: CountIneffectiveCtrls_finitem(p_statement_group_id ,
1367: p_financial_statement_id, p_financial_item_id , v_ineff_ctrls );
1368:
1369: UPDATE rci_sig_acct_eval_f
1370: SET
1371: ORGS_WITH_INEFF_CTRLS = v_orgs_with_ineff_ctrls,
1372: UNMITI_RISKS = v_unmiti_risks,
1373: INEFF_CTRLS = v_ineff_ctrls,

Line 1391: DELETE FROM rci_dr_inc WHERE fact_name='RCI_SIG_ACCT_EVAL_F';

1387: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1388: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1389: l_run_date := sysdate - 5/(24*60);
1390:
1391: DELETE FROM rci_dr_inc WHERE fact_name='RCI_SIG_ACCT_EVAL_F';
1392:
1393: INSERT INTO rci_dr_inc( fact_name
1394: ,last_run_date
1395: ,created_by

Line 1404: 'RCI_SIG_ACCT_EVAL_F'

1400: ,program_id
1401: ,program_login_id
1402: ,program_application_id
1403: ,request_id ) VALUES (
1404: 'RCI_SIG_ACCT_EVAL_F'
1405: ,l_run_date
1406: ,l_user_id
1407: ,sysdate
1408: ,sysdate