983: BEGIN
984: x_progress := '004';
985: SELECT nvl(ship_to_location_id,location_id)
986: INTO x_ship_to_location_id
987: FROM hr_locations
988: WHERE location_id = x_deliver_to_location_id;
989:
990: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
991: fnd_log.string(fnd_log.level_statement,g_log_head,'x_ship_to_location_id : '||x_ship_to_location_id);
2847: BEGIN
2848: x_progress := '004';
2849: SELECT nvl(ship_to_location_id,location_id)
2850: INTO x_ship_to_location_id
2851: FROM hr_locations
2852: WHERE location_id = x_deliver_to_location_id;
2853:
2854: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2855: fnd_log.string(fnd_log.level_statement,g_log_head,'x_ship_to_location_id : '||x_ship_to_location_id);