481: NULL,
482: NULL)),
483: geometry_status_code = p_status,
484: last_update_date = sysdate,
485: last_updated_by = fnd_global.user_id,
486: last_update_login = fnd_global.login_id,
487: request_id = fnd_global.conc_request_id,
488: program_application_id = fnd_global.prog_appl_id,
489: program_id = fnd_global.conc_program_id,
482: NULL)),
483: geometry_status_code = p_status,
484: last_update_date = sysdate,
485: last_updated_by = fnd_global.user_id,
486: last_update_login = fnd_global.login_id,
487: request_id = fnd_global.conc_request_id,
488: program_application_id = fnd_global.prog_appl_id,
489: program_id = fnd_global.conc_program_id,
490: program_update_date = sysdate
483: geometry_status_code = p_status,
484: last_update_date = sysdate,
485: last_updated_by = fnd_global.user_id,
486: last_update_login = fnd_global.login_id,
487: request_id = fnd_global.conc_request_id,
488: program_application_id = fnd_global.prog_appl_id,
489: program_id = fnd_global.conc_program_id,
490: program_update_date = sysdate
491: WHERE
484: last_update_date = sysdate,
485: last_updated_by = fnd_global.user_id,
486: last_update_login = fnd_global.login_id,
487: request_id = fnd_global.conc_request_id,
488: program_application_id = fnd_global.prog_appl_id,
489: program_id = fnd_global.conc_program_id,
490: program_update_date = sysdate
491: WHERE
492: location_id = p_loc_id;
485: last_updated_by = fnd_global.user_id,
486: last_update_login = fnd_global.login_id,
487: request_id = fnd_global.conc_request_id,
488: program_application_id = fnd_global.prog_appl_id,
489: program_id = fnd_global.conc_program_id,
490: program_update_date = sysdate
491: WHERE
492: location_id = p_loc_id;
493: