1876: --
1877: UPDATE igs_as_su_atmpt_itm suaai
1878: SET suaai.logical_delete_dt = SYSDATE,
1879: suaai.last_update_date = SYSDATE,
1880: suaai.last_updated_by = fnd_global.user_id,
1881: suaai.last_update_login = fnd_global.login_id,
1882: suaai.request_id = fnd_global.conc_request_id,
1883: suaai.program_id = fnd_global.conc_program_id,
1884: suaai.program_application_id = fnd_global.prog_appl_id,
1877: UPDATE igs_as_su_atmpt_itm suaai
1878: SET suaai.logical_delete_dt = SYSDATE,
1879: suaai.last_update_date = SYSDATE,
1880: suaai.last_updated_by = fnd_global.user_id,
1881: suaai.last_update_login = fnd_global.login_id,
1882: suaai.request_id = fnd_global.conc_request_id,
1883: suaai.program_id = fnd_global.conc_program_id,
1884: suaai.program_application_id = fnd_global.prog_appl_id,
1885: suaai.program_update_date = SYSDATE
1878: SET suaai.logical_delete_dt = SYSDATE,
1879: suaai.last_update_date = SYSDATE,
1880: suaai.last_updated_by = fnd_global.user_id,
1881: suaai.last_update_login = fnd_global.login_id,
1882: suaai.request_id = fnd_global.conc_request_id,
1883: suaai.program_id = fnd_global.conc_program_id,
1884: suaai.program_application_id = fnd_global.prog_appl_id,
1885: suaai.program_update_date = SYSDATE
1886: WHERE suaai.person_id = p_person_id
1879: suaai.last_update_date = SYSDATE,
1880: suaai.last_updated_by = fnd_global.user_id,
1881: suaai.last_update_login = fnd_global.login_id,
1882: suaai.request_id = fnd_global.conc_request_id,
1883: suaai.program_id = fnd_global.conc_program_id,
1884: suaai.program_application_id = fnd_global.prog_appl_id,
1885: suaai.program_update_date = SYSDATE
1886: WHERE suaai.person_id = p_person_id
1887: AND suaai.course_cd = p_course_cd
1880: suaai.last_updated_by = fnd_global.user_id,
1881: suaai.last_update_login = fnd_global.login_id,
1882: suaai.request_id = fnd_global.conc_request_id,
1883: suaai.program_id = fnd_global.conc_program_id,
1884: suaai.program_application_id = fnd_global.prog_appl_id,
1885: suaai.program_update_date = SYSDATE
1886: WHERE suaai.person_id = p_person_id
1887: AND suaai.course_cd = p_course_cd
1888: AND suaai.uoo_id = p_uoo_id
1891: --
1892: UPDATE igs_as_sua_ai_group suaaig
1893: SET suaaig.logical_delete_date = SYSDATE,
1894: suaaig.last_update_date = SYSDATE,
1895: suaaig.last_updated_by = fnd_global.user_id,
1896: suaaig.last_update_login = fnd_global.login_id
1897: WHERE suaaig.person_id = p_person_id
1898: AND suaaig.course_cd = p_course_cd
1899: AND suaaig.uoo_id = p_uoo_id
1892: UPDATE igs_as_sua_ai_group suaaig
1893: SET suaaig.logical_delete_date = SYSDATE,
1894: suaaig.last_update_date = SYSDATE,
1895: suaaig.last_updated_by = fnd_global.user_id,
1896: suaaig.last_update_login = fnd_global.login_id
1897: WHERE suaaig.person_id = p_person_id
1898: AND suaaig.course_cd = p_course_cd
1899: AND suaaig.uoo_id = p_uoo_id
1900: AND suaaig.unit_ass_item_group_id IS NOT NULL
2037: --
2038: UPDATE igs_as_su_atmpt_itm suaai
2039: SET suaai.logical_delete_dt = NULL,
2040: suaai.last_update_date = SYSDATE,
2041: suaai.last_updated_by = fnd_global.user_id,
2042: suaai.last_update_login = fnd_global.login_id,
2043: suaai.request_id = fnd_global.conc_request_id,
2044: suaai.program_id = fnd_global.conc_program_id,
2045: suaai.program_application_id = fnd_global.prog_appl_id,
2038: UPDATE igs_as_su_atmpt_itm suaai
2039: SET suaai.logical_delete_dt = NULL,
2040: suaai.last_update_date = SYSDATE,
2041: suaai.last_updated_by = fnd_global.user_id,
2042: suaai.last_update_login = fnd_global.login_id,
2043: suaai.request_id = fnd_global.conc_request_id,
2044: suaai.program_id = fnd_global.conc_program_id,
2045: suaai.program_application_id = fnd_global.prog_appl_id,
2046: suaai.program_update_date = SYSDATE ,
2039: SET suaai.logical_delete_dt = NULL,
2040: suaai.last_update_date = SYSDATE,
2041: suaai.last_updated_by = fnd_global.user_id,
2042: suaai.last_update_login = fnd_global.login_id,
2043: suaai.request_id = fnd_global.conc_request_id,
2044: suaai.program_id = fnd_global.conc_program_id,
2045: suaai.program_application_id = fnd_global.prog_appl_id,
2046: suaai.program_update_date = SYSDATE ,
2047: suaai.midterm_mandatory_type_code = p_midterm_mandatory_type_code,
2040: suaai.last_update_date = SYSDATE,
2041: suaai.last_updated_by = fnd_global.user_id,
2042: suaai.last_update_login = fnd_global.login_id,
2043: suaai.request_id = fnd_global.conc_request_id,
2044: suaai.program_id = fnd_global.conc_program_id,
2045: suaai.program_application_id = fnd_global.prog_appl_id,
2046: suaai.program_update_date = SYSDATE ,
2047: suaai.midterm_mandatory_type_code = p_midterm_mandatory_type_code,
2048: suaai.midterm_weight_qty = p_midterm_weight_qty,
2041: suaai.last_updated_by = fnd_global.user_id,
2042: suaai.last_update_login = fnd_global.login_id,
2043: suaai.request_id = fnd_global.conc_request_id,
2044: suaai.program_id = fnd_global.conc_program_id,
2045: suaai.program_application_id = fnd_global.prog_appl_id,
2046: suaai.program_update_date = SYSDATE ,
2047: suaai.midterm_mandatory_type_code = p_midterm_mandatory_type_code,
2048: suaai.midterm_weight_qty = p_midterm_weight_qty,
2049: suaai.final_mandatory_type_code = p_final_mandatory_type_code,
2116: -- Item already exists; so apply the changed assessment item definition if any
2117: --
2118: UPDATE igs_as_su_atmpt_itm suaai
2119: SET suaai.last_update_date = SYSDATE,
2120: suaai.last_updated_by = fnd_global.user_id,
2121: suaai.last_update_login = fnd_global.login_id,
2122: suaai.request_id = fnd_global.conc_request_id,
2123: suaai.program_id = fnd_global.conc_program_id,
2124: suaai.program_application_id = fnd_global.prog_appl_id,
2117: --
2118: UPDATE igs_as_su_atmpt_itm suaai
2119: SET suaai.last_update_date = SYSDATE,
2120: suaai.last_updated_by = fnd_global.user_id,
2121: suaai.last_update_login = fnd_global.login_id,
2122: suaai.request_id = fnd_global.conc_request_id,
2123: suaai.program_id = fnd_global.conc_program_id,
2124: suaai.program_application_id = fnd_global.prog_appl_id,
2125: suaai.program_update_date = SYSDATE,
2118: UPDATE igs_as_su_atmpt_itm suaai
2119: SET suaai.last_update_date = SYSDATE,
2120: suaai.last_updated_by = fnd_global.user_id,
2121: suaai.last_update_login = fnd_global.login_id,
2122: suaai.request_id = fnd_global.conc_request_id,
2123: suaai.program_id = fnd_global.conc_program_id,
2124: suaai.program_application_id = fnd_global.prog_appl_id,
2125: suaai.program_update_date = SYSDATE,
2126: suaai.midterm_mandatory_type_code = p_midterm_mandatory_type_code,
2119: SET suaai.last_update_date = SYSDATE,
2120: suaai.last_updated_by = fnd_global.user_id,
2121: suaai.last_update_login = fnd_global.login_id,
2122: suaai.request_id = fnd_global.conc_request_id,
2123: suaai.program_id = fnd_global.conc_program_id,
2124: suaai.program_application_id = fnd_global.prog_appl_id,
2125: suaai.program_update_date = SYSDATE,
2126: suaai.midterm_mandatory_type_code = p_midterm_mandatory_type_code,
2127: suaai.midterm_weight_qty = p_midterm_weight_qty,
2120: suaai.last_updated_by = fnd_global.user_id,
2121: suaai.last_update_login = fnd_global.login_id,
2122: suaai.request_id = fnd_global.conc_request_id,
2123: suaai.program_id = fnd_global.conc_program_id,
2124: suaai.program_application_id = fnd_global.prog_appl_id,
2125: suaai.program_update_date = SYSDATE,
2126: suaai.midterm_mandatory_type_code = p_midterm_mandatory_type_code,
2127: suaai.midterm_weight_qty = p_midterm_weight_qty,
2128: suaai.final_mandatory_type_code = p_final_mandatory_type_code,