2172: UPDATE xla_ae_headers
2173: SET gl_transfer_status_code = 'Y',
2174: gl_transfer_date = TO_CHAR (SYSDATE, 'DD-MON-YYYY'),
2175: last_update_date = TO_CHAR (SYSDATE, 'DD-MON-YYYY'),
2176: last_updated_by = fnd_profile.VALUE ('USER_ID'),
2177: last_update_login = fnd_profile.VALUE ('LOGIN_ID')
2178: WHERE GROUP_ID = l_group_id
2179: AND accounting_entry_status_code = 'F'
2180: AND gl_transfer_status_code = 'S';
2173: SET gl_transfer_status_code = 'Y',
2174: gl_transfer_date = TO_CHAR (SYSDATE, 'DD-MON-YYYY'),
2175: last_update_date = TO_CHAR (SYSDATE, 'DD-MON-YYYY'),
2176: last_updated_by = fnd_profile.VALUE ('USER_ID'),
2177: last_update_login = fnd_profile.VALUE ('LOGIN_ID')
2178: WHERE GROUP_ID = l_group_id
2179: AND accounting_entry_status_code = 'F'
2180: AND gl_transfer_status_code = 'S';
2181:
2198: UPDATE xla_ae_headers
2199: SET GROUP_ID = NULL,
2200: gl_transfer_status_code = 'N',
2201: last_update_date = TO_CHAR (SYSDATE, 'DD-MON-YYYY'),
2202: last_updated_by = fnd_profile.VALUE ('USER_ID'),
2203: last_update_login = fnd_profile.VALUE ('LOGIN_ID')
2204: WHERE GROUP_ID = l_group_id
2205: AND accounting_entry_status_code = 'F'
2206: AND gl_transfer_status_code = 'S';
2199: SET GROUP_ID = NULL,
2200: gl_transfer_status_code = 'N',
2201: last_update_date = TO_CHAR (SYSDATE, 'DD-MON-YYYY'),
2202: last_updated_by = fnd_profile.VALUE ('USER_ID'),
2203: last_update_login = fnd_profile.VALUE ('LOGIN_ID')
2204: WHERE GROUP_ID = l_group_id
2205: AND accounting_entry_status_code = 'F'
2206: AND gl_transfer_status_code = 'S';
2207: