223: l_net_zero_flag(l_j) ,
224: l_reduce_capacity_flag(l_j) ,
225: l_line_num_reversed(l_j) ,
226: sysdate ,
227: fnd_global.user_id ,
228: sysdate ,
229: fnd_global.user_id ,
230: fnd_global.login_id ,
231: fnd_global.conc_request_id() ,
225: l_line_num_reversed(l_j) ,
226: sysdate ,
227: fnd_global.user_id ,
228: sysdate ,
229: fnd_global.user_id ,
230: fnd_global.login_id ,
231: fnd_global.conc_request_id() ,
232: fnd_global.prog_appl_id () ,
233: fnd_global.conc_program_id() ,
226: sysdate ,
227: fnd_global.user_id ,
228: sysdate ,
229: fnd_global.user_id ,
230: fnd_global.login_id ,
231: fnd_global.conc_request_id() ,
232: fnd_global.prog_appl_id () ,
233: fnd_global.conc_program_id() ,
234: trunc(sysdate)
227: fnd_global.user_id ,
228: sysdate ,
229: fnd_global.user_id ,
230: fnd_global.login_id ,
231: fnd_global.conc_request_id() ,
232: fnd_global.prog_appl_id () ,
233: fnd_global.conc_program_id() ,
234: trunc(sysdate)
235: -- Start Bug 2592045: Finish select statement.
228: sysdate ,
229: fnd_global.user_id ,
230: fnd_global.login_id ,
231: fnd_global.conc_request_id() ,
232: fnd_global.prog_appl_id () ,
233: fnd_global.conc_program_id() ,
234: trunc(sysdate)
235: -- Start Bug 2592045: Finish select statement.
236: from pa_forecast_items fi
229: fnd_global.user_id ,
230: fnd_global.login_id ,
231: fnd_global.conc_request_id() ,
232: fnd_global.prog_appl_id () ,
233: fnd_global.conc_program_id() ,
234: trunc(sysdate)
235: -- Start Bug 2592045: Finish select statement.
236: from pa_forecast_items fi
237: where fi.forecast_item_id = l_forecast_item_id(l_j);
422: reduce_capacity_flag = l_reduce_capacity_flag(l_j) ,
423: net_zero_flag = l_net_zero_flag(l_j) ,
424: line_num_reversed = l_line_num_reversed(l_j) ,
425: last_update_date = sysdate ,
426: last_updated_by = fnd_global.user_id ,
427: last_update_login = fnd_global.login_id
428: WHERE forecast_item_id = l_forecast_item_id(l_j)
429: AND line_num = l_line_num(l_j);
430:
423: net_zero_flag = l_net_zero_flag(l_j) ,
424: line_num_reversed = l_line_num_reversed(l_j) ,
425: last_update_date = sysdate ,
426: last_updated_by = fnd_global.user_id ,
427: last_update_login = fnd_global.login_id
428: WHERE forecast_item_id = l_forecast_item_id(l_j)
429: AND line_num = l_line_num(l_j);
430:
431: PA_FORECAST_ITEMS_UTILS.log_message('end of update row .... ');