eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_INTERFACE_EXT_GRP SQL Statements

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

Line: 234


     x_out_rec.selection_issue_flag  	    := p_in_rec.selection_issue_flag ;

Line: 413


x_out_tab(i).LAST_UPDATE_DATE                 := handle_missing_info(p_in_tab(i).LAST_UPDATE_DATE);

Line: 414


x_out_tab(i).LAST_UPDATED_BY                  := handle_missing_info(p_in_tab(i).LAST_UPDATED_BY);

Line: 415


x_out_tab(i).LAST_UPDATE_LOGIN                := handle_missing_info(p_in_tab(i).LAST_UPDATE_LOGIN);

Line: 418


x_out_tab(i).PROGRAM_UPDATE_DATE              := handle_missing_info(p_in_tab(i).PROGRAM_UPDATE_DATE);

Line: 503


  PROCEDURE Create_Update_Delivery
  ( p_api_version_number     IN   NUMBER,
    p_init_msg_list          IN   VARCHAR2,
    p_commit		     IN   VARCHAR2 , -- default fnd_api.g_false
    p_in_rec                 IN   WSH_INTERFACE_EXT_GRP.Del_In_Rec_Type,
    p_rec_attr_tab	     IN   WSH_INTERFACE_EXT_GRP.Delivery_Attr_Tbl_Type,
    x_del_out_rec_tab        OUT  NOCOPY WSH_INTERFACE_EXT_GRP.Del_Out_Tbl_Type,
    x_return_status          OUT  NOCOPY VARCHAR2,
    x_msg_count              OUT  NOCOPY NUMBER,
    x_msg_data               OUT  NOCOPY VARCHAR2)
  IS
    --

    l_Del_In_Rec_Type            WSH_DELIVERIES_GRP.Del_In_Rec_Type;

Line: 526


    WSH_INTERFACE_GRP.Create_Update_Delivery(
    p_api_version_number     =>   p_api_version_number,
    p_init_msg_list          =>   p_init_msg_list,
    p_commit                 =>   p_commit , -- default fnd_api.g_false
    p_in_rec                 =>   l_Del_In_Rec_Type,
    p_rec_attr_tab           =>   l_Del_Attr_Tbl_Type,
    x_del_out_rec_tab        =>   l_Del_Out_Tbl_Type,
    x_return_status          =>   x_return_status,
    x_msg_count              =>   x_msg_count,
    x_msg_data               =>   x_msg_data);

Line: 544


      wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_DELIVERY');

Line: 547


END Create_Update_Delivery;

Line: 587


         x_out_rec.selection_issue_flag  :=  p_in_rec.selection_issue_flag;

Line: 758


       x_out_tab(i).last_update_date           	  := handle_missing_info(p_in_tab(i).last_update_date,l_entity,p_action);

Line: 759


       x_out_tab(i).last_update_login          	  := handle_missing_info(p_in_tab(i).last_update_login,l_entity,p_action);

Line: 760


       x_out_tab(i).last_updated_by            	  := handle_missing_info(p_in_tab(i).last_updated_by,l_entity,p_action);

Line: 763


       x_out_tab(i).program_update_date        	  := handle_missing_info(p_in_tab(i).program_update_date,l_entity,p_action);

Line: 886


    PROCEDURE Create_Update_Delivery_Detail
    (
       -- Standard Parameters
       p_api_version_number	 IN	 NUMBER,
       p_init_msg_list           IN 	 VARCHAR2,
       p_commit                  IN 	 VARCHAR2,
       x_return_status           OUT NOCOPY	 VARCHAR2,
       x_msg_count               OUT NOCOPY	 NUMBER,
       x_msg_data                OUT NOCOPY	 VARCHAR2,

       -- Procedure Specific Parameters
       p_detail_info_tab         IN 	WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type,
       p_IN_rec                  IN  	WSH_INTERFACE_EXT_GRP.detailInRecType,
       x_OUT_rec                 OUT NOCOPY	WSH_INTERFACE_EXT_GRP.detailOutRecType
    ) IS

       l_det_Attr_tbl_Type  wsh_glbl_var_strct_grp.delivery_details_Attr_tbl_Type;

Line: 930


    WSH_INTERFACE_GRP.Create_Update_Delivery_Detail (
       -- Standard Parameters
       p_api_version_number      =>      p_api_version_number,
       p_init_msg_list           =>      p_init_msg_list,
       p_commit                  =>      p_commit,
       x_return_status           =>      x_return_status,
       x_msg_count               =>      x_msg_count,
       x_msg_data                =>      x_msg_data,

       -- Procedure Specific Parameters
       p_detail_info_tab         =>     l_det_Attr_tbl_Type,
       p_IN_rec                  =>     l_detailInRecType,
       x_OUT_rec                 =>     l_detailOutRecType
    );

Line: 950


               WSH_UTIL_CORE.default_handler('WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail');

Line: 952


  END Create_Update_Delivery_Detail;

Line: 992


          x_out_rec.selection_issue_flag     	:= p_in_rec.selection_issue_flag;

Line: 1071


   x_out_rec.selection_issue_flag     := p_in_rec.selection_issue_flag;

Line: 1194


x_out_tab(i).LAST_UPDATE_DATE                := handle_missing_info(p_in_tab(i).LAST_UPDATE_DATE);

Line: 1195


x_out_tab(i).LAST_UPDATED_BY                 := handle_missing_info(p_in_tab(i).LAST_UPDATED_BY);

Line: 1196


x_out_tab(i).LAST_UPDATE_LOGIN               := handle_missing_info(p_in_tab(i).LAST_UPDATE_LOGIN);

Line: 1199


x_out_tab(i).PROGRAM_UPDATE_DATE             := handle_missing_info(p_in_tab(i).PROGRAM_UPDATE_DATE);

Line: 1254


PROCEDURE CREATE_UPDATE_STOP(
        p_api_version_number    IN NUMBER,
        p_init_msg_list         IN VARCHAR2,
        p_commit                IN VARCHAR2,
        p_in_rec                IN WSH_INTERFACE_EXT_GRP.stopInRecType,
        p_rec_attr_tab          IN WSH_INTERFACE_EXT_GRP.Stop_Attr_Tbl_Type,
        x_stop_out_tab          OUT NOCOPY WSH_INTERFACE_EXT_GRP.stop_out_tab_type,
        x_return_status         OUT NOCOPY VARCHAR2,
        x_msg_count             OUT NOCOPY NUMBER,
        x_msg_data              OUT NOCOPY VARCHAR2) IS

        l_stopInRecType             WSH_TRIP_STOPS_GRP.stopInRecType;

Line: 1273


WSH_INTERFACE_GRP.CREATE_UPDATE_STOP(
        p_api_version_number    => p_api_version_number,
        p_init_msg_list         => p_init_msg_list,
        p_commit                => p_commit,
        p_in_rec                => l_stopInRecType,
        p_rec_attr_tab          => l_Stop_Attr_Tbl_Type,
        x_stop_out_tab          => l_stop_out_tab_type,
        x_return_status         => x_return_status,
        x_msg_count             => x_msg_count,
        x_msg_data              => x_msg_data) ;

Line: 1289


      wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_STOP');

Line: 1291


END Create_Update_Stop;

Line: 1331


 x_out_tab(i).LAST_UPDATE_DATE          := handle_missing_info(p_in_tab(i).LAST_UPDATE_DATE          );

Line: 1332


 x_out_tab(i).LAST_UPDATED_BY           := handle_missing_info(p_in_tab(i).LAST_UPDATED_BY           );

Line: 1333


 x_out_tab(i).LAST_UPDATE_LOGIN         := handle_missing_info(p_in_tab(i).LAST_UPDATE_LOGIN         );

Line: 1336


 x_out_tab(i).PROGRAM_UPDATE_DATE       := handle_missing_info(p_in_tab(i).PROGRAM_UPDATE_DATE       );

Line: 1414


PROCEDURE Create_Update_Trip(
        p_api_version_number     IN     NUMBER,
        p_init_msg_list          IN     VARCHAR2,
        p_commit                 IN     VARCHAR2,
        x_return_status          OUT    NOCOPY VARCHAR2,
        x_msg_count              OUT    NOCOPY NUMBER,
        x_msg_data               OUT    NOCOPY VARCHAR2,
        p_trip_info_tab          IN     WSH_INTERFACE_EXT_GRP.Trip_Attr_Tbl_Type,
        p_In_rec                 IN     WSH_INTERFACE_EXT_GRP.tripInRecType,
        x_Out_Tab                OUT    NOCOPY WSH_INTERFACE_EXT_GRP.trip_Out_Tab_Type) IS

        l_Trip_Attr_Tbl_Type     WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

Line: 1433


WSH_INTERFACE_GRP.Create_Update_Trip(
        p_api_version_number     =>     p_api_version_number,
        p_init_msg_list          =>     p_init_msg_list,
        p_commit                 =>     p_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_Attr_Tbl_Type,
        p_In_rec                 =>     l_tripInRecType,
        x_Out_Tab                =>     l_trip_Out_Tab_Type);

Line: 1449


      wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_TRIP');

Line: 1451


END Create_Update_Trip;

Line: 1495


x_out_tab(i).LAST_UPDATE_DATE       	    := handle_missing_info(p_in_tab(i).LAST_UPDATE_DATE  );

Line: 1496


x_out_tab(i).LAST_UPDATE_LOGIN      	    := handle_missing_info(p_in_tab(i).LAST_UPDATE_LOGIN );

Line: 1499


x_out_tab(i).PROGRAM_UPDATE_DATE    	    := handle_missing_info(p_in_tab(i).PROGRAM_UPDATE_DATE    );

Line: 1550


PROCEDURE Create_Update_Freight_Costs(
        p_api_version_number     IN     NUMBER,
        p_init_msg_list          IN     VARCHAR2,
        p_commit                 IN     VARCHAR2,
        x_return_status          OUT    NOCOPY VARCHAR2,
        x_msg_count              OUT    NOCOPY NUMBER,
        x_msg_data               OUT    NOCOPY VARCHAR2,
        p_freight_info_tab       IN     WSH_INTERFACE_EXT_GRP.freight_rec_tab_type,
        p_in_rec                 IN     WSH_INTERFACE_EXT_GRP.freightInRecType,
        x_out_tab                OUT    NOCOPY WSH_INTERFACE_EXT_GRP.freight_out_tab_type) IS

        l_freight_rec_tab_type  WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;

Line: 1570


WSH_INTERFACE_GRP.Create_Update_Freight_Costs(
        p_api_version_number     =>     p_api_version_number,
        p_init_msg_list          =>     p_init_msg_list,
        p_commit                 =>     p_commit,
        x_return_status          =>     x_return_status,
        x_msg_count              =>     x_msg_count,
        x_msg_data               =>     x_msg_data,
        p_freight_info_tab       =>     l_freight_rec_tab_type,
        p_in_rec                 =>     l_freightInRecType,
        x_out_tab                =>     l_freight_out_tab_type);

Line: 1585


      wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_FREIGHT_COSTS');

Line: 1586


END Create_Update_Freight_costs;

Line: 1726


                                                       WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
                                                       WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
                                                       WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS)) THEN

      IF l_debug_on THEN
        WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.GET_OTM_DELIVERY_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);

Line: 1804


                                                           WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
                                                           WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS
                                                          )) THEN

      IF l_debug_on THEN
        WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.GET_OTM_DELIVERY_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);