1187: /*===================================================*/
1188: /* 3050444 old issue 2
1189: update xtr_batch_events
1190: set authorized = 'Y',
1191: authorized_by = fnd_global.user_id,
1192: authorized_on = trunc(sysdate),
1193: last_updated_by = fnd_global.user_id,
1194: last_update_date = trunc(sysdate),
1195: last_update_login = fnd_global.user_id
1189: update xtr_batch_events
1190: set authorized = 'Y',
1191: authorized_by = fnd_global.user_id,
1192: authorized_on = trunc(sysdate),
1193: last_updated_by = fnd_global.user_id,
1194: last_update_date = trunc(sysdate),
1195: last_update_login = fnd_global.user_id
1196: where batch_id = p_batch_id
1197: and event_code = C_REVAL;
1191: authorized_by = fnd_global.user_id,
1192: authorized_on = trunc(sysdate),
1193: last_updated_by = fnd_global.user_id,
1194: last_update_date = trunc(sysdate),
1195: last_update_login = fnd_global.user_id
1196: where batch_id = p_batch_id
1197: and event_code = C_REVAL;
1198: */
1199:
1626: /* Authorize Accrual Details */
1627: /*===================================================*/
1628: update xtr_batch_events
1629: set authorized = 'Y',
1630: authorized_by = fnd_global.user_id,
1631: authorized_on = trunc(sysdate),
1632: last_updated_by = fnd_global.user_id,
1633: last_update_date = trunc(sysdate),
1634: last_update_login = fnd_global.user_id
1628: update xtr_batch_events
1629: set authorized = 'Y',
1630: authorized_by = fnd_global.user_id,
1631: authorized_on = trunc(sysdate),
1632: last_updated_by = fnd_global.user_id,
1633: last_update_date = trunc(sysdate),
1634: last_update_login = fnd_global.user_id
1635: where batch_id = p_batch_id
1636: and event_code = C_ACCRUAL;
1630: authorized_by = fnd_global.user_id,
1631: authorized_on = trunc(sysdate),
1632: last_updated_by = fnd_global.user_id,
1633: last_update_date = trunc(sysdate),
1634: last_update_login = fnd_global.user_id
1635: where batch_id = p_batch_id
1636: and event_code = C_ACCRUAL;
1637:
1638: COMMIT;