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.AMW_FINSTMT_CERT_PVT dependencies on FND_GLOBAL

Line 102: g_user_id := fnd_global.user_id;

98: end loop;
99:
100: -- /* Update the summary table with the certified subprocess info*/
101:
102: g_user_id := fnd_global.user_id;
103: Update AMW_PROC_CERT_EVAL_SUM
104: SET SUB_PROCESS_CERT = l_sum_certified,TOTAL_SUB_PROCESS_CERT = l_subprocess_total, LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = G_USER_ID
105: where PROCESS_ID = p_process_id and CERTIFICATION_ID = p_certification_id and ORGANIZATION_ID = p_org_id;
106:

Line 134: g_user_id := fnd_global.user_id;

130:
131:
132:
133: BEGIN
134: g_user_id := fnd_global.user_id;
135:
136: Update AMW_PROC_CERT_EVAL_SUM
137: SET (CERTIFICATION_OPINION_ID) =
138: (select opinion.OPINION_ID

Line 189: g_user_id := fnd_global.user_id;

185: BEGIN
186:
187: -- Set Global Process flag for each row of the global process, also update the total no. of orgs in which
188: -- the process is executed in
189: g_user_id := fnd_global.user_id;
190: Update AMW_PROC_CERT_EVAL_SUM
191: SET TOTAL_ORG_PROCESS_CERT =
192: (Select distinct count(*) from AMW_PROCESS_ORGANIZATION processorg where
193: (processorg.PROCESS_ID = p_process_id) and

Line 250: g_user_id := fnd_global.user_id;

246:
247:
248:
249: BEGIN
250: g_user_id := fnd_global.user_id;
251:
252: Update AMW_PROC_CERT_EVAL_SUM
253: SET (EVALUATION_OPINION_ID) =
254: (

Line 295: g_user_id := fnd_global.user_id;

291:
292:
293:
294: BEGIN
295: g_user_id := fnd_global.user_id;
296:
297: Update AMW_PROC_CERT_EVAL_SUM
298: SET UNMITIGATED_RISKS =
299: (

Line 373: g_user_id := fnd_global.user_id;

369:
370:
371:
372: BEGIN
373: g_user_id := fnd_global.user_id;
374:
375: Update AMW_PROC_CERT_EVAL_SUM
376: SET INEFFECTIVE_CONTROLS =
377: (select distinct Count(*)

Line 474: g_user_id := fnd_global.user_id;

470:
471: BEGIN
472: -- Insert all this info into the summary table with one row per process, org.
473: l_global_org_id := fnd_profile.value('AMW_GLOBAL_ORG_ID');
474: g_user_id := fnd_global.user_id;
475: g_login_id := fnd_global.conc_login_id;
476:
477: for proc_rec in proc loop
478:

Line 475: g_login_id := fnd_global.conc_login_id;

471: BEGIN
472: -- Insert all this info into the summary table with one row per process, org.
473: l_global_org_id := fnd_profile.value('AMW_GLOBAL_ORG_ID');
474: g_user_id := fnd_global.user_id;
475: g_login_id := fnd_global.conc_login_id;
476:
477: for proc_rec in proc loop
478:
479: select count(*) into l_count from amw_proc_cert_eval_sum

Line 1428: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1424: ORGS_IN_SCOPE = l_orgs_in_scope,
1425: ORGS_PENDING_IN_SCOPE = l_orgs_pending_in_scope,
1426: PERIOD_START_DATE = p_start_date,
1427: LAST_UPDATE_DATE = sysdate,
1428: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1429: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
1430: WHERE certification_id = p_certification_id;
1431:
1432: IF (SQL%NOTFOUND) THEN

Line 1429: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

1425: ORGS_PENDING_IN_SCOPE = l_orgs_pending_in_scope,
1426: PERIOD_START_DATE = p_start_date,
1427: LAST_UPDATE_DATE = sysdate,
1428: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1429: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
1430: WHERE certification_id = p_certification_id;
1431:
1432: IF (SQL%NOTFOUND) THEN
1433: INSERT INTO AMW_CERT_DASHBOARD_SUM (

Line 1467: FND_GLOBAL.USER_ID,

1463: l_ineffective_controls,
1464: l_orgs_in_scope,
1465: l_orgs_pending_in_scope,
1466: p_start_date,
1467: FND_GLOBAL.USER_ID,
1468: SYSDATE,
1469: SYSDATE,
1470: FND_GLOBAL.USER_ID,
1471: FND_GLOBAL.USER_ID

Line 1470: FND_GLOBAL.USER_ID,

1466: p_start_date,
1467: FND_GLOBAL.USER_ID,
1468: SYSDATE,
1469: SYSDATE,
1470: FND_GLOBAL.USER_ID,
1471: FND_GLOBAL.USER_ID
1472: FROM DUAL;
1473: END IF;
1474:

Line 1471: FND_GLOBAL.USER_ID

1467: FND_GLOBAL.USER_ID,
1468: SYSDATE,
1469: SYSDATE,
1470: FND_GLOBAL.USER_ID,
1471: FND_GLOBAL.USER_ID
1472: FROM DUAL;
1473: END IF;
1474:
1475: commit;

Line 1801: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1797: TOTAL_NUMBER_OF_ORG_PROCS = l_total_org_processes,
1798: ORG_PROCS_CERTIFIED_PRCNT = round((l_org_processes_certified/decode(nvl(l_total_org_processes,0),0,1,l_total_org_processes) *100),0),
1799: OPEN_FINDINGS = l_open_findings,
1800: LAST_UPDATE_DATE = sysdate,
1801: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1802: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
1803: WHERE fin_certification_id = p_certification_id
1804: AND organization_id = p_organization_id
1805: AND process_id = p_process_id;

Line 1802: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

1798: ORG_PROCS_CERTIFIED_PRCNT = round((l_org_processes_certified/decode(nvl(l_total_org_processes,0),0,1,l_total_org_processes) *100),0),
1799: OPEN_FINDINGS = l_open_findings,
1800: LAST_UPDATE_DATE = sysdate,
1801: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1802: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
1803: WHERE fin_certification_id = p_certification_id
1804: AND organization_id = p_organization_id
1805: AND process_id = p_process_id;
1806:

Line 1848: FND_GLOBAL.USER_ID,

1844: l_org_processes_certified,
1845: round((l_org_processes_certified/decode(nvl(l_total_org_processes,0),0,1,l_total_org_processes) *100),0),
1846: l_open_findings,
1847: p_account_process_flag,
1848: FND_GLOBAL.USER_ID,
1849: SYSDATE,
1850: SYSDATE,
1851: FND_GLOBAL.USER_ID,
1852: FND_GLOBAL.USER_ID

Line 1851: FND_GLOBAL.USER_ID,

1847: p_account_process_flag,
1848: FND_GLOBAL.USER_ID,
1849: SYSDATE,
1850: SYSDATE,
1851: FND_GLOBAL.USER_ID,
1852: FND_GLOBAL.USER_ID
1853: FROM DUAL;
1854: END IF;
1855:

Line 1852: FND_GLOBAL.USER_ID

1848: FND_GLOBAL.USER_ID,
1849: SYSDATE,
1850: SYSDATE,
1851: FND_GLOBAL.USER_ID,
1852: FND_GLOBAL.USER_ID
1853: FROM DUAL;
1854: END IF;
1855:
1856:

Line 2918: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2914: UNMITIGATED_RISKS_PRCNT = round(l_unmitigated_risks/decode(l_risks,0,1,l_risks), 2)*100,
2915: INEFFECTIVE_CONTROLS_PRCNT = round(l_ineff_controls/decode(l_controls,0,1,l_controls), 2)*100,
2916: OPEN_FINDINGS = l_open_findings,
2917: LAST_UPDATE_DATE = sysdate,
2918: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2919: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,
2920: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
2921: SUBSIDIARY_VS = l_sub_vs,
2922: SUBSIDIARY_CODE = l_sub_code,

Line 2919: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,

2915: INEFFECTIVE_CONTROLS_PRCNT = round(l_ineff_controls/decode(l_controls,0,1,l_controls), 2)*100,
2916: OPEN_FINDINGS = l_open_findings,
2917: LAST_UPDATE_DATE = sysdate,
2918: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2919: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,
2920: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
2921: SUBSIDIARY_VS = l_sub_vs,
2922: SUBSIDIARY_CODE = l_sub_code,
2923: LOB_VS = l_lob_vs,

Line 2978: FND_GLOBAL.USER_ID,

2974: round(l_proc_with_ineff_ctrl/decode(l_total_num_of_procs, 0,1,l_total_num_of_procs),2)*100,
2975: round(l_unmitigated_risks/decode(l_risks,0,1,l_risks), 2)*100,
2976: round(l_ineff_controls/decode(l_controls,0,1,l_controls), 2)*100,
2977: l_open_findings,
2978: FND_GLOBAL.USER_ID,
2979: SYSDATE,
2980: FND_GLOBAL.USER_ID,
2981: SYSDATE,
2982: FND_GLOBAL.USER_ID,

Line 2980: FND_GLOBAL.USER_ID,

2976: round(l_ineff_controls/decode(l_controls,0,1,l_controls), 2)*100,
2977: l_open_findings,
2978: FND_GLOBAL.USER_ID,
2979: SYSDATE,
2980: FND_GLOBAL.USER_ID,
2981: SYSDATE,
2982: FND_GLOBAL.USER_ID,
2983: 1,
2984: l_sub_vs,

Line 2982: FND_GLOBAL.USER_ID,

2978: FND_GLOBAL.USER_ID,
2979: SYSDATE,
2980: FND_GLOBAL.USER_ID,
2981: SYSDATE,
2982: FND_GLOBAL.USER_ID,
2983: 1,
2984: l_sub_vs,
2985: l_sub_code,
2986: l_lob_vs,

Line 3673: g_user_id := fnd_global.user_id;

3669: M_STATEMENT_GROUP_ID := statement_items.STATEMENT_GROUP_ID;
3670: M_FINANCIAL_STATEMENT_ID := statement_items.FINANCIAL_STATEMENT_ID;
3671: M_FINANCIAL_ITEM_ID := statement_items.FINANCIAL_ITEM_ID;
3672:
3673: g_user_id := fnd_global.user_id;
3674: g_login_id := fnd_global.conc_login_id;
3675:
3676: AMW_FINSTMT_CERT_PVT.compute_values_for_eval_sum
3677: (P_CERTIFICATION_ID => M_CERTIFICATION_ID,

Line 3674: g_login_id := fnd_global.conc_login_id;

3670: M_FINANCIAL_STATEMENT_ID := statement_items.FINANCIAL_STATEMENT_ID;
3671: M_FINANCIAL_ITEM_ID := statement_items.FINANCIAL_ITEM_ID;
3672:
3673: g_user_id := fnd_global.user_id;
3674: g_login_id := fnd_global.conc_login_id;
3675:
3676: AMW_FINSTMT_CERT_PVT.compute_values_for_eval_sum
3677: (P_CERTIFICATION_ID => M_CERTIFICATION_ID,
3678: P_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,