APPS.WSH_ACTIONS_LEVELS SQL Statements

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

Line: 152

     g_validation_level_tab(C_CHK_UPDATE_STATUS_LVL)     :=1;

Line: 361

     g_validation_level_tab(C_CHK_UPDATE_STATUS_LVL)     :=0;

Line: 534

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

Line: 545

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

Line: 549

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

Line: 601

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

Line: 670

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

Line: 694

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

Line: 708

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

Line: 730

           g_validation_level_tab(C_CHK_UPDATE_STATUS_LVL):=1;

Line: 747

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

Line: 753

           g_validation_level_tab(C_CHK_UPDATE_STATUS_LVL):=1;

Line: 757

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

Line: 787

        g_validation_level_tab(C_CHK_UPDATE_STATUS_LVL):=1;

Line: 799

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

Line: 808

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

Line: 820

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