APPS.WSH_TRIPS_PUB SQL Statements

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

Line: 583

  x_pvt_trip_rec.LAST_UPDATE_DATE			 := p_pub_trip_rec.LAST_UPDATE_DATE;

Line: 584

  x_pvt_trip_rec.LAST_UPDATED_BY			  := p_pub_trip_rec.LAST_UPDATED_BY;

Line: 585

  x_pvt_trip_rec.LAST_UPDATE_LOGIN			:= p_pub_trip_rec.LAST_UPDATE_LOGIN;

Line: 588

  x_pvt_trip_rec.PROGRAM_UPDATE_DATE		  := p_pub_trip_rec.PROGRAM_UPDATE_DATE;

Line: 690

PROCEDURE Create_Update_Trip
  ( 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_trip_info          IN OUT NOCOPY   Trip_Pub_Rec_Type,
    p_trip_name              IN   VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
    x_trip_id                OUT NOCOPY   NUMBER,
    x_trip_name              OUT NOCOPY   VARCHAR2) IS

l_api_version_number CONSTANT NUMBER := 1.0;

Line: 703

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

Line: 706

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

Line: 725

      wsh_debug_sv.push (l_module_name, 'Create_Update_Trip');

Line: 777

   WSH_INTERFACE_GRP.Create_Update_Trip(
        p_api_version_number     => p_api_version_number,
        p_init_msg_list          => p_init_msg_list,
        p_commit                 => l_commit,
        x_return_status          => x_return_status,
        x_msg_count              => x_msg_count,
        x_msg_data               => x_msg_data,
        p_trip_info_tab          => l_trip_info_tab,
        p_In_rec                 => l_In_rec,
        x_Out_tab                => l_Out_Tab);

Line: 789

       wsh_debug_sv.log (l_module_name,'WSH_INTERFACE_GRP.Create_Update_Trip x_return_status',x_return_status);

Line: 843

      wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

Line: 854

END Create_Update_Trip;