DBA Data[Home] [Help]

APPS.AMW_PROCCERT_EVENT_PVT dependencies on FND_GLOBAL

Line 40: last_updated_by = fnd_global.user_id,

36: CLOSE c_obj_opin_type_id;
37:
38: UPDATE amw_risk_associations assoc
39: SET last_update_date = sysdate,
40: last_updated_by = fnd_global.user_id,
41: last_update_login = fnd_global.conc_login_id,
42: pk4 = (SELECT max(opinion_log_id)
43: FROM amw_opinions_log opin
44: WHERE opin.object_opinion_type_id = l_obj_opinion_type_id

Line 41: last_update_login = fnd_global.conc_login_id,

37:
38: UPDATE amw_risk_associations assoc
39: SET last_update_date = sysdate,
40: last_updated_by = fnd_global.user_id,
41: last_update_login = fnd_global.conc_login_id,
42: pk4 = (SELECT max(opinion_log_id)
43: FROM amw_opinions_log opin
44: WHERE opin.object_opinion_type_id = l_obj_opinion_type_id
45: AND opin.pk1_value = assoc.risk_id

Line 60: last_updated_by = fnd_global.user_id,

56: CLOSE c_obj_opin_type_id;
57:
58: UPDATE amw_control_associations assoc
59: SET last_update_date = sysdate,
60: last_updated_by = fnd_global.user_id,
61: last_update_login = fnd_global.conc_login_id,
62: pk5 = (SELECT max(opinion_log_id)
63: FROM amw_opinions_log opin
64: WHERE opin.object_opinion_type_id = l_obj_opinion_type_id

Line 61: last_update_login = fnd_global.conc_login_id,

57:
58: UPDATE amw_control_associations assoc
59: SET last_update_date = sysdate,
60: last_updated_by = fnd_global.user_id,
61: last_update_login = fnd_global.conc_login_id,
62: pk5 = (SELECT max(opinion_log_id)
63: FROM amw_opinions_log opin
64: WHERE opin.object_opinion_type_id = l_obj_opinion_type_id
65: AND opin.pk1_value = assoc.control_id

Line 76: last_updated_by = fnd_global.user_id,

72: CLOSE c_obj_opin_type_id;
73:
74: UPDATE amw_ap_associations assoc
75: SET last_update_date = sysdate,
76: last_updated_by = fnd_global.user_id,
77: last_update_login = fnd_global.conc_login_id,
78: pk4 = (SELECT max(opinion_log_id)
79: FROM amw_opinions_log opin
80: WHERE opin.object_opinion_type_id = l_obj_opinion_type_id

Line 77: last_update_login = fnd_global.conc_login_id,

73:
74: UPDATE amw_ap_associations assoc
75: SET last_update_date = sysdate,
76: last_updated_by = fnd_global.user_id,
77: last_update_login = fnd_global.conc_login_id,
78: pk4 = (SELECT max(opinion_log_id)
79: FROM amw_opinions_log opin
80: WHERE opin.object_opinion_type_id = l_obj_opinion_type_id
81: AND opin.pk1_value = assoc.pk3

Line 386: last_updated_by = fnd_global.user_id,

382: -- find all the active proc cert that having this org
383: -- update amw_org_cert_eval_sum.evaluation_opinion_log_id
384: UPDATE amw_org_cert_eval_sum
385: SET last_update_date = sysdate,
386: last_updated_by = fnd_global.user_id,
387: last_update_login = fnd_global.conc_login_id,
388: evaluation_opinion_id = l_opin_id,
389: evaluation_opinion_log_id = l_opin_log_id
390: WHERE organization_id = l_pk1

Line 387: last_update_login = fnd_global.conc_login_id,

383: -- update amw_org_cert_eval_sum.evaluation_opinion_log_id
384: UPDATE amw_org_cert_eval_sum
385: SET last_update_date = sysdate,
386: last_updated_by = fnd_global.user_id,
387: last_update_login = fnd_global.conc_login_id,
388: evaluation_opinion_id = l_opin_id,
389: evaluation_opinion_log_id = l_opin_log_id
390: WHERE organization_id = l_pk1
391: AND certification_id IN (

Line 430: last_updated_by = fnd_global.user_id,

426: ELSE
427: *****/
428: UPDATE amw_org_cert_eval_sum
429: SET last_update_date = sysdate,
430: last_updated_by = fnd_global.user_id,
431: last_update_login = fnd_global.conc_login_id,
432: evaluated_processes = least(evaluated_processes+1,total_processes),
433: ineff_processes = least(ineff_processes+1,evaluated_processes+1,total_processes),
434: ineff_processes_prcnt = decode(total_processes, 0, 0,

Line 431: last_update_login = fnd_global.conc_login_id,

427: *****/
428: UPDATE amw_org_cert_eval_sum
429: SET last_update_date = sysdate,
430: last_updated_by = fnd_global.user_id,
431: last_update_login = fnd_global.conc_login_id,
432: evaluated_processes = least(evaluated_processes+1,total_processes),
433: ineff_processes = least(ineff_processes+1,evaluated_processes+1,total_processes),
434: ineff_processes_prcnt = decode(total_processes, 0, 0,
435: round(least(ineff_processes+1,evaluated_processes+1,total_processes)/total_processes*100))

Line 442: last_updated_by = fnd_global.user_id,

438: --END IF;
439: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
440: UPDATE amw_cert_dashboard_sum
441: SET last_update_date = sysdate,
442: last_updated_by = fnd_global.user_id,
443: last_update_login = fnd_global.conc_login_id,
444: proc_ineff_control = proc_ineff_control+1
445: WHERE certification_id = proc_rec.certification_id;
446: ELSE

Line 443: last_update_login = fnd_global.conc_login_id,

439: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
440: UPDATE amw_cert_dashboard_sum
441: SET last_update_date = sysdate,
442: last_updated_by = fnd_global.user_id,
443: last_update_login = fnd_global.conc_login_id,
444: proc_ineff_control = proc_ineff_control+1
445: WHERE certification_id = proc_rec.certification_id;
446: ELSE
447: UPDATE amw_cert_dashboard_sum

Line 449: last_updated_by = fnd_global.user_id,

445: WHERE certification_id = proc_rec.certification_id;
446: ELSE
447: UPDATE amw_cert_dashboard_sum
448: SET last_update_date = sysdate,
449: last_updated_by = fnd_global.user_id,
450: last_update_login = fnd_global.conc_login_id,
451: org_proc_ineff_control = org_proc_ineff_control+1
452: WHERE certification_id = proc_rec.certification_id;
453: END IF;

Line 450: last_update_login = fnd_global.conc_login_id,

446: ELSE
447: UPDATE amw_cert_dashboard_sum
448: SET last_update_date = sysdate,
449: last_updated_by = fnd_global.user_id,
450: last_update_login = fnd_global.conc_login_id,
451: org_proc_ineff_control = org_proc_ineff_control+1
452: WHERE certification_id = proc_rec.certification_id;
453: END IF;
454:

Line 466: last_updated_by = fnd_global.user_id,

462: ELSE
463: *********/
464: UPDATE amw_org_cert_eval_sum
465: SET last_update_date = sysdate,
466: last_updated_by = fnd_global.user_id,
467: last_update_login = fnd_global.conc_login_id,
468: evaluated_processes = least(evaluated_processes+1, total_processes)
469: WHERE certification_id = proc_rec.certification_id
470: AND organization_id = l_pk3;

Line 467: last_update_login = fnd_global.conc_login_id,

463: *********/
464: UPDATE amw_org_cert_eval_sum
465: SET last_update_date = sysdate,
466: last_updated_by = fnd_global.user_id,
467: last_update_login = fnd_global.conc_login_id,
468: evaluated_processes = least(evaluated_processes+1, total_processes)
469: WHERE certification_id = proc_rec.certification_id
470: AND organization_id = l_pk3;
471: --END IF;

Line 484: last_updated_by = fnd_global.user_id,

480: ELSE
481: *****/
482: UPDATE amw_org_cert_eval_sum
483: SET last_update_date = sysdate,
484: last_updated_by = fnd_global.user_id,
485: last_update_login = fnd_global.conc_login_id,
486: ineff_processes = least(ineff_processes+1,evaluated_processes,total_processes),
487: ineff_processes_prcnt = decode(total_processes, 0, 0,
488: round(least(ineff_processes+1,evaluated_processes,total_processes)/total_processes*100))

Line 485: last_update_login = fnd_global.conc_login_id,

481: *****/
482: UPDATE amw_org_cert_eval_sum
483: SET last_update_date = sysdate,
484: last_updated_by = fnd_global.user_id,
485: last_update_login = fnd_global.conc_login_id,
486: ineff_processes = least(ineff_processes+1,evaluated_processes,total_processes),
487: ineff_processes_prcnt = decode(total_processes, 0, 0,
488: round(least(ineff_processes+1,evaluated_processes,total_processes)/total_processes*100))
489: WHERE certification_id = proc_rec.certification_id

Line 495: last_updated_by = fnd_global.user_id,

491: --END IF;
492: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
493: UPDATE amw_cert_dashboard_sum
494: SET last_update_date = sysdate,
495: last_updated_by = fnd_global.user_id,
496: last_update_login = fnd_global.conc_login_id,
497: proc_ineff_control = proc_ineff_control+1
498: WHERE certification_id = proc_rec.certification_id;
499: ELSE

Line 496: last_update_login = fnd_global.conc_login_id,

492: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
493: UPDATE amw_cert_dashboard_sum
494: SET last_update_date = sysdate,
495: last_updated_by = fnd_global.user_id,
496: last_update_login = fnd_global.conc_login_id,
497: proc_ineff_control = proc_ineff_control+1
498: WHERE certification_id = proc_rec.certification_id;
499: ELSE
500: UPDATE amw_cert_dashboard_sum

Line 502: last_updated_by = fnd_global.user_id,

498: WHERE certification_id = proc_rec.certification_id;
499: ELSE
500: UPDATE amw_cert_dashboard_sum
501: SET last_update_date = sysdate,
502: last_updated_by = fnd_global.user_id,
503: last_update_login = fnd_global.conc_login_id,
504: org_proc_ineff_control = org_proc_ineff_control+1
505: WHERE certification_id = proc_rec.certification_id;
506: END IF;

Line 503: last_update_login = fnd_global.conc_login_id,

499: ELSE
500: UPDATE amw_cert_dashboard_sum
501: SET last_update_date = sysdate,
502: last_updated_by = fnd_global.user_id,
503: last_update_login = fnd_global.conc_login_id,
504: org_proc_ineff_control = org_proc_ineff_control+1
505: WHERE certification_id = proc_rec.certification_id;
506: END IF;
507:

Line 519: last_updated_by = fnd_global.user_id,

515: ELSE
516: *************/
517: UPDATE amw_org_cert_eval_sum
518: SET last_update_date = sysdate,
519: last_updated_by = fnd_global.user_id,
520: last_update_login = fnd_global.conc_login_id,
521: ineff_processes = greatest(0,ineff_processes-1),
522: ineff_processes_prcnt = decode(total_processes, 0, 0,
523: round(greatest(0,ineff_processes-1)/total_processes*100))

Line 520: last_update_login = fnd_global.conc_login_id,

516: *************/
517: UPDATE amw_org_cert_eval_sum
518: SET last_update_date = sysdate,
519: last_updated_by = fnd_global.user_id,
520: last_update_login = fnd_global.conc_login_id,
521: ineff_processes = greatest(0,ineff_processes-1),
522: ineff_processes_prcnt = decode(total_processes, 0, 0,
523: round(greatest(0,ineff_processes-1)/total_processes*100))
524: WHERE certification_id = proc_rec.certification_id

Line 538: last_updated_by = fnd_global.user_id,

534: ELSE
535: **********/
536: UPDATE amw_cert_dashboard_sum
537: SET last_update_date = sysdate,
538: last_updated_by = fnd_global.user_id,
539: last_update_login = fnd_global.conc_login_id,
540: proc_ineff_control = greatest(0,proc_ineff_control-1)
541: WHERE certification_id = proc_rec.certification_id;
542: --END IF;

Line 539: last_update_login = fnd_global.conc_login_id,

535: **********/
536: UPDATE amw_cert_dashboard_sum
537: SET last_update_date = sysdate,
538: last_updated_by = fnd_global.user_id,
539: last_update_login = fnd_global.conc_login_id,
540: proc_ineff_control = greatest(0,proc_ineff_control-1)
541: WHERE certification_id = proc_rec.certification_id;
542: --END IF;
543: ELSE

Line 552: last_updated_by = fnd_global.user_id,

548: ELSE
549: *******/
550: UPDATE amw_cert_dashboard_sum
551: SET last_update_date = sysdate,
552: last_updated_by = fnd_global.user_id,
553: last_update_login = fnd_global.conc_login_id,
554: org_proc_ineff_control = greatest(0,org_proc_ineff_control-1)
555: WHERE certification_id = proc_rec.certification_id;
556: --END IF;

Line 553: last_update_login = fnd_global.conc_login_id,

549: *******/
550: UPDATE amw_cert_dashboard_sum
551: SET last_update_date = sysdate,
552: last_updated_by = fnd_global.user_id,
553: last_update_login = fnd_global.conc_login_id,
554: org_proc_ineff_control = greatest(0,org_proc_ineff_control-1)
555: WHERE certification_id = proc_rec.certification_id;
556: --END IF;
557: END IF;

Line 564: last_updated_by = fnd_global.user_id,

560:
561: -- update amw_proc_cert_eval_sum.evaluation_opinion_log_id
562: UPDATE amw_proc_cert_eval_sum
563: SET last_update_date = sysdate,
564: last_updated_by = fnd_global.user_id,
565: last_update_login = fnd_global.conc_login_id,
566: evaluation_opinion_id = l_opin_id,
567: evaluation_opinion_log_id = l_opin_log_id
568: WHERE process_id = l_pk1

Line 565: last_update_login = fnd_global.conc_login_id,

561: -- update amw_proc_cert_eval_sum.evaluation_opinion_log_id
562: UPDATE amw_proc_cert_eval_sum
563: SET last_update_date = sysdate,
564: last_updated_by = fnd_global.user_id,
565: last_update_login = fnd_global.conc_login_id,
566: evaluation_opinion_id = l_opin_id,
567: evaluation_opinion_log_id = l_opin_log_id
568: WHERE process_id = l_pk1
569: AND organization_id = l_pk3

Line 611: last_updated_by = fnd_global.user_id,

607: ELSE
608: ***********/
609: UPDATE amw_org_cert_eval_sum
610: SET last_update_date = sysdate,
611: last_updated_by = fnd_global.user_id,
612: last_update_login = fnd_global.conc_login_id,
613: evaluated_risks = least(evaluated_risks+1,total_risks),
614: unmitigated_risks = least(unmitigated_risks+1,evaluated_risks+1,total_risks),
615: unmitigated_risks_prcnt = decode(total_risks, 0, 0,

Line 612: last_update_login = fnd_global.conc_login_id,

608: ***********/
609: UPDATE amw_org_cert_eval_sum
610: SET last_update_date = sysdate,
611: last_updated_by = fnd_global.user_id,
612: last_update_login = fnd_global.conc_login_id,
613: evaluated_risks = least(evaluated_risks+1,total_risks),
614: unmitigated_risks = least(unmitigated_risks+1,evaluated_risks+1,total_risks),
615: unmitigated_risks_prcnt = decode(total_risks, 0, 0,
616: round(least(unmitigated_risks+1,evaluated_risks+1,total_risks)/total_risks*100))

Line 631: last_updated_by = fnd_global.user_id,

627: ELSE
628: **********/
629: UPDATE amw_proc_cert_eval_sum
630: SET last_update_date = sysdate,
631: last_updated_by = fnd_global.user_id,
632: last_update_login = fnd_global.conc_login_id,
633: evaluated_risks = least(evaluated_risks+1,total_risks),
634: unmitigated_risks = least(unmitigated_risks+1,evaluated_risks+1,total_risks),
635: unmitigated_risks_prcnt = decode(total_risks, 0, 0,

Line 632: last_update_login = fnd_global.conc_login_id,

628: **********/
629: UPDATE amw_proc_cert_eval_sum
630: SET last_update_date = sysdate,
631: last_updated_by = fnd_global.user_id,
632: last_update_login = fnd_global.conc_login_id,
633: evaluated_risks = least(evaluated_risks+1,total_risks),
634: unmitigated_risks = least(unmitigated_risks+1,evaluated_risks+1,total_risks),
635: unmitigated_risks_prcnt = decode(total_risks, 0, 0,
636: round(least(unmitigated_risks+1,evaluated_risks+1,total_risks)/total_risks*100))

Line 654: last_updated_by = fnd_global.user_id,

650: --END IF;
651:
652: UPDATE amw_cert_dashboard_sum
653: SET last_update_date = sysdate,
654: last_updated_by = fnd_global.user_id,
655: last_update_login = fnd_global.conc_login_id,
656: unmitigated_risks = unmitigated_risks+1
657: WHERE certification_id = risk_rec.certification_id;
658:

Line 655: last_update_login = fnd_global.conc_login_id,

651:
652: UPDATE amw_cert_dashboard_sum
653: SET last_update_date = sysdate,
654: last_updated_by = fnd_global.user_id,
655: last_update_login = fnd_global.conc_login_id,
656: unmitigated_risks = unmitigated_risks+1
657: WHERE certification_id = risk_rec.certification_id;
658:
659: ELSIF risk_rec.old_eval IS NULL AND l_new_eval = 'EFFECTIVE' THEN

Line 670: last_updated_by = fnd_global.user_id,

666: ELSE
667: ****/
668: UPDATE amw_org_cert_eval_sum
669: SET last_update_date = sysdate,
670: last_updated_by = fnd_global.user_id,
671: last_update_login = fnd_global.conc_login_id,
672: evaluated_risks = least(evaluated_risks+1,total_risks)
673: WHERE certification_id = risk_rec.certification_id
674: AND organization_id = l_pk3;

Line 671: last_update_login = fnd_global.conc_login_id,

667: ****/
668: UPDATE amw_org_cert_eval_sum
669: SET last_update_date = sysdate,
670: last_updated_by = fnd_global.user_id,
671: last_update_login = fnd_global.conc_login_id,
672: evaluated_risks = least(evaluated_risks+1,total_risks)
673: WHERE certification_id = risk_rec.certification_id
674: AND organization_id = l_pk3;
675: --END IF;

Line 686: last_updated_by = fnd_global.user_id,

682: ELSE
683: **************/
684: UPDATE amw_proc_cert_eval_sum
685: SET last_update_date = sysdate,
686: last_updated_by = fnd_global.user_id,
687: last_update_login = fnd_global.conc_login_id,
688: evaluated_risks = least(evaluated_risks+1,total_risks)
689: WHERE certification_id = risk_rec.certification_id
690: AND organization_id = l_pk3

Line 687: last_update_login = fnd_global.conc_login_id,

683: **************/
684: UPDATE amw_proc_cert_eval_sum
685: SET last_update_date = sysdate,
686: last_updated_by = fnd_global.user_id,
687: last_update_login = fnd_global.conc_login_id,
688: evaluated_risks = least(evaluated_risks+1,total_risks)
689: WHERE certification_id = risk_rec.certification_id
690: AND organization_id = l_pk3
691: AND process_id IN (

Line 713: last_updated_by = fnd_global.user_id,

709: ELSE
710: *************/
711: UPDATE amw_org_cert_eval_sum
712: SET last_update_date = sysdate,
713: last_updated_by = fnd_global.user_id,
714: last_update_login = fnd_global.conc_login_id,
715: unmitigated_risks = least(unmitigated_risks+1,evaluated_risks,total_risks),
716: unmitigated_risks_prcnt = decode(total_risks, 0, 0,
717: round(least(unmitigated_risks+1,evaluated_risks,total_risks)/total_risks*100))

Line 714: last_update_login = fnd_global.conc_login_id,

710: *************/
711: UPDATE amw_org_cert_eval_sum
712: SET last_update_date = sysdate,
713: last_updated_by = fnd_global.user_id,
714: last_update_login = fnd_global.conc_login_id,
715: unmitigated_risks = least(unmitigated_risks+1,evaluated_risks,total_risks),
716: unmitigated_risks_prcnt = decode(total_risks, 0, 0,
717: round(least(unmitigated_risks+1,evaluated_risks,total_risks)/total_risks*100))
718: WHERE certification_id = risk_rec.certification_id

Line 732: last_updated_by = fnd_global.user_id,

728: ELSE
729: **********/
730: UPDATE amw_proc_cert_eval_sum
731: SET last_update_date = sysdate,
732: last_updated_by = fnd_global.user_id,
733: last_update_login = fnd_global.conc_login_id,
734: unmitigated_risks = least(unmitigated_risks+1,evaluated_risks,total_risks),
735: unmitigated_risks_prcnt = decode(total_risks, 0, 0,
736: round(least(unmitigated_risks+1,evaluated_risks,total_risks)/total_risks*100))

Line 733: last_update_login = fnd_global.conc_login_id,

729: **********/
730: UPDATE amw_proc_cert_eval_sum
731: SET last_update_date = sysdate,
732: last_updated_by = fnd_global.user_id,
733: last_update_login = fnd_global.conc_login_id,
734: unmitigated_risks = least(unmitigated_risks+1,evaluated_risks,total_risks),
735: unmitigated_risks_prcnt = decode(total_risks, 0, 0,
736: round(least(unmitigated_risks+1,evaluated_risks,total_risks)/total_risks*100))
737: WHERE certification_id = risk_rec.certification_id

Line 753: last_updated_by = fnd_global.user_id,

749: AND entity_type = PRIOR entity_type);
750: --END IF;
751: UPDATE amw_cert_dashboard_sum
752: SET last_update_date = sysdate,
753: last_updated_by = fnd_global.user_id,
754: last_update_login = fnd_global.conc_login_id,
755: unmitigated_risks = unmitigated_risks+1
756: WHERE certification_id = risk_rec.certification_id;
757:

Line 754: last_update_login = fnd_global.conc_login_id,

750: --END IF;
751: UPDATE amw_cert_dashboard_sum
752: SET last_update_date = sysdate,
753: last_updated_by = fnd_global.user_id,
754: last_update_login = fnd_global.conc_login_id,
755: unmitigated_risks = unmitigated_risks+1
756: WHERE certification_id = risk_rec.certification_id;
757:
758: ELSIF risk_rec.old_eval <> 'EFFECTIVE' AND l_new_eval = 'EFFECTIVE' THEN

Line 769: last_updated_by = fnd_global.user_id,

765: ELSE
766: ******************/
767: UPDATE amw_org_cert_eval_sum
768: SET last_update_date = sysdate,
769: last_updated_by = fnd_global.user_id,
770: last_update_login = fnd_global.conc_login_id,
771: unmitigated_risks = greatest(0,unmitigated_risks-1),
772: unmitigated_risks_prcnt = decode(total_risks, 0, 0,
773: round(greatest(0,unmitigated_risks-1)/total_risks*100))

Line 770: last_update_login = fnd_global.conc_login_id,

766: ******************/
767: UPDATE amw_org_cert_eval_sum
768: SET last_update_date = sysdate,
769: last_updated_by = fnd_global.user_id,
770: last_update_login = fnd_global.conc_login_id,
771: unmitigated_risks = greatest(0,unmitigated_risks-1),
772: unmitigated_risks_prcnt = decode(total_risks, 0, 0,
773: round(greatest(0,unmitigated_risks-1)/total_risks*100))
774: WHERE certification_id = risk_rec.certification_id

Line 788: last_updated_by = fnd_global.user_id,

784: ELSE
785: ************/
786: UPDATE amw_proc_cert_eval_sum
787: SET last_update_date = sysdate,
788: last_updated_by = fnd_global.user_id,
789: last_update_login = fnd_global.conc_login_id,
790: unmitigated_risks = greatest(0,unmitigated_risks-1),
791: unmitigated_risks_prcnt = decode(total_risks, 0, 0,
792: round(greatest(0,unmitigated_risks-1)/total_risks*100))

Line 789: last_update_login = fnd_global.conc_login_id,

785: ************/
786: UPDATE amw_proc_cert_eval_sum
787: SET last_update_date = sysdate,
788: last_updated_by = fnd_global.user_id,
789: last_update_login = fnd_global.conc_login_id,
790: unmitigated_risks = greatest(0,unmitigated_risks-1),
791: unmitigated_risks_prcnt = decode(total_risks, 0, 0,
792: round(greatest(0,unmitigated_risks-1)/total_risks*100))
793: WHERE certification_id = risk_rec.certification_id

Line 818: last_updated_by = fnd_global.user_id,

814: ELSE
815: ************/
816: UPDATE amw_cert_dashboard_sum
817: SET last_update_date = sysdate,
818: last_updated_by = fnd_global.user_id,
819: last_update_login = fnd_global.conc_login_id,
820: unmitigated_risks = greatest(0,unmitigated_risks-1)
821: WHERE certification_id = risk_rec.certification_id;
822: --END IF;

Line 819: last_update_login = fnd_global.conc_login_id,

815: ************/
816: UPDATE amw_cert_dashboard_sum
817: SET last_update_date = sysdate,
818: last_updated_by = fnd_global.user_id,
819: last_update_login = fnd_global.conc_login_id,
820: unmitigated_risks = greatest(0,unmitigated_risks-1)
821: WHERE certification_id = risk_rec.certification_id;
822: --END IF;
823: END IF;

Line 829: last_updated_by = fnd_global.user_id,

825:
826: -- update amw_risk_association.pk4 with evaluation_opinion_log_id
827: UPDATE amw_risk_associations
828: SET last_update_date = sysdate,
829: last_updated_by = fnd_global.user_id,
830: last_update_login = fnd_global.conc_login_id,
831: pk4 = l_opin_log_id
832: WHERE object_type = 'BUSIPROC_CERTIFICATION'
833: AND risk_id = l_pk1

Line 830: last_update_login = fnd_global.conc_login_id,

826: -- update amw_risk_association.pk4 with evaluation_opinion_log_id
827: UPDATE amw_risk_associations
828: SET last_update_date = sysdate,
829: last_updated_by = fnd_global.user_id,
830: last_update_login = fnd_global.conc_login_id,
831: pk4 = l_opin_log_id
832: WHERE object_type = 'BUSIPROC_CERTIFICATION'
833: AND risk_id = l_pk1
834: AND pk2 = l_pk3 -- organization_id

Line 880: last_updated_by = fnd_global.user_id,

876: ELSE
877: **********/
878: UPDATE amw_org_cert_eval_sum
879: SET last_update_date = sysdate,
880: last_updated_by = fnd_global.user_id,
881: last_update_login = fnd_global.conc_login_id,
882: evaluated_controls = least(evaluated_controls+1,total_controls),
883: ineffective_controls = least(ineffective_controls+1,evaluated_controls+1,total_controls),
884: ineff_controls_prcnt = decode(total_controls, 0, 0,

Line 881: last_update_login = fnd_global.conc_login_id,

877: **********/
878: UPDATE amw_org_cert_eval_sum
879: SET last_update_date = sysdate,
880: last_updated_by = fnd_global.user_id,
881: last_update_login = fnd_global.conc_login_id,
882: evaluated_controls = least(evaluated_controls+1,total_controls),
883: ineffective_controls = least(ineffective_controls+1,evaluated_controls+1,total_controls),
884: ineff_controls_prcnt = decode(total_controls, 0, 0,
885: round(least(ineffective_controls+1,evaluated_controls+1,total_controls)/total_controls*100))

Line 900: last_updated_by = fnd_global.user_id,

896: ELSE
897: ************/
898: UPDATE amw_proc_cert_eval_sum
899: SET last_update_date = sysdate,
900: last_updated_by = fnd_global.user_id,
901: last_update_login = fnd_global.conc_login_id,
902: evaluated_controls = least(evaluated_controls+1,total_controls),
903: ineffective_controls = least(ineffective_controls+1,evaluated_controls+1,total_controls),
904: ineffective_controls_prcnt = decode(total_controls, 0, 0,

Line 901: last_update_login = fnd_global.conc_login_id,

897: ************/
898: UPDATE amw_proc_cert_eval_sum
899: SET last_update_date = sysdate,
900: last_updated_by = fnd_global.user_id,
901: last_update_login = fnd_global.conc_login_id,
902: evaluated_controls = least(evaluated_controls+1,total_controls),
903: ineffective_controls = least(ineffective_controls+1,evaluated_controls+1,total_controls),
904: ineffective_controls_prcnt = decode(total_controls, 0, 0,
905: round(least(ineffective_controls+1,evaluated_controls+1,total_controls)/total_controls*100))

Line 928: last_updated_by = fnd_global.user_id,

924: AND entity_type = PRIOR entity_type);
925: --END IF;
926: UPDATE amw_cert_dashboard_sum
927: SET last_update_date = sysdate,
928: last_updated_by = fnd_global.user_id,
929: last_update_login = fnd_global.conc_login_id,
930: ineffective_controls = ineffective_controls+1
931: WHERE certification_id = ctrl_rec.certification_id;
932:

Line 929: last_update_login = fnd_global.conc_login_id,

925: --END IF;
926: UPDATE amw_cert_dashboard_sum
927: SET last_update_date = sysdate,
928: last_updated_by = fnd_global.user_id,
929: last_update_login = fnd_global.conc_login_id,
930: ineffective_controls = ineffective_controls+1
931: WHERE certification_id = ctrl_rec.certification_id;
932:
933: ELSIF ctrl_rec.old_eval IS NULL AND l_new_eval = 'EFFECTIVE' THEN

Line 944: last_updated_by = fnd_global.user_id,

940: ELSE
941: ***********/
942: UPDATE amw_org_cert_eval_sum
943: SET last_update_date = sysdate,
944: last_updated_by = fnd_global.user_id,
945: last_update_login = fnd_global.conc_login_id,
946: evaluated_controls = least(evaluated_controls+1,total_controls)
947: WHERE certification_id = ctrl_rec.certification_id
948: AND organization_id = l_pk3;

Line 945: last_update_login = fnd_global.conc_login_id,

941: ***********/
942: UPDATE amw_org_cert_eval_sum
943: SET last_update_date = sysdate,
944: last_updated_by = fnd_global.user_id,
945: last_update_login = fnd_global.conc_login_id,
946: evaluated_controls = least(evaluated_controls+1,total_controls)
947: WHERE certification_id = ctrl_rec.certification_id
948: AND organization_id = l_pk3;
949: --END IF;

Line 962: last_updated_by = fnd_global.user_id,

958: ELSE
959: **************/
960: UPDATE amw_proc_cert_eval_sum
961: SET last_update_date = sysdate,
962: last_updated_by = fnd_global.user_id,
963: last_update_login = fnd_global.conc_login_id,
964: evaluated_controls = least(evaluated_controls+1,total_controls)
965: WHERE certification_id = ctrl_rec.certification_id
966: AND organization_id = l_pk3

Line 963: last_update_login = fnd_global.conc_login_id,

959: **************/
960: UPDATE amw_proc_cert_eval_sum
961: SET last_update_date = sysdate,
962: last_updated_by = fnd_global.user_id,
963: last_update_login = fnd_global.conc_login_id,
964: evaluated_controls = least(evaluated_controls+1,total_controls)
965: WHERE certification_id = ctrl_rec.certification_id
966: AND organization_id = l_pk3
967: AND process_id IN (

Line 997: last_updated_by = fnd_global.user_id,

993: ELSE
994: *********/
995: UPDATE amw_org_cert_eval_sum
996: SET last_update_date = sysdate,
997: last_updated_by = fnd_global.user_id,
998: last_update_login = fnd_global.conc_login_id,
999: ineffective_controls = least(ineffective_controls+1,evaluated_controls,total_controls),
1000: ineff_controls_prcnt = decode(total_controls, 0, 0,
1001: round(least(ineffective_controls+1,evaluated_controls,total_controls)/total_controls*100))

Line 998: last_update_login = fnd_global.conc_login_id,

994: *********/
995: UPDATE amw_org_cert_eval_sum
996: SET last_update_date = sysdate,
997: last_updated_by = fnd_global.user_id,
998: last_update_login = fnd_global.conc_login_id,
999: ineffective_controls = least(ineffective_controls+1,evaluated_controls,total_controls),
1000: ineff_controls_prcnt = decode(total_controls, 0, 0,
1001: round(least(ineffective_controls+1,evaluated_controls,total_controls)/total_controls*100))
1002: WHERE certification_id = ctrl_rec.certification_id

Line 1016: last_updated_by = fnd_global.user_id,

1012: ELSE
1013: ***********/
1014: UPDATE amw_proc_cert_eval_sum
1015: SET last_update_date = sysdate,
1016: last_updated_by = fnd_global.user_id,
1017: last_update_login = fnd_global.conc_login_id,
1018: ineffective_controls = least(ineffective_controls+1,evaluated_controls,total_controls),
1019: ineffective_controls_prcnt = decode(total_controls, 0, 0,
1020: round(least(ineffective_controls+1,evaluated_controls,total_controls)/total_controls*100))

Line 1017: last_update_login = fnd_global.conc_login_id,

1013: ***********/
1014: UPDATE amw_proc_cert_eval_sum
1015: SET last_update_date = sysdate,
1016: last_updated_by = fnd_global.user_id,
1017: last_update_login = fnd_global.conc_login_id,
1018: ineffective_controls = least(ineffective_controls+1,evaluated_controls,total_controls),
1019: ineffective_controls_prcnt = decode(total_controls, 0, 0,
1020: round(least(ineffective_controls+1,evaluated_controls,total_controls)/total_controls*100))
1021: WHERE certification_id = ctrl_rec.certification_id

Line 1044: last_updated_by = fnd_global.user_id,

1040: --END IF;
1041:
1042: UPDATE amw_cert_dashboard_sum
1043: SET last_update_date = sysdate,
1044: last_updated_by = fnd_global.user_id,
1045: last_update_login = fnd_global.conc_login_id,
1046: ineffective_controls = ineffective_controls+1
1047: WHERE certification_id = ctrl_rec.certification_id;
1048:

Line 1045: last_update_login = fnd_global.conc_login_id,

1041:
1042: UPDATE amw_cert_dashboard_sum
1043: SET last_update_date = sysdate,
1044: last_updated_by = fnd_global.user_id,
1045: last_update_login = fnd_global.conc_login_id,
1046: ineffective_controls = ineffective_controls+1
1047: WHERE certification_id = ctrl_rec.certification_id;
1048:
1049: ELSIF ctrl_rec.old_eval <> 'EFFECTIVE' AND l_new_eval = 'EFFECTIVE' THEN

Line 1060: last_updated_by = fnd_global.user_id,

1056: ELSE
1057: ***********/
1058: UPDATE amw_org_cert_eval_sum
1059: SET last_update_date = sysdate,
1060: last_updated_by = fnd_global.user_id,
1061: last_update_login = fnd_global.conc_login_id,
1062: ineffective_controls = greatest(0,ineffective_controls-1),
1063: ineff_controls_prcnt = decode(total_controls, 0, 0,
1064: round(greatest(0,ineffective_controls-1)/total_controls*100))

Line 1061: last_update_login = fnd_global.conc_login_id,

1057: ***********/
1058: UPDATE amw_org_cert_eval_sum
1059: SET last_update_date = sysdate,
1060: last_updated_by = fnd_global.user_id,
1061: last_update_login = fnd_global.conc_login_id,
1062: ineffective_controls = greatest(0,ineffective_controls-1),
1063: ineff_controls_prcnt = decode(total_controls, 0, 0,
1064: round(greatest(0,ineffective_controls-1)/total_controls*100))
1065: WHERE certification_id = ctrl_rec.certification_id

Line 1080: last_updated_by = fnd_global.user_id,

1076: ELSE
1077: ************/
1078: UPDATE amw_proc_cert_eval_sum
1079: SET last_update_date = sysdate,
1080: last_updated_by = fnd_global.user_id,
1081: last_update_login = fnd_global.conc_login_id,
1082: ineffective_controls = greatest(0,ineffective_controls-1),
1083: ineffective_controls_prcnt = decode(total_controls, 0, 0,
1084: round(greatest(0,ineffective_controls-1)/total_controls*100))

Line 1081: last_update_login = fnd_global.conc_login_id,

1077: ************/
1078: UPDATE amw_proc_cert_eval_sum
1079: SET last_update_date = sysdate,
1080: last_updated_by = fnd_global.user_id,
1081: last_update_login = fnd_global.conc_login_id,
1082: ineffective_controls = greatest(0,ineffective_controls-1),
1083: ineffective_controls_prcnt = decode(total_controls, 0, 0,
1084: round(greatest(0,ineffective_controls-1)/total_controls*100))
1085: WHERE certification_id = ctrl_rec.certification_id

Line 1116: last_updated_by = fnd_global.user_id,

1112: ELSE
1113: *************/
1114: UPDATE amw_cert_dashboard_sum
1115: SET last_update_date = sysdate,
1116: last_updated_by = fnd_global.user_id,
1117: last_update_login = fnd_global.conc_login_id,
1118: ineffective_controls = greatest(0,ineffective_controls-1)
1119: WHERE certification_id = ctrl_rec.certification_id;
1120: --END IF;

Line 1117: last_update_login = fnd_global.conc_login_id,

1113: *************/
1114: UPDATE amw_cert_dashboard_sum
1115: SET last_update_date = sysdate,
1116: last_updated_by = fnd_global.user_id,
1117: last_update_login = fnd_global.conc_login_id,
1118: ineffective_controls = greatest(0,ineffective_controls-1)
1119: WHERE certification_id = ctrl_rec.certification_id;
1120: --END IF;
1121: END IF;

Line 1127: last_updated_by = fnd_global.user_id,

1123:
1124: -- update amw_contrl_associations.pk5 with evaluation_opinion_log_id
1125: UPDATE amw_control_associations
1126: SET last_update_date = sysdate,
1127: last_updated_by = fnd_global.user_id,
1128: last_update_login = fnd_global.conc_login_id,
1129: pk5 = l_opin_log_id
1130: WHERE object_type = 'BUSIPROC_CERTIFICATION'
1131: AND control_id = l_pk1

Line 1128: last_update_login = fnd_global.conc_login_id,

1124: -- update amw_contrl_associations.pk5 with evaluation_opinion_log_id
1125: UPDATE amw_control_associations
1126: SET last_update_date = sysdate,
1127: last_updated_by = fnd_global.user_id,
1128: last_update_login = fnd_global.conc_login_id,
1129: pk5 = l_opin_log_id
1130: WHERE object_type = 'BUSIPROC_CERTIFICATION'
1131: AND control_id = l_pk1
1132: AND pk2 = l_pk3 -- organization_id

Line 1145: last_updated_by = fnd_global.user_id,

1141:
1142: ELSIF l_obj_name = 'AMW_ORG_AP_CONTROL' THEN
1143: UPDATE amw_ap_associations
1144: SET last_update_date = sysdate,
1145: last_updated_by = fnd_global.user_id,
1146: last_update_login = fnd_global.conc_login_id,
1147: pk4 = l_opin_log_id
1148: WHERE object_type = 'BUSIPROC_CERTIFICATION'
1149: AND audit_procedure_id = l_pk1

Line 1146: last_update_login = fnd_global.conc_login_id,

1142: ELSIF l_obj_name = 'AMW_ORG_AP_CONTROL' THEN
1143: UPDATE amw_ap_associations
1144: SET last_update_date = sysdate,
1145: last_updated_by = fnd_global.user_id,
1146: last_update_login = fnd_global.conc_login_id,
1147: pk4 = l_opin_log_id
1148: WHERE object_type = 'BUSIPROC_CERTIFICATION'
1149: AND audit_procedure_id = l_pk1
1150: AND pk2 = l_pk3 -- organization_id

Line 1410: last_updated_by = fnd_global.user_id,

1406: CLOSE c_old_opinion;
1407:
1408: UPDATE amw_org_cert_eval_sum
1409: SET last_update_date = sysdate,
1410: last_updated_by = fnd_global.user_id,
1411: last_update_login = fnd_global.conc_login_id,
1412: certification_opinion_id = l_opin_id
1413: WHERE certification_id = l_pk2
1414: AND organization_id = l_pk1;

Line 1411: last_update_login = fnd_global.conc_login_id,

1407:
1408: UPDATE amw_org_cert_eval_sum
1409: SET last_update_date = sysdate,
1410: last_updated_by = fnd_global.user_id,
1411: last_update_login = fnd_global.conc_login_id,
1412: certification_opinion_id = l_opin_id
1413: WHERE certification_id = l_pk2
1414: AND organization_id = l_pk1;
1415:

Line 1433: last_updated_by = fnd_global.user_id,

1429: ELSE
1430: *************/
1431: UPDATE amw_cert_dashboard_sum
1432: SET last_update_date = sysdate,
1433: last_updated_by = fnd_global.user_id,
1434: last_update_login = fnd_global.conc_login_id,
1435: orgs_pending_certification = greatest(0,orgs_pending_certification-1)
1436: WHERE certification_id = l_pk1;
1437: --END IF;

Line 1434: last_update_login = fnd_global.conc_login_id,

1430: *************/
1431: UPDATE amw_cert_dashboard_sum
1432: SET last_update_date = sysdate,
1433: last_updated_by = fnd_global.user_id,
1434: last_update_login = fnd_global.conc_login_id,
1435: orgs_pending_certification = greatest(0,orgs_pending_certification-1)
1436: WHERE certification_id = l_pk1;
1437: --END IF;
1438:

Line 1458: last_updated_by = fnd_global.user_id,

1454: ELSE
1455: ************/
1456: UPDATE amw_org_cert_eval_sum
1457: SET last_update_date = sysdate,
1458: last_updated_by = fnd_global.user_id,
1459: last_update_login = fnd_global.conc_login_id,
1460: sub_org_cert = least(sub_org_cert+1,total_sub_org)
1461: WHERE certification_id = l_pk1
1462: AND organization_id = Get_org_cert_Rec.organization_id;

Line 1459: last_update_login = fnd_global.conc_login_id,

1455: ************/
1456: UPDATE amw_org_cert_eval_sum
1457: SET last_update_date = sysdate,
1458: last_updated_by = fnd_global.user_id,
1459: last_update_login = fnd_global.conc_login_id,
1460: sub_org_cert = least(sub_org_cert+1,total_sub_org)
1461: WHERE certification_id = l_pk1
1462: AND organization_id = Get_org_cert_Rec.organization_id;
1463: --END IF;

Line 1477: last_updated_by = fnd_global.user_id,

1473: ELSE
1474: ***********/
1475: UPDATE amw_org_cert_eval_sum
1476: SET last_update_date = sysdate,
1477: last_updated_by = fnd_global.user_id,
1478: last_update_login = fnd_global.conc_login_id,
1479: sub_org_cert = least(sub_org_cert+1,total_sub_org),
1480: sub_org_cert_issues = least(sub_org_cert_issues+1,sub_org_cert+1,total_sub_org)
1481: WHERE certification_id = l_pk1

Line 1478: last_update_login = fnd_global.conc_login_id,

1474: ***********/
1475: UPDATE amw_org_cert_eval_sum
1476: SET last_update_date = sysdate,
1477: last_updated_by = fnd_global.user_id,
1478: last_update_login = fnd_global.conc_login_id,
1479: sub_org_cert = least(sub_org_cert+1,total_sub_org),
1480: sub_org_cert_issues = least(sub_org_cert_issues+1,sub_org_cert+1,total_sub_org)
1481: WHERE certification_id = l_pk1
1482: AND organization_id = Get_org_cert_Rec.organization_id;

Line 1497: last_updated_by = fnd_global.user_id,

1493: ELSE
1494: ***********/
1495: UPDATE amw_org_cert_eval_sum
1496: SET last_update_date = sysdate,
1497: last_updated_by = fnd_global.user_id,
1498: last_update_login = fnd_global.conc_login_id,
1499: sub_org_cert_issues = least(sub_org_cert_issues+1,sub_org_cert,total_sub_org)
1500: WHERE certification_id = l_pk1
1501: AND organization_id = Get_org_cert_Rec.organization_id;

Line 1498: last_update_login = fnd_global.conc_login_id,

1494: ***********/
1495: UPDATE amw_org_cert_eval_sum
1496: SET last_update_date = sysdate,
1497: last_updated_by = fnd_global.user_id,
1498: last_update_login = fnd_global.conc_login_id,
1499: sub_org_cert_issues = least(sub_org_cert_issues+1,sub_org_cert,total_sub_org)
1500: WHERE certification_id = l_pk1
1501: AND organization_id = Get_org_cert_Rec.organization_id;
1502: --END IF;

Line 1516: last_updated_by = fnd_global.user_id,

1512: ELSE
1513: ************/
1514: UPDATE amw_org_cert_eval_sum
1515: SET last_update_date = sysdate,
1516: last_updated_by = fnd_global.user_id,
1517: last_update_login = fnd_global.conc_login_id,
1518: sub_org_cert_issues = greatest(0,sub_org_cert_issues-1)
1519: WHERE certification_id = l_pk1
1520: AND organization_id = Get_org_cert_Rec.organization_id;

Line 1517: last_update_login = fnd_global.conc_login_id,

1513: ************/
1514: UPDATE amw_org_cert_eval_sum
1515: SET last_update_date = sysdate,
1516: last_updated_by = fnd_global.user_id,
1517: last_update_login = fnd_global.conc_login_id,
1518: sub_org_cert_issues = greatest(0,sub_org_cert_issues-1)
1519: WHERE certification_id = l_pk1
1520: AND organization_id = Get_org_cert_Rec.organization_id;
1521: --END IF;

Line 1543: last_updated_by = fnd_global.user_id,

1539: CLOSE c_orgs_pending_in_scope;
1540:
1541: UPDATE amw_proc_cert_eval_sum
1542: SET last_update_date = sysdate,
1543: last_updated_by = fnd_global.user_id,
1544: last_update_login = fnd_global.conc_login_id,
1545: certification_opinion_id = l_opin_id
1546: WHERE certification_id = l_pk2
1547: AND organization_id = l_pk3

Line 1544: last_update_login = fnd_global.conc_login_id,

1540:
1541: UPDATE amw_proc_cert_eval_sum
1542: SET last_update_date = sysdate,
1543: last_updated_by = fnd_global.user_id,
1544: last_update_login = fnd_global.conc_login_id,
1545: certification_opinion_id = l_opin_id
1546: WHERE certification_id = l_pk2
1547: AND organization_id = l_pk3
1548: AND process_id = l_pk1;

Line 1578: last_updated_by = fnd_global.user_id,

1574: ELSE
1575: **********/
1576: UPDATE amw_org_cert_eval_sum
1577: SET last_update_date = sysdate,
1578: last_updated_by = fnd_global.user_id,
1579: last_update_login = fnd_global.conc_login_id,
1580: processes_certified = least(processes_certified+1,total_processes)
1581: WHERE certification_id = l_pk2
1582: AND organization_id = l_pk3;

Line 1579: last_update_login = fnd_global.conc_login_id,

1575: **********/
1576: UPDATE amw_org_cert_eval_sum
1577: SET last_update_date = sysdate,
1578: last_updated_by = fnd_global.user_id,
1579: last_update_login = fnd_global.conc_login_id,
1580: processes_certified = least(processes_certified+1,total_processes)
1581: WHERE certification_id = l_pk2
1582: AND organization_id = l_pk3;
1583: --END IF;

Line 1598: last_updated_by = fnd_global.user_id,

1594: ELSE
1595: *************/
1596: UPDATE amw_cert_dashboard_sum
1597: SET last_update_date = sysdate,
1598: last_updated_by = fnd_global.user_id,
1599: last_update_login = fnd_global.conc_login_id,
1600: orgs_pending_in_scope = l_orgs_pending,
1601: processes_not_cert = greatest(0,processes_not_cert-1)
1602: WHERE certification_id = l_pk2;

Line 1599: last_update_login = fnd_global.conc_login_id,

1595: *************/
1596: UPDATE amw_cert_dashboard_sum
1597: SET last_update_date = sysdate,
1598: last_updated_by = fnd_global.user_id,
1599: last_update_login = fnd_global.conc_login_id,
1600: orgs_pending_in_scope = l_orgs_pending,
1601: processes_not_cert = greatest(0,processes_not_cert-1)
1602: WHERE certification_id = l_pk2;
1603: --END IF;

Line 1617: last_updated_by = fnd_global.user_id,

1613: ELSE
1614: ********/
1615: UPDATE amw_cert_dashboard_sum
1616: SET last_update_date = sysdate,
1617: last_updated_by = fnd_global.user_id,
1618: last_update_login = fnd_global.conc_login_id,
1619: orgs_pending_in_scope = l_orgs_pending,
1620: org_process_not_cert = greatest(0,org_process_not_cert-1)
1621: WHERE certification_id = l_pk2;

Line 1618: last_update_login = fnd_global.conc_login_id,

1614: ********/
1615: UPDATE amw_cert_dashboard_sum
1616: SET last_update_date = sysdate,
1617: last_updated_by = fnd_global.user_id,
1618: last_update_login = fnd_global.conc_login_id,
1619: orgs_pending_in_scope = l_orgs_pending,
1620: org_process_not_cert = greatest(0,org_process_not_cert-1)
1621: WHERE certification_id = l_pk2;
1622: -- END IF;

Line 1638: last_updated_by = fnd_global.user_id,

1634: ELSE
1635: ***************/
1636: UPDATE amw_org_cert_eval_sum
1637: SET last_update_date = sysdate,
1638: last_updated_by = fnd_global.user_id,
1639: last_update_login = fnd_global.conc_login_id,
1640: processes_certified = least(processes_certified+1,total_processes),
1641: proc_cert_issues = least(proc_cert_issues+1,processes_certified+1,total_processes)
1642: WHERE certification_id = l_pk2

Line 1639: last_update_login = fnd_global.conc_login_id,

1635: ***************/
1636: UPDATE amw_org_cert_eval_sum
1637: SET last_update_date = sysdate,
1638: last_updated_by = fnd_global.user_id,
1639: last_update_login = fnd_global.conc_login_id,
1640: processes_certified = least(processes_certified+1,total_processes),
1641: proc_cert_issues = least(proc_cert_issues+1,processes_certified+1,total_processes)
1642: WHERE certification_id = l_pk2
1643: AND organization_id = l_pk3;

Line 1649: last_updated_by = fnd_global.user_id,

1645:
1646: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
1647: UPDATE amw_cert_dashboard_sum
1648: SET last_update_date = sysdate,
1649: last_updated_by = fnd_global.user_id,
1650: last_update_login = fnd_global.conc_login_id,
1651: orgs_pending_in_scope = l_orgs_pending,
1652: processes_not_cert = greatest(0,processes_not_cert-1),
1653: processes_cert_issues = processes_cert_issues+1

Line 1650: last_update_login = fnd_global.conc_login_id,

1646: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
1647: UPDATE amw_cert_dashboard_sum
1648: SET last_update_date = sysdate,
1649: last_updated_by = fnd_global.user_id,
1650: last_update_login = fnd_global.conc_login_id,
1651: orgs_pending_in_scope = l_orgs_pending,
1652: processes_not_cert = greatest(0,processes_not_cert-1),
1653: processes_cert_issues = processes_cert_issues+1
1654: WHERE certification_id = l_pk2;

Line 1659: last_updated_by = fnd_global.user_id,

1655: ELSE
1656:
1657: UPDATE amw_cert_dashboard_sum
1658: SET last_update_date = sysdate,
1659: last_updated_by = fnd_global.user_id,
1660: last_update_login = fnd_global.conc_login_id,
1661: orgs_pending_in_scope = l_orgs_pending,
1662: org_process_not_cert = greatest(0,org_process_not_cert-1),
1663: org_process_cert_issues = org_process_cert_issues+1

Line 1660: last_update_login = fnd_global.conc_login_id,

1656:
1657: UPDATE amw_cert_dashboard_sum
1658: SET last_update_date = sysdate,
1659: last_updated_by = fnd_global.user_id,
1660: last_update_login = fnd_global.conc_login_id,
1661: orgs_pending_in_scope = l_orgs_pending,
1662: org_process_not_cert = greatest(0,org_process_not_cert-1),
1663: org_process_cert_issues = org_process_cert_issues+1
1664: WHERE certification_id = l_pk2;

Line 1679: last_updated_by = fnd_global.user_id,

1675: ELSE
1676: ***********/
1677: UPDATE amw_org_cert_eval_sum
1678: SET last_update_date = sysdate,
1679: last_updated_by = fnd_global.user_id,
1680: last_update_login = fnd_global.conc_login_id,
1681: proc_cert_issues = greatest(0,proc_cert_issues-1)
1682: WHERE certification_id = l_pk2
1683: AND organization_id = l_pk3;

Line 1680: last_update_login = fnd_global.conc_login_id,

1676: ***********/
1677: UPDATE amw_org_cert_eval_sum
1678: SET last_update_date = sysdate,
1679: last_updated_by = fnd_global.user_id,
1680: last_update_login = fnd_global.conc_login_id,
1681: proc_cert_issues = greatest(0,proc_cert_issues-1)
1682: WHERE certification_id = l_pk2
1683: AND organization_id = l_pk3;
1684: --END IF;

Line 1699: last_updated_by = fnd_global.user_id,

1695: ELSE
1696: *************/
1697: UPDATE amw_cert_dashboard_sum
1698: SET last_update_date = sysdate,
1699: last_updated_by = fnd_global.user_id,
1700: last_update_login = fnd_global.conc_login_id,
1701: orgs_pending_in_scope = l_orgs_pending,
1702: processes_cert_issues = greatest(0,processes_cert_issues-1)
1703: WHERE certification_id = l_pk2;

Line 1700: last_update_login = fnd_global.conc_login_id,

1696: *************/
1697: UPDATE amw_cert_dashboard_sum
1698: SET last_update_date = sysdate,
1699: last_updated_by = fnd_global.user_id,
1700: last_update_login = fnd_global.conc_login_id,
1701: orgs_pending_in_scope = l_orgs_pending,
1702: processes_cert_issues = greatest(0,processes_cert_issues-1)
1703: WHERE certification_id = l_pk2;
1704: -- END IF;

Line 1717: last_updated_by = fnd_global.user_id,

1713: ELSE
1714: **************/
1715: UPDATE amw_cert_dashboard_sum
1716: SET last_update_date = sysdate,
1717: last_updated_by = fnd_global.user_id,
1718: last_update_login = fnd_global.conc_login_id,
1719: orgs_pending_in_scope = l_orgs_pending,
1720: org_process_cert_issues = greatest(org_process_cert_issues-1,0)
1721: WHERE certification_id = l_pk2;

Line 1718: last_update_login = fnd_global.conc_login_id,

1714: **************/
1715: UPDATE amw_cert_dashboard_sum
1716: SET last_update_date = sysdate,
1717: last_updated_by = fnd_global.user_id,
1718: last_update_login = fnd_global.conc_login_id,
1719: orgs_pending_in_scope = l_orgs_pending,
1720: org_process_cert_issues = greatest(org_process_cert_issues-1,0)
1721: WHERE certification_id = l_pk2;
1722: -- END IF;

Line 1737: last_updated_by = fnd_global.user_id,

1733: ELSE
1734: **************/
1735: UPDATE amw_org_cert_eval_sum
1736: SET last_update_date = sysdate,
1737: last_updated_by = fnd_global.user_id,
1738: last_update_login = fnd_global.conc_login_id,
1739: proc_cert_issues = least(proc_cert_issues+1,processes_certified,total_processes)
1740: WHERE certification_id = l_pk2
1741: AND organization_id = l_pk3;

Line 1738: last_update_login = fnd_global.conc_login_id,

1734: **************/
1735: UPDATE amw_org_cert_eval_sum
1736: SET last_update_date = sysdate,
1737: last_updated_by = fnd_global.user_id,
1738: last_update_login = fnd_global.conc_login_id,
1739: proc_cert_issues = least(proc_cert_issues+1,processes_certified,total_processes)
1740: WHERE certification_id = l_pk2
1741: AND organization_id = l_pk3;
1742: --END IF;

Line 1747: last_updated_by = fnd_global.user_id,

1743:
1744: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
1745: UPDATE amw_cert_dashboard_sum
1746: SET last_update_date = sysdate,
1747: last_updated_by = fnd_global.user_id,
1748: last_update_login = fnd_global.conc_login_id,
1749: orgs_pending_in_scope = l_orgs_pending,
1750: processes_cert_issues = processes_cert_issues+1
1751: WHERE certification_id = l_pk2;

Line 1748: last_update_login = fnd_global.conc_login_id,

1744: IF l_pk3 = fnd_profile.value('AMW_GLOBAL_ORG_ID') THEN
1745: UPDATE amw_cert_dashboard_sum
1746: SET last_update_date = sysdate,
1747: last_updated_by = fnd_global.user_id,
1748: last_update_login = fnd_global.conc_login_id,
1749: orgs_pending_in_scope = l_orgs_pending,
1750: processes_cert_issues = processes_cert_issues+1
1751: WHERE certification_id = l_pk2;
1752: ELSE

Line 1755: last_updated_by = fnd_global.user_id,

1751: WHERE certification_id = l_pk2;
1752: ELSE
1753: UPDATE amw_cert_dashboard_sum
1754: SET last_update_date = sysdate,
1755: last_updated_by = fnd_global.user_id,
1756: last_update_login = fnd_global.conc_login_id,
1757: orgs_pending_in_scope = l_orgs_pending,
1758: org_process_cert_issues = org_process_cert_issues+1
1759: WHERE certification_id = l_pk2;

Line 1756: last_update_login = fnd_global.conc_login_id,

1752: ELSE
1753: UPDATE amw_cert_dashboard_sum
1754: SET last_update_date = sysdate,
1755: last_updated_by = fnd_global.user_id,
1756: last_update_login = fnd_global.conc_login_id,
1757: orgs_pending_in_scope = l_orgs_pending,
1758: org_process_cert_issues = org_process_cert_issues+1
1759: WHERE certification_id = l_pk2;
1760: END IF;

Line 1779: last_updated_by = fnd_global.user_id,

1775: ELSE
1776: ************/
1777: UPDATE amw_proc_cert_eval_sum
1778: SET last_update_date = sysdate,
1779: last_updated_by = fnd_global.user_id,
1780: last_update_login = fnd_global.conc_login_id,
1781: sub_process_cert = least(sub_process_cert+1,total_sub_process_cert)
1782: WHERE certification_id = Get_parent_process_Rec.certification_id
1783: AND organization_id = Get_parent_process_Rec.organization_id

Line 1780: last_update_login = fnd_global.conc_login_id,

1776: ************/
1777: UPDATE amw_proc_cert_eval_sum
1778: SET last_update_date = sysdate,
1779: last_updated_by = fnd_global.user_id,
1780: last_update_login = fnd_global.conc_login_id,
1781: sub_process_cert = least(sub_process_cert+1,total_sub_process_cert)
1782: WHERE certification_id = Get_parent_process_Rec.certification_id
1783: AND organization_id = Get_parent_process_Rec.organization_id
1784: AND process_id = Get_parent_process_Rec.process_id;

Line 1801: last_updated_by = fnd_global.user_id,

1797: ELSE
1798: ********/
1799: UPDATE amw_proc_cert_eval_sum
1800: SET last_update_date = sysdate,
1801: last_updated_by = fnd_global.user_id,
1802: last_update_login = fnd_global.conc_login_id,
1803: sub_process_cert = least(sub_process_cert+1,total_sub_process_cert),
1804: sub_process_cert_issues = least(sub_process_cert_issues+1,sub_process_cert+1,total_sub_process_cert)
1805: WHERE certification_id = Get_parent_process_Rec.certification_id

Line 1802: last_update_login = fnd_global.conc_login_id,

1798: ********/
1799: UPDATE amw_proc_cert_eval_sum
1800: SET last_update_date = sysdate,
1801: last_updated_by = fnd_global.user_id,
1802: last_update_login = fnd_global.conc_login_id,
1803: sub_process_cert = least(sub_process_cert+1,total_sub_process_cert),
1804: sub_process_cert_issues = least(sub_process_cert_issues+1,sub_process_cert+1,total_sub_process_cert)
1805: WHERE certification_id = Get_parent_process_Rec.certification_id
1806: AND organization_id = Get_parent_process_Rec.organization_id

Line 1822: last_updated_by = fnd_global.user_id,

1818: ELSE
1819: ************/
1820: UPDATE amw_proc_cert_eval_sum
1821: SET last_update_date = sysdate,
1822: last_updated_by = fnd_global.user_id,
1823: last_update_login = fnd_global.conc_login_id,
1824: sub_process_cert_issues = greatest(0,sub_process_cert_issues-1)
1825: WHERE certification_id = Get_parent_process_Rec.certification_id
1826: AND organization_id = Get_parent_process_Rec.organization_id

Line 1823: last_update_login = fnd_global.conc_login_id,

1819: ************/
1820: UPDATE amw_proc_cert_eval_sum
1821: SET last_update_date = sysdate,
1822: last_updated_by = fnd_global.user_id,
1823: last_update_login = fnd_global.conc_login_id,
1824: sub_process_cert_issues = greatest(0,sub_process_cert_issues-1)
1825: WHERE certification_id = Get_parent_process_Rec.certification_id
1826: AND organization_id = Get_parent_process_Rec.organization_id
1827: AND process_id = Get_parent_process_Rec.process_id;

Line 1841: last_updated_by = fnd_global.user_id,

1837: ELSE
1838: ***********/
1839: UPDATE amw_proc_cert_eval_sum
1840: SET last_update_date = sysdate,
1841: last_updated_by = fnd_global.user_id,
1842: last_update_login = fnd_global.conc_login_id,
1843: sub_process_cert_issues = least(sub_process_cert_issues+1,sub_process_cert,total_sub_process_cert)
1844: WHERE certification_id = Get_parent_process_Rec.certification_id
1845: AND organization_id = Get_parent_process_Rec.organization_id

Line 1842: last_update_login = fnd_global.conc_login_id,

1838: ***********/
1839: UPDATE amw_proc_cert_eval_sum
1840: SET last_update_date = sysdate,
1841: last_updated_by = fnd_global.user_id,
1842: last_update_login = fnd_global.conc_login_id,
1843: sub_process_cert_issues = least(sub_process_cert_issues+1,sub_process_cert,total_sub_process_cert)
1844: WHERE certification_id = Get_parent_process_Rec.certification_id
1845: AND organization_id = Get_parent_process_Rec.organization_id
1846: AND process_id = Get_parent_process_Rec.process_id;

Line 1867: last_updated_by = fnd_global.user_id,

1863: ELSE
1864: ************/
1865: UPDATE amw_proc_cert_eval_sum
1866: SET last_update_date = sysdate,
1867: last_updated_by = fnd_global.user_id,
1868: last_update_login = fnd_global.conc_login_id,
1869: org_process_cert = least(org_process_cert+1,total_org_process_cert)
1870: WHERE certification_id = Get_related_org_proc_Rec.certification_id
1871: AND process_id = Get_related_org_proc_Rec.process_id

Line 1868: last_update_login = fnd_global.conc_login_id,

1864: ************/
1865: UPDATE amw_proc_cert_eval_sum
1866: SET last_update_date = sysdate,
1867: last_updated_by = fnd_global.user_id,
1868: last_update_login = fnd_global.conc_login_id,
1869: org_process_cert = least(org_process_cert+1,total_org_process_cert)
1870: WHERE certification_id = Get_related_org_proc_Rec.certification_id
1871: AND process_id = Get_related_org_proc_Rec.process_id
1872: AND organization_id = Get_related_org_proc_Rec.organization_id;

Line 1890: last_updated_by = fnd_global.user_id,

1886: ELSE
1887: ***************/
1888: UPDATE amw_proc_cert_eval_sum
1889: SET last_update_date = sysdate,
1890: last_updated_by = fnd_global.user_id,
1891: last_update_login = fnd_global.conc_login_id,
1892: org_process_cert = least(org_process_cert+1,total_org_process_cert),
1893: org_process_cert_issues = least(org_process_cert_issues+1,org_process_cert+1,total_org_process_cert)
1894: WHERE certification_id = Get_related_org_proc_Rec.certification_id

Line 1891: last_update_login = fnd_global.conc_login_id,

1887: ***************/
1888: UPDATE amw_proc_cert_eval_sum
1889: SET last_update_date = sysdate,
1890: last_updated_by = fnd_global.user_id,
1891: last_update_login = fnd_global.conc_login_id,
1892: org_process_cert = least(org_process_cert+1,total_org_process_cert),
1893: org_process_cert_issues = least(org_process_cert_issues+1,org_process_cert+1,total_org_process_cert)
1894: WHERE certification_id = Get_related_org_proc_Rec.certification_id
1895: AND process_id = Get_related_org_proc_Rec.process_id

Line 1911: last_updated_by = fnd_global.user_id,

1907: ELSE
1908: ************/
1909: UPDATE amw_proc_cert_eval_sum
1910: SET last_update_date = sysdate,
1911: last_updated_by = fnd_global.user_id,
1912: last_update_login = fnd_global.conc_login_id,
1913: org_process_cert_issues = greatest(0,org_process_cert_issues-1)
1914: WHERE certification_id = Get_related_org_proc_Rec.certification_id
1915: AND process_id = Get_related_org_proc_Rec.process_id

Line 1912: last_update_login = fnd_global.conc_login_id,

1908: ************/
1909: UPDATE amw_proc_cert_eval_sum
1910: SET last_update_date = sysdate,
1911: last_updated_by = fnd_global.user_id,
1912: last_update_login = fnd_global.conc_login_id,
1913: org_process_cert_issues = greatest(0,org_process_cert_issues-1)
1914: WHERE certification_id = Get_related_org_proc_Rec.certification_id
1915: AND process_id = Get_related_org_proc_Rec.process_id
1916: AND organization_id = Get_related_org_proc_Rec.organization_id;

Line 1931: last_updated_by = fnd_global.user_id,

1927: ELSE
1928: *************/
1929: UPDATE amw_proc_cert_eval_sum
1930: SET last_update_date = sysdate,
1931: last_updated_by = fnd_global.user_id,
1932: last_update_login = fnd_global.conc_login_id,
1933: org_process_cert_issues = least(org_process_cert_issues+1,org_process_cert,total_org_process_cert)
1934: WHERE certification_id = Get_related_org_proc_Rec.certification_id
1935: AND process_id = Get_related_org_proc_Rec.process_id

Line 1932: last_update_login = fnd_global.conc_login_id,

1928: *************/
1929: UPDATE amw_proc_cert_eval_sum
1930: SET last_update_date = sysdate,
1931: last_updated_by = fnd_global.user_id,
1932: last_update_login = fnd_global.conc_login_id,
1933: org_process_cert_issues = least(org_process_cert_issues+1,org_process_cert,total_org_process_cert)
1934: WHERE certification_id = Get_related_org_proc_Rec.certification_id
1935: AND process_id = Get_related_org_proc_Rec.process_id
1936: AND organization_id = Get_related_org_proc_Rec.organization_id;