845: --
846: UPDATE igs_as_su_atmpt_itm suaai
847: SET suaai.logical_delete_dt = SYSDATE,
848: suaai.last_update_date = SYSDATE,
849: suaai.last_updated_by = fnd_global.user_id,
850: suaai.last_update_login = fnd_global.login_id,
851: suaai.request_id = fnd_global.conc_request_id,
852: suaai.program_id = fnd_global.conc_program_id,
853: suaai.program_application_id = fnd_global.prog_appl_id,
846: UPDATE igs_as_su_atmpt_itm suaai
847: SET suaai.logical_delete_dt = SYSDATE,
848: suaai.last_update_date = SYSDATE,
849: suaai.last_updated_by = fnd_global.user_id,
850: suaai.last_update_login = fnd_global.login_id,
851: suaai.request_id = fnd_global.conc_request_id,
852: suaai.program_id = fnd_global.conc_program_id,
853: suaai.program_application_id = fnd_global.prog_appl_id,
854: suaai.program_update_date = SYSDATE
847: SET suaai.logical_delete_dt = SYSDATE,
848: suaai.last_update_date = SYSDATE,
849: suaai.last_updated_by = fnd_global.user_id,
850: suaai.last_update_login = fnd_global.login_id,
851: suaai.request_id = fnd_global.conc_request_id,
852: suaai.program_id = fnd_global.conc_program_id,
853: suaai.program_application_id = fnd_global.prog_appl_id,
854: suaai.program_update_date = SYSDATE
855: WHERE suaai.unit_cd = p_unit_cd
848: suaai.last_update_date = SYSDATE,
849: suaai.last_updated_by = fnd_global.user_id,
850: suaai.last_update_login = fnd_global.login_id,
851: suaai.request_id = fnd_global.conc_request_id,
852: suaai.program_id = fnd_global.conc_program_id,
853: suaai.program_application_id = fnd_global.prog_appl_id,
854: suaai.program_update_date = SYSDATE
855: WHERE suaai.unit_cd = p_unit_cd
856: AND suaai.cal_type = p_cal_type
849: suaai.last_updated_by = fnd_global.user_id,
850: suaai.last_update_login = fnd_global.login_id,
851: suaai.request_id = fnd_global.conc_request_id,
852: suaai.program_id = fnd_global.conc_program_id,
853: suaai.program_application_id = fnd_global.prog_appl_id,
854: suaai.program_update_date = SYSDATE
855: WHERE suaai.unit_cd = p_unit_cd
856: AND suaai.cal_type = p_cal_type
857: AND suaai.ci_sequence_number = p_ci_sequence_number