490: NULL)),
491: geometry_status_code = p_status,
492: geometry_source = p_geo_source,
493: last_update_date = sysdate,
494: last_updated_by = fnd_global.user_id,
495: last_update_login = fnd_global.login_id,
496: request_id = fnd_global.conc_request_id,
497: program_application_id = fnd_global.prog_appl_id,
498: program_id = fnd_global.conc_program_id,
491: geometry_status_code = p_status,
492: geometry_source = p_geo_source,
493: last_update_date = sysdate,
494: last_updated_by = fnd_global.user_id,
495: last_update_login = fnd_global.login_id,
496: request_id = fnd_global.conc_request_id,
497: program_application_id = fnd_global.prog_appl_id,
498: program_id = fnd_global.conc_program_id,
499: program_update_date = sysdate
492: geometry_source = p_geo_source,
493: last_update_date = sysdate,
494: last_updated_by = fnd_global.user_id,
495: last_update_login = fnd_global.login_id,
496: request_id = fnd_global.conc_request_id,
497: program_application_id = fnd_global.prog_appl_id,
498: program_id = fnd_global.conc_program_id,
499: program_update_date = sysdate
500: WHERE
493: last_update_date = sysdate,
494: last_updated_by = fnd_global.user_id,
495: last_update_login = fnd_global.login_id,
496: request_id = fnd_global.conc_request_id,
497: program_application_id = fnd_global.prog_appl_id,
498: program_id = fnd_global.conc_program_id,
499: program_update_date = sysdate
500: WHERE
501: location_id = p_loc_id;
494: last_updated_by = fnd_global.user_id,
495: last_update_login = fnd_global.login_id,
496: request_id = fnd_global.conc_request_id,
497: program_application_id = fnd_global.prog_appl_id,
498: program_id = fnd_global.conc_program_id,
499: program_update_date = sysdate
500: WHERE
501: location_id = p_loc_id;
502:
885: v_object_type(ins_index),
886: v_object_id(ins_index),
887: P_USER_ID,
888: sysdate,
889: fnd_global.user_id,
890: sysdate,
891: fnd_global.user_id,
892: fnd_global.login_id);
893: end if;
887: P_USER_ID,
888: sysdate,
889: fnd_global.user_id,
890: sysdate,
891: fnd_global.user_id,
892: fnd_global.login_id);
893: end if;
894: end loop;
895: end if;
888: sysdate,
889: fnd_global.user_id,
890: sysdate,
891: fnd_global.user_id,
892: fnd_global.login_id);
893: end if;
894: end loop;
895: end if;
896: end if;