APPS.AHL_LTP_SPACE_ASSIGN_PUB SQL Statements

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

Line: 105

    	-- To Update space assignment
        ELSIF p_x_space_assignment_tbl(i).operation_flag = 'U' THEN
         Ahl_Ltp_Space_Assign_Pvt.UPDATE_SPACE_ASSIGNMENT
           (
            p_api_version             => l_api_version,
            p_init_msg_list           => p_init_msg_list,
            p_commit                  => p_commit,
            p_validation_level        => p_validation_level,
            p_module_type             => p_module_type,
            p_space_assign_rec        => p_x_space_assignment_tbl(i),
            x_return_status           => l_return_status,
            x_msg_count               => l_msg_count,
            x_msg_data                => l_msg_data
          );

Line: 122

         Ahl_Ltp_Space_Assign_Pvt.DELETE_SPACE_ASSIGNMENT
           (
            p_api_version             => l_api_version,
            p_init_msg_list           => p_init_msg_list,
            p_commit                  => p_commit,
            p_validation_level        => p_validation_level,
            p_space_assign_rec        => p_x_space_assignment_tbl(i),
            x_return_status           => l_return_status,
            x_msg_count               => l_msg_count,
            x_msg_data                => l_msg_data
          );