APPS.WSH_ACTIONS_LEVELS SQL Statements

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

Line: 153

     g_validation_level_tab(C_CHK_UPDATE_STATUS_LVL)     :=1;

Line: 363

     g_validation_level_tab(C_CHK_UPDATE_STATUS_LVL)     :=0;

Line: 536

           ELSIF p_action IN ('CREATE', 'UPDATE') THEN
              IF (p_action = 'CREATE')  THEN
                 g_validation_level_tab(C_CONTAINER_ORG_LVL) := 1;

Line: 547

              IF(p_action = 'UPDATE') THEN
                 g_validation_level_tab(C_DISABLED_LIST_LVL) := 1;

Line: 551

               OR (p_action = 'UPDATE' ) THEN
                  g_validation_level_tab(C_WMS_CONTAINERS_LVL) := 1;

Line: 603

        ELSIF p_action = 'UPDATE' THEN
          g_validation_level_tab(C_NUMBER_OF_LPN_LVL) := 1;

Line: 678

        ELSIF p_action IN( 'CREATE','UPDATE') THEN
           g_validation_level_tab(C_VALIDATE_CONSTRAINTS_LVL) := 1;

Line: 703

           IF p_action = 'UPDATE' THEN
             g_validation_level_tab(C_DELIVERY_NAME_LVL)       := 1;

Line: 717

     IF p_action IN ('CREATE','UPDATE') THEN
       g_validation_level_tab(C_TRIP_STOP_VALIDATION_LVL) := 1;

Line: 739

           g_validation_level_tab(C_CHK_UPDATE_STATUS_LVL):=1;

Line: 756

           IF p_action = 'UPDATE-STATUS' THEN
              g_validation_level_tab(C_STOP_DEFAULTS_LVL) := 1;

Line: 762

           g_validation_level_tab(C_CHK_UPDATE_STATUS_LVL):=1;

Line: 766

           IF p_action = 'UPDATE-STATUS' THEN
              g_validation_level_tab(C_TRIP_STOP_VALIDATION_LVL) := 1;

Line: 796

        g_validation_level_tab(C_CHK_UPDATE_STATUS_LVL):=1;

Line: 808

        IF p_action ='UPDATE-STATUS' THEN
           g_validation_level_tab(C_TRIP_STOP_VALIDATION_LVL) := 1;

Line: 817

     IF p_action = 'UPDATE' THEN
       g_validation_level_tab(C_TRIP_STOP_VALIDATION_LVL) := 1;

Line: 829

     IF p_action IN ('CREATE', 'UPDATE') THEN
        g_validation_level_tab(C_CONSOL_ALLW_LVL)    :=1;