APPS.WSH_TRIP_STOPS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 170

       l_action_prms.action_code := 'UPDATE-STATUS';

Line: 339

  x_pvt_stop_rec.LAST_UPDATE_DATE		:= p_pub_stop_rec.LAST_UPDATE_DATE;

Line: 340

  x_pvt_stop_rec.LAST_UPDATED_BY		:= p_pub_stop_rec.LAST_UPDATED_BY;

Line: 341

  x_pvt_stop_rec.LAST_UPDATE_LOGIN		:= p_pub_stop_rec.LAST_UPDATE_LOGIN;

Line: 344

  x_pvt_stop_rec.PROGRAM_UPDATE_DATE	  	:= p_pub_stop_rec.PROGRAM_UPDATE_DATE;

Line: 408

PROCEDURE Create_Update_Stop
  ( p_api_version_number     IN   NUMBER,
    p_init_msg_list          IN   VARCHAR2,
    x_return_status          OUT NOCOPY   VARCHAR2,
    x_msg_count              OUT NOCOPY   NUMBER,
    x_msg_data               OUT NOCOPY   VARCHAR2,
    p_action_code            IN   VARCHAR2,
    p_stop_info	         IN OUT NOCOPY   Trip_Stop_Pub_Rec_Type,
    p_trip_id                IN   NUMBER DEFAULT FND_API.G_MISS_NUM,
    p_trip_name              IN   VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
    p_stop_location_id       IN   NUMBER DEFAULT FND_API.G_MISS_NUM,
    p_stop_location_code     IN   VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
    p_planned_dep_date       IN   DATE DEFAULT FND_API.G_MISS_DATE,
    x_stop_id                OUT NOCOPY   NUMBER) IS

l_debug_on BOOLEAN;

Line: 424

l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Update_Stop';

Line: 427

l_api_name           CONSTANT VARCHAR2(30):= 'Create_Update_Stop';

Line: 446

      wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');

Line: 507

   WSH_INTERFACE_GRP.CREATE_UPDATE_STOP(
        p_api_version_number    => p_api_version_number,
        p_init_msg_list         => p_init_msg_list,
        p_commit                => l_commit,
        p_in_rec                => l_in_rec,
        p_rec_attr_tab          => l_rec_attr_tab,
        x_stop_out_tab          => l_stop_out_tab,
        x_return_status         => x_return_status,
        x_msg_count             => x_msg_count,
        x_msg_data              => x_msg_data);

Line: 519

      WSH_DEBUG_SV.log(l_module_name,'WSH_INTERFACE_GRP.CREATE_UPDATE_STOP x_return_status',x_return_status);

Line: 574

      wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

Line: 585

END Create_Update_Stop;