DBA Data[Home] [Help]

APPS.AMW_FINSTMT_CERT_BES_PKG dependencies on FND_GLOBAL

Line 4: --G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

1: PACKAGE BODY AMW_FINSTMT_CERT_BES_PKG AS
2: /* $Header: amwfbusb.pls 120.28 2007/12/10 06:41:35 srbalasu noship $ */
3:
4: --G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5: --G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6:
7: G_PKG_NAME CONSTANT VARCHAR2 (30) := 'AMW_FINSTMT_CERT_BES_PKG';
8: G_API_NAME CONSTANT VARCHAR2 (15) := 'amwfbusb.pls';

Line 5: --G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

1: PACKAGE BODY AMW_FINSTMT_CERT_BES_PKG AS
2: /* $Header: amwfbusb.pls 120.28 2007/12/10 06:41:35 srbalasu noship $ */
3:
4: --G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5: --G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6:
7: G_PKG_NAME CONSTANT VARCHAR2 (30) := 'AMW_FINSTMT_CERT_BES_PKG';
8: G_API_NAME CONSTANT VARCHAR2 (15) := 'amwfbusb.pls';
9:

Line 2720: fnd_global.apps_initialize (l_user_id, l_resp_id, l_resp_appl_id, l_security_group_id);

2716: l_resp_id := p_event.GetValueForParameter('RESP_ID');
2717: l_resp_appl_id := p_event.GetValueForParameter('RESP_APPL_ID');
2718: l_security_group_id := p_event.GetValueForParameter('SECURITY_GROUP_ID');
2719:
2720: fnd_global.apps_initialize (l_user_id, l_resp_id, l_resp_appl_id, l_security_group_id);
2721:
2722: --l_org_id := p_event.GetValueForParameter('ORG_ID');
2723: l_fin_cert_id := p_event.GetValueForParameter('FIN_CERTIFICATION_ID');
2724:

Line 2780: fnd_global.apps_initialize (l_user_id, l_resp_id, l_resp_appl_id, l_security_group_id);

2776: l_resp_id := p_event.GetValueForParameter('RESP_ID');
2777: l_resp_appl_id := p_event.GetValueForParameter('RESP_APPL_ID');
2778: l_security_group_id := p_event.GetValueForParameter('SECURITY_GROUP_ID');
2779:
2780: fnd_global.apps_initialize (l_user_id, l_resp_id, l_resp_appl_id, l_security_group_id);
2781: */
2782:
2783:
2784:

Line 2841: fnd_global.apps_initialize (l_user_id, l_resp_id, l_resp_appl_id, l_security_group_id);

2837: l_resp_id := p_event.GetValueForParameter('RESP_ID');
2838: l_resp_appl_id := p_event.GetValueForParameter('RESP_APPL_ID');
2839: l_security_group_id := p_event.GetValueForParameter('SECURITY_GROUP_ID');
2840:
2841: fnd_global.apps_initialize (l_user_id, l_resp_id, l_resp_appl_id, l_security_group_id);
2842: */
2843:
2844:
2845: l_opinion_log_id := p_event.GetValueForParameter('OPINION_LOG_ID');

Line 2948: last_updated_by = fnd_global.user_id,

2944:
2945: UPDATE AMW_FIN_ORG_EVAL_SUM
2946: SET
2947: LAST_UPDATE_DATE = sysdate,
2948: last_updated_by = fnd_global.user_id,
2949: last_update_login = fnd_global.conc_login_id,
2950: CERT_OPINION_LOG_ID = l_opinion_log_id,
2951: CERT_OPINION_ID = l_opinion_id
2952: WHERE ORGANIZATION_ID = l_pk1

Line 2949: last_update_login = fnd_global.conc_login_id,

2945: UPDATE AMW_FIN_ORG_EVAL_SUM
2946: SET
2947: LAST_UPDATE_DATE = sysdate,
2948: last_updated_by = fnd_global.user_id,
2949: last_update_login = fnd_global.conc_login_id,
2950: CERT_OPINION_LOG_ID = l_opinion_log_id,
2951: CERT_OPINION_ID = l_opinion_id
2952: WHERE ORGANIZATION_ID = l_pk1
2953: AND FIN_CERTIFICATION_ID IN (SELECT CERTIFICATION_ID FROM AMW_CERTIFICATION_B

Line 2974: last_updated_by = fnd_global.user_id,

2970: x_msg_data => l_msg_data);
2971:
2972: UPDATE AMW_FIN_PROCESS_EVAL_SUM SET
2973: LAST_UPDATE_DATE = sysdate,
2974: last_updated_by = fnd_global.user_id,
2975: last_update_login = fnd_global.conc_login_id,
2976: CERT_OPINION_LOG_ID = l_opinion_log_id,
2977: CERT_OPINION_ID = l_opinion_id
2978: WHERE ORGANIZATION_ID = l_pk3

Line 2975: last_update_login = fnd_global.conc_login_id,

2971:
2972: UPDATE AMW_FIN_PROCESS_EVAL_SUM SET
2973: LAST_UPDATE_DATE = sysdate,
2974: last_updated_by = fnd_global.user_id,
2975: last_update_login = fnd_global.conc_login_id,
2976: CERT_OPINION_LOG_ID = l_opinion_log_id,
2977: CERT_OPINION_ID = l_opinion_id
2978: WHERE ORGANIZATION_ID = l_pk3
2979: AND PROCESS_ID = l_pk1

Line 3099: last_updated_by = fnd_global.user_id,

3095:
3096: UPDATE AMW_FIN_ORG_EVAL_SUM
3097: SET
3098: LAST_UPDATE_DATE = sysdate,
3099: last_updated_by = fnd_global.user_id,
3100: last_update_login = fnd_global.conc_login_id,
3101: EVAL_OPINION_LOG_ID = l_opinion_log_id,
3102: EVAL_OPINION_ID = l_opinion_id
3103: WHERE ORGANIZATION_ID = l_pk1

Line 3100: last_update_login = fnd_global.conc_login_id,

3096: UPDATE AMW_FIN_ORG_EVAL_SUM
3097: SET
3098: LAST_UPDATE_DATE = sysdate,
3099: last_updated_by = fnd_global.user_id,
3100: last_update_login = fnd_global.conc_login_id,
3101: EVAL_OPINION_LOG_ID = l_opinion_log_id,
3102: EVAL_OPINION_ID = l_opinion_id
3103: WHERE ORGANIZATION_ID = l_pk1
3104: AND FIN_CERTIFICATION_ID IN (SELECT CERTIFICATION_ID FROM AMW_CERTIFICATION_B

Line 3125: last_updated_by = fnd_global.user_id,

3121: x_msg_data => l_msg_data);
3122:
3123: UPDATE AMW_FIN_PROCESS_EVAL_SUM SET
3124: LAST_UPDATE_DATE = sysdate,
3125: last_updated_by = fnd_global.user_id,
3126: last_update_login = fnd_global.conc_login_id,
3127: EVAL_OPINION_LOG_ID = l_opinion_log_id,
3128: EVAL_OPINION_ID = l_opinion_id
3129: WHERE ORGANIZATION_ID = l_pk3

Line 3126: last_update_login = fnd_global.conc_login_id,

3122:
3123: UPDATE AMW_FIN_PROCESS_EVAL_SUM SET
3124: LAST_UPDATE_DATE = sysdate,
3125: last_updated_by = fnd_global.user_id,
3126: last_update_login = fnd_global.conc_login_id,
3127: EVAL_OPINION_LOG_ID = l_opinion_log_id,
3128: EVAL_OPINION_ID = l_opinion_id
3129: WHERE ORGANIZATION_ID = l_pk3
3130: AND PROCESS_ID = l_pk1

Line 3153: last_updated_by = fnd_global.user_id,

3149: x_msg_data => l_msg_data);
3150:
3151: UPDATE AMW_RISK_ASSOCIATIONS SET
3152: LAST_UPDATE_DATE = sysdate,
3153: last_updated_by = fnd_global.user_id,
3154: last_update_login = fnd_global.conc_login_id,
3155: pk4 = l_opinion_log_id
3156: WHERE OBJECT_TYPE = 'PROCESS_FINCERT'
3157: AND risk_id = l_pk1

Line 3154: last_update_login = fnd_global.conc_login_id,

3150:
3151: UPDATE AMW_RISK_ASSOCIATIONS SET
3152: LAST_UPDATE_DATE = sysdate,
3153: last_updated_by = fnd_global.user_id,
3154: last_update_login = fnd_global.conc_login_id,
3155: pk4 = l_opinion_log_id
3156: WHERE OBJECT_TYPE = 'PROCESS_FINCERT'
3157: AND risk_id = l_pk1
3158: AND pk2= l_pk3

Line 3180: last_updated_by = fnd_global.user_id,

3176: x_msg_data => l_msg_data);
3177:
3178: UPDATE AMW_CONTROL_ASSOCIATIONS SET
3179: LAST_UPDATE_DATE = sysdate,
3180: last_updated_by = fnd_global.user_id,
3181: last_update_login = fnd_global.conc_login_id,
3182: pk5 = l_opinion_log_id
3183: WHERE OBJECT_TYPE = 'RISK_FINCERT'
3184: AND control_id = l_pk1

Line 3181: last_update_login = fnd_global.conc_login_id,

3177:
3178: UPDATE AMW_CONTROL_ASSOCIATIONS SET
3179: LAST_UPDATE_DATE = sysdate,
3180: last_updated_by = fnd_global.user_id,
3181: last_update_login = fnd_global.conc_login_id,
3182: pk5 = l_opinion_log_id
3183: WHERE OBJECT_TYPE = 'RISK_FINCERT'
3184: AND control_id = l_pk1
3185: AND pk2 = l_pk3

Line 3200: last_updated_by = fnd_global.user_id,

3196: fnd_file.put_line(fnd_file.LOG, 'before ap_evaluation_handler: org_id=' || l_pk3 || 'control_id=' || l_pk1 || ' opinion_log_id= ' || l_opinion_log_id || to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
3197:
3198: UPDATE AMW_AP_ASSOCIATIONS
3199: SET LAST_UPDATE_DATE = sysdate,
3200: last_updated_by = fnd_global.user_id,
3201: last_update_login = fnd_global.conc_login_id,
3202: /**05.02.2006 npanandi: fixing the below bug, since it is actually
3203: pk5 that stores the opinionLogId
3204: pk4 = l_opinion_log_id

Line 3201: last_update_login = fnd_global.conc_login_id,

3197:
3198: UPDATE AMW_AP_ASSOCIATIONS
3199: SET LAST_UPDATE_DATE = sysdate,
3200: last_updated_by = fnd_global.user_id,
3201: last_update_login = fnd_global.conc_login_id,
3202: /**05.02.2006 npanandi: fixing the below bug, since it is actually
3203: pk5 that stores the opinionLogId
3204: pk4 = l_opinion_log_id
3205: **/

Line 3314: fnd_global.apps_initialize (l_user_id, l_resp_id, l_resp_appl_id, l_security_group_id);

3310: l_resp_id := p_event.GetValueForParameter('RESP_ID');
3311: l_resp_appl_id := p_event.GetValueForParameter('RESP_APPL_ID');
3312: l_security_group_id := p_event.GetValueForParameter('SECURITY_GROUP_ID');
3313:
3314: fnd_global.apps_initialize (l_user_id, l_resp_id, l_resp_appl_id, l_security_group_id);
3315:
3316: --l_org_id := p_event.GetValueForParameter('ORG_ID');
3317: l_fin_cert_id := p_event.GetValueForParameter('FIN_CERTIFICATION_ID');
3318:

Line 3952: last_updated_by = fnd_global.user_id,

3948: l_total_org_var_processes;
3949:
3950: UPDATE AMW_FIN_PROCESS_EVAL_SUM
3951: SET LAST_UPDATE_DATE = sysdate,
3952: last_updated_by = fnd_global.user_id,
3953: last_update_login = fnd_global.conc_login_id,
3954: TOTAL_NUMBER_OF_ORG_PROCS = l_total_org_processes,
3955: NUMBER_OF_ORG_PROCS_CERTIFIED = l_org_processes_certified,
3956: ORG_PROCS_CERTIFIED_PRCNT =

Line 3953: last_update_login = fnd_global.conc_login_id,

3949:
3950: UPDATE AMW_FIN_PROCESS_EVAL_SUM
3951: SET LAST_UPDATE_DATE = sysdate,
3952: last_updated_by = fnd_global.user_id,
3953: last_update_login = fnd_global.conc_login_id,
3954: TOTAL_NUMBER_OF_ORG_PROCS = l_total_org_processes,
3955: NUMBER_OF_ORG_PROCS_CERTIFIED = l_org_processes_certified,
3956: ORG_PROCS_CERTIFIED_PRCNT =
3957: round(((l_org_processes_certified/decode(l_total_org_processes,0,1,l_total_org_processes)) *100),0)

Line 4441: FND_GLOBAL.USER_ID,

4437: l_org_processes_certified,
4438: round((nvl(l_org_processes_certified, 0)/decode(nvl(l_total_org_processes,0),0,1,l_total_org_processes) *100),0),
4439: l_open_findings,
4440: p_account_process_flag,
4441: FND_GLOBAL.USER_ID,
4442: SYSDATE,
4443: SYSDATE,
4444: FND_GLOBAL.USER_ID,
4445: FND_GLOBAL.USER_ID,

Line 4444: FND_GLOBAL.USER_ID,

4440: p_account_process_flag,
4441: FND_GLOBAL.USER_ID,
4442: SYSDATE,
4443: SYSDATE,
4444: FND_GLOBAL.USER_ID,
4445: FND_GLOBAL.USER_ID,
4446: l_cert_opinion_log_id,
4447: l_eval_opinion_log_id,
4448: p_revision_number,

Line 4445: FND_GLOBAL.USER_ID,

4441: FND_GLOBAL.USER_ID,
4442: SYSDATE,
4443: SYSDATE,
4444: FND_GLOBAL.USER_ID,
4445: FND_GLOBAL.USER_ID,
4446: l_cert_opinion_log_id,
4447: l_eval_opinion_log_id,
4448: p_revision_number,
4449: p_process_org_rev_id);

Line 4472: CREATED_BY = FND_GLOBAL.USER_ID,

4468: TOTAL_NUMBER_OF_ORG_PROCS = l_total_org_processes,
4469: NUMBER_OF_ORG_PROCS_CERTIFIED = l_org_processes_certified,
4470: ORG_PROCS_CERTIFIED_PRCNT = round((nvl(l_org_processes_certified, 0)/decode(nvl(l_total_org_processes,0),0,1,l_total_org_processes) *100),0),
4471: OPEN_FINDINGS = l_open_findings,
4472: CREATED_BY = FND_GLOBAL.USER_ID,
4473: CREATION_DATE = SYSDATE,
4474: LAST_UPDATE_DATE = SYSDATE,
4475: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4476: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,

Line 4475: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

4471: OPEN_FINDINGS = l_open_findings,
4472: CREATED_BY = FND_GLOBAL.USER_ID,
4473: CREATION_DATE = SYSDATE,
4474: LAST_UPDATE_DATE = SYSDATE,
4475: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4476: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
4477: CERT_OPINION_LOG_ID = l_cert_opinion_log_id,
4478: EVAL_OPINION_LOG_ID = l_eval_opinion_log_id
4479: WHERE FIN_CERTIFICATION_ID = p_certification_id

Line 4476: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,

4472: CREATED_BY = FND_GLOBAL.USER_ID,
4473: CREATION_DATE = SYSDATE,
4474: LAST_UPDATE_DATE = SYSDATE,
4475: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4476: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
4477: CERT_OPINION_LOG_ID = l_cert_opinion_log_id,
4478: EVAL_OPINION_LOG_ID = l_eval_opinion_log_id
4479: WHERE FIN_CERTIFICATION_ID = p_certification_id
4480: AND PROCESS_ID = p_process_id

Line 4729: FND_GLOBAL.USER_ID,

4725: p_certification_id,
4726: risk_rec.PK1,
4727: risk_rec.PK2,
4728: m_opinion_log_id,
4729: FND_GLOBAL.USER_ID,
4730: SYSDATE,
4731: SYSDATE,
4732: FND_GLOBAL.USER_ID,
4733: FND_GLOBAL.USER_ID,

Line 4732: FND_GLOBAL.USER_ID,

4728: m_opinion_log_id,
4729: FND_GLOBAL.USER_ID,
4730: SYSDATE,
4731: SYSDATE,
4732: FND_GLOBAL.USER_ID,
4733: FND_GLOBAL.USER_ID,
4734: 1,
4735: 'PROCESS_FINCERT',
4736: risk_rec.ASSOCIATION_CREATION_DATE,

Line 4733: FND_GLOBAL.USER_ID,

4729: FND_GLOBAL.USER_ID,
4730: SYSDATE,
4731: SYSDATE,
4732: FND_GLOBAL.USER_ID,
4733: FND_GLOBAL.USER_ID,
4734: 1,
4735: 'PROCESS_FINCERT',
4736: risk_rec.ASSOCIATION_CREATION_DATE,
4737: risk_rec.APPROVAL_DATE,

Line 4760: LAST_UPDATED_BY = fnd_global.USER_ID,

4756:
4757: update AMW_RISK_ASSOCIATIONS /**need only to update the opinionLogId here**/
4758: set PK4 = m_opinion_log_id,
4759: LAST_UPDATE_DATE = sysdate,
4760: LAST_UPDATED_BY = fnd_global.USER_ID,
4761: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,
4762: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
4763: where object_type = 'PROCESS_FINCERT'
4764: and risk_id = risk_rec.risk_id

Line 4761: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,

4757: update AMW_RISK_ASSOCIATIONS /**need only to update the opinionLogId here**/
4758: set PK4 = m_opinion_log_id,
4759: LAST_UPDATE_DATE = sysdate,
4760: LAST_UPDATED_BY = fnd_global.USER_ID,
4761: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,
4762: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
4763: where object_type = 'PROCESS_FINCERT'
4764: and risk_id = risk_rec.risk_id
4765: and PK2 = risk_rec.PK1

Line 5067: FND_GLOBAL.USER_ID,

5063: control_rec.PK1,
5064: control_rec.PK2,
5065: control_rec.PK3,
5066: m_opinion_log_id,
5067: FND_GLOBAL.USER_ID,
5068: SYSDATE,
5069: SYSDATE,
5070: FND_GLOBAL.USER_ID,
5071: FND_GLOBAL.USER_ID,

Line 5070: FND_GLOBAL.USER_ID,

5066: m_opinion_log_id,
5067: FND_GLOBAL.USER_ID,
5068: SYSDATE,
5069: SYSDATE,
5070: FND_GLOBAL.USER_ID,
5071: FND_GLOBAL.USER_ID,
5072: 1,
5073: 'RISK_FINCERT',
5074: control_rec.ASSOCIATION_CREATION_DATE,

Line 5071: FND_GLOBAL.USER_ID,

5067: FND_GLOBAL.USER_ID,
5068: SYSDATE,
5069: SYSDATE,
5070: FND_GLOBAL.USER_ID,
5071: FND_GLOBAL.USER_ID,
5072: 1,
5073: 'RISK_FINCERT',
5074: control_rec.ASSOCIATION_CREATION_DATE,
5075: control_rec.APPROVAL_DATE,

Line 5094: last_updated_by = fnd_global.user_id,

5090: CLOSE last_evaluation;
5091:
5092: UPDATE AMW_CONTROL_ASSOCIATIONS SET
5093: LAST_UPDATE_DATE = sysdate,
5094: last_updated_by = fnd_global.user_id,
5095: last_update_login = fnd_global.conc_login_id,
5096: pk5 = m_opinion_log_id
5097: WHERE OBJECT_TYPE = 'RISK_FINCERT'
5098: AND control_id = control_rec.control_id

Line 5095: last_update_login = fnd_global.conc_login_id,

5091:
5092: UPDATE AMW_CONTROL_ASSOCIATIONS SET
5093: LAST_UPDATE_DATE = sysdate,
5094: last_updated_by = fnd_global.user_id,
5095: last_update_login = fnd_global.conc_login_id,
5096: pk5 = m_opinion_log_id
5097: WHERE OBJECT_TYPE = 'RISK_FINCERT'
5098: AND control_id = control_rec.control_id
5099: AND pk2 = control_rec.pk1

Line 5408: FND_GLOBAL.USER_ID,

5404: ap_rec.PK1, /*organizationId*/
5405: ap_rec.PK2, /*processId*/
5406: ap_rec.PK3, /*controlId*/
5407: m_opinion_id, /*opinionLogId*/
5408: FND_GLOBAL.USER_ID,
5409: SYSDATE,
5410: SYSDATE,
5411: FND_GLOBAL.USER_ID,
5412: FND_GLOBAL.USER_ID,

Line 5411: FND_GLOBAL.USER_ID,

5407: m_opinion_id, /*opinionLogId*/
5408: FND_GLOBAL.USER_ID,
5409: SYSDATE,
5410: SYSDATE,
5411: FND_GLOBAL.USER_ID,
5412: FND_GLOBAL.USER_ID,
5413: 1,
5414: 'CTRL_FINCERT',
5415: ap_rec.ASSOCIATION_CREATION_DATE,

Line 5412: FND_GLOBAL.USER_ID,

5408: FND_GLOBAL.USER_ID,
5409: SYSDATE,
5410: SYSDATE,
5411: FND_GLOBAL.USER_ID,
5412: FND_GLOBAL.USER_ID,
5413: 1,
5414: 'CTRL_FINCERT',
5415: ap_rec.ASSOCIATION_CREATION_DATE,
5416: ap_rec.APPROVAL_DATE,

Line 5438: ,LAST_UPDATED_BY = FND_GLOBAL.USER_ID

5434:
5435: update AMW_AP_ASSOCIATIONS
5436: set PK5 = m_opinion_id
5437: ,LAST_UPDATE_DATE = SYSDATE
5438: ,LAST_UPDATED_BY = FND_GLOBAL.USER_ID
5439: ,LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
5440: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
5441: where object_type = 'CTRL_FINCERT'
5442: and AUDIT_PROCEDURE_ID = ap_rec.audit_procedure_id

Line 5439: ,LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

5435: update AMW_AP_ASSOCIATIONS
5436: set PK5 = m_opinion_id
5437: ,LAST_UPDATE_DATE = SYSDATE
5438: ,LAST_UPDATED_BY = FND_GLOBAL.USER_ID
5439: ,LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
5440: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
5441: where object_type = 'CTRL_FINCERT'
5442: and AUDIT_PROCEDURE_ID = ap_rec.audit_procedure_id
5443: AND PK2 = AP_REC.PK1 /**organizationId**/

Line 6098: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

6094: UNMITIGATED_RISKS_PRCNT = round(nvl(l_unmitigated_risks, 0) /decode(nvl(l_total_risks, 0),0,1,l_total_risks), 2)*100,
6095: INEFFECTIVE_CONTROLS_PRCNT = round(nvl(l_ineff_controls, 0) /decode(nvl(l_total_controls, 0),0,1,l_total_controls), 2)*100,
6096: OPEN_FINDINGS = l_open_findings,
6097: LAST_UPDATE_DATE = sysdate,
6098: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
6099: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
6100: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
6101: SUBSIDIARY_VS = l_sub_vs,
6102: SUBSIDIARY_CODE = l_sub_code,

Line 6099: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,

6095: INEFFECTIVE_CONTROLS_PRCNT = round(nvl(l_ineff_controls, 0) /decode(nvl(l_total_controls, 0),0,1,l_total_controls), 2)*100,
6096: OPEN_FINDINGS = l_open_findings,
6097: LAST_UPDATE_DATE = sysdate,
6098: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
6099: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
6100: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
6101: SUBSIDIARY_VS = l_sub_vs,
6102: SUBSIDIARY_CODE = l_sub_code,
6103: LOB_VS = l_lob_vs,

Line 6169: FND_GLOBAL.USER_ID,

6165: round(nvl(l_proc_with_ineff_ctrl, 0)/decode(nvl(l_total_num_of_procs, 0), 0,1,l_total_num_of_procs),2)*100,
6166: round(nvl(l_unmitigated_risks, 0)/decode(nvl(l_total_risks, 0),0,1,l_total_risks), 2)*100,
6167: round(nvl(l_ineff_controls, 0) /decode(nvl(l_total_controls, 0),0,1,l_total_controls), 2)*100,
6168: l_open_findings,
6169: FND_GLOBAL.USER_ID,
6170: SYSDATE,
6171: FND_GLOBAL.USER_ID,
6172: SYSDATE,
6173: FND_GLOBAL.USER_ID,

Line 6171: FND_GLOBAL.USER_ID,

6167: round(nvl(l_ineff_controls, 0) /decode(nvl(l_total_controls, 0),0,1,l_total_controls), 2)*100,
6168: l_open_findings,
6169: FND_GLOBAL.USER_ID,
6170: SYSDATE,
6171: FND_GLOBAL.USER_ID,
6172: SYSDATE,
6173: FND_GLOBAL.USER_ID,
6174: 1,
6175: l_sub_vs,

Line 6173: FND_GLOBAL.USER_ID,

6169: FND_GLOBAL.USER_ID,
6170: SYSDATE,
6171: FND_GLOBAL.USER_ID,
6172: SYSDATE,
6173: FND_GLOBAL.USER_ID,
6174: 1,
6175: l_sub_vs,
6176: l_sub_code,
6177: l_lob_vs,

Line 7069: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

7065: ORGS_IN_SCOPE = l_orgs_in_scope,
7066: ORGS_PENDING_IN_SCOPE = l_orgs_pending_in_scope,
7067: PERIOD_START_DATE = p_start_date,
7068: LAST_UPDATE_DATE = sysdate,
7069: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7070: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
7071: WHERE certification_id = p_certification_id;
7072:
7073: IF (SQL%NOTFOUND) THEN

Line 7070: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

7066: ORGS_PENDING_IN_SCOPE = l_orgs_pending_in_scope,
7067: PERIOD_START_DATE = p_start_date,
7068: LAST_UPDATE_DATE = sysdate,
7069: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7070: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
7071: WHERE certification_id = p_certification_id;
7072:
7073: IF (SQL%NOTFOUND) THEN
7074: INSERT INTO AMW_CERT_DASHBOARD_SUM (

Line 7108: FND_GLOBAL.USER_ID,

7104: l_ineffective_controls,
7105: l_orgs_in_scope,
7106: l_orgs_pending_in_scope,
7107: p_start_date,
7108: FND_GLOBAL.USER_ID,
7109: SYSDATE,
7110: SYSDATE,
7111: FND_GLOBAL.USER_ID,
7112: FND_GLOBAL.USER_ID

Line 7111: FND_GLOBAL.USER_ID,

7107: p_start_date,
7108: FND_GLOBAL.USER_ID,
7109: SYSDATE,
7110: SYSDATE,
7111: FND_GLOBAL.USER_ID,
7112: FND_GLOBAL.USER_ID
7113: FROM DUAL;
7114: END IF;
7115:

Line 7112: FND_GLOBAL.USER_ID

7108: FND_GLOBAL.USER_ID,
7109: SYSDATE,
7110: SYSDATE,
7111: FND_GLOBAL.USER_ID,
7112: FND_GLOBAL.USER_ID
7113: FROM DUAL;
7114: END IF;
7115:
7116: if(p_commit <> FND_API.g_false)

Line 7154: last_updated_by = fnd_global.user_id,

7150: if p_certification_id is not null then
7151: update amw_fin_cert_eval_sum
7152: set
7153: LAST_UPDATE_DATE = sysdate,
7154: last_updated_by = fnd_global.user_id,
7155: last_update_login = fnd_global.conc_login_id,
7156: PROC_PENDING_CERTIFICATION = 0,
7157: TOTAL_NUMBER_OF_PROCESSES =0,
7158: PROC_CERTIFIED_WITH_ISSUES =0,

Line 7155: last_update_login = fnd_global.conc_login_id,

7151: update amw_fin_cert_eval_sum
7152: set
7153: LAST_UPDATE_DATE = sysdate,
7154: last_updated_by = fnd_global.user_id,
7155: last_update_login = fnd_global.conc_login_id,
7156: PROC_PENDING_CERTIFICATION = 0,
7157: TOTAL_NUMBER_OF_PROCESSES =0,
7158: PROC_CERTIFIED_WITH_ISSUES =0,
7159: -- PROC_VERIFIED =0 ,

Line 7186: last_updated_by = fnd_global.user_id,

7182: else
7183: update amw_fin_cert_eval_sum
7184: set
7185: LAST_UPDATE_DATE = sysdate,
7186: last_updated_by = fnd_global.user_id,
7187: last_update_login = fnd_global.conc_login_id,
7188: PROC_PENDING_CERTIFICATION = 0,
7189: TOTAL_NUMBER_OF_PROCESSES =0,
7190: PROC_CERTIFIED_WITH_ISSUES =0,

Line 7187: last_update_login = fnd_global.conc_login_id,

7183: update amw_fin_cert_eval_sum
7184: set
7185: LAST_UPDATE_DATE = sysdate,
7186: last_updated_by = fnd_global.user_id,
7187: last_update_login = fnd_global.conc_login_id,
7188: PROC_PENDING_CERTIFICATION = 0,
7189: TOTAL_NUMBER_OF_PROCESSES =0,
7190: PROC_CERTIFIED_WITH_ISSUES =0,
7191: --PROC_VERIFIED =0 ,

Line 7231: last_updated_by = fnd_global.user_id,

7227: IF(p_certification_id is not null) then
7228: UPDATE AMW_FIN_PROCESS_EVAL_SUM
7229: SET
7230: LAST_UPDATE_DATE = sysdate,
7231: last_updated_by = fnd_global.user_id,
7232: last_update_login = fnd_global.conc_login_id,
7233: CERT_OPINION_ID = 0,
7234: EVAL_OPINION_ID = 0,
7235: CERT_OPINION_LOG_ID = 0,

Line 7232: last_update_login = fnd_global.conc_login_id,

7228: UPDATE AMW_FIN_PROCESS_EVAL_SUM
7229: SET
7230: LAST_UPDATE_DATE = sysdate,
7231: last_updated_by = fnd_global.user_id,
7232: last_update_login = fnd_global.conc_login_id,
7233: CERT_OPINION_ID = 0,
7234: EVAL_OPINION_ID = 0,
7235: CERT_OPINION_LOG_ID = 0,
7236: EVAL_OPINION_LOG_ID = 0,

Line 7255: last_updated_by = fnd_global.user_id,

7251: ELSE
7252: UPDATE AMW_FIN_PROCESS_EVAL_SUM
7253: SET
7254: LAST_UPDATE_DATE = sysdate,
7255: last_updated_by = fnd_global.user_id,
7256: last_update_login = fnd_global.conc_login_id,
7257: CERT_OPINION_ID = 0,
7258: EVAL_OPINION_ID = 0,
7259: CERT_OPINION_LOG_ID = 0,

Line 7256: last_update_login = fnd_global.conc_login_id,

7252: UPDATE AMW_FIN_PROCESS_EVAL_SUM
7253: SET
7254: LAST_UPDATE_DATE = sysdate,
7255: last_updated_by = fnd_global.user_id,
7256: last_update_login = fnd_global.conc_login_id,
7257: CERT_OPINION_ID = 0,
7258: EVAL_OPINION_ID = 0,
7259: CERT_OPINION_LOG_ID = 0,
7260: EVAL_OPINION_LOG_ID = 0,

Line 7297: last_updated_by = fnd_global.user_id,

7293: UPDATE
7294: AMW_FIN_ORG_EVAL_SUM
7295: SET
7296: LAST_UPDATE_DATE = sysdate,
7297: last_updated_by = fnd_global.user_id,
7298: last_update_login = fnd_global.conc_login_id,
7299: EVAL_OPINION_ID = 0,
7300: CERT_OPINION_LOG_ID = 0,
7301: CERT_OPINION_ID = 0,

Line 7298: last_update_login = fnd_global.conc_login_id,

7294: AMW_FIN_ORG_EVAL_SUM
7295: SET
7296: LAST_UPDATE_DATE = sysdate,
7297: last_updated_by = fnd_global.user_id,
7298: last_update_login = fnd_global.conc_login_id,
7299: EVAL_OPINION_ID = 0,
7300: CERT_OPINION_LOG_ID = 0,
7301: CERT_OPINION_ID = 0,
7302: EVAL_OPINION_LOG_ID = 0,

Line 7326: last_updated_by = fnd_global.user_id,

7322: ELSE
7323: UPDATE AMW_FIN_ORG_EVAL_SUM
7324: SET
7325: LAST_UPDATE_DATE = sysdate,
7326: last_updated_by = fnd_global.user_id,
7327: last_update_login = fnd_global.conc_login_id,
7328: EVAL_OPINION_ID = 0,
7329: CERT_OPINION_LOG_ID = 0,
7330: CERT_OPINION_ID = 0,

Line 7327: last_update_login = fnd_global.conc_login_id,

7323: UPDATE AMW_FIN_ORG_EVAL_SUM
7324: SET
7325: LAST_UPDATE_DATE = sysdate,
7326: last_updated_by = fnd_global.user_id,
7327: last_update_login = fnd_global.conc_login_id,
7328: EVAL_OPINION_ID = 0,
7329: CERT_OPINION_LOG_ID = 0,
7330: CERT_OPINION_ID = 0,
7331: EVAL_OPINION_LOG_ID = 0,

Line 7370: last_updated_by = fnd_global.user_id,

7366: IF p_certification_id is not null THEN
7367: UPDATE AMW_CERT_DASHBOARD_SUM
7368: SET
7369: LAST_UPDATE_DATE = sysdate,
7370: last_updated_by = fnd_global.user_id,
7371: last_update_login = fnd_global.conc_login_id,
7372: NEW_RISKS_ADDED = 0,
7373: NEW_CONTROLS_ADDED = 0,
7374: PROCESSES_NOT_CERT = 0,

Line 7371: last_update_login = fnd_global.conc_login_id,

7367: UPDATE AMW_CERT_DASHBOARD_SUM
7368: SET
7369: LAST_UPDATE_DATE = sysdate,
7370: last_updated_by = fnd_global.user_id,
7371: last_update_login = fnd_global.conc_login_id,
7372: NEW_RISKS_ADDED = 0,
7373: NEW_CONTROLS_ADDED = 0,
7374: PROCESSES_NOT_CERT = 0,
7375: PROCESSES_CERT_ISSUES = 0,

Line 7390: last_updated_by = fnd_global.user_id,

7386: ELSE
7387: UPDATE AMW_CERT_DASHBOARD_SUM
7388: SET
7389: LAST_UPDATE_DATE = sysdate,
7390: last_updated_by = fnd_global.user_id,
7391: last_update_login = fnd_global.conc_login_id,
7392: NEW_RISKS_ADDED = 0,
7393: NEW_CONTROLS_ADDED = 0,
7394: PROCESSES_NOT_CERT = 0,

Line 7391: last_update_login = fnd_global.conc_login_id,

7387: UPDATE AMW_CERT_DASHBOARD_SUM
7388: SET
7389: LAST_UPDATE_DATE = sysdate,
7390: last_updated_by = fnd_global.user_id,
7391: last_update_login = fnd_global.conc_login_id,
7392: NEW_RISKS_ADDED = 0,
7393: NEW_CONTROLS_ADDED = 0,
7394: PROCESSES_NOT_CERT = 0,
7395: PROCESSES_CERT_ISSUES = 0,

Line 7617: last_updated_by = fnd_global.user_id,

7613: ********/
7614: UPDATE AMW_FIN_CERT_EVAL_SUM
7615: SET
7616: last_update_date = sysdate,
7617: last_updated_by = fnd_global.user_id,
7618: last_update_login = fnd_global.conc_login_id,
7619: risks_verified = least(risks_verified + 1, total_number_of_risks)
7620: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
7621: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID

Line 7618: last_update_login = fnd_global.conc_login_id,

7614: UPDATE AMW_FIN_CERT_EVAL_SUM
7615: SET
7616: last_update_date = sysdate,
7617: last_updated_by = fnd_global.user_id,
7618: last_update_login = fnd_global.conc_login_id,
7619: risks_verified = least(risks_verified + 1, total_number_of_risks)
7620: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
7621: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
7622: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID

Line 7642: last_updated_by = fnd_global.user_id,

7638: *************/
7639: UPDATE AMW_FIN_CERT_EVAL_SUM
7640: SET
7641: last_update_date = sysdate,
7642: last_updated_by = fnd_global.user_id,
7643: last_update_login = fnd_global.conc_login_id,
7644: unmitigated_risks = greatest(0, unmitigated_risks -1),
7645: unmitigated_risks_prcnt = round( (greatest(0, m_item_unmitigated_risks -1))/decode(nvl(m_item_risks_total, 0), 0, 1, m_item_risks_total), 2)*100
7646: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID

Line 7643: last_update_login = fnd_global.conc_login_id,

7639: UPDATE AMW_FIN_CERT_EVAL_SUM
7640: SET
7641: last_update_date = sysdate,
7642: last_updated_by = fnd_global.user_id,
7643: last_update_login = fnd_global.conc_login_id,
7644: unmitigated_risks = greatest(0, unmitigated_risks -1),
7645: unmitigated_risks_prcnt = round( (greatest(0, m_item_unmitigated_risks -1))/decode(nvl(m_item_risks_total, 0), 0, 1, m_item_risks_total), 2)*100
7646: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
7647: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID

Line 7664: last_updated_by = fnd_global.user_id,

7660: ***********/
7661: UPDATE AMW_FIN_CERT_EVAL_SUM
7662: SET
7663: last_update_date = sysdate,
7664: last_updated_by = fnd_global.user_id,
7665: last_update_login = fnd_global.conc_login_id,
7666: unmitigated_risks = least(unmitigated_risks + 1, risks_verified),
7667: unmitigated_risks_prcnt = round((least(m_item_unmitigated_risks + 1, risks_verified))/decode(nvl(m_item_risks_total, 0), 0, 1, m_item_risks_total), 2)*100
7668: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID

Line 7665: last_update_login = fnd_global.conc_login_id,

7661: UPDATE AMW_FIN_CERT_EVAL_SUM
7662: SET
7663: last_update_date = sysdate,
7664: last_updated_by = fnd_global.user_id,
7665: last_update_login = fnd_global.conc_login_id,
7666: unmitigated_risks = least(unmitigated_risks + 1, risks_verified),
7667: unmitigated_risks_prcnt = round((least(m_item_unmitigated_risks + 1, risks_verified))/decode(nvl(m_item_risks_total, 0), 0, 1, m_item_risks_total), 2)*100
7668: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
7669: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID

Line 7679: last_updated_by = fnd_global.user_id,

7675:
7676: UPDATE AMW_FIN_ITEM_ACC_RISK
7677: SET
7678: LAST_UPDATE_DATE = sysdate,
7679: last_updated_by = fnd_global.user_id,
7680: last_update_login = fnd_global.conc_login_id,
7681: OPINION_LOG_ID = P_opinion_log_id
7682: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
7683: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID

Line 7680: last_update_login = fnd_global.conc_login_id,

7676: UPDATE AMW_FIN_ITEM_ACC_RISK
7677: SET
7678: LAST_UPDATE_DATE = sysdate,
7679: last_updated_by = fnd_global.user_id,
7680: last_update_login = fnd_global.conc_login_id,
7681: OPINION_LOG_ID = P_opinion_log_id
7682: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
7683: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
7684: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID

Line 7722: last_updated_by = fnd_global.user_id,

7718: *************/
7719: UPDATE AMW_FIN_CERT_EVAL_SUM
7720: SET
7721: last_update_date = sysdate,
7722: last_updated_by = fnd_global.user_id,
7723: last_update_login = fnd_global.conc_login_id,
7724: risks_verified = least(risks_verified + 1, total_number_of_risks)
7725: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
7726: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID

Line 7723: last_update_login = fnd_global.conc_login_id,

7719: UPDATE AMW_FIN_CERT_EVAL_SUM
7720: SET
7721: last_update_date = sysdate,
7722: last_updated_by = fnd_global.user_id,
7723: last_update_login = fnd_global.conc_login_id,
7724: risks_verified = least(risks_verified + 1, total_number_of_risks)
7725: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
7726: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
7727: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID

Line 7744: last_updated_by = fnd_global.user_id,

7740: **********/
7741: UPDATE AMW_FIN_CERT_EVAL_SUM
7742: SET
7743: last_update_date = sysdate,
7744: last_updated_by = fnd_global.user_id,
7745: last_update_login = fnd_global.conc_login_id,
7746: unmitigated_risks = greatest(0, unmitigated_risks -1) ,
7747: unmitigated_risks_prcnt = round((greatest(0, m_acc_unmitigated_risks - 1))/ decode(nvl(m_acc_risks_total,0), 0,1, m_acc_risks_total), 2) * 100
7748: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID

Line 7745: last_update_login = fnd_global.conc_login_id,

7741: UPDATE AMW_FIN_CERT_EVAL_SUM
7742: SET
7743: last_update_date = sysdate,
7744: last_updated_by = fnd_global.user_id,
7745: last_update_login = fnd_global.conc_login_id,
7746: unmitigated_risks = greatest(0, unmitigated_risks -1) ,
7747: unmitigated_risks_prcnt = round((greatest(0, m_acc_unmitigated_risks - 1))/ decode(nvl(m_acc_risks_total,0), 0,1, m_acc_risks_total), 2) * 100
7748: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
7749: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID

Line 7767: last_updated_by = fnd_global.user_id,

7763: ***************/
7764: UPDATE AMW_FIN_CERT_EVAL_SUM
7765: SET
7766: last_update_date = sysdate,
7767: last_updated_by = fnd_global.user_id,
7768: last_update_login = fnd_global.conc_login_id,
7769: unmitigated_risks = least(unmitigated_risks + 1 ,risks_verified),
7770: unmitigated_risks_prcnt = round((least(risks_verified, m_acc_unmitigated_risks + 1))/ decode(nvl(m_acc_risks_total,0), 0,1, m_acc_risks_total), 2) * 100
7771: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID

Line 7768: last_update_login = fnd_global.conc_login_id,

7764: UPDATE AMW_FIN_CERT_EVAL_SUM
7765: SET
7766: last_update_date = sysdate,
7767: last_updated_by = fnd_global.user_id,
7768: last_update_login = fnd_global.conc_login_id,
7769: unmitigated_risks = least(unmitigated_risks + 1 ,risks_verified),
7770: unmitigated_risks_prcnt = round((least(risks_verified, m_acc_unmitigated_risks + 1))/ decode(nvl(m_acc_risks_total,0), 0,1, m_acc_risks_total), 2) * 100
7771: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
7772: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID

Line 7781: last_updated_by = fnd_global.user_id,

7777:
7778: UPDATE AMW_FIN_ITEM_ACC_RISK
7779: SET
7780: LAST_UPDATE_DATE = sysdate,
7781: last_updated_by = fnd_global.user_id,
7782: last_update_login = fnd_global.conc_login_id,
7783: OPINION_LOG_ID = P_opinion_log_id
7784: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
7785: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID

Line 7782: last_update_login = fnd_global.conc_login_id,

7778: UPDATE AMW_FIN_ITEM_ACC_RISK
7779: SET
7780: LAST_UPDATE_DATE = sysdate,
7781: last_updated_by = fnd_global.user_id,
7782: last_update_login = fnd_global.conc_login_id,
7783: OPINION_LOG_ID = P_opinion_log_id
7784: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
7785: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
7786: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID

Line 7832: last_updated_by = fnd_global.user_id,

7828: ************/
7829: UPDATE AMW_FIN_PROCESS_EVAL_SUM
7830: SET
7831: last_update_date = sysdate,
7832: last_updated_by = fnd_global.user_id,
7833: last_update_login = fnd_global.conc_login_id,
7834: risks_verified = least(risks_verified + 1, total_number_of_risks)
7835: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
7836: AND ORGANIZATION_ID = p_org_id

Line 7833: last_update_login = fnd_global.conc_login_id,

7829: UPDATE AMW_FIN_PROCESS_EVAL_SUM
7830: SET
7831: last_update_date = sysdate,
7832: last_updated_by = fnd_global.user_id,
7833: last_update_login = fnd_global.conc_login_id,
7834: risks_verified = least(risks_verified + 1, total_number_of_risks)
7835: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
7836: AND ORGANIZATION_ID = p_org_id
7837: AND PROCESS_ID = p_process_id;

Line 7850: last_updated_by = fnd_global.user_id,

7846: *********/
7847: UPDATE AMW_FIN_ORG_EVAL_SUM
7848: SET
7849: last_update_date = sysdate,
7850: last_updated_by = fnd_global.user_id,
7851: last_update_login = fnd_global.conc_login_id,
7852: risks_verified = least(risks_verified + 1, total_number_of_risks)
7853: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
7854: AND ORGANIZATION_ID = p_org_id;

Line 7851: last_update_login = fnd_global.conc_login_id,

7847: UPDATE AMW_FIN_ORG_EVAL_SUM
7848: SET
7849: last_update_date = sysdate,
7850: last_updated_by = fnd_global.user_id,
7851: last_update_login = fnd_global.conc_login_id,
7852: risks_verified = least(risks_verified + 1, total_number_of_risks)
7853: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
7854: AND ORGANIZATION_ID = p_org_id;
7855: --END IF;

Line 7870: last_updated_by = fnd_global.user_id,

7866: *************/
7867: UPDATE AMW_CERT_DASHBOARD_SUM
7868: SET
7869: LAST_UPDATE_DATE = sysdate,
7870: last_updated_by = fnd_global.user_id,
7871: last_update_login = fnd_global.conc_login_id,
7872: unmitigated_risks = greatest(0, unmitigated_risks -1 )
7873: WHERE CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id;
7874: --END IF;

Line 7871: last_update_login = fnd_global.conc_login_id,

7867: UPDATE AMW_CERT_DASHBOARD_SUM
7868: SET
7869: LAST_UPDATE_DATE = sysdate,
7870: last_updated_by = fnd_global.user_id,
7871: last_update_login = fnd_global.conc_login_id,
7872: unmitigated_risks = greatest(0, unmitigated_risks -1 )
7873: WHERE CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id;
7874: --END IF;
7875: /********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b

Line 7886: last_updated_by = fnd_global.user_id,

7882: ************/
7883: UPDATE AMW_FIN_PROCESS_EVAL_SUM
7884: SET
7885: LAST_UPDATE_DATE = sysdate,
7886: last_updated_by = fnd_global.user_id,
7887: last_update_login = fnd_global.conc_login_id,
7888: UNMITIGATED_RISKS = UNMITIGATED_RISKS - 1
7889: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
7890: AND ORGANIZATION_ID = p_org_id

Line 7887: last_update_login = fnd_global.conc_login_id,

7883: UPDATE AMW_FIN_PROCESS_EVAL_SUM
7884: SET
7885: LAST_UPDATE_DATE = sysdate,
7886: last_updated_by = fnd_global.user_id,
7887: last_update_login = fnd_global.conc_login_id,
7888: UNMITIGATED_RISKS = UNMITIGATED_RISKS - 1
7889: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
7890: AND ORGANIZATION_ID = p_org_id
7891: AND PROCESS_ID = p_process_id;

Line 7904: last_updated_by = fnd_global.user_id,

7900: *********/
7901: UPDATE AMW_FIN_ORG_EVAL_SUM
7902: SET
7903: last_update_date = sysdate,
7904: last_updated_by = fnd_global.user_id,
7905: last_update_login = fnd_global.conc_login_id,
7906: unmitigated_risks = greatest(0, unmitigated_risks -1),
7907: unmitigated_risks_prcnt = round((greatest(0, m_org_unmitigated_risks - 1))/decode(nvl(m_org_risks_total, 0), 0, 1, m_org_risks_total), 2)*100
7908: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id

Line 7905: last_update_login = fnd_global.conc_login_id,

7901: UPDATE AMW_FIN_ORG_EVAL_SUM
7902: SET
7903: last_update_date = sysdate,
7904: last_updated_by = fnd_global.user_id,
7905: last_update_login = fnd_global.conc_login_id,
7906: unmitigated_risks = greatest(0, unmitigated_risks -1),
7907: unmitigated_risks_prcnt = round((greatest(0, m_org_unmitigated_risks - 1))/decode(nvl(m_org_risks_total, 0), 0, 1, m_org_risks_total), 2)*100
7908: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
7909: AND ORGANIZATION_ID = p_org_id;

Line 7915: last_updated_by = fnd_global.user_id,

7911: ELSIF(M_change_flag = 'B') THEN
7912: UPDATE AMW_CERT_DASHBOARD_SUM
7913: SET
7914: LAST_UPDATE_DATE = sysdate,
7915: last_updated_by = fnd_global.user_id,
7916: last_update_login = fnd_global.conc_login_id,
7917: UNMITIGATED_RISKS = UNMITIGATED_RISKS + 1
7918: WHERE CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id;
7919:

Line 7916: last_update_login = fnd_global.conc_login_id,

7912: UPDATE AMW_CERT_DASHBOARD_SUM
7913: SET
7914: LAST_UPDATE_DATE = sysdate,
7915: last_updated_by = fnd_global.user_id,
7916: last_update_login = fnd_global.conc_login_id,
7917: UNMITIGATED_RISKS = UNMITIGATED_RISKS + 1
7918: WHERE CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id;
7919:
7920: /********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b

Line 7931: last_updated_by = fnd_global.user_id,

7927: ************/
7928: UPDATE AMW_FIN_PROCESS_EVAL_SUM
7929: SET
7930: last_update_date = sysdate,
7931: last_updated_by = fnd_global.user_id,
7932: last_update_login = fnd_global.conc_login_id,
7933: unmitigated_risks = least(unmitigated_risks +1, risks_verified)
7934: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
7935: AND ORGANIZATION_ID = p_org_id

Line 7932: last_update_login = fnd_global.conc_login_id,

7928: UPDATE AMW_FIN_PROCESS_EVAL_SUM
7929: SET
7930: last_update_date = sysdate,
7931: last_updated_by = fnd_global.user_id,
7932: last_update_login = fnd_global.conc_login_id,
7933: unmitigated_risks = least(unmitigated_risks +1, risks_verified)
7934: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
7935: AND ORGANIZATION_ID = p_org_id
7936: AND PROCESS_ID = p_process_id;

Line 7949: last_updated_by = fnd_global.user_id,

7945: ***************/
7946: UPDATE AMW_FIN_ORG_EVAL_SUM
7947: SET
7948: last_update_date = sysdate,
7949: last_updated_by = fnd_global.user_id,
7950: last_update_login = fnd_global.conc_login_id,
7951: unmitigated_risks = least(unmitigated_risks + 1,risks_verified),
7952: unmitigated_risks_prcnt = round((least(m_org_unmitigated_risks + 1, risks_verified))/decode(nvl(m_org_risks_total, 0), 0, 1, m_org_risks_total), 2)*100
7953: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id

Line 7950: last_update_login = fnd_global.conc_login_id,

7946: UPDATE AMW_FIN_ORG_EVAL_SUM
7947: SET
7948: last_update_date = sysdate,
7949: last_updated_by = fnd_global.user_id,
7950: last_update_login = fnd_global.conc_login_id,
7951: unmitigated_risks = least(unmitigated_risks + 1,risks_verified),
7952: unmitigated_risks_prcnt = round((least(m_org_unmitigated_risks + 1, risks_verified))/decode(nvl(m_org_risks_total, 0), 0, 1, m_org_risks_total), 2)*100
7953: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
7954: AND ORGANIZATION_ID = p_org_id;

Line 8170: last_updated_by = fnd_global.user_id,

8166: *************/
8167: UPDATE AMW_FIN_CERT_EVAL_SUM
8168: SET
8169: last_update_date = sysdate,
8170: last_updated_by = fnd_global.user_id,
8171: last_update_login = fnd_global.conc_login_id,
8172: controls_verified = least(controls_verified + 1, total_number_of_ctrls)
8173: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
8174: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID

Line 8171: last_update_login = fnd_global.conc_login_id,

8167: UPDATE AMW_FIN_CERT_EVAL_SUM
8168: SET
8169: last_update_date = sysdate,
8170: last_updated_by = fnd_global.user_id,
8171: last_update_login = fnd_global.conc_login_id,
8172: controls_verified = least(controls_verified + 1, total_number_of_ctrls)
8173: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
8174: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
8175: AND FINANCIAL_ITEM_ID = get_all_items_rec.FINANCIAL_ITEM_ID

Line 8192: last_updated_by = fnd_global.user_id,

8188: *************/
8189: UPDATE AMW_FIN_CERT_EVAL_SUM
8190: SET
8191: last_update_date = sysdate,
8192: last_updated_by = fnd_global.user_id,
8193: last_update_login = fnd_global.conc_login_id,
8194: ineffective_controls = greatest(0, ineffective_controls -1),
8195: ineffective_controls_prcnt = round( (greatest(0, m_item_ineff_ctrls -1))/decode(nvl(m_item_ctrls_total, 0), 0, 1, m_item_ctrls_total), 2)*100
8196: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID

Line 8193: last_update_login = fnd_global.conc_login_id,

8189: UPDATE AMW_FIN_CERT_EVAL_SUM
8190: SET
8191: last_update_date = sysdate,
8192: last_updated_by = fnd_global.user_id,
8193: last_update_login = fnd_global.conc_login_id,
8194: ineffective_controls = greatest(0, ineffective_controls -1),
8195: ineffective_controls_prcnt = round( (greatest(0, m_item_ineff_ctrls -1))/decode(nvl(m_item_ctrls_total, 0), 0, 1, m_item_ctrls_total), 2)*100
8196: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
8197: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID

Line 8214: last_updated_by = fnd_global.user_id,

8210: *************/
8211: UPDATE AMW_FIN_CERT_EVAL_SUM
8212: SET
8213: last_update_date = sysdate,
8214: last_updated_by = fnd_global.user_id,
8215: last_update_login = fnd_global.conc_login_id,
8216: ineffective_controls = least(ineffective_controls + 1, controls_verified),
8217: ineffective_controls_prcnt = round( (least(m_item_ineff_ctrls + 1, controls_verified))/decode(nvl(m_item_ctrls_total, 0), 0, 1, m_item_ctrls_total), 2)*100
8218: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID

Line 8215: last_update_login = fnd_global.conc_login_id,

8211: UPDATE AMW_FIN_CERT_EVAL_SUM
8212: SET
8213: last_update_date = sysdate,
8214: last_updated_by = fnd_global.user_id,
8215: last_update_login = fnd_global.conc_login_id,
8216: ineffective_controls = least(ineffective_controls + 1, controls_verified),
8217: ineffective_controls_prcnt = round( (least(m_item_ineff_ctrls + 1, controls_verified))/decode(nvl(m_item_ctrls_total, 0), 0, 1, m_item_ctrls_total), 2)*100
8218: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
8219: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID

Line 8258: last_updated_by = fnd_global.user_id,

8254:
8255: UPDATE AMW_FIN_ITEM_ACC_CTRL
8256: SET
8257: LAST_UPDATE_DATE = sysdate,
8258: last_updated_by = fnd_global.user_id,
8259: last_update_login = fnd_global.conc_login_id,
8260: OPINION_LOG_ID = P_opinion_log_id
8261: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
8262: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID

Line 8259: last_update_login = fnd_global.conc_login_id,

8255: UPDATE AMW_FIN_ITEM_ACC_CTRL
8256: SET
8257: LAST_UPDATE_DATE = sysdate,
8258: last_updated_by = fnd_global.user_id,
8259: last_update_login = fnd_global.conc_login_id,
8260: OPINION_LOG_ID = P_opinion_log_id
8261: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
8262: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
8263: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID

Line 8304: last_updated_by = fnd_global.user_id,

8300: ************/
8301: UPDATE AMW_FIN_CERT_EVAL_SUM
8302: SET
8303: last_update_date = sysdate,
8304: last_updated_by = fnd_global.user_id,
8305: last_update_login = fnd_global.conc_login_id,
8306: controls_verified = least(controls_verified + 1, total_number_of_ctrls )
8307: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
8308: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID

Line 8305: last_update_login = fnd_global.conc_login_id,

8301: UPDATE AMW_FIN_CERT_EVAL_SUM
8302: SET
8303: last_update_date = sysdate,
8304: last_updated_by = fnd_global.user_id,
8305: last_update_login = fnd_global.conc_login_id,
8306: controls_verified = least(controls_verified + 1, total_number_of_ctrls )
8307: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
8308: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
8309: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID

Line 8326: last_updated_by = fnd_global.user_id,

8322: ****************/
8323: UPDATE AMW_FIN_CERT_EVAL_SUM
8324: SET
8325: last_update_date = sysdate,
8326: last_updated_by = fnd_global.user_id,
8327: last_update_login = fnd_global.conc_login_id,
8328: ineffective_controls = greatest(0, ineffective_controls - 1),
8329: ineffective_controls_prcnt = round( (greatest(0, m_acc_ineff_ctrls - 1))/decode(nvl(m_acc_ctrls_total, 0), 0, 1, m_acc_ctrls_total), 2)*100
8330: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID

Line 8327: last_update_login = fnd_global.conc_login_id,

8323: UPDATE AMW_FIN_CERT_EVAL_SUM
8324: SET
8325: last_update_date = sysdate,
8326: last_updated_by = fnd_global.user_id,
8327: last_update_login = fnd_global.conc_login_id,
8328: ineffective_controls = greatest(0, ineffective_controls - 1),
8329: ineffective_controls_prcnt = round( (greatest(0, m_acc_ineff_ctrls - 1))/decode(nvl(m_acc_ctrls_total, 0), 0, 1, m_acc_ctrls_total), 2)*100
8330: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
8331: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID

Line 8348: last_updated_by = fnd_global.user_id,

8344: ***********/
8345: UPDATE AMW_FIN_CERT_EVAL_SUM
8346: SET
8347: last_update_date = sysdate,
8348: last_updated_by = fnd_global.user_id,
8349: last_update_login = fnd_global.conc_login_id,
8350: ineffective_controls = least(ineffective_controls + 1, controls_verified),
8351: ineffective_controls_prcnt = round( (least(m_acc_ineff_ctrls + 1, controls_verified)) /decode(nvl(m_acc_ctrls_total, 0), 0, 1, m_acc_ctrls_total), 2)*100
8352: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID

Line 8349: last_update_login = fnd_global.conc_login_id,

8345: UPDATE AMW_FIN_CERT_EVAL_SUM
8346: SET
8347: last_update_date = sysdate,
8348: last_updated_by = fnd_global.user_id,
8349: last_update_login = fnd_global.conc_login_id,
8350: ineffective_controls = least(ineffective_controls + 1, controls_verified),
8351: ineffective_controls_prcnt = round( (least(m_acc_ineff_ctrls + 1, controls_verified)) /decode(nvl(m_acc_ctrls_total, 0), 0, 1, m_acc_ctrls_total), 2)*100
8352: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
8353: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID

Line 8390: last_updated_by = fnd_global.user_id,

8386:
8387: UPDATE AMW_FIN_ITEM_ACC_CTRL
8388: SET
8389: LAST_UPDATE_DATE = sysdate,
8390: last_updated_by = fnd_global.user_id,
8391: last_update_login = fnd_global.conc_login_id,
8392: OPINION_LOG_ID = P_opinion_log_id
8393: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
8394: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID

Line 8391: last_update_login = fnd_global.conc_login_id,

8387: UPDATE AMW_FIN_ITEM_ACC_CTRL
8388: SET
8389: LAST_UPDATE_DATE = sysdate,
8390: last_updated_by = fnd_global.user_id,
8391: last_update_login = fnd_global.conc_login_id,
8392: OPINION_LOG_ID = P_opinion_log_id
8393: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
8394: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
8395: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID

Line 8440: last_updated_by = fnd_global.user_id,

8436: *************/
8437: UPDATE AMW_FIN_PROCESS_EVAL_SUM
8438: SET
8439: last_update_date = sysdate,
8440: last_updated_by = fnd_global.user_id,
8441: last_update_login = fnd_global.conc_login_id,
8442: controls_verified = least(controls_verified + 1, total_number_of_ctrls )
8443: WHERE FIN_CERTIFICATION_ID = get_all_fin_cert_rec.fin_certification_id
8444: AND ORGANIZATION_ID = p_org_id;

Line 8441: last_update_login = fnd_global.conc_login_id,

8437: UPDATE AMW_FIN_PROCESS_EVAL_SUM
8438: SET
8439: last_update_date = sysdate,
8440: last_updated_by = fnd_global.user_id,
8441: last_update_login = fnd_global.conc_login_id,
8442: controls_verified = least(controls_verified + 1, total_number_of_ctrls )
8443: WHERE FIN_CERTIFICATION_ID = get_all_fin_cert_rec.fin_certification_id
8444: AND ORGANIZATION_ID = p_org_id;
8445: --END IF;

Line 8458: last_updated_by = fnd_global.user_id,

8454: ***********/
8455: UPDATE AMW_FIN_ORG_EVAL_SUM
8456: SET
8457: LAST_UPDATE_DATE = sysdate,
8458: last_updated_by = fnd_global.user_id,
8459: last_update_login = fnd_global.conc_login_id,
8460: controls_verified = least(controls_verified + 1, total_number_of_ctrls )
8461: WHERE FIN_CERTIFICATION_ID = get_all_fin_cert_rec.fin_certification_id
8462: AND ORGANIZATION_ID = p_org_id;

Line 8459: last_update_login = fnd_global.conc_login_id,

8455: UPDATE AMW_FIN_ORG_EVAL_SUM
8456: SET
8457: LAST_UPDATE_DATE = sysdate,
8458: last_updated_by = fnd_global.user_id,
8459: last_update_login = fnd_global.conc_login_id,
8460: controls_verified = least(controls_verified + 1, total_number_of_ctrls )
8461: WHERE FIN_CERTIFICATION_ID = get_all_fin_cert_rec.fin_certification_id
8462: AND ORGANIZATION_ID = p_org_id;
8463: --END IF;

Line 8480: last_updated_by = fnd_global.user_id,

8476: *****************/
8477: UPDATE AMW_CERT_DASHBOARD_SUM
8478: SET
8479: LAST_UPDATE_DATE = sysdate,
8480: last_updated_by = fnd_global.user_id,
8481: last_update_login = fnd_global.conc_login_id,
8482: ineffective_controls = greatest(0, ineffective_controls - 1)
8483: WHERE CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id;
8484: -- END IF;

Line 8481: last_update_login = fnd_global.conc_login_id,

8477: UPDATE AMW_CERT_DASHBOARD_SUM
8478: SET
8479: LAST_UPDATE_DATE = sysdate,
8480: last_updated_by = fnd_global.user_id,
8481: last_update_login = fnd_global.conc_login_id,
8482: ineffective_controls = greatest(0, ineffective_controls - 1)
8483: WHERE CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id;
8484: -- END IF;
8485:

Line 8497: last_updated_by = fnd_global.user_id,

8493: ************/
8494: UPDATE AMW_FIN_PROCESS_EVAL_SUM
8495: SET
8496: LAST_UPDATE_DATE = sysdate,
8497: last_updated_by = fnd_global.user_id,
8498: last_update_login = fnd_global.conc_login_id,
8499: ineffective_controls = greatest(0, ineffective_controls - 1)
8500: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
8501: AND ORGANIZATION_ID = p_org_id;

Line 8498: last_update_login = fnd_global.conc_login_id,

8494: UPDATE AMW_FIN_PROCESS_EVAL_SUM
8495: SET
8496: LAST_UPDATE_DATE = sysdate,
8497: last_updated_by = fnd_global.user_id,
8498: last_update_login = fnd_global.conc_login_id,
8499: ineffective_controls = greatest(0, ineffective_controls - 1)
8500: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
8501: AND ORGANIZATION_ID = p_org_id;
8502: --END IF;

Line 8515: last_updated_by = fnd_global.user_id,

8511: ************/
8512: UPDATE AMW_FIN_ORG_EVAL_SUM
8513: SET
8514: last_update_date = sysdate,
8515: last_updated_by = fnd_global.user_id,
8516: last_update_login = fnd_global.conc_login_id,
8517: ineffective_controls = greatest(0, ineffective_controls - 1),
8518: ineffective_controls_prcnt = round( (greatest(0, m_org_ineff_ctrls - 1))/decode(nvl(m_org_ctrls_total, 0), 0, 1, m_org_ctrls_total), 2)*100
8519: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id

Line 8516: last_update_login = fnd_global.conc_login_id,

8512: UPDATE AMW_FIN_ORG_EVAL_SUM
8513: SET
8514: last_update_date = sysdate,
8515: last_updated_by = fnd_global.user_id,
8516: last_update_login = fnd_global.conc_login_id,
8517: ineffective_controls = greatest(0, ineffective_controls - 1),
8518: ineffective_controls_prcnt = round( (greatest(0, m_org_ineff_ctrls - 1))/decode(nvl(m_org_ctrls_total, 0), 0, 1, m_org_ctrls_total), 2)*100
8519: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
8520: AND ORGANIZATION_ID = p_org_id;

Line 8528: last_updated_by = fnd_global.user_id,

8524:
8525: UPDATE AMW_CERT_DASHBOARD_SUM
8526: SET
8527: last_update_date = sysdate,
8528: last_updated_by = fnd_global.user_id,
8529: last_update_login = fnd_global.conc_login_id,
8530: ineffective_controls = ineffective_controls + 1
8531: WHERE CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id;
8532:

Line 8529: last_update_login = fnd_global.conc_login_id,

8525: UPDATE AMW_CERT_DASHBOARD_SUM
8526: SET
8527: last_update_date = sysdate,
8528: last_updated_by = fnd_global.user_id,
8529: last_update_login = fnd_global.conc_login_id,
8530: ineffective_controls = ineffective_controls + 1
8531: WHERE CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id;
8532:
8533: /********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b

Line 8544: last_updated_by = fnd_global.user_id,

8540: ***********/
8541: UPDATE AMW_FIN_ORG_EVAL_SUM
8542: SET
8543: last_update_date = sysdate,
8544: last_updated_by = fnd_global.user_id,
8545: last_update_login = fnd_global.conc_login_id,
8546: ineffective_controls = least(ineffective_controls + 1, controls_verified),
8547: ineffective_controls_prcnt = round((least(m_org_ineff_ctrls + 1, controls_verified))/decode(nvl(m_org_ctrls_total, 0), 0, 1, m_org_ctrls_total), 2)*100
8548: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id

Line 8545: last_update_login = fnd_global.conc_login_id,

8541: UPDATE AMW_FIN_ORG_EVAL_SUM
8542: SET
8543: last_update_date = sysdate,
8544: last_updated_by = fnd_global.user_id,
8545: last_update_login = fnd_global.conc_login_id,
8546: ineffective_controls = least(ineffective_controls + 1, controls_verified),
8547: ineffective_controls_prcnt = round((least(m_org_ineff_ctrls + 1, controls_verified))/decode(nvl(m_org_ctrls_total, 0), 0, 1, m_org_ctrls_total), 2)*100
8548: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
8549: AND ORGANIZATION_ID = p_org_id;

Line 8563: last_updated_by = fnd_global.user_id,

8559: ********/
8560: UPDATE AMW_FIN_PROCESS_EVAL_SUM
8561: SET
8562: last_update_date = sysdate,
8563: last_updated_by = fnd_global.user_id,
8564: last_update_login = fnd_global.conc_login_id,
8565: ineffective_controls = least(ineffective_controls + 1, controls_verified),
8566: ineffective_controls_prcnt = round((least(ineffective_controls + 1, controls_verified))/decode(nvl(total_number_of_ctrls , 0), 0, 1, total_number_of_ctrls), 2)*100
8567: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id

Line 8564: last_update_login = fnd_global.conc_login_id,

8560: UPDATE AMW_FIN_PROCESS_EVAL_SUM
8561: SET
8562: last_update_date = sysdate,
8563: last_updated_by = fnd_global.user_id,
8564: last_update_login = fnd_global.conc_login_id,
8565: ineffective_controls = least(ineffective_controls + 1, controls_verified),
8566: ineffective_controls_prcnt = round((least(ineffective_controls + 1, controls_verified))/decode(nvl(total_number_of_ctrls , 0), 0, 1, total_number_of_ctrls), 2)*100
8567: WHERE FIN_CERTIFICATION_ID = Get_all_fin_cert_Rec.fin_certification_id
8568: AND ORGANIZATION_ID = p_org_id;

Line 8854: last_updated_by = fnd_global.user_id,

8850: UPDATE AMW_FIN_CERT_EVAL_SUM
8851: SET
8852: proc_evaluated = least(proc_evaluated + 1,total_number_of_processes),
8853: last_update_date = sysdate,
8854: last_updated_by = fnd_global.user_id,
8855: last_update_login = fnd_global.conc_login_id
8856: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
8857: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
8858: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID

Line 8855: last_update_login = fnd_global.conc_login_id

8851: SET
8852: proc_evaluated = least(proc_evaluated + 1,total_number_of_processes),
8853: last_update_date = sysdate,
8854: last_updated_by = fnd_global.user_id,
8855: last_update_login = fnd_global.conc_login_id
8856: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
8857: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
8858: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID
8859: AND OBJECT_TYPE = 'FINANCIAL ITEM';

Line 8879: last_updated_by = fnd_global.user_id,

8875: SET
8876: proc_with_ineffective_controls = least(proc_with_ineffective_controls + 1, controls_verified),
8877: proc_with_ineff_controls_prcnt = round( (least(m_item_proc_with_ineff_ctrl + 1, controls_verified))/decode(nvl(m_item_total_number_process, 0), 0, 1, m_item_total_number_process), 2) * 100,
8878: last_update_date = sysdate,
8879: last_updated_by = fnd_global.user_id,
8880: last_update_login = fnd_global.conc_login_id
8881: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
8882: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
8883: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID

Line 8880: last_update_login = fnd_global.conc_login_id

8876: proc_with_ineffective_controls = least(proc_with_ineffective_controls + 1, controls_verified),
8877: proc_with_ineff_controls_prcnt = round( (least(m_item_proc_with_ineff_ctrl + 1, controls_verified))/decode(nvl(m_item_total_number_process, 0), 0, 1, m_item_total_number_process), 2) * 100,
8878: last_update_date = sysdate,
8879: last_updated_by = fnd_global.user_id,
8880: last_update_login = fnd_global.conc_login_id
8881: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
8882: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
8883: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID
8884: AND OBJECT_TYPE = 'FINANCIAL ITEM';

Line 8901: last_updated_by = fnd_global.user_id,

8897: SET
8898: proc_with_ineffective_controls = greatest(0, proc_with_ineffective_controls - 1),
8899: proc_with_ineff_controls_prcnt = round( (greatest(0,m_item_proc_with_ineff_ctrl - 1))/decode(nvl(m_item_total_number_process, 0), 0, 1, m_item_total_number_process), 2) * 100,
8900: last_update_date = sysdate,
8901: last_updated_by = fnd_global.user_id,
8902: last_update_login = fnd_global.conc_login_id
8903: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
8904: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
8905: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID

Line 8902: last_update_login = fnd_global.conc_login_id

8898: proc_with_ineffective_controls = greatest(0, proc_with_ineffective_controls - 1),
8899: proc_with_ineff_controls_prcnt = round( (greatest(0,m_item_proc_with_ineff_ctrl - 1))/decode(nvl(m_item_total_number_process, 0), 0, 1, m_item_total_number_process), 2) * 100,
8900: last_update_date = sysdate,
8901: last_updated_by = fnd_global.user_id,
8902: last_update_login = fnd_global.conc_login_id
8903: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
8904: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
8905: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID
8906: AND OBJECT_TYPE = 'FINANCIAL ITEM';

Line 8949: last_updated_by = fnd_global.user_id,

8945: UPDATE AMW_FIN_CERT_EVAL_SUM
8946: SET
8947: proc_evaluated = least(proc_evaluated + 1, total_number_of_processes),
8948: last_update_date = sysdate,
8949: last_updated_by = fnd_global.user_id,
8950: last_update_login = fnd_global.conc_login_id
8951: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
8952: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
8953: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID

Line 8950: last_update_login = fnd_global.conc_login_id

8946: SET
8947: proc_evaluated = least(proc_evaluated + 1, total_number_of_processes),
8948: last_update_date = sysdate,
8949: last_updated_by = fnd_global.user_id,
8950: last_update_login = fnd_global.conc_login_id
8951: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
8952: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
8953: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID
8954: AND OBJECT_TYPE = 'ACCOUNT';

Line 8972: last_updated_by = fnd_global.user_id,

8968: SET
8969: proc_with_ineffective_controls = least(proc_with_ineffective_controls + 1,controls_verified),
8970: proc_with_ineff_controls_prcnt = round( (least(m_item_proc_with_ineff_ctrl + 1, controls_verified))/decode(nvl(m_acc_total_number_process, 0), 0, 1, m_acc_total_number_process), 2) * 100,
8971: last_update_date = sysdate,
8972: last_updated_by = fnd_global.user_id,
8973: last_update_login = fnd_global.conc_login_id
8974: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
8975: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
8976: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID

Line 8973: last_update_login = fnd_global.conc_login_id

8969: proc_with_ineffective_controls = least(proc_with_ineffective_controls + 1,controls_verified),
8970: proc_with_ineff_controls_prcnt = round( (least(m_item_proc_with_ineff_ctrl + 1, controls_verified))/decode(nvl(m_acc_total_number_process, 0), 0, 1, m_acc_total_number_process), 2) * 100,
8971: last_update_date = sysdate,
8972: last_updated_by = fnd_global.user_id,
8973: last_update_login = fnd_global.conc_login_id
8974: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
8975: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
8976: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID
8977: AND OBJECT_TYPE = 'ACCOUNT';

Line 8994: last_updated_by = fnd_global.user_id,

8990: SET
8991: proc_with_ineffective_controls = greatest(0,proc_with_ineffective_controls - 1),
8992: proc_with_ineff_controls_prcnt = round( (greatest(0,m_acc_proc_with_ineff_ctrl - 1))/decode(nvl(m_acc_total_number_process, 0), 0, 1, m_acc_total_number_process), 2) * 100,
8993: last_update_date = sysdate,
8994: last_updated_by = fnd_global.user_id,
8995: last_update_login = fnd_global.conc_login_id
8996: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
8997: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
8998: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID

Line 8995: last_update_login = fnd_global.conc_login_id

8991: proc_with_ineffective_controls = greatest(0,proc_with_ineffective_controls - 1),
8992: proc_with_ineff_controls_prcnt = round( (greatest(0,m_acc_proc_with_ineff_ctrl - 1))/decode(nvl(m_acc_total_number_process, 0), 0, 1, m_acc_total_number_process), 2) * 100,
8993: last_update_date = sysdate,
8994: last_updated_by = fnd_global.user_id,
8995: last_update_login = fnd_global.conc_login_id
8996: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
8997: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
8998: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID
8999: AND OBJECT_TYPE = 'ACCOUNT';

Line 9036: last_updated_by = fnd_global.user_id,

9032: ELSE
9033: ***********/
9034: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9035: LAST_UPDATE_DATE = sysdate,
9036: last_updated_by = fnd_global.user_id,
9037: last_update_login = fnd_global.conc_login_id,
9038: proc_verified = least(proc_verified + 1, total_number_of_procs )
9039: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID
9040: AND ORGANIZATION_ID = p_org_id;

Line 9037: last_update_login = fnd_global.conc_login_id,

9033: ***********/
9034: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9035: LAST_UPDATE_DATE = sysdate,
9036: last_updated_by = fnd_global.user_id,
9037: last_update_login = fnd_global.conc_login_id,
9038: proc_verified = least(proc_verified + 1, total_number_of_procs )
9039: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID
9040: AND ORGANIZATION_ID = p_org_id;
9041: --END IF;

Line 9056: last_updated_by = fnd_global.user_id,

9052: ELSE
9053: *************/
9054: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9055: last_update_date = sysdate,
9056: last_updated_by = fnd_global.user_id,
9057: last_update_login = fnd_global.conc_login_id,
9058: proc_verified = least(proc_verified + 1,total_number_of_procs),
9059: proc_with_ineffective_controls = least(proc_with_ineffective_controls + 1,proc_verified),
9060: proc_with_ineff_controls_prcnt = round( (least(proc_with_ineffective_controls + 1, proc_verified))/decode(nvl(total_number_of_procs, 0), 0, 1, total_number_of_procs), 2)*100

Line 9057: last_update_login = fnd_global.conc_login_id,

9053: *************/
9054: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9055: last_update_date = sysdate,
9056: last_updated_by = fnd_global.user_id,
9057: last_update_login = fnd_global.conc_login_id,
9058: proc_verified = least(proc_verified + 1,total_number_of_procs),
9059: proc_with_ineffective_controls = least(proc_with_ineffective_controls + 1,proc_verified),
9060: proc_with_ineff_controls_prcnt = round( (least(proc_with_ineffective_controls + 1, proc_verified))/decode(nvl(total_number_of_procs, 0), 0, 1, total_number_of_procs), 2)*100
9061: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID

Line 9068: last_updated_by = fnd_global.user_id,

9064:
9065: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
9066: UPDATE amw_cert_dashboard_sum
9067: SET last_update_date = sysdate,
9068: last_updated_by = fnd_global.user_id,
9069: last_update_login = fnd_global.conc_login_id,
9070: proc_ineff_control = proc_ineff_control+1
9071: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9072: ELSE

Line 9069: last_update_login = fnd_global.conc_login_id,

9065: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
9066: UPDATE amw_cert_dashboard_sum
9067: SET last_update_date = sysdate,
9068: last_updated_by = fnd_global.user_id,
9069: last_update_login = fnd_global.conc_login_id,
9070: proc_ineff_control = proc_ineff_control+1
9071: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9072: ELSE
9073: UPDATE amw_cert_dashboard_sum

Line 9075: last_updated_by = fnd_global.user_id,

9071: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9072: ELSE
9073: UPDATE amw_cert_dashboard_sum
9074: SET last_update_date = sysdate,
9075: last_updated_by = fnd_global.user_id,
9076: last_update_login = fnd_global.conc_login_id,
9077: org_proc_ineff_control = org_proc_ineff_control+1
9078: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9079: END IF;

Line 9076: last_update_login = fnd_global.conc_login_id,

9072: ELSE
9073: UPDATE amw_cert_dashboard_sum
9074: SET last_update_date = sysdate,
9075: last_updated_by = fnd_global.user_id,
9076: last_update_login = fnd_global.conc_login_id,
9077: org_proc_ineff_control = org_proc_ineff_control+1
9078: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9079: END IF;
9080:

Line 9092: last_updated_by = fnd_global.user_id,

9088: ELSE
9089: ****************/
9090: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9091: last_update_date = sysdate,
9092: last_updated_by = fnd_global.user_id,
9093: last_update_login = fnd_global.conc_login_id,
9094: proc_with_ineffective_controls = greatest(0, proc_with_ineffective_controls - 1),
9095: proc_with_ineff_controls_prcnt = round( (greatest(0, proc_with_ineffective_controls - 1))/decode(nvl(total_number_of_procs, 0), 0, 1, total_number_of_procs), 2)*100
9096: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID

Line 9093: last_update_login = fnd_global.conc_login_id,

9089: ****************/
9090: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9091: last_update_date = sysdate,
9092: last_updated_by = fnd_global.user_id,
9093: last_update_login = fnd_global.conc_login_id,
9094: proc_with_ineffective_controls = greatest(0, proc_with_ineffective_controls - 1),
9095: proc_with_ineff_controls_prcnt = round( (greatest(0, proc_with_ineffective_controls - 1))/decode(nvl(total_number_of_procs, 0), 0, 1, total_number_of_procs), 2)*100
9096: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID
9097: AND ORGANIZATION_ID = p_org_id;

Line 9110: last_updated_by = fnd_global.user_id,

9106: ELSE
9107: ***********/
9108: UPDATE amw_cert_dashboard_sum
9109: SET last_update_date = sysdate,
9110: last_updated_by = fnd_global.user_id,
9111: last_update_login = fnd_global.conc_login_id,
9112: proc_ineff_control = greatest(0,proc_ineff_control-1)
9113: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9114: -- END IF;

Line 9111: last_update_login = fnd_global.conc_login_id,

9107: ***********/
9108: UPDATE amw_cert_dashboard_sum
9109: SET last_update_date = sysdate,
9110: last_updated_by = fnd_global.user_id,
9111: last_update_login = fnd_global.conc_login_id,
9112: proc_ineff_control = greatest(0,proc_ineff_control-1)
9113: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9114: -- END IF;
9115: ELSE

Line 9126: last_updated_by = fnd_global.user_id,

9122: ELSE
9123: *************/
9124: UPDATE amw_cert_dashboard_sum
9125: SET last_update_date = sysdate,
9126: last_updated_by = fnd_global.user_id,
9127: last_update_login = fnd_global.conc_login_id,
9128: org_proc_ineff_control = greatest(0, org_proc_ineff_control-1)
9129: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9130: -- END IF;

Line 9127: last_update_login = fnd_global.conc_login_id,

9123: *************/
9124: UPDATE amw_cert_dashboard_sum
9125: SET last_update_date = sysdate,
9126: last_updated_by = fnd_global.user_id,
9127: last_update_login = fnd_global.conc_login_id,
9128: org_proc_ineff_control = greatest(0, org_proc_ineff_control-1)
9129: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9130: -- END IF;
9131: END IF;

Line 9143: last_updated_by = fnd_global.user_id,

9139: ELSE
9140: **************/
9141: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9142: last_update_date = sysdate,
9143: last_updated_by = fnd_global.user_id,
9144: last_update_login = fnd_global.conc_login_id,
9145: proc_with_ineffective_controls = least(proc_with_ineffective_controls + 1, proc_verified),
9146: proc_with_ineff_controls_prcnt = round( (least(proc_with_ineffective_controls + 1, proc_verified) )/decode(nvl(total_number_of_procs, 0), 0, 1, total_number_of_procs), 2)*100
9147: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID

Line 9144: last_update_login = fnd_global.conc_login_id,

9140: **************/
9141: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9142: last_update_date = sysdate,
9143: last_updated_by = fnd_global.user_id,
9144: last_update_login = fnd_global.conc_login_id,
9145: proc_with_ineffective_controls = least(proc_with_ineffective_controls + 1, proc_verified),
9146: proc_with_ineff_controls_prcnt = round( (least(proc_with_ineffective_controls + 1, proc_verified) )/decode(nvl(total_number_of_procs, 0), 0, 1, total_number_of_procs), 2)*100
9147: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID
9148: AND ORGANIZATION_ID = p_org_id;

Line 9154: last_updated_by = fnd_global.user_id,

9150:
9151: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
9152: UPDATE amw_cert_dashboard_sum
9153: SET last_update_date = sysdate,
9154: last_updated_by = fnd_global.user_id,
9155: last_update_login = fnd_global.conc_login_id,
9156: proc_ineff_control = proc_ineff_control + 1
9157: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9158: ELSE

Line 9155: last_update_login = fnd_global.conc_login_id,

9151: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
9152: UPDATE amw_cert_dashboard_sum
9153: SET last_update_date = sysdate,
9154: last_updated_by = fnd_global.user_id,
9155: last_update_login = fnd_global.conc_login_id,
9156: proc_ineff_control = proc_ineff_control + 1
9157: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9158: ELSE
9159: UPDATE amw_cert_dashboard_sum

Line 9161: last_updated_by = fnd_global.user_id,

9157: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9158: ELSE
9159: UPDATE amw_cert_dashboard_sum
9160: SET last_update_date = sysdate,
9161: last_updated_by = fnd_global.user_id,
9162: last_update_login = fnd_global.conc_login_id,
9163: org_proc_ineff_control = org_proc_ineff_control + 1
9164: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9165: END IF;

Line 9162: last_update_login = fnd_global.conc_login_id,

9158: ELSE
9159: UPDATE amw_cert_dashboard_sum
9160: SET last_update_date = sysdate,
9161: last_updated_by = fnd_global.user_id,
9162: last_update_login = fnd_global.conc_login_id,
9163: org_proc_ineff_control = org_proc_ineff_control + 1
9164: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9165: END IF;
9166:

Line 9208: last_updated_by = fnd_global.user_id,

9204: ELSE
9205: ***********/
9206: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9207: last_update_date = sysdate,
9208: last_updated_by = fnd_global.user_id,
9209: last_update_login = fnd_global.conc_login_id,
9210: proc_pending_certification = greatest(0, proc_pending_certification - 1),
9211: procs_for_cert_done = least(procs_for_cert_done + 1, total_number_of_processes ),
9212: pro_pending_cert_prcnt = round( (greatest(0,proc_pending_certification -1) )/decode(nvl(total_number_of_processes, 0), 0, 1, total_number_of_processes) ,2)*100

Line 9209: last_update_login = fnd_global.conc_login_id,

9205: ***********/
9206: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9207: last_update_date = sysdate,
9208: last_updated_by = fnd_global.user_id,
9209: last_update_login = fnd_global.conc_login_id,
9210: proc_pending_certification = greatest(0, proc_pending_certification - 1),
9211: procs_for_cert_done = least(procs_for_cert_done + 1, total_number_of_processes ),
9212: pro_pending_cert_prcnt = round( (greatest(0,proc_pending_certification -1) )/decode(nvl(total_number_of_processes, 0), 0, 1, total_number_of_processes) ,2)*100
9213: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID

Line 9232: last_updated_by = fnd_global.user_id,

9228: ELSE
9229: *************/
9230: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9231: last_update_date = sysdate,
9232: last_updated_by = fnd_global.user_id,
9233: last_update_login = fnd_global.conc_login_id,
9234: proc_certified_with_issues = least(0,proc_certified_with_issues -1),
9235: processes_with_issues_prcnt = round( (least(0, m_item_proc_cert_with_issue -1))/decode(nvl(m_item_total_number_process, 0), 0, 1, m_item_total_number_process), 2)*100
9236: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID

Line 9233: last_update_login = fnd_global.conc_login_id,

9229: *************/
9230: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9231: last_update_date = sysdate,
9232: last_updated_by = fnd_global.user_id,
9233: last_update_login = fnd_global.conc_login_id,
9234: proc_certified_with_issues = least(0,proc_certified_with_issues -1),
9235: processes_with_issues_prcnt = round( (least(0, m_item_proc_cert_with_issue -1))/decode(nvl(m_item_total_number_process, 0), 0, 1, m_item_total_number_process), 2)*100
9236: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
9237: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID

Line 9254: last_updated_by = fnd_global.user_id,

9250: ELSE
9251: ****************/
9252: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9253: last_update_date = sysdate,
9254: last_updated_by = fnd_global.user_id,
9255: last_update_login = fnd_global.conc_login_id,
9256: proc_certified_with_issues = least(proc_certified_with_issues + 1, total_number_of_processes ),
9257: processes_with_issues_prcnt = round( (least(m_item_proc_cert_with_issue + 1, total_number_of_processes))/decode(nvl(m_item_total_number_process, 0), 0, 1, m_item_total_number_process), 2)*100
9258: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID

Line 9255: last_update_login = fnd_global.conc_login_id,

9251: ****************/
9252: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9253: last_update_date = sysdate,
9254: last_updated_by = fnd_global.user_id,
9255: last_update_login = fnd_global.conc_login_id,
9256: proc_certified_with_issues = least(proc_certified_with_issues + 1, total_number_of_processes ),
9257: processes_with_issues_prcnt = round( (least(m_item_proc_cert_with_issue + 1, total_number_of_processes))/decode(nvl(m_item_total_number_process, 0), 0, 1, m_item_total_number_process), 2)*100
9258: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
9259: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID

Line 9302: last_updated_by = fnd_global.user_id,

9298: ELSE
9299: ***************/
9300: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9301: last_update_date = sysdate,
9302: last_updated_by = fnd_global.user_id,
9303: last_update_login = fnd_global.conc_login_id,
9304: proc_pending_certification = greatest(0, proc_pending_certification - 1),
9305: procs_for_cert_done = least(procs_for_cert_done + 1,total_number_of_processes),
9306: pro_pending_cert_prcnt = round( (greatest(0,proc_pending_certification -1))/decode(nvl(total_number_of_processes, 0), 0, 1, total_number_of_processes), 2)*100

Line 9303: last_update_login = fnd_global.conc_login_id,

9299: ***************/
9300: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9301: last_update_date = sysdate,
9302: last_updated_by = fnd_global.user_id,
9303: last_update_login = fnd_global.conc_login_id,
9304: proc_pending_certification = greatest(0, proc_pending_certification - 1),
9305: procs_for_cert_done = least(procs_for_cert_done + 1,total_number_of_processes),
9306: pro_pending_cert_prcnt = round( (greatest(0,proc_pending_certification -1))/decode(nvl(total_number_of_processes, 0), 0, 1, total_number_of_processes), 2)*100
9307: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID

Line 9324: last_updated_by = fnd_global.user_id,

9320: ELSE
9321: ***********/
9322: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9323: last_update_date = sysdate,
9324: last_updated_by = fnd_global.user_id,
9325: last_update_login = fnd_global.conc_login_id,
9326: proc_certified_with_issues = greatest(0,proc_certified_with_issues -1),
9327: processes_with_issues_prcnt = round( (greatest(0,m_acc_proc_cert_with_issue -1))/decode(nvl(m_acc_total_number_process, 0), 0, 1, m_acc_total_number_process), 2)*100
9328: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID

Line 9325: last_update_login = fnd_global.conc_login_id,

9321: ***********/
9322: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9323: last_update_date = sysdate,
9324: last_updated_by = fnd_global.user_id,
9325: last_update_login = fnd_global.conc_login_id,
9326: proc_certified_with_issues = greatest(0,proc_certified_with_issues -1),
9327: processes_with_issues_prcnt = round( (greatest(0,m_acc_proc_cert_with_issue -1))/decode(nvl(m_acc_total_number_process, 0), 0, 1, m_acc_total_number_process), 2)*100
9328: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
9329: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID

Line 9345: last_updated_by = fnd_global.user_id,

9341: ELSE
9342: ********************/
9343: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9344: last_update_date = sysdate,
9345: last_updated_by = fnd_global.user_id,
9346: last_update_login = fnd_global.conc_login_id,
9347: proc_certified_with_issues = least(proc_certified_with_issues + 1,total_number_of_processes),
9348: processes_with_issues_prcnt = round( (least(m_acc_proc_cert_with_issue + 1, total_number_of_processes))/decode(nvl(m_acc_total_number_process, 0), 0, 1, m_acc_total_number_process), 2)*100
9349: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID

Line 9346: last_update_login = fnd_global.conc_login_id,

9342: ********************/
9343: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9344: last_update_date = sysdate,
9345: last_updated_by = fnd_global.user_id,
9346: last_update_login = fnd_global.conc_login_id,
9347: proc_certified_with_issues = least(proc_certified_with_issues + 1,total_number_of_processes),
9348: processes_with_issues_prcnt = round( (least(m_acc_proc_cert_with_issue + 1, total_number_of_processes))/decode(nvl(m_acc_total_number_process, 0), 0, 1, m_acc_total_number_process), 2)*100
9349: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
9350: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID

Line 9393: last_updated_by = fnd_global.user_id,

9389: ELSE
9390: *****************/
9391: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9392: last_update_date = sysdate,
9393: last_updated_by = fnd_global.user_id,
9394: last_update_login = fnd_global.conc_login_id,
9395: proc_certified = least(proc_certified + 1,total_number_of_procs ),
9396: proc_pending_certification = greatest(0, proc_pending_certification - 1)
9397: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID

Line 9394: last_update_login = fnd_global.conc_login_id,

9390: *****************/
9391: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9392: last_update_date = sysdate,
9393: last_updated_by = fnd_global.user_id,
9394: last_update_login = fnd_global.conc_login_id,
9395: proc_certified = least(proc_certified + 1,total_number_of_procs ),
9396: proc_pending_certification = greatest(0, proc_pending_certification - 1)
9397: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID
9398: AND ORGANIZATION_ID = p_org_id;

Line 9416: last_updated_by = fnd_global.user_id,

9412: ELSE
9413: **************/
9414: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9415: last_update_date = sysdate,
9416: last_updated_by = fnd_global.user_id,
9417: last_update_login = fnd_global.conc_login_id,
9418: proc_certified = least(proc_certified + 1,total_number_of_procs),
9419: proc_pending_certification = greatest(0, proc_pending_certification - 1),
9420: proc_certified_with_issues = least(proc_certified_with_issues + 1, proc_certified),

Line 9417: last_update_login = fnd_global.conc_login_id,

9413: **************/
9414: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9415: last_update_date = sysdate,
9416: last_updated_by = fnd_global.user_id,
9417: last_update_login = fnd_global.conc_login_id,
9418: proc_certified = least(proc_certified + 1,total_number_of_procs),
9419: proc_pending_certification = greatest(0, proc_pending_certification - 1),
9420: proc_certified_with_issues = least(proc_certified_with_issues + 1, proc_certified),
9421: proc_pending_cert_prcnt = round( (least(proc_pending_certification + 1, total_number_of_procs))/decode(nvl(total_number_of_procs, 0), 0, 1, total_number_of_procs), 2)*100,

Line 9437: last_updated_by = fnd_global.user_id,

9433: ELSE
9434: *******************/
9435: UPDATE amw_cert_dashboard_sum
9436: SET last_update_date = sysdate,
9437: last_updated_by = fnd_global.user_id,
9438: last_update_login = fnd_global.conc_login_id,
9439: processes_cert_issues = processes_cert_issues +1,
9440: processes_not_cert = processes_not_cert - 1
9441: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;

Line 9438: last_update_login = fnd_global.conc_login_id,

9434: *******************/
9435: UPDATE amw_cert_dashboard_sum
9436: SET last_update_date = sysdate,
9437: last_updated_by = fnd_global.user_id,
9438: last_update_login = fnd_global.conc_login_id,
9439: processes_cert_issues = processes_cert_issues +1,
9440: processes_not_cert = processes_not_cert - 1
9441: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9442: -- END IF;

Line 9454: last_updated_by = fnd_global.user_id,

9450: ELSE
9451: ***************/
9452: UPDATE amw_cert_dashboard_sum
9453: SET last_update_date = sysdate,
9454: last_updated_by = fnd_global.user_id,
9455: last_update_login = fnd_global.conc_login_id,
9456: org_process_cert_issues = org_process_cert_issues+1,
9457: org_process_not_cert = greatest(0, org_process_not_cert -1)
9458: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;

Line 9455: last_update_login = fnd_global.conc_login_id,

9451: ***************/
9452: UPDATE amw_cert_dashboard_sum
9453: SET last_update_date = sysdate,
9454: last_updated_by = fnd_global.user_id,
9455: last_update_login = fnd_global.conc_login_id,
9456: org_process_cert_issues = org_process_cert_issues+1,
9457: org_process_not_cert = greatest(0, org_process_not_cert -1)
9458: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9459: -- END IF;

Line 9472: last_updated_by = fnd_global.user_id,

9468: ELSE
9469: *************/
9470: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9471: last_update_date = sysdate,
9472: last_updated_by = fnd_global.user_id,
9473: last_update_login = fnd_global.conc_login_id,
9474: proc_certified_with_issues = greatest(0, proc_certified_with_issues - 1),
9475: processes_with_issues_prcnt = round( (greatest(0, proc_certified_with_issues - 1))/decode(nvl(total_number_of_procs, 0), 0, 1, total_number_of_procs), 2)*100
9476: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID

Line 9473: last_update_login = fnd_global.conc_login_id,

9469: *************/
9470: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9471: last_update_date = sysdate,
9472: last_updated_by = fnd_global.user_id,
9473: last_update_login = fnd_global.conc_login_id,
9474: proc_certified_with_issues = greatest(0, proc_certified_with_issues - 1),
9475: processes_with_issues_prcnt = round( (greatest(0, proc_certified_with_issues - 1))/decode(nvl(total_number_of_procs, 0), 0, 1, total_number_of_procs), 2)*100
9476: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID
9477: AND ORGANIZATION_ID = p_org_id;

Line 9490: last_updated_by = fnd_global.user_id,

9486: ELSE
9487: *****************/
9488: UPDATE amw_cert_dashboard_sum
9489: set last_update_date = sysdate,
9490: last_updated_by = fnd_global.user_id,
9491: last_update_login = fnd_global.conc_login_id,
9492: processes_cert_issues = greatest(0, processes_cert_issues - 1)
9493: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9494: --END IF;

Line 9491: last_update_login = fnd_global.conc_login_id,

9487: *****************/
9488: UPDATE amw_cert_dashboard_sum
9489: set last_update_date = sysdate,
9490: last_updated_by = fnd_global.user_id,
9491: last_update_login = fnd_global.conc_login_id,
9492: processes_cert_issues = greatest(0, processes_cert_issues - 1)
9493: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9494: --END IF;
9495: ELSE

Line 9506: last_updated_by = fnd_global.user_id,

9502: ELSE
9503: ****************/
9504: UPDATE amw_cert_dashboard_sum
9505: set last_update_date = sysdate,
9506: last_updated_by = fnd_global.user_id,
9507: last_update_login = fnd_global.conc_login_id,
9508: org_process_cert_issues = greatest(0, org_process_cert_issues - 1)
9509: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9510: -- END IF;

Line 9507: last_update_login = fnd_global.conc_login_id,

9503: ****************/
9504: UPDATE amw_cert_dashboard_sum
9505: set last_update_date = sysdate,
9506: last_updated_by = fnd_global.user_id,
9507: last_update_login = fnd_global.conc_login_id,
9508: org_process_cert_issues = greatest(0, org_process_cert_issues - 1)
9509: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9510: -- END IF;
9511: END IF;

Line 9523: last_updated_by = fnd_global.user_id,

9519: ELSE
9520: ***************/
9521: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9522: last_update_date = sysdate,
9523: last_updated_by = fnd_global.user_id,
9524: last_update_login = fnd_global.conc_login_id,
9525: proc_certified_with_issues = least(proc_certified_with_issues + 1, total_number_of_procs),
9526: processes_with_issues_prcnt = round( (least(proc_certified_with_issues + 1, total_number_of_procs))/decode(nvl(total_number_of_procs, 0), 0, 1, total_number_of_procs), 2)*100
9527: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID

Line 9524: last_update_login = fnd_global.conc_login_id,

9520: ***************/
9521: UPDATE AMW_FIN_ORG_EVAL_SUM SET
9522: last_update_date = sysdate,
9523: last_updated_by = fnd_global.user_id,
9524: last_update_login = fnd_global.conc_login_id,
9525: proc_certified_with_issues = least(proc_certified_with_issues + 1, total_number_of_procs),
9526: processes_with_issues_prcnt = round( (least(proc_certified_with_issues + 1, total_number_of_procs))/decode(nvl(total_number_of_procs, 0), 0, 1, total_number_of_procs), 2)*100
9527: WHERE FIN_CERTIFICATION_ID = Get_All_Org_Cert_Rec.FIN_CERTIFICATION_ID
9528: AND ORGANIZATION_ID = p_org_id;

Line 9533: last_updated_by = fnd_global.user_id,

9529: --END IF;
9530: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
9531: UPDATE amw_cert_dashboard_sum
9532: SET last_update_date = sysdate,
9533: last_updated_by = fnd_global.user_id,
9534: last_update_login = fnd_global.conc_login_id,
9535: processes_cert_issues = processes_cert_issues + 1
9536: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9537: ELSE

Line 9534: last_update_login = fnd_global.conc_login_id,

9530: IF p_org_id = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
9531: UPDATE amw_cert_dashboard_sum
9532: SET last_update_date = sysdate,
9533: last_updated_by = fnd_global.user_id,
9534: last_update_login = fnd_global.conc_login_id,
9535: processes_cert_issues = processes_cert_issues + 1
9536: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9537: ELSE
9538: UPDATE amw_cert_dashboard_sum

Line 9540: last_updated_by = fnd_global.user_id,

9536: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9537: ELSE
9538: UPDATE amw_cert_dashboard_sum
9539: SET last_update_date = sysdate,
9540: last_updated_by = fnd_global.user_id,
9541: last_update_login = fnd_global.conc_login_id,
9542: org_process_cert_issues = greatest(0, org_process_cert_issues - 1)
9543: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9544: END IF;

Line 9541: last_update_login = fnd_global.conc_login_id,

9537: ELSE
9538: UPDATE amw_cert_dashboard_sum
9539: SET last_update_date = sysdate,
9540: last_updated_by = fnd_global.user_id,
9541: last_update_login = fnd_global.conc_login_id,
9542: org_process_cert_issues = greatest(0, org_process_cert_issues - 1)
9543: WHERE certification_id = get_all_org_cert_rec.fin_certification_id;
9544: END IF;
9545:

Line 9570: last_updated_by = fnd_global.user_id,

9566: ***************/
9567: UPDATE amw_fin_process_eval_sum
9568: SET
9569: last_update_date = sysdate,
9570: last_updated_by = fnd_global.user_id,
9571: last_update_login = fnd_global.conc_login_id,
9572: number_of_sub_procs_certified = number_of_sub_procs_certified + 1
9573: WHERE fin_certification_id = get_parent_process_rec.fin_certification_id
9574: AND organization_id = get_parent_process_rec.organization_id

Line 9571: last_update_login = fnd_global.conc_login_id,

9567: UPDATE amw_fin_process_eval_sum
9568: SET
9569: last_update_date = sysdate,
9570: last_updated_by = fnd_global.user_id,
9571: last_update_login = fnd_global.conc_login_id,
9572: number_of_sub_procs_certified = number_of_sub_procs_certified + 1
9573: WHERE fin_certification_id = get_parent_process_rec.fin_certification_id
9574: AND organization_id = get_parent_process_rec.organization_id
9575: AND process_id = get_parent_process_rec.process_id;

Line 9778: last_updated_by = fnd_global.user_id,

9774: UPDATE AMW_FIN_CERT_EVAL_SUM
9775: SET
9776: orgs_evaluated = least(orgs_evaluated + 1, total_number_of_orgs),
9777: last_update_date = sysdate,
9778: last_updated_by = fnd_global.user_id,
9779: last_update_login = fnd_global.conc_login_id
9780: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
9781: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
9782: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID

Line 9779: last_update_login = fnd_global.conc_login_id

9775: SET
9776: orgs_evaluated = least(orgs_evaluated + 1, total_number_of_orgs),
9777: last_update_date = sysdate,
9778: last_updated_by = fnd_global.user_id,
9779: last_update_login = fnd_global.conc_login_id
9780: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
9781: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
9782: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID
9783: AND OBJECT_TYPE = 'FINANCIAL ITEM';

Line 9800: last_updated_by = fnd_global.user_id,

9796: SET
9797: org_with_ineffective_controls = least(org_with_ineffective_controls + 1, orgs_evaluated),
9798: org_with_ineff_controls_prcnt = round( (least(org_with_ineffective_controls + 1, orgs_evaluated, total_number_of_orgs) )/decode(nvl(total_number_of_orgs, 0), 0, 1, total_number_of_orgs), 2) * 100,
9799: last_update_date = sysdate,
9800: last_updated_by = fnd_global.user_id,
9801: last_update_login = fnd_global.conc_login_id
9802: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
9803: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
9804: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID

Line 9801: last_update_login = fnd_global.conc_login_id

9797: org_with_ineffective_controls = least(org_with_ineffective_controls + 1, orgs_evaluated),
9798: org_with_ineff_controls_prcnt = round( (least(org_with_ineffective_controls + 1, orgs_evaluated, total_number_of_orgs) )/decode(nvl(total_number_of_orgs, 0), 0, 1, total_number_of_orgs), 2) * 100,
9799: last_update_date = sysdate,
9800: last_updated_by = fnd_global.user_id,
9801: last_update_login = fnd_global.conc_login_id
9802: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
9803: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
9804: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID
9805: AND OBJECT_TYPE = 'FINANCIAL ITEM';

Line 9821: last_updated_by = fnd_global.user_id,

9817: SET
9818: org_with_ineffective_controls = greatest(0,org_with_ineffective_controls - 1),
9819: org_with_ineff_controls_prcnt = round( (greatest(0, m_item_org_with_ineff_ctrl - 1) )/decode(nvl(m_item_total_orgs, 0), 0, 1, m_item_total_orgs), 2) * 100,
9820: last_update_date = sysdate,
9821: last_updated_by = fnd_global.user_id,
9822: last_update_login = fnd_global.conc_login_id
9823: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
9824: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
9825: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID

Line 9822: last_update_login = fnd_global.conc_login_id

9818: org_with_ineffective_controls = greatest(0,org_with_ineffective_controls - 1),
9819: org_with_ineff_controls_prcnt = round( (greatest(0, m_item_org_with_ineff_ctrl - 1) )/decode(nvl(m_item_total_orgs, 0), 0, 1, m_item_total_orgs), 2) * 100,
9820: last_update_date = sysdate,
9821: last_updated_by = fnd_global.user_id,
9822: last_update_login = fnd_global.conc_login_id
9823: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
9824: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
9825: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID
9826: AND OBJECT_TYPE = 'FINANCIAL ITEM';

Line 9865: last_updated_by = fnd_global.user_id,

9861: UPDATE AMW_FIN_CERT_EVAL_SUM
9862: SET
9863: orgs_evaluated = least(orgs_evaluated + 1, total_number_of_orgs),
9864: last_update_date = sysdate,
9865: last_updated_by = fnd_global.user_id,
9866: last_update_login = fnd_global.conc_login_id
9867: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
9868: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
9869: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID

Line 9866: last_update_login = fnd_global.conc_login_id

9862: SET
9863: orgs_evaluated = least(orgs_evaluated + 1, total_number_of_orgs),
9864: last_update_date = sysdate,
9865: last_updated_by = fnd_global.user_id,
9866: last_update_login = fnd_global.conc_login_id
9867: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
9868: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
9869: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID
9870: AND OBJECT_TYPE = 'ACCOUNT';

Line 9887: last_updated_by = fnd_global.user_id,

9883: SET
9884: org_with_ineffective_controls = least(org_with_ineffective_controls + 1, orgs_evaluated),
9885: proc_with_ineff_controls_prcnt = round( (least(m_acc_org_with_ineff_ctrl + 1, orgs_evaluated))/decode(nvl(m_acc_total_orgs, 0), 0, 1, m_acc_total_orgs), 2) * 100,
9886: last_update_date = sysdate,
9887: last_updated_by = fnd_global.user_id,
9888: last_update_login = fnd_global.conc_login_id
9889: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
9890: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
9891: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID

Line 9888: last_update_login = fnd_global.conc_login_id

9884: org_with_ineffective_controls = least(org_with_ineffective_controls + 1, orgs_evaluated),
9885: proc_with_ineff_controls_prcnt = round( (least(m_acc_org_with_ineff_ctrl + 1, orgs_evaluated))/decode(nvl(m_acc_total_orgs, 0), 0, 1, m_acc_total_orgs), 2) * 100,
9886: last_update_date = sysdate,
9887: last_updated_by = fnd_global.user_id,
9888: last_update_login = fnd_global.conc_login_id
9889: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
9890: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
9891: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID
9892: AND OBJECT_TYPE = 'ACCOUNT';

Line 9908: last_updated_by = fnd_global.user_id,

9904: SET
9905: org_with_ineffective_controls = greatest(0, org_with_ineffective_controls - 1),
9906: proc_with_ineff_controls_prcnt = round( (m_acc_org_with_ineff_ctrl - 1)/decode(nvl(m_acc_total_orgs, 0), 0, 1, m_acc_total_orgs), 2) * 100,
9907: last_update_date = sysdate,
9908: last_updated_by = fnd_global.user_id,
9909: last_update_login = fnd_global.conc_login_id
9910: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
9911: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
9912: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID

Line 9909: last_update_login = fnd_global.conc_login_id

9905: org_with_ineffective_controls = greatest(0, org_with_ineffective_controls - 1),
9906: proc_with_ineff_controls_prcnt = round( (m_acc_org_with_ineff_ctrl - 1)/decode(nvl(m_acc_total_orgs, 0), 0, 1, m_acc_total_orgs), 2) * 100,
9907: last_update_date = sysdate,
9908: last_updated_by = fnd_global.user_id,
9909: last_update_login = fnd_global.conc_login_id
9910: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
9911: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
9912: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID
9913: AND OBJECT_TYPE = 'ACCOUNT';

Line 9936: last_updated_by = fnd_global.user_id,

9932: M_new_flag := 'Y';
9933:
9934: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9935: LAST_UPDATE_DATE = sysdate,
9936: last_updated_by = fnd_global.user_id,
9937: last_update_login = fnd_global.conc_login_id,
9938: orgs_for_cert_done = least(orgs_for_cert_done + 1, total_number_of_orgs)
9939: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
9940: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID

Line 9937: last_update_login = fnd_global.conc_login_id,

9933:
9934: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9935: LAST_UPDATE_DATE = sysdate,
9936: last_updated_by = fnd_global.user_id,
9937: last_update_login = fnd_global.conc_login_id,
9938: orgs_for_cert_done = least(orgs_for_cert_done + 1, total_number_of_orgs)
9939: WHERE FIN_CERTIFICATION_ID = Get_all_items_Rec.FIN_CERTIFICATION_ID
9940: AND FINANCIAL_STATEMENT_ID = Get_all_items_Rec.FINANCIAL_STATEMENT_ID
9941: AND FINANCIAL_ITEM_ID = Get_all_items_Rec.FINANCIAL_ITEM_ID

Line 9956: last_updated_by = fnd_global.user_id,

9952: M_new_flag := 'Y';
9953:
9954: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9955: LAST_UPDATE_DATE = sysdate,
9956: last_updated_by = fnd_global.user_id,
9957: last_update_login = fnd_global.conc_login_id,
9958: orgs_for_cert_done = least(orgs_for_cert_done + 1, total_number_of_orgs)
9959: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
9960: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID

Line 9957: last_update_login = fnd_global.conc_login_id,

9953:
9954: UPDATE AMW_FIN_CERT_EVAL_SUM SET
9955: LAST_UPDATE_DATE = sysdate,
9956: last_updated_by = fnd_global.user_id,
9957: last_update_login = fnd_global.conc_login_id,
9958: orgs_for_cert_done = least(orgs_for_cert_done + 1, total_number_of_orgs)
9959: WHERE FIN_CERTIFICATION_ID = Get_all_accts_Rec.FIN_CERTIFICATION_ID
9960: AND ACCOUNT_GROUP_ID = Get_all_accts_Rec.ACCOUNT_GROUP_ID
9961: AND NATURAL_ACCOUNT_ID = Get_all_accts_Rec.NATURAL_ACCOUNT_ID

Line 10159: FND_GLOBAL.USER_ID,

10155: p_certification_id,
10156: risk_rec.PK1,
10157: risk_rec.PK2,
10158: m_opinion_log_id,
10159: FND_GLOBAL.USER_ID,
10160: SYSDATE,
10161: SYSDATE,
10162: FND_GLOBAL.USER_ID,
10163: FND_GLOBAL.USER_ID,

Line 10162: FND_GLOBAL.USER_ID,

10158: m_opinion_log_id,
10159: FND_GLOBAL.USER_ID,
10160: SYSDATE,
10161: SYSDATE,
10162: FND_GLOBAL.USER_ID,
10163: FND_GLOBAL.USER_ID,
10164: 1,
10165: 'PROCESS_FINCERT',
10166: risk_rec.ASSOCIATION_CREATION_DATE,

Line 10163: FND_GLOBAL.USER_ID,

10159: FND_GLOBAL.USER_ID,
10160: SYSDATE,
10161: SYSDATE,
10162: FND_GLOBAL.USER_ID,
10163: FND_GLOBAL.USER_ID,
10164: 1,
10165: 'PROCESS_FINCERT',
10166: risk_rec.ASSOCIATION_CREATION_DATE,
10167: risk_rec.APPROVAL_DATE,

Line 10368: FND_GLOBAL.USER_ID,

10364: control_rec.PK1,
10365: control_rec.PK2,
10366: control_rec.PK3,
10367: m_opinion_log_id,
10368: FND_GLOBAL.USER_ID,
10369: SYSDATE,
10370: SYSDATE,
10371: FND_GLOBAL.USER_ID,
10372: FND_GLOBAL.USER_ID,

Line 10371: FND_GLOBAL.USER_ID,

10367: m_opinion_log_id,
10368: FND_GLOBAL.USER_ID,
10369: SYSDATE,
10370: SYSDATE,
10371: FND_GLOBAL.USER_ID,
10372: FND_GLOBAL.USER_ID,
10373: 1,
10374: 'RISK_FINCERT',
10375: control_rec.ASSOCIATION_CREATION_DATE,

Line 10372: FND_GLOBAL.USER_ID,

10368: FND_GLOBAL.USER_ID,
10369: SYSDATE,
10370: SYSDATE,
10371: FND_GLOBAL.USER_ID,
10372: FND_GLOBAL.USER_ID,
10373: 1,
10374: 'RISK_FINCERT',
10375: control_rec.ASSOCIATION_CREATION_DATE,
10376: control_rec.APPROVAL_DATE,

Line 10578: FND_GLOBAL.USER_ID,

10574: ap_rec.PK1,
10575: ap_rec.PK2,
10576: ap_rec.PK3,
10577: m_opinion_id,
10578: FND_GLOBAL.USER_ID,
10579: SYSDATE,
10580: SYSDATE,
10581: FND_GLOBAL.USER_ID,
10582: FND_GLOBAL.USER_ID,

Line 10581: FND_GLOBAL.USER_ID,

10577: m_opinion_id,
10578: FND_GLOBAL.USER_ID,
10579: SYSDATE,
10580: SYSDATE,
10581: FND_GLOBAL.USER_ID,
10582: FND_GLOBAL.USER_ID,
10583: 1,
10584: 'CTRL_FINCERT',
10585: ap_rec.ASSOCIATION_CREATION_DATE,

Line 10582: FND_GLOBAL.USER_ID,

10578: FND_GLOBAL.USER_ID,
10579: SYSDATE,
10580: SYSDATE,
10581: FND_GLOBAL.USER_ID,
10582: FND_GLOBAL.USER_ID,
10583: 1,
10584: 'CTRL_FINCERT',
10585: ap_rec.ASSOCIATION_CREATION_DATE,
10586: ap_rec.APPROVAL_DATE,