APPS.FTE_WORKFLOW_UTIL SQL Statements

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

Line: 18

        SELECT WDL.DELIVERY_ID
        FROM WSH_TRIP_STOPS WTS, WSH_DELIVERY_LEGS WDL
        WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID
        AND WTS.TRIP_ID = c_trip_id;

Line: 32

        SELECT WDL.DELIVERY_ID
        FROM WSH_DELIVERY_LEGS WDL
        WHERE WDL.DELIVERY_LEG_ID = c_dleg_id;

Line: 45

        SELECT WTS.TRIP_ID
        FROM WSH_TRIP_STOPS WTS, WSH_DELIVERY_LEGS WDL
        WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID
        AND WDL.DELIVERY_LEG_ID = c_dleg_id;

Line: 59

        SELECT ORGANIZATION_ID
        FROM WSH_NEW_DELIVERIES
        WHERE DELIVERY_ID = c_del_id;

Line: 96

            WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.fte.trip.svc.serviceselectioninitiated for trip '||p_trip_id);

Line: 104

                p_event         => 'oracle.apps.fte.trip.svc.serviceselectioninitiated' ,
                x_return_status => l_return_status);

Line: 114

                WSH_DEBUG_SV.logmsg(l_module_name, 'Unable to raise Select Service Init for trip '||p_trip_id);

Line: 174

            WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.wsh.delivery.svc.serviceselected for delivery '||p_del_id||', org '||p_org_id);

Line: 182

                p_event         => 'oracle.apps.fte.delivery.svc.serviceselected',
                p_organization_id =>  p_org_id,
                x_return_status => l_return_status);

Line: 193

                WSH_DEBUG_SV.logmsg(l_module_name, 'Unable to raise Select Service for delivery '||p_del_id||', org '||p_org_id);

Line: 314

    PROCEDURE Trip_Select_Service_Init(
                p_trip_id           IN NUMBER,
                x_return_status     OUT NOCOPY VARCHAR2)
    IS
        l_del_id            NUMBER;

Line: 321

        l_module_name       CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'TRIP_SELECT_SERVICE_INIT';

Line: 340

            WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection Initiated for the trip '||p_trip_id);

Line: 355

                WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service Initiated for the trip '||p_trip_id||' failed');

Line: 376

                WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection for the delivery '||l_del_id);

Line: 392

                    WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service for the delivery '||l_del_id||' failed');

Line: 422

    END Trip_Select_Service_Init;

Line: 537

    PROCEDURE Dleg_Select_Service(
                p_dleg_id           IN NUMBER,
                x_return_status     OUT NOCOPY VARCHAR2)
    IS
        l_trip_id           NUMBER;

Line: 545

        l_module_name       CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'DLEG_SELECT_SERVICE';

Line: 581

            WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection for the delivery '||l_del_id);

Line: 597

                WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service for the delivery '||l_del_id||' failed');

Line: 615

                WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection Initiated for the trip '||l_trip_id);

Line: 630

                    WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service for the trip '||l_trip_id||' failed');

Line: 662

    END Dleg_Select_Service;